whitescorpion
07-17-2006, 09:54 AM
سلام من موقع نصب مامبو وقتی قسمته خطا ياب رو فعال کردم اين پيقام ها رو داد42 تا مشکله کوچولو
42 queries executed
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'--------------------------------------------------------------------------------2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1--------------------------------------------------------------------------------3
DELETE FROM mos_session
WHERE (time < 1153128348)--------------------------------------------------------------------------------4
SELECT * FROM mos_session WHERE session_id='087cb43af479f8ac03705c3d92d63fca'--------------------------------------------------------------------------------5
UPDATE mos_session SET `time`='1153129248',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1' WHERE session_id='087cb43af479f8ac03705c3d92d63fca'--------------------------------------------------------------------------------6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering--------------------------------------------------------------------------------7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering--------------------------------------------------------------------------------8
SELECT access FROM mos_menu WHERE id='1'--------------------------------------------------------------------------------9
SELECT * FROM mos_menu WHERE id='1'--------------------------------------------------------------------------------10
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
FROM mos_content AS a
INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN mos_categories AS cc ON cc.id = a.catid
INNER JOIN mos_sections AS s ON s.id = a.sectionid
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.state = '1'
AND a.access <= '0'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2006-07-17 12:40:48' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2006-07-17 12:40:48' )
ORDER BY f.ordering--------------------------------------------------------------------------------11
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------12
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------13
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------14
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'--------------------------------------------------------------------------------15
SELECT * FROM mos_components WHERE id='17'--------------------------------------------------------------------------------16
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering--------------------------------------------------------------------------------17
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering--------------------------------------------------------------------------------18
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering--------------------------------------------------------------------------------19
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering--------------------------------------------------------------------------------20
SELECT a.id, a.title, a.sectionid, a.catid
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48' )
AND a.access <= '0'
ORDER BY a.created DESC LIMIT 5--------------------------------------------------------------------------------21
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------22
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------23
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------24
SELECT a.id, a.title, a.sectionid, a.catid
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48' )
AND a.access <= '0'
ORDER BY a.hits DESC LIMIT 5--------------------------------------------------------------------------------25
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------26
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------27
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------28
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1--------------------------------------------------------------------------------29
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering--------------------------------------------------------------------------------30
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND a.access <= '0' AND b.access <= '0'
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48')
AND catid='3'
ORDER BY a.ordering--------------------------------------------------------------------------------31
SELECT * FROM mos_content WHERE id='0'--------------------------------------------------------------------------------32
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering--------------------------------------------------------------------------------33
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'--------------------------------------------------------------------------------34
SELECT * FROM mos_mambots WHERE id='16'--------------------------------------------------------------------------------35
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=0--------------------------------------------------------------------------------36
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1--------------------------------------------------------------------------------37
SELECT id, text FROM mos_poll_data
WHERE pollid='15' AND text <> ''
ORDER BY id--------------------------------------------------------------------------------38
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')--------------------------------------------------------------------------------39
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------40
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1--------------------------------------------------------------------------------41
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 1,1--------------------------------------------------------------------------------42
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='4'
42 queries executed
1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'--------------------------------------------------------------------------------2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1--------------------------------------------------------------------------------3
DELETE FROM mos_session
WHERE (time < 1153128348)--------------------------------------------------------------------------------4
SELECT * FROM mos_session WHERE session_id='087cb43af479f8ac03705c3d92d63fca'--------------------------------------------------------------------------------5
UPDATE mos_session SET `time`='1153129248',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1' WHERE session_id='087cb43af479f8ac03705c3d92d63fca'--------------------------------------------------------------------------------6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering--------------------------------------------------------------------------------7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering--------------------------------------------------------------------------------8
SELECT access FROM mos_menu WHERE id='1'--------------------------------------------------------------------------------9
SELECT * FROM mos_menu WHERE id='1'--------------------------------------------------------------------------------10
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
FROM mos_content AS a
INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN mos_categories AS cc ON cc.id = a.catid
INNER JOIN mos_sections AS s ON s.id = a.sectionid
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.state = '1'
AND a.access <= '0'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2006-07-17 12:40:48' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2006-07-17 12:40:48' )
ORDER BY f.ordering--------------------------------------------------------------------------------11
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------12
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------13
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------14
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'--------------------------------------------------------------------------------15
SELECT * FROM mos_components WHERE id='17'--------------------------------------------------------------------------------16
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering--------------------------------------------------------------------------------17
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering--------------------------------------------------------------------------------18
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering--------------------------------------------------------------------------------19
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering--------------------------------------------------------------------------------20
SELECT a.id, a.title, a.sectionid, a.catid
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48' )
AND a.access <= '0'
ORDER BY a.created DESC LIMIT 5--------------------------------------------------------------------------------21
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------22
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------23
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------24
SELECT a.id, a.title, a.sectionid, a.catid
FROM mos_content AS a
LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48' )
AND a.access <= '0'
ORDER BY a.hits DESC LIMIT 5--------------------------------------------------------------------------------25
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_blog_section'
AND m.published='1'--------------------------------------------------------------------------------26
SELECT COUNT( m.id )
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id
WHERE m.type='content_blog_category'
AND m.published='1'--------------------------------------------------------------------------------27
SELECT COUNT( id )
FROM mos_menu
WHERE type='content_blog_section'
AND published='1'
AND componentid=0--------------------------------------------------------------------------------28
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1--------------------------------------------------------------------------------29
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering--------------------------------------------------------------------------------30
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND a.access <= '0' AND b.access <= '0'
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-17 12:40:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-17 12:40:48')
AND catid='3'
ORDER BY a.ordering--------------------------------------------------------------------------------31
SELECT * FROM mos_content WHERE id='0'--------------------------------------------------------------------------------32
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering--------------------------------------------------------------------------------33
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'--------------------------------------------------------------------------------34
SELECT * FROM mos_mambots WHERE id='16'--------------------------------------------------------------------------------35
SELECT m.id
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=0--------------------------------------------------------------------------------36
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1--------------------------------------------------------------------------------37
SELECT id, text FROM mos_poll_data
WHERE pollid='15' AND text <> ''
ORDER BY id--------------------------------------------------------------------------------38
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')--------------------------------------------------------------------------------39
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------40
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1--------------------------------------------------------------------------------41
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 1,1--------------------------------------------------------------------------------42
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='4'