Thanks Ghia,

I will change them this evening and post the result.

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.

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 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

Thanks Ghia,

I will try the new version and let you know

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

Hi Darin,

I have tested with different theme (including XOOPS default theme) and i have the same issue.. not sure where is the problem.

thanks again for your help.

Hi,

the newbb subfourm topic counts are not shown under forum index page. It shows only count of topic under each forum but excludes the count of its subforum. Is there a way to show the sum of subforum topic count on the forum count.

Visit my website
http://aquariumhomecare.com/modules/newbb/viewforum.php?forum=16

if you select " Fresh Water Aquarium" forum the count is zero but there is a record under its sub category "Turtle & Tortoise".

thanks for your help

Hi Nitin,
yes.. i made the changes .. thanks a lot for your help..

I really like XOOPS community..

Hi Nitin,

Thanks for your help.

I am using Blueland_v1 a free theme.

Also may I ask you to review my site and give me your feedback.

This is my first website and I am very excited about it.

Regards
Deepak