vitbrevis,
Please read the following: http://www.handyphp.com/component/option,com_fireboard/Itemid,21/func,view/id,239/catid,15/
You'll have to either post the data here or send it to the email address I'll send you. The email system tries to filter out HTML and as a result, mistakes some of the required data as HTML.
Please answer the following questions as well:
What version of PHP are you using?
What version of MySQL are you using?
Are you using some authorization system for Joomla other than the default such as JACLPlus?
Are there any other searchbots that seem to have similar problems on your site?
My hunch is that you are also using MySQL 4.0 whereas I developed the SearchBot on MySQL 5.0.27
Anyone experiencing a problem with this SearchBot, please do the following:
If you have access to your database with a tool such as
phpMyAdmin, please try the following SQL command on your database:
| Code: |
SELECT b.subject AS title,
a.message AS text,
b.hits,
c.pub_access,
c.published,
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 ( (LOWER(b.subject) LIKE '%sample%' OR LOWER(a.message) LIKE '%sample%' OR LOWER(b.name) LIKE '%sample%') )
AND c.published = 1
AND c.pub_access <= (SELECT gid FROM jos_users WHERE id = 62)
ORDER BY b.time DESC
LIMIT 50
|
Be sure to change
sample to a term that can actually be found on your forums:
'%sample%' -> '%my term%'
If there is an error returned, please post that here as well. That will tell me if it is an incompatibility issue or not. If it doesn't give and error
AND returns zero results, then I'll know it is a situation where my database somehow differs from yours.
I'm sorry, I'm asking for a lot of input from all of you to try and fix this issue. Unfortunately, I can only resolve the problem if I can somehow replicate it on my system. I have looked through all of the queries sent to me so far and have found zero errors in them. The error message I have been sent refers to a MySQL error but the PHP code is generating the exact same MySQL statement that is being produced on my website. That statement is working without error on my website and in my tests directly on the database.
I had hoped that there was a PHP bug that was producing a "bad" MySQL statement but that isn't the case. My next focus will be on compatibility. I think that I can resolve the issue by using a less efficient method to gather the user's authorization level but I don't want to get ahead of myself.
With any luck, not that I have had any yet, I can simply add a line or two to check the joomla installation and determine the best method to handle the search.
Thank you,
vujsa<br><br>Post edited by: vujsa, at: 2007/09/20 14:08
Forum 
Favoured: 0
