Module Repository - XOOPS Web Application System

Dictionary (glossar) modul with templates and notification.

Features:

System Requirements:

Submitter:	Anonymous	Publisher:
Released:	2004/09/11	Version:	1.13
Downloads:	8027	File Size:	99.12 Kb
Home Page:		Price::	Free
Platform:	2.0.x	License:	Apache License (v. 1.0)
Limitations:	None

XOOPS Web Application System User Reviews

Read User Reviews on Dictionary">

Other files by: Anonymous

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)

The comments are owned by the author. We aren't responsible for their content.

Re: Dictionary 0.91b

deepak267 Published 04/06/2009 20:51 Quite a regular Joined 08/15/2008 Comments 352

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

Re: Dictionary 0.91b

deepak267 Published 04/08/2009 16:11 Updated 04/08/2009 22:18 Quite a regular Joined 08/15/2008 Comments 352

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?