How very odd -- I copied and pasted the entire thing! I'll try again, and see if only putting in part of it (say, 25-35?) helps it go through all right.

Again, a query was omitted from the PM and at the same bit of code as before. For whatever reason, your Joomla installation, server, or browser is omitting LESS THAN "<" symbols from ALL queries you have sent me. As a result, many of your SearchBots are not actually functioning but you probably didn't notice since the components they search are either not used by you or have so little data in them that you wouldn't expect to get many results from them. For example, based on the debug information you sent, the SearchBot that searches the contacts component is also broken. I also believe that the SearchBot for your newsfeeds component is affected as well.

Unfortunately, I can not find any problem from the debug info that would explain why this is happening. Usually, when a query is damaged in this way, PHP sends it as is and MySQL does it's best to match it but in this case, the query is checking the access level of the resource against an entity that it will never match. And PHP never notices that the query might be wrong.

So we'll try and get more information.
I need you to turn your error reporting on to the highest setting:
First go to your Admin Control Panel.

Click on Site -> Global Configuration -> Server [TAB] -> Error Reporting (Maximum)
Go ahead and turn the debug on again as well.

Perform the same query and return all warnings and errors that you might get along with the debug queries.

If your website is omitting queries, we really need to find out why and try to find a solution for that. I think that by fixing this, we can get the SearchBot working for you.

vujsa

By the way, would you mind PM'ing me the address to your website so I might see first hand what might be happening.

Since PMs are eating everything after a <, let's try this.

Code:

26 SELECT params FROM jos_mambots WHERE element = 'fireboard.searchbot' AND folder = 'search' 27 SELECT id AS ItemId FROM jos_menu WHERE link = 'index.php?option=com_fireboard' 28 SELECT c.name AS title, c.description AS text, c.pub_access, c.published, c.pub_access, '' AS created, 'Forum' AS section, '2' AS browsernav, CONCAT('index.php?option=com_fireboard&Itemid=', '26', '&func=showcat&catid=',c.id) AS href FROM jos_fb_categories AS c WHERE ( c.name LIKE '%poking%' OR c.description LIKE '%poking%' ) AND c.published = 1 AND c.pub_access <= 2 LIMIT 50 29 SELECT b.subject AS title, a.message AS text, 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=', '26', '&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 ( b.subject LIKE '%poking%' OR a.message LIKE '%poking%' OR b.name LIKE '%poking%' OR c.name LIKE '%poking%' OR c.description LIKE '%poking%' ) AND c.published = 1 AND c.pub_access <= 2 ORDER BY b.subject DESC LIMIT 50 30 SELECT f.* FROM jos_comprofiler_fields f WHERE f.published=1 AND f.profile = 1 AND f.name<>'NA' ORDER BY f.ordering 31 SELECT b.name AS title, b.name AS text, b.registerDate AS created, 'Community Buidler' AS section, '2' AS browsernav, CONCAT( 'index.php?option=com_comprofiler&task=userProfile&user=', a.id ) AS href FROM jos_comprofiler AS a INNER JOIN jos_users AS b ON b.id = a.user_id WHERE ((LOWER(b.name) LIKE '%poking%' OR LOWER(b.lastvisitDate) LIKE '%poking%' OR LOWER(b.registerDate) LIKE '%poking%' OR LOWER(a.avatar) LIKE '%poking%' OR LOWER(b.username) LIKE '%poking%' OR LOWER(a.firstname) LIKE '%poking%' OR LOWER(a.middlename) LIKE '%poking%' OR LOWER(a.lastname) LIKE '%poking%' OR LOWER(a.lastupdatedate) LIKE '%poking%' OR LOWER(b.email) LIKE '%poking%' OR LOWER(a.website) LIKE '%poking%' OR LOWER(a.location) LIKE '%poking%' OR LOWER(a.occupation) LIKE '%poking%' OR LOWER(a.interests) LIKE '%poking%' OR LOWER(a.company) LIKE '%poking%' OR LOWER(a.city) LIKE '%poking%' OR LOWER(a.state) LIKE '%poking%' OR LOWER(a.zipcode) LIKE '%poking%' OR LOWER(a.country) LIKE '%poking%' OR LOWER(a.address) LIKE '%poking%' OR LOWER(a.phone) LIKE '%poking%' OR LOWER(a.fax) LIKE '%poking%')) AND a.banned = 0 ORDER BY b.name DESC 32 SELECT params FROM jos_mambots WHERE element = 'weblinks.searchbot' AND folder = 'search'

Well, unless you have altered the queries you posted, it says that your user group ID (GID) is 2! For a Super Admin, it should be 25. Since your GID is being read as 2, it lower than the required GID for the resources you are trying to match.

Are you using some type of user group component or hack to increase the functionality of your authorization system? Since the biggest problem with Joomla is it's limited way in which it can create and set permissions for new user groups, many users upgrade the default system. If you are using such an upgrade, then it could cause the problem.
Here is the problem in the query:

Code:

AND c.pub_access <= 2

I would need to replicate your installation to perform the testing needed to find the problem. Please submit a list of add-ons and hacks you have performed and I'll try to figure out the problem. Funny thing is, I didn't actually create the FireBoard SearchBot! I created the JoomlaBoard SearchBot which the author of FireBoard modified to use with FireBoard. The system is the same and he was considerate enough to give me credit since he only changed about 50 characters of code. Right now, my guess is that there is a conflicting component work here. I have a hard time fixing errors when I can't duplicate them on my server. So I usually have to do a lot of guessing and frequently guess wrong since I have limited access to the data. If I could analyze the database, code, and settings first hand, the process would be easier but that just isn't an option. I hope we can resolve this issue soon. vujsa

Well, I wasn't using a superadmin-level account to do the search -- I've just done it with that account, and in 28 and 29 I still get

Code:

AND c.pub_access <= 2

Hmm. I don't have any hacks or components dealing with groups (although I did wish for one -- I couldn't find any that fit what I wanted so I didn't put any in). While this is the only one of my searchbots using pub_access (which I assume therefore is a forum db field), the others in similar places have things like: AND b.access <= 2 So the number seems to be the same there. All the other searchbots have

Code:

. "\n AND c.pub_access <= $my->gid"

as opposed to

Code:

. "\n AND c.pub_access <= " . (int) $my->gid

...but making it match as a test didn't fix it (or break it, for that matter). Just checked two accounts -- one (correctly) giving `usertype`='Publisher' and one (correctly) giving `usertype`='Super Administrator' but BOTH (correctly? incorrectly?) giving `gid`='2'. ::does some research:: Okay, it looks like that should be right? The Joomla Developer Network says that on the frontend,

Code:

$my→gid = 0 =⇒ the user is not logged in $my→gid = 1 =⇒ the user is a registered user $my→gid = 2 =⇒ the user is a special user

Publisher and Superadmin are both special, so that seems right. Hrm. I wonder if it's not finding, or not reporting? I'll poke at more things and see if I find anything notable...<br><br>Post edited by: Ninjakitten, at: 2007/07/23 16:29

Let's try this again:

Code:

$my->gid = 0 => the user is not logged in $my->gid = 1 => the user is a registered user $my->gid = 2 =>the user is a special user

<br><br>Post edited by: Ninjakitten, at: 2007/07/23 16:32