Hello,

just downloaded and installed the latest version of your fireboard searchbot to my site at www.hounslowtw3.net

On the frontpage you can see there is a thread that has the word Tesco in it but when I search for "tesco" nothing is returned. The mambot is published.

any help would be much appreciated.

Thanks!

Paul

Hello Paul,

Thank you for reporting your issue here. I'm a little disappointed since I just finished rewriting the script to fix the same error you seem to have.

I would very much like to resolve this issue for you as soon as possible but I'll need your help. In order for me to locate the problem, I'll need your websites debug information. Basically, this is a list of every database query that is performed when you load a page. Additionally, script warnings are also visable in the debug mode which often point to the problem.

So here is what I need you to do:

• Set your website to debug
  --- Click on Site -> Global Configuration -> Debug Site (Yes)


• Perform a search on your website that should return a result from the forum like "Tesco".


• Above your search results there may be some warning messages, copy and post those here.


• At the bottom of the page should be several lines of MySQL database queries, please copy and post them here as well.

This information is pretty much the only way I can locate any problems which could account for your issue.

Be sure to turn the debug mode off after you get the information needed.

vujsa

Hi vujsa,

Here's the output from the top:

QUOTE:
/home/sites/hounslowtw3.net/public_html/includes/database.php:485
/home/sites/hounslowtw3.net/public_html/mambots/search/jreviews.searchbot.php:178
/home/sites/hounslowtw3.net/public_html/includes/joomla.php:4254
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:154
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:25
/home/sites/hounslowtw3.net/public_html/index.php:235
/home/sites/hounslowtw3.net/public_html/includes/database.php:485
/home/sites/hounslowtw3.net/public_html/mambots/search/marketplace.searchbot.php:174
/home/sites/hounslowtw3.net/public_html/includes/joomla.php:4254
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:154
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:25
/home/sites/hounslowtw3.net/public_html/index.php:235
/home/sites/hounslowtw3.net/public_html/includes/database.php:464
/home/sites/hounslowtw3.net/public_html/mambots/search/bot_jcalpro_search.php:118
/home/sites/hounslowtw3.net/public_html/includes/joomla.php:4254
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:154
/home/sites/hounslowtw3.net/public_html/components/com_search/search.php:25
/home/sites/hounslowtw3.net/public_html/index.php:235

and here's the output from the bottom:

QUOTE:
140 queries executed

1
SET sql_mode = 'MYSQL40'2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering3
SELECT params
FROM jos_mambots
WHERE element = 'jombackup.systembot'
AND folder = 'system'4
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
LIMIT 15
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 99999999 )
ORDER BY menuid DESC
LIMIT 16
DELETE FROM jos_session
WHERE (
( time < '1186992630' )
AND guest = 0
AND gid > 0
) OR (
( time < '1186992930' )
AND guest = 1
AND userid = 0
)7
SELECT session_id
FROM jos_session
WHERE session_id = 'b88d54a0b1b3bffabd4ea4d200112e48'8
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'b88d54a0b1b3bffabd4ea4d200112e48','1186993830','','0','1' )9
SELECT id
FROM jos_mambots
WHERE element = 'jceutils'
AND folder = 'system'10
SELECT *
FROM jos_mambots
WHERE id = '62'11
SELECT published
FROM jos_mambots
WHERE element = 'jceembed'
AND folder = 'system'12
SELECT params
FROM jos_mambots
WHERE element = 'xajax.system'
AND folder = 'system'13
SELECT `option` FROM jos_components WHERE parent=0 AND iscore=014
SELECT id
FROM jos_mambots
WHERE element = 'xajax.system'
AND folder = 'system'15
SELECT *
FROM jos_mambots
WHERE id = '37'16
SELECT *
FROM jos_menu
WHERE published = 1 AND
link LIKE 'index.php?option=com_search%'17
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_search'18
SELECT hits
FROM jos_core_log_searches
WHERE LOWER( search_term ) = 'tesco'19
UPDATE jos_core_log_searches
SET hits = ( hits + 1 )
WHERE LOWER( search_term ) = 'tesco'20
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'search'
ORDER BY ordering21
SELECT params
FROM jos_mambots
WHERE element = 'jreviews.searchbot'
AND folder = 'search'22
SHOW FIELDS FROM jos_jreviews_content23
SELECT a.title AS title,
a.created AS created,
CONCAT(a.introtext, a.fulltext) AS text,
CONCAT_WS( '/', u.title, b.title ) AS section,
CONCAT( 'index.php?option=com_content&task=view&id=', a.id ) AS href,
'2' AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b ON b.id=a.catid
INNER JOIN jos_sections AS u ON u.id = a.sectionid
LEFT JOIN jos_jreviews_content AS jr ON jr.contentid = a.id
LEFT JOIN jos_jreviews_comments AS r ON r.pid = a.id
WHERE ( (LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%' OR LOWER(jr.email) LIKE '%tesco%' OR LOWER(jr.jr_address) LIKE '%tesco%' OR LOWER(jr.jr_town) LIKE '%tesco%' OR LOWER(jr.jr_postcode) LIKE '%tesco%' OR LOWER(jr.jr_telephone) LIKE '%tesco%' OR LOWER(jr.jr_fax) LIKE '%tesco%' OR LOWER(jr.jr_contactperson) LIKE '%tesco%' OR LOWER(jr.jr_website) LIKE '%tesco%' OR LOWER(jr.jr_email) LIKE '%tesco%' OR LOWER(jr.jr_gmap) LIKE '%tesco%' OR LOWER(jr.jr_othertel) LIKE '%tesco%' OR LOWER(jr.jr_vendor) LIKE '%tesco%' OR LOWER(jr.jr_vendorpage) LIKE '%tesco%' OR LOWER(jr.jr_expirydate) LIKE '%tesco%' OR LOWER(jr.jr_contactinfo) LIKE '%tesco%' OR LOWER(r.comments) LIKE '%tesco%' OR LOWER(r.title) LIKE '%tesco%') )
AND a.state = 1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 5024
SELECT a.title AS title, a.created AS created,
a.introtext AS text,
CONCAT( 'index.php?option=com_content&task=view&id=', a.id, '&Itemid=', m.id ) AS href,
'2' as browsernav, 'Menu' AS section
FROM jos_content AS a
LEFT JOIN jos_menu AS m ON m.componentid = a.id
WHERE ((LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%' OR LOWER(jr.email) LIKE '%tesco%' OR LOWER(jr.jr_address) LIKE '%tesco%' OR LOWER(jr.jr_town) LIKE '%tesco%' OR LOWER(jr.jr_postcode) LIKE '%tesco%' OR LOWER(jr.jr_telephone) LIKE '%tesco%' OR LOWER(jr.jr_fax) LIKE '%tesco%' OR LOWER(jr.jr_contactperson) LIKE '%tesco%' OR LOWER(jr.jr_website) LIKE '%tesco%' OR LOWER(jr.jr_email) LIKE '%tesco%' OR LOWER(jr.jr_gmap) LIKE '%tesco%' OR LOWER(jr.jr_othertel) LIKE '%tesco%' OR LOWER(jr.jr_vendor) LIKE '%tesco%' OR LOWER(jr.jr_vendorpage) LIKE '%tesco%' OR LOWER(jr.jr_expirydate) LIKE '%tesco%' OR LOWER(jr.jr_contactinfo) LIKE '%tesco%' OR LOWER(r.comments) LIKE '%tesco%' OR LOWER(r.title) LIKE '%tesco%'))
AND a.state = 1
AND a.access <= 0
AND m.type = 'content_typed'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
ORDER BY a.created DESC
LIMIT 5025
SELECT a.title AS title,
a.created AS created,
a.introtext AS text,
CONCAT_WS( '/', 'Archived ', u.title, b.title ) AS section,
CONCAT('index.php?option=com_content&task=view&id=',a.id) AS href,
'2' AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b ON b.id=a.catid
INNER JOIN jos_sections AS u ON u.id = a.sectionid
LEFT JOIN jos_jreviews_content AS jr ON jr.contentid = a.id
LEFT JOIN jos_jreviews_comments AS r ON r.pid = a.id
WHERE ( (LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%' OR LOWER(jr.email) LIKE '%tesco%' OR LOWER(jr.jr_address) LIKE '%tesco%' OR LOWER(jr.jr_town) LIKE '%tesco%' OR LOWER(jr.jr_postcode) LIKE '%tesco%' OR LOWER(jr.jr_telephone) LIKE '%tesco%' OR LOWER(jr.jr_fax) LIKE '%tesco%' OR LOWER(jr.jr_contactperson) LIKE '%tesco%' OR LOWER(jr.jr_website) LIKE '%tesco%' OR LOWER(jr.jr_email) LIKE '%tesco%' OR LOWER(jr.jr_gmap) LIKE '%tesco%' OR LOWER(jr.jr_othertel) LIKE '%tesco%' OR LOWER(jr.jr_vendor) LIKE '%tesco%' OR LOWER(jr.jr_vendorpage) LIKE '%tesco%' OR LOWER(jr.jr_expirydate) LIKE '%tesco%' OR LOWER(jr.jr_contactinfo) LIKE '%tesco%' OR LOWER(r.comments) LIKE '%tesco%' OR LOWER(r.title) LIKE '%tesco%') )
AND a.state = -1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
ORDER BY a.created DESC
LIMIT 5026
SELECT params
FROM jos_mambots
WHERE element = 'fireboard.searchbot'
AND folder = 'search'27
CREATE TABLE IF NOT EXISTS `jos_handy_php` ( `title` text NOT NULL, `text` text NOT NULL, `section` text NOT NULL, `href` text NOT NULL, `created` text NOT NULL, `keywords` text NOT NULL, `browsernav` tinyint(4) NOT NULL default '0', UNIQUE KEY `key` (`title`(10)) ) TYPE=MyISAM28
INSERT IGNORE INTO `jos_handy_php` (
`title`,
`text`,
`section`,
`href`,
`created`,
`keywords`,
`browsernav`
) VALUES (
'Handy PHP',
'Handy PHP offers scripts, discussions, tutorials, answers, and other resources for PHP. This includes a growing number of resources for the Joomla! - Content Management System. Your ideas and questions are always welcome. Thank you.',
'Joomla! & PHP Resources',
'http://www.handyphp.com/',
'',
'PHP, MySQL, JavaScript, HTML, XHTML, XML, CSS, Cascading Style Sheets, Joomla!, Tutorials, Functions, Scripts, Code, CMS, Content Management Systems, Forums, SMF, phpBB, Mambo, SearchBot, DocMan',
'1'
)29
SELECT id AS ItemId
FROM jos_menu
WHERE link = 'index.php?option=com_fireboard'30
SELECT a.title AS title,
a.text AS text,
a.created AS created,
a.section AS section,
a.browsernav AS browsernav,
a.href AS href
FROM jos_handy_php AS a
WHERE a.title LIKE '%tesco%'
OR a.text LIKE '%tesco%'
OR a.section LIKE '%tesco%'
LIMIT 5031
SELECT c.name AS title,
c.description AS text,
c.hits,
c.pub_access,
c.published,
c.pub_access,
'' AS created,
'Forum' AS section,
'2' AS browsernav,
CONCAT('index.php?option=com_fireboard&Itemid=', '92', '&func=showcat&catid=',c.id) AS href
FROM jos_fb_categories AS c
WHERE ( (LOWER(c.name) LIKE '%tesco%' OR LOWER(c.description) LIKE '%tesco%') )
AND c.published = 1
AND c.pub_access <= (SELECT gid FROM jos_users WHERE id = 0)
ORDER BY c.name DESC
LIMIT 5032
SELECT b.subject AS title,
a.message AS text,
b.hits,
c.pub_access,
c.published,
c.pub_access,
c.description,
FROM_UNIXTIME(b.time) AS created,
CONCAT('Forum','/', c.name) AS section,
'2' AS browsernav,
CONCAT('index.php?option=com_fireboard&Itemid=', '92', '&func=view&catid=',b.catid,'&id=',b.thread) AS href
FROM jos_fb_messages_text AS a
INNER JOIN jos_fb_messages AS b ON b.id = a.mesid
INNER JOIN jos_fb_categories AS c ON c.id = b.catid
WHERE ( (LOWER(b.subject) LIKE '%tesco%' OR LOWER(a.message) LIKE '%tesco%' OR LOWER(b.name) LIKE '%tesco%') )
AND c.published = 1
AND c.pub_access <= (SELECT gid FROM jos_users WHERE id = 0)
ORDER BY b.subject DESC
LIMIT 5033
SELECT params
FROM jos_mambots
WHERE element = 'marketplace.searchbot'
AND folder = 'search'34
SELECT id AS ItemId,
access AS Access,
FROM jos_menu
WHERE link = 'index.php?option=com_marketplace'35
SELECT a.name AS title,
a.description AS text,
a.published,
'' AS created,
'Forum' AS section,
'2' AS browsernav,
CONCAT('index.php?option=com_marketplace&page=show_category&catid=', a.id, '&Itemid=', '') AS href
FROM jos_marketplace_categories AS a
WHERE ( a.name LIKE '%tesco%'
OR a.description LIKE '%tesco%' )
AND a.published = 1
LIMIT 5036
SELECT a.ad_headline AS title,
a.ad_text AS text,
a.date_created AS created,
CONCAT('Forum','/', b.name) AS section,
'2' AS browsernav,
CONCAT('index.php?option=com_marketplace&page=show_ad&catid=', b.id, '&adid=', a.id, '&Itemid=', '') AS href
FROM jos_marketplace_ads AS a
INNER JOIN jos_marketplace_categories AS b ON b.id = a.category
WHERE ( a.ad_headline LIKE '%tesco%'
OR a.ad_text LIKE '%tesco%'
OR a.user LIKE '%tesco%' )
AND a.published = 1
AND b.published = 1
ORDER BY a.flag_top DESC, a.ad_headline DESC
LIMIT 5037
SELECT params
FROM jos_mambots
WHERE element = 'rssfactory.searchbot'
AND folder = 'search'38
SELECT item_title AS title,
item_date AS created,
item_description AS text,
channel_category AS section,
CONCAT( 'index.php?option=com_rssfactory&task=visit&linkvisited=', a.id ) AS href,
'1' AS browsernav
FROM jos_rssfactory_cache a
INNER JOIN jos_rssfactory AS b ON b.id = a.rssid
WHERE ( (LOWER(item_title) LIKE '%tesco%' OR LOWER(item_description) LIKE '%tesco%') )
AND b.published = 1
ORDER BY item_title ASC
LIMIT 5039
SELECT * FROM jos_rsgallery2_config WHERE `name` = 'imagepath'40
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_rsgallery2'41
SELECT id
FROM jos_mambots
WHERE element = 'rsgallery2.searchbot'
AND folder = 'search'42
SELECT *
FROM jos_mambots
WHERE id = '77'43
SELECT CONCAT(a.title,' - Foto') AS title,
a.descr AS text,
a.date AS created,
'0' AS browsernav,
CONCAT('http://www.hounslowtw3.net/index.php?option=com_rsgallery2&page=inline','&id=',a.id,'&catid=',a.gallery_id,'&limitstart=',a.ordering-1) AS href
FROM jos_rsgallery2_files AS a
INNER JOIN jos_rsgallery2_galleries
ON a.gallery_id=jos_rsgallery2_galleries.id
WHERE ((LOWER(a.name) LIKE '%tesco%' OR LOWER(a.descr) LIKE '%tesco%' OR LOWER(a.title) LIKE '%tesco%'))
AND jos_rsgallery2_galleries.published = 1
ORDER BY a.date DESC
LIMIT 5044
SELECT CONCAT(a.title,' - Foto') AS title,
a.descr AS text,
a.date AS created,
'0' AS browsernav,
CONCAT('http://www.hounslowtw3.net/index.php?option=com_rsgallery2&page=inline','&id=',a.id,'&catid=',a.gallery_id,'&limitstart=',a.ordering-1) AS href
FROM jos_rsgallery2_files AS a
INNER JOIN jos_rsgallery2_galleries
ON a.gallery_id=jos_rsgallery2_galleries.id
WHERE ((LOWER(a.name) LIKE '%tesco%' OR LOWER(a.descr) LIKE '%tesco%' OR LOWER(a.title) LIKE '%tesco%'))
AND jos_rsgallery2_galleries.published = 1
ORDER BY a.date DESC
LIMIT 50
LIMIT 5045
SELECT title as title,
b.start_date AS created,
b.description as text,
'Calendar Event' as section,
CONCAT('index.php?option=com_jcalpro&Itemid=99999999&extmode=view&extid=',extid) as href,
b.cat as category,
c.level as level,
'3' as browsernav
FROM jos_jcalpro_events AS b LEFT JOIN jos_jcalpro_categories AS c ON c.cat_id=b.cat
WHERE (LOWER(b.title) LIKE '%tesco%' OR LOWER(b.description) LIKE '%tesco%' OR LOWER(c.cat_name) LIKE '%tesco%' OR LOWER(c.description) LIKE '%tesco%')
AND approved=146
SELECT a.title AS title,
a.created AS created,
CONCAT(a.introtext, a.fulltext) AS text,
CONCAT_WS( '/', u.title, b.title ) AS section,
CONCAT( 'index.php?option=com_content&task=view&id=', a.id ) AS href,
'2' AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b ON b.id=a.catid AND b.access <= '0'
LEFT JOIN jos_sections AS u ON u.id = a.sectionid
WHERE ( (LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%') )
AND a.state = '1'
AND a.access <= '0'
AND u.published = '1'
AND b.published = '1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
ORDER BY a.created DESC47
SELECT a.title AS title, a.created AS created,
a.introtext AS text,
CONCAT( 'index.php?option=com_content&task=view&id=', a.id, '&Itemid=', m.id ) AS href,
'2' as browsernav, 'Menu' AS section
FROM jos_content AS a
LEFT JOIN jos_menu AS m ON m.componentid = a.id
WHERE ((LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%'))
AND a.state='1' AND a.access<='0' AND m.type='content_typed'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
ORDER BY a.created DESC48
SELECT a.title AS title,
a.created AS created,
a.introtext AS text,
CONCAT_WS( '/', 'Archived ', u.title, b.title ) AS section,
CONCAT('index.php?option=com_content&task=view&id=',a.id) AS href,
'2' AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b ON b.id=a.catid AND b.access <='0'
LEFT JOIN jos_sections AS u ON u.id = a.sectionid
WHERE ( (LOWER(a.title) LIKE '%tesco%' OR LOWER(a.introtext) LIKE '%tesco%' OR LOWER(a.fulltext) LIKE '%tesco%' OR LOWER(a.metakey) LIKE '%tesco%' OR LOWER(a.metadesc) LIKE '%tesco%') )
AND a.state = '-1' AND a.access <= '0'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2007-08-13 08:30:30' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2007-08-13 08:30:30' )
ORDER BY a.created DESC49
SELECT params
FROM jos_mambots
WHERE element = 'weblinks.searchbot'
AND folder = 'search'50
SELECT a.title AS title,
a.description AS text,
a.date AS created,
CONCAT_WS( ' / ', 'Web Links', b.title ) AS section,
'1' AS browsernav,
a.url AS href
FROM jos_weblinks AS a
INNER JOIN jos_categories AS b ON b.id = a.catid
WHERE ((LOWER(a.url) LIKE '%tesco%' OR LOWER(a.description) LIKE '%tesco%' OR LOWER(a.title) LIKE '%tesco%'))
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.date DESC
LIMIT 5051
SELECT params
FROM jos_mambots
WHERE element = 'contacts.searchbot'
AND folder = 'search'52
SELECT a.name AS title,
CONCAT_WS( ', ', a.name, a.con_position, a.misc ) AS text,
'' AS created,
CONCAT_WS( ' / ', 'Contact', b.title ) AS section,
'2' AS browsernav,
CONCAT( 'index.php?option=com_contact&task=view&contact_id=', a.id ) AS href
FROM jos_contact_details AS a
INNER JOIN jos_categories AS b ON b.id = a.catid
WHERE ( a.name LIKE '%tesco%'
OR a.misc LIKE '%tesco%'
OR a.con_position LIKE '%tesco%'
OR a.address LIKE '%tesco%'
OR a.suburb LIKE '%tesco%'
OR a.state LIKE '%tesco%'
OR a.country LIKE '%tesco%'
OR a.postcode LIKE '%tesco%'
OR a.telephone LIKE '%tesco%'
OR a.fax LIKE '%tesco%' )
AND a.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 5053
SELECT params
FROM jos_mambots
WHERE element = 'categories.searchbot'
AND folder = 'search'54
SELECT a.name AS title,
a.description AS text,
'' AS created,
'2' AS browsernav,
'' AS section,
'' AS href,
s.id AS secid, a.id AS catid,
m.id AS menuid, m.type AS menutype
FROM jos_categories AS a
INNER JOIN jos_sections AS s ON s.id = a.section
LEFT JOIN jos_menu AS m ON m.componentid = a.id
WHERE ( a.name LIKE '%tesco%'
OR a.title LIKE '%tesco%'
OR a.description LIKE '%tesco%' )
AND a.published = 1
AND s.published = 1
AND a.access <= 0
AND s.access <= 0
AND ( m.type = 'content_section' OR m.type = 'content_blog_section'
OR m.type = 'content_category' OR m.type = 'content_blog_category')
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 5055
SELECT params
FROM jos_mambots
WHERE element = 'sections.searchbot'
AND folder = 'search'56
SELECT a.name AS title,
a.description AS text,
'' AS created,
'2' AS browsernav,
a.id AS secid, m.id AS menuid, m.type AS menutype
FROM jos_sections AS a
LEFT JOIN jos_menu AS m ON m.componentid = a.id
WHERE ( a.name LIKE '%tesco%'
OR a.title LIKE '%tesco%'
OR a.description LIKE '%tesco%' )
AND a.published = 1
AND a.access <= 0
AND ( m.type = 'content_section' OR m.type = 'content_blog_section' )
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 5057
SELECT params
FROM jos_mambots
WHERE element = 'newsfeeds.searchbot'
AND folder = 'search'58
SELECT a.name AS title,
'' AS created,
a.link AS text,
CONCAT_WS( ' / ','News Feeds ', b.title )AS section,
CONCAT( 'index.php?option=com_newsfeeds&task=view&feedid=', a.id ) AS href,
'1' AS browsernav
FROM jos_newsfeeds AS a
INNER JOIN jos_categories AS b ON b.id = a.catid
WHERE ( (LOWER(a.name) LIKE '%tesco%' OR LOWER(a.link) LIKE '%tesco%') )
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.name ASC
LIMIT 5059
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
LIMIT 160
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'61
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 = '99999999' )
ORDER BY ordering62
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering63
SELECT a.id, a.catid, a.sectionid, a.title, a.created, a.introtext, a.fulltext, a.images, a.attribs AS `params`
FROM jos_content AS a
LEFT JOIN jos_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 <= '2007-08-13 08:30:30' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-08-13 08:30:30' )
AND a.access <= '0'
AND f.content_id IS NULL
AND ( a.id IN (435) )
ORDER BY a.ordering LIMIT 0,164
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 435
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id65
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 066
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 067
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=435〈=en&task=view'
LIMIT 168
SELECT sectionid from jos_content WHERE id = 43569
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 170
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=435'71
SELECT count(content_id) from jos_content_frontpage WHERE content_id = 43572
SELECT title_alias FROM jos_content WHERE id=43573
SELECT a.title_alias AS title FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=43574
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_content&id=435〈=en&task=view'75
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering76
SELECT published,params FROM jos_mambots WHERE element = 'jreviews' AND folder = 'content'77
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'78
SELECT *
FROM jos_mambots
WHERE id = '59'79
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_tabs_slides' AND folder = 'content'80
SELECT *
FROM jos_mambots
WHERE id = '40'81
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'82
SELECT *
FROM jos_mambots
WHERE id = '38'83
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'84
SELECT *
FROM jos_mambots
WHERE id = '38'85
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'86
SELECT *
FROM jos_mambots
WHERE id = '38'87
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'88
SELECT *
FROM jos_mambots
WHERE id = '38'89
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'90
SELECT *
FROM jos_mambots
WHERE id = '41'91
SELECT *
FROM jos_categories
WHERE id = '64'92
SELECT *
FROM jos_sections
WHERE id = '12'93
SELECT a.id, a.catid, a.sectionid, a.title, a.created, a.introtext, a.fulltext, a.images, a.attribs AS `params`
FROM jos_content AS a
LEFT JOIN jos_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 <= '2007-08-13 08:30:30' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-08-13 08:30:30' )
AND a.access <= '0'
AND f.content_id IS NULL
AND ( a.id IN (713) )
ORDER BY RAND() LIMIT 0,194
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 713
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id95
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=713〈=en&task=view'
LIMIT 196
SELECT sectionid from jos_content WHERE id = 71397
SELECT count(content_id) from jos_content_frontpage WHERE content_id = 71398
SELECT title_alias FROM jos_content WHERE id=71399
SELECT a.title_alias AS title FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=713100
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_content&id=713〈=en&task=view'101
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'102
SELECT *
FROM jos_mambots
WHERE id = '59'103
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_tabs_slides' AND folder = 'content'104
SELECT *
FROM jos_mambots
WHERE id = '40'105
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'106
SELECT *
FROM jos_mambots
WHERE id = '38'107
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'108
SELECT *
FROM jos_mambots
WHERE id = '38'109
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'110
SELECT *
FROM jos_mambots
WHERE id = '38'111
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'112
SELECT *
FROM jos_mambots
WHERE id = '38'113
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_sig' AND folder = 'content'114
SELECT *
FROM jos_mambots
WHERE id = '41'115
SELECT *
FROM jos_categories
WHERE id = '43'116
SELECT *
FROM jos_sections
WHERE id = '11'117
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1118
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=login'
LIMIT 1119
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=99999999〈=en&task=login'120
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=lostPassword'
LIMIT 1121
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=99999999〈=en&task=lostPassword'122
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=registers'
LIMIT 1123
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=99999999〈=en&task=registers'124
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'termsmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering125
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1126
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=50'127
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=855'128
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=53'129
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=89&id=1〈=en&task=archivesection'
LIMIT 1130
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=170'131
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=169'132
SELECT guest, usertype
FROM jos_session133
SELECT a.username, a.userid as uid,a.usertype AS type , c.avatar, c.cb_pgtotalitems as imagecount
FROM jos_session AS a
LEFT JOIN jos_comprofiler AS c ON (a.userid = c.user_id)
WHERE a.userid != 0 GROUP BY a.username134
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=userProfile&user=62'
LIMIT 1135
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=89〈=en&task=userProfile'136
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=userProfile&user=62'
LIMIT 1137
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=89〈=en&task=userProfile'138
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler〈=en&task=userProfile&user=62'
LIMIT 1139
SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&Itemid=89〈=en&task=userProfile'140
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering

hope this helps!

Paul

Thanks for the information Paul.

I see that you performed the search as a guest user which is where the problem was. The new method I used for retrieving the access level for the user no matter what authorization system the site owner may have installed didn't understand how to deal with the guest user. Since the guest user is referred to as user id "0" and the user table doesn't have a user "0", the system wasn't returning results correctly.

The script has been fixed and tested for multiple user levels and can be re downloaded at your convenience.

Thank You,
vujsa

Many thanks vujsa!