Knowledgebases
|
Submitter: Anonymous
Updated On: 2004/09/11
Version: 1.13
Release Status:
Downloads: 8189
File Size: 99.12 Kb
Rating:
 (3 Votes) Reviews:  (3) Mirrors Available: 0 Download Times:
Modem(56k) : 16s
ISDN(64k) : 14s DSL(768k) : 1s LAN(10M) : 0.09s |
||||
|
Price: |
Platform: 2.0.x |
License: Apache License (v. 1.0) |
Limitations: None
|
|||||
Download Now
|
Debaser
(2004/11/07)
|
|
Stats
(2004/06/17)
|
|
Comments Search
(2004/06/17)
|
|
Google Search Krakite
(2004/06/16)
|
|
Aleatoire
(2004/06/16)
|
|
Addressbook
(2004/06/16)
|
|
myPinup 2.1
(2004/06/16)
|
|
Symantec Alert Block
(2004/06/16)
|
|
XoopsDigger
(2004/06/16)
|
|
Metamoteur
(2004/06/16)
|
|
BopComments 0.61
(2004/06/16)
|
|
A Slot Management System
(2004/06/15)
|
|
Block Utils 1.0
(2004/06/15)
|
|
Zmagazine 1.0
(2004/04/28)
|
|
bfStats
(2004/04/28)
|
|
xMail
(2004/04/28)
|
|
Camportail 1.1
(2004/04/28)
|
|
TechThemeConfig Bundle
(2004/04/28)
|
|
WebFTP
(2004/04/28)
|
|
Book Lists 0.8
(2004/04/28)
|
Re: Dictionary 0.91b
Hi All,
I have a funny problem. The module works great on my Test/Development system but not in the production system. when you add a defination. i dont get any error message but no record is getting instered.
While debugging I found the Insert SQL is not getting generated at all. Find the SQLs from both Production & Test system..
------------------------------------
On Production System
------------------------------------
All errors (0) queries (7) blocks (0) extra (0) timers (3)
Errors
Queries
SET NAMES 'utf8'
SELECT * FROM xoops__config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops__session WHERE sess_id = 'no6k0vrcov1g1in5qsog9vont6'
SELECT * FROM xoops__users WHERE uid = '1'
SELECT * FROM xoops__modules WHERE dirname = 'dictionary'
SELECT * FROM xoops__config WHERE (conf_modid = '27') ORDER BY conf_order ASC
SELECT * FROM xoops__group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
Total: 7 queries
------------------------------------
On test System
------------------------------------
All errors (0) queries (12) blocks (0) extra (0) timers (3)
Queries
SET NAMES 'utf8'
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '7db4f9e5cb3327684510f5125675b97f'
SELECT * FROM xoops_users WHERE uid = '1'
SELECT * FROM xoops_modules WHERE dirname = 'dictionary'
SELECT * FROM xoops_config WHERE (conf_modid = '56') ORDER BY conf_order ASC
INSERT INTO xoops_dictionary (letter, name, definition, state) VALUES ('E', 'England', 'England Text', 'O')
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 3, 1
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
Total: 12 queries
------------------------------------
Any idea where to start for debugging?
Re: Dictionary 0.91b
Can someone update this module please.
Thanks
Re: Dictionary 0.91b
hi'
You should try this version updated thanks to Mowaffak : http://www.arabxoops.com/modules/mydownloads/singlefile.php?cid=5&lid=191
Login
Search
Top Module Downloads
- News (75541)
- myAlbum-P (66877)
- xcGallery (50522)
- newBB (CBB) (50042)
- XoopsGallery (49520)
- Invision Power ... (37165)
- DMS (Document M... (36386)
- Galeria (30686)
- Chat MX 1.1 (28902)
- XPressMe (WordP... (27909)
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|
Hi,
Its a good module. However if you are using mysqlv5.0, you need to make few update for the SQL changes.
1. Add ENGINE=MyISAM at the end of the mysql.sql create table
2. Replace line 12 of question.php by :
$xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("dictionary")." (letter, name, definition, state) VALUES ('' , '$name', '', '$state')");
3. Replace line 13 of submit.php by :
$xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("dictionary")." (letter, name, definition, state) VALUES ('$letter' , '$name', '$definition', '$state')");
4. Replace line 17 of add-def.php by :
$xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("dictionary")." (letter, name, definition, state) VALUES ('$letter', '$name', '$definition', '$state')");
5. Replace line 36 of import.php by :
$insert = $xoopsDB->queryF("INSERT INTO ".$xoopsDB->prefix("dictionary")." (letter, name, definition, state) VALUES ('".$glo['lettre']."','".$glo['nom']."','".$glo['definition']."','".$glo['affiche']."')");
Good Luck
Deepak
http://www.AquariumHomeCare.com