Hi --

Installed the fireboard searchbot (1.1.0), but it isn't returning any results. I'm searching for words I know are in a post, subject, or board title, but it tells me there are 0 results. I can't find any sign of anyone else having this problem, but I can't see what I could have done wrong. If I search for a word that appears elsewhere in the site, that shows up, so it doesn't seem to be search itself that's broken. A word in the forum and elsewhere brings up only the elsewhere result.

Using Joomla 1.0.12 and Fireboard 1.0.1. Sorry I can't give much more detail, but... there isn't much more to tell. Hope there's some obvious known problem I'm missing. Thanks.

My first guess is that the bot hasn't been published. My second thought would be that it's permissions are set for your user level but this would only occur if you weren't logged in or if your user level is below the required user authorization level. Since you are more than likely the Admin, I am going back to the unpublished theory.

Goto, Admin Control Panel -> Mambots -> Site Mambots -> FireBoard SearchBot -> Publish

If this doesn't do it, I'll need Debug information from your site to find the problem.

vujsa

Alas, it was (and is) published. And I'm Super Administrator, so that ought not be it. What do you need in the way of debug info?

Thanks for the help.

Sorry for the delay in getting back to you.

To get the Debugging information I need, you will have to go to your Admin Control Panel.
Click on Site -> Global Configuration -> Debug Site (Yes)

Once you have done this, perform a search that should return a result from your forum. In the results page, there may be an error or warning at the top of the results section. Probably just a warning since an error would have shown up sooner usually. If there is such a message, I'll need that but it probably is an array_merge() problem... I have gotten these warnings from users before but that doesn't really tell me much. What I really need should be at the bottom of the page.

There will be a very long list of database queries at the bottom of the page. Don't worry, your queries won't show me anything I shouldn't see unless it is the debug information shown during a log in attempt. Basically, every little bit of information shown on your page as one or more database queries associated with it. I'll need to review those queries and determine what is going wrong with the system.

Even though your queries won't show me something that could cause a security risk, you probably shouldn't publicly post it so here is the link you can use to send me a personal message:
PM vujsa

Once I analyze the data, I can either fix the searchbot or tell you how to fix your system.

vujsa

Thanks -- I'll PM that to you now.

Yes, I got your PM and the debug information and did see one problem with the search query but more importantly, I noticed several queries were missing!

I had a little trouble at first trying to read the queries since so many are missing and you are using a different database prefix than the default. Here is a filtered excerpt from your debug information that you forwardd to me.

Code:

31 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('My Forum','/', c.name) AS section, '2' AS browsernav, CONCAT('index.php?option=com_fireboard&Itemid=', '99', '&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 '%searchterm%' OR a.message LIKE '%searchterm%' OR b.name LIKE '%searchterm%' OR c.name LIKE '%searchterm%' OR c.description LIKE '%searchterm%' ) AND c.published = 1 AND c.pub_access folder = 'search'

Notice the last line where it reads "AND c.pub_access folder = 'search'", this is incorrect. It looks like two queries spliced together. After "AND c.pub_access", there should be the following:

Code:

<= 99 LIMIT 0, 50

The query shown above is number 31. I really need queries 28, 29, 30, and 31 to get all of the FireBoard SearchBot data. I hope the added data will show me the problem. vujsa