ok here is a FRESH smartfaq version 1.04
SELECT * FROM dext_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM dext_session WHERE sess_id = '56cf5d75303092f772f5cb6968041616'
SELECT * FROM dext_users WHERE uid=1
SELECT * FROM dext_modules WHERE dirname = 'smartfaq'
SELECT * FROM dext_config WHERE (conf_modid = 17) ORDER BY conf_order ASC
DELETE FROM dext_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM dext_protector_access WHERE ip='67.162.232.195' AND request_uri='/modules/smartfaq/index.php'
SELECT COUNT(*) FROM dext_protector_access WHERE ip='67.162.232.195'
INSERT INTO dext_protector_access SET ip='67.162.232.195',request_uri='/modules/smartfaq/index.php',expire=UNIX_TIMESTAMP()+'60'
SELECT COUNT(*) FROM dext_smartfaq_categories WHERE (parentid = 0)
SELECT COUNT(*) FROM dext_smartfaq_faq WHERE ((status = 5 OR status = 6))
SELECT * FROM dext_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM dext_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM dext_newblocks b, dext_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,17) AND b.bid IN (1,2,3,25,4,6,5,50,7,49,8,48,9,47,10,17,11,42,12,46,19,18,45,44,20,21,22,23,24,41,40,39,38,37,36,35,34,33,32,31,26,27,30,29,28,51,52,53,54,55,56,57,58) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM dext_priv_msgs WHERE (read_msg = 0 AND to_userid = 1)
SELECT * FROM dext_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC
SELECT * FROM dext_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
SELECT * FROM dext_modules WHERE dirname = 'news'
SELECT COUNT(*) FROM dext_smartfaq_faq WHERE ((status = 2))
SELECT * FROM dext_groups
SELECT * FROM dext_modules WHERE dirname = 'hosting'
SELECT * FROM dext_config WHERE (conf_modid = 8) ORDER BY conf_order ASC
SELECT CID, pagetitle, defaultpage FROM dext_wfschannel WHERE defaultpage = '0' AND submenu = 1 AND (publishdate > 0 AND publishdate <= 1111863891) AND (expiredate = 0 OR expiredate > 1111863891) ORDER BY weight
SELECT submenuitem, titlelink FROM dext_wfslinktous
SELECT submenuitem , titlerefer FROM dext_wfsrefer
SELECT * FROM dext_modules WHERE dirname = 'spaw'
SELECT * FROM dext_modules WHERE dirname = 'downloads'
SELECT * FROM dext_modules WHERE dirname = 'links'
SELECT * FROM dext_groups
SELECT * FROM dext_groups
SELECT * FROM dext_smiles
SELECT * FROM dext_smartfaq_categories WHERE (parentid = 0) ORDER BY weight ASC LIMIT 0, 5
SELECT * FROM dext_smartfaq_categories
SELECT categoryid, COUNT(*) AS count FROM dext_smartfaq_faq WHERE status IN (5,6) GROUP BY categoryid
CREATE TEMPORARY TABLE tmp (categoryid INT(8) UNSIGNED NOT NULL,datesub int(11) DEFAULT '0' NOT NULL);
LOCK TABLES dext_smartfaq_faq READ;
INSERT INTO tmp SELECT categoryid, MAX(datesub) FROM dext_smartfaq_faq WHERE status IN (5,6) GROUP BY categoryid;
SELECT dext_smartfaq_faq.categoryid, faqid, question, uid, dext_smartfaq_faq.datesub FROM dext_smartfaq_faq, tmp WHERE dext_smartfaq_faq.categoryid=tmp.categoryid AND dext_smartfaq_faq.datesub=tmp.datesub;
Error number: 2013
Error message: Lost connection to MySQL server during query
UNLOCK TABLES;
Error number: 2006
Error message: MySQL server has gone away
DROP TABLE tmp;
Error number: 2006
Error message: MySQL server has gone away
SELECT * FROM dext_smartfaq_faq WHERE ((status = 5 OR status = 6)) ORDER BY datesub DESC LIMIT 0, 5
SELECT * FROM dext_smartfaq_categories
SELECT faqid, answer, uid, datesub FROM dext_smartfaq_answers WHERE faqid IN (1) AND status = 1 GROUP BY faqid
SELECT * FROM dext_users WHERE uid IN (1)
SELECT COUNT(*) FROM dext_smartfaq_faq WHERE ((status = 2))
SELECT * FROM dext_groups
SELECT * FROM dext_xoopsnotifications WHERE (not_modid = 17 AND not_category = 'global_faq' AND not_uid = 1) ORDER BY not_id ASC
SELECT * FROM dext_modules WHERE mid = 17
SELECT COUNT(*) FROM dext_smartfaq_faq WHERE ((status = 2))
SELECT * FROM dext_groups
Total: 50 queries
Blocks
User Menu: No Cache
Main Menu: No Cache
Custom Block (HTML): No Cache
Symantec Alert Box: No Cache
Protector: No Cache
Total: 5 blocks
Execution Time
XOOPS took 9.47105813026 seconds to load.
ok so i ran the first BAD query through phpmyadmin and it says
SQL-query:
SELECT dext_smartfaq_faq.categoryid, faqid, question, uid, dext_smartfaq_faq.datesub
FROM dext_smartfaq_faq, tmp
WHERE dext_smartfaq_faq.categoryid = tmp.categoryid
AND dext_smartfaq_faq.datesub = tmp.datesub
LIMIT 0 , 30
MySQL said:
#1146 - Table 'dataextreme_site.tmp' doesn't exist
same thing
