Hi All,

I have a funny problem. The Dictionary (v0.91b) module works great on my Test/Development system but not in the production system. When I add a defination/record, i don't get any error message but no record is getting instered.

While debugging I found the insert SQL is not getting generated at all in production. Find the SQLs from both Production & Test system.. If I execute the insert SQL mannually, it inserts without any issue.
------------------------------------
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?

Thanks in Advance

Try the latest version V1.13.
Check that you have the same preferences and permissions for the module on both systems.

Thanks Ghia,

I will try the new version and let you know

Hi Ghia,

I tried the version v1.13 but I still have the same funny problem. The SQL are not getting generated.

--------------------------------------
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 = 'shqtd2279hbvqt1o7c6vf2nfo1'
SELECT * FROM xoops__users WHERE uid = '1'
SELECT * FROM xoops__modules WHERE dirname = 'dictionary'
SELECT * FROM xoops__config WHERE (conf_modid = '28') 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
--------------------------------------

System --> Group permission are same on both system.
What do you mean by preference?

Please help

And you have PHP 4 on the test system and PHP 5 on the production system?

Try one of the Wordbook clones Lexicon or Lexique instead.

My System Overview:

Production
-------------------
XOOPS Version - XOOPS 2.3.1
PHP Version - 5.2.8
MySQL Version - 5.0.67.d7-ourdelta-log
Server API Version - cgi-fcgi
OS Version - Linux

Test
---------------

XOOPS Version - XOOPS 2.3.2
PHP Version - 5.0.0RC2
MySQL Version - 5.0.67-community-nt-log
Server API Version - apache2handler
OS Version - WINNT

Will try your suggested module. and get back to you in few days.

Thanks for your help.

Happy Easter to you.

Hi Ghia,

I found the similar problem with "cquote" module.

in this module, the index.php has folloing code for insert:


-------------------------------------
if ($op == "add") {
// Add quote
$myts =& MyTextSanitizer::getInstance();
$client = $myts->makeTboxData4Save($client);
$quote = $myts->makeTboxData4Save($quote);
$curl = $myts->makeTboxData4Save($curl);
$newid = $xoopsDB->genId($xoopsDB->prefix("cquotes")."id");
$sql = "INSERT INTO ".$xoopsDB->prefix("cquotes")." (id, client, quote, curl) VALUES (".$newid.", '".$client."', '".$quote."', '".$curl."')";
if (!$xoopsDB->query($sql)) {
xoops_cp_header();
echo "Could not add category";
xoops_cp_footer();
} else {
redirect_header("index.php?op=list",1,_XD_DBSUCCESS);
}
exit();
}
-------------------------------------

is it something to do with "MyTextSanitizer"

sorry for asking so many question.

The module (Random client Quotes?) was written for PHP4 and you are probably on PHP5.
Replace all occurences in all files of HTTP_*_VARS to _* (eg HTTP_GET_VARS to _GET).

Thanks Ghia,

I will change them this evening and post the result.