Public Forums 71,145 posts

[a_westcott Friend a_westcottJoin date: February 2008Posts: 13Downloads:0Uploads:0]

#125764

Hi

If you visit my site: http://www.franklinscott.com – and then scroll all the way down you will see something strange appearing for all to see, what is it and how do I get rid of it?

23 queries executed
1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = ‘system’
ORDER BY ordering——————————————————————————–2
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1——————————————————————————–3
DELETE FROM jos_session
WHERE (
( time < ‘1203261442’ )
AND guest = 0
AND gid > 0
) OR (
( time < ‘1203261442’ )
AND guest = 1
AND userid = 0
)——————————————————————————–4
SELECT *
FROM jos_session
WHERE session_id = ‘14422d359bde9e977c8680f1c95d98fd’——————————————————————————–5
UPDATE jos_session SET `time`=’1203262342′,`userid`=’0′,`usertype`=”,`us ername`=”,`gid`=’0′,`guest`=’1′ WHERE session_id=’14422d359bde9e977c8680f1c95d98fd’——————————————————————————–6
SELECT *
FROM jos_menu
WHERE id = 1——————————————————————————–7
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-02-17 15:32’ )
AND ( a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-02-17 15:32’ )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0——————————————————————————–8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-02-17 15:32’ )
AND ( a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-02-17 15:32’ )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
ORDER BY f.ordering
LIMIT 4——————————————————————————–9
SELECT COUNT( id )
FROM jos_menu
WHERE type = ‘content_item_link’
AND published = 1——————————————————————————–10
SELECT id
FROM jos_menu
WHERE type = ‘content_item_link’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=1’——————————————————————————–11
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering——————————————————————————–12
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = ‘option=com_syndicate’ OR a.admin_menu_link = ‘option=com_syndicate&hidemainmenu=1’ )
AND a.option = ‘com_syndicate’——————————————————————————–13
SELECT id
FROM jos_menu
WHERE link = ‘index.php?option=com_search’
AND published = 1——————————————————————————–14
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering——————————————————————————–15
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
FROM jos_content AS a
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-02-17 15:32’ )
AND (a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-02-17 15:32’ )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering——————————————————————————–16
SELECT m.*
FROM jos_menu AS m
WHERE menutype = ‘mainmenu’
AND published = 1
AND access <= 0
ORDER BY parent, ordering——————————————————————————–17
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = ‘content’
ORDER BY ordering——————————————————————————–18
SELECT params
FROM jos_mambots
WHERE element = ‘mosemailcloak’
AND folder = ‘content’——————————————————————————–19
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-02-17 15:32’ )
AND ( a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-02-17 15:32’ )
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 5——————————————————————————–20
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0 )
AND ( a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2008-02-17 15:32’ )
AND ( a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2008-02-17 15:32’ )
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 5——————————————————————————–21
SELECT m.*
FROM jos_menu AS m
WHERE menutype = ‘topmenu’
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering——————————————————————————–22
SELECT COUNT( id )
FROM jos_menu
WHERE type = ‘content_typed’
AND published = 1——————————————————————————–23
SELECT id
FROM jos_menu
WHERE type = ‘content_typed’
AND published = 1
AND link = ‘index.php?option=com_content&task=view&id=5’

[a_westcott Friend a_westcottJoin date: February 2008Posts: 13Downloads:0Uploads:0]

#239336

Ah, problem solved, seemed that I had debug set to yes in the global config.

[Author]

Posts