With MySQL Debug Activated, this is the error message -
"SELECT * FROM xoops3_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops3_session WHERE sess_id = '12e0bed51cfdd8f8325cb8c4040d28f9'
SELECT * FROM xoops3_users WHERE uid=2
SELECT * FROM xoops3_modules WHERE dirname = 'news'
SELECT * FROM xoops3_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM xoops3_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops3_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops3_newblocks b, xoops3_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,2,-1) AND b.bid IN (21,20,19,18,14,15,16,13,12,10,9,8,7,6,5,4,3,2,1) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops3_priv_msgs WHERE (read_msg = '0' AND to_userid = '2')
SELECT * FROM xoops3_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM xoops3_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops3_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT COUNT(*) as cpt FROM xoops3_topics WHERE menu=1
SELECT * FROM xoops3_topics ORDER BY topic_title
SELECT * FROM xoops3_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM xoops3_topics ORDER BY topic_title
SELECT s.*, t.* FROM xoops3_stories s, xoops3_topics t WHERE (published > 0 AND published <= 1140701539) AND (expired = 0 OR expired > 1140701539) AND (s.topicid=t.topic_id) AND ihome=0 AND t.topic_frontpage=1 ORDER BY s.published DESC LIMIT 0, 5
Error number: 1030
Error message: Got error 124 from table handler
SELECT COUNT(*) FROM xoops3_stories WHERE published > 0 AND published <= 1140701539 AND (expired = 0 OR expired > 1140701539) AND ihome=0
SELECT COUNT(*) as cpt FROM xoops3_topics WHERE menu=1
SELECT * FROM xoops3_topics ORDER BY topic_title
SELECT * FROM xoops3_xoopsnotifications WHERE (not_modid = '2' AND not_category = 'global' AND not_uid = '2') ORDER BY not_id ASC
SELECT * FROM xoops3_modules WHERE mid = 2
SELECT COUNT(*) as cpt FROM xoops3_topics WHERE menu=1
SELECT * FROM xoops3_topics ORDER BY topic_title
SELECT * FROM xoops3_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'news_index.html') ORDER BY tpl_refid
SELECT * FROM xoops3_tplfile WHERE (tpl_tplset = 'default' AND tpl_fi"
Please email me at
malexandria@eclipsemagazine.com if you can help as I don't have time to really check the forums.
thanks
Michelle
