Titre du sujet : Re: Modules catads de petite annonces
par ON3AT sur 26/09/2010 13:45:25
Citation :
xmouse a écrit :
Salut,
As-tu essayé de mettre ton site en mode debug pour voir ce que cela donne ?
Bonjour xmouse,
Je sais pas si vous comprener quelque chose la dedant moi je n y comprent pas grand chose voici mon mode debug :
None All errors(19)queries(121)blocks(21)extra(2) timers (6)
[right]Errors[/right]
Unknown: Assigning the return value of new by reference is deprecated in file /header.php line 57
Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 464
Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 514
Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 73
Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 196
Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 248
Unknown: Assigning the return value of new by reference is deprecated in file /class/theme_blocks.php line 90
Notice: Undefined index: gallery in file /class/module.textsanitizer.php line 184
Notice: Use of undefined constant _MYTUBE_JANUARI - assumed '_MYTUBE_JANUARI' in file /modules/mytube/include/functions.php line 1251
Notice: Use of undefined constant _MYTUBE_FEBRUARI - assumed '_MYTUBE_FEBRUARI' in file /modules/mytube/include/functions.php line 1252
Notice: Use of undefined constant _MYTUBE_MAY2 - assumed '_MYTUBE_MAY2' in file /modules/mytube/include/functions.php line 1267
Unknown: Assigning the return value of new by reference is deprecated in file /modules/extgallery/class/ExtgalleryPersistableObjectHandler.php line 78
Unknown: Assigning the return value of new by reference is deprecated in file /modules/smartsection/include/functions.php line 1013
Unknown: Assigning the return value of new by reference is deprecated in file /modules/smartsection/class/session.php line 78
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665
Unknown: Assigning the return value of new by reference is deprecated in file /modules/extcal/class/pear/Calendar/Month/Weeks.php line 97
Unknown: Assigning the return value of new by reference is deprecated in file /modules/extcal/class/pear/Calendar/Calendar.php line 404
Unknown: Assigning the return value of new by reference is deprecated in file /modules/extcal/class/ExtcalPersistableObjectHandler.php line 53
Unknown: Assigning the return value of new by reference is deprecated in file /modules/extcal/class/pear/Calendar/Week.php line 123
Queries
SET NAMES 'utf8'
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM session WHERE sess_id = '8a714dd349bd8e44fde8010780f3b4de'
SELECT * FROM users WHERE uid = '1'
SELECT * FROM modules WHERE dirname = 'catads'
SELECT * FROM config WHERE (conf_modid = '103') ORDER BY conf_order ASC
DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM protector_access WHERE ip='***.***.***.***' AND request_uri='/modules/catads/'
SELECT COUNT(*) FROM protector_access WHERE ip='***.***.***.***'
INSERT INTO protector_access SET ip='***.***.***.***',request_uri='/modules/catads/',expire=UNIX_TIMESTAMP()+'60'
SELECT COUNT(*) FROM banner
SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,4)
SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,103) AND b.bid IN (428,431,269,268,267,266,265,264,263,262,258,259,260,261,257,256,255,254,253,252,251,245,244,243,442,143,133,134,135,137,139,136,140,138,142,
141,106,105,104,103,86,87,78,79,74,73,70,91,69,51,50,49,48,47,46,45,44,43,430,429,42,40,39,38,37,36,35,34,33,32,31,30,29,28,27,453,26,101,444,25,24,
23,22,21,443,20,19,17,16,451,12,11,452,10,9,8,7,6,5,4,3,2,1,432,271,270,351,
352,370,152,350,233,92,147,145,146,14,13,421,426,425,424,423,422,449,450,409,484,392,427,496,486,487,488,489,490,491,492,493,494,495,485,498) ORDER BY b.weight, m.block_id
SELECT * FROM modules WHERE dirname = 'mytube'
SELECT * FROM config WHERE (conf_modid = '38') ORDER BY conf_order ASC
SELECT lid, cid, title, vidid, screenshot, published, vidsource, picurl FROM xoopstube_videos WHERE published > 0 AND published<=1285501167 AND (expired=0 OR expired>1285501167) AND offline=0 ORDER BY RAND() LIMIT 1
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'xoopstube_block_random_h.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE dirname = 'extgallery'
SELECT * FROM group_permission WHERE (gperm_name = 'public_access' AND gperm_modid = '11' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM extgallery_publicphoto WHERE (cat_id IN (24,5,25,22,4,1,18,17,14,13,9,3,8,7,6,2,12,11,15,10,19,20,21,23) AND cat_id IN (15,11,12)) ORDER BY RAND() ASC LIMIT 0, 1
SELECT * FROM smiles
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'extgallery_block_random.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE dirname = 'pm'
SELECT COUNT(*) FROM `priv_msgs` WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE dirname = 'mpmanager'
SELECT * FROM config WHERE (conf_modid = '24') ORDER BY conf_order ASC
SELECT COUNT(*) FROM online WHERE online_uid=1
UPDATE online SET online_updated=1285501167, online_module = 103 WHERE online_uid = 1
SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT * FROM `users` WHERE (uid > '87')
SELECT COUNT(*) FROM priv_msgs WHERE (to_userid = '1')
SELECT COUNT(*) FROM online WHERE online_uid=1
UPDATE online SET online_updated=1285501168, online_module = 103 WHERE online_uid = 1
SELECT * FROM online
SELECT COUNT(*) FROM online WHERE online_module = '103'
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM modules WHERE dirname = 'news'
SELECT * FROM config WHERE (conf_modid = '5') ORDER BY conf_order ASC
SELECT * FROM bb_forums ORDER BY forum_order
SELECT * FROM groups
SELECT COUNT(*) FROM catads_ads WHERE uid = '1'
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM `users` WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 5
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_newusers.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE dirname = 'smartsection'
SELECT * FROM config WHERE (conf_modid = '102') ORDER BY conf_order ASC
SELECT * FROM smartsection_categories WHERE (parentid = '0') ORDER BY weight ASC
SELECT * FROM group_permission WHERE (gperm_modid = '102')
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'smartsection_items_menu.html') ORDER BY tpl_refid
SELECT * FROM userpage WHERE (1 = '1') ORDER BY up_created DESC LIMIT 0, 10
SELECT * FROM modules WHERE dirname = 'userpage'
SELECT * FROM config WHERE (conf_modid = '64') ORDER BY conf_order ASC
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'userpage_block_last.html') ORDER BY tpl_refid
SELECT count(user_id) as number FROM evennews_members WHERE confirmed='1'
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'evennews_block_subcr.html') ORDER BY tpl_refid
SELECT * FROM modules WHERE dirname = 'extcal'
SELECT * FROM config WHERE (conf_modid = '6' AND conf_catid = '0') ORDER BY conf_order ASC
SELECT * FROM group_permission WHERE (gperm_name = 'extcal_cat_view' AND gperm_modid = '6' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM extcal_event WHERE (((event_start <= '1285891199' AND event_end >= '1283299200' AND event_isrecur = '0') OR (event_recur_start <= '1285891199' AND event_recur_end >= '1283299200' AND event_isrecur = '1')) AND event_approved = '1' AND cat_id IN (1,2)) ORDER BY event_start ASC
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'extcal_block_minical.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
SELECT * FROM xoopspoll_option WHERE poll_id=1 ORDER BY option_id
SELECT * FROM xoopspoll_option WHERE poll_id=5 ORDER BY option_id
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'xoopspoll_block_poll.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_siteinfo.html') ORDER BY tpl_refid
select count(distinct date) as count from TDMStats_daycount
select * from TDMStats_count
select * from TDMStats_daycount order by daycount desc limit 1
select daycount from TDMStats_daycount where date='2010-09-26'
select count from TDMStats_week_count where week='38' and year='2010'
select count from TDMStats_mth where mth='09' and year='2010'
select * from TDMStats_week_count order by count desc limit 1
select * from TDMStats_mth order by count desc limit 1
select sum(count) as total from TDMStats_page
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'tdmstats_block_counter.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM catads_ads WHERE waiting = '1'
SELECT cat_id, count(*) FROM catads_ads WHERE (waiting = '0' AND suspend = '0' AND published < '1285501168' AND expired > '1285501168') GROUP BY cat_id
SELECT cat_id, count(*) FROM catads_ads WHERE (published > '1285241968' AND waiting = '0' AND suspend = '0' AND expired > '1285501168') GROUP BY cat_id
SELECT * FROM catads_cat ORDER BY weight
SELECT topic_id, topic_pid FROM catads_cat
SELECT topic_id, topic_title, topic_desc, img FROM catads_cat WHERE topic_pid = 0 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =1 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =2 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =3 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =5 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =6 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =7 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =8 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =9 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =10 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =11 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =12 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =13 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =14 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =15 AND display_cat = 1 ORDER BY weight
SELECT * FROM catads_cat WHERE topic_pid =16 AND display_cat = 1 ORDER BY weight
SELECT COUNT(*) FROM catads_ads WHERE (waiting = '0' AND suspend = '0' AND published < '1285501168' AND expired > '1285501168')
SELECT * FROM group_permission WHERE (gperm_name = 'catads_access' AND gperm_modid = '103' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM catads_ads WHERE (waiting = '0' AND suspend = '0' AND published < '1285501168' AND expired > '1285501168' AND (cat_id = '11' OR cat_id = '12' OR cat_id = '15' OR cat_id = '3' OR cat_id = '5' OR cat_id = '6' OR cat_id = '2' OR cat_id = '1' OR cat_id = '14' OR cat_id = '9' OR cat_id = '8' OR cat_id = '13' OR cat_id = '16' OR cat_id = '7' OR cat_id = '10')) ORDER BY published DESC LIMIT 0, 10
SELECT COUNT(*) FROM catads_ads WHERE uid = '1'
SELECT * FROM xoopsnotifications WHERE (not_modid = '103' AND not_category = 'global' AND not_uid = '1') ORDER BY not_id ASC
SELECT * FROM modules WHERE mid = 103
SELECT COUNT(*) FROM catads_ads WHERE uid = '1'
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'catads_index.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'catads_cat.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'catads_subcat.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'catads_adssublist.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid
SELECT groupid FROM groups_users_link WHERE uid=1
SELECT * FROM groups WHERE groupid=1
SELECT * FROM groups WHERE groupid=2
SELECT * FROM groups WHERE groupid=4
SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM groups
SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND gperm_groupid = '1')
Total: 121 queries
Blocks
Vidéos aléatoires (h): No Cache
Photo aléatoire: No Cache
Menu utilisateur: No Cache
Connexion: No Cache
Qui est en ligne: No Cache
Menu Principal: No Cache
Nouveaux membres: No Cache
Bloc personnalisé (Format Auto): No Cache
Menu navigation des catégories: No Cache
Derni: No Cache
Bloc personnalisé (HTML): No Cache
Bloc personnalisé (Format Auto): No Cache
Abonnement: No Cache
Minical: No Cache
Bloc personnalisé (Format Auto): No Cache
Bloc personnalisé (Format Auto): No Cache
Recherche: No Cache
Sondages: No Cache
Infos du site: No Cache
Stats Compteur: No Cache
Bloc personnalisé (Format Auto): No Cache
Total: 21 blocks
Extra
Included files: 208 files
Memory usage: 13413932 bytes
Timers
XOOPS took 2,226 seconds to load.
XOOPS Boot took 0,135 seconds to load.
Module init took 1,007 seconds to load.
XOOPS output init took 0,895 seconds to load.
Module display took 0,103 seconds to load.
Page rendering took 0,066 seconds to load.
|
