my result:

SQL-query: Documentatie

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 '%youtube%'
OR LOWER( a.message ) LIKE '%youtube%'
OR LOWER( b.name ) LIKE '%youtube%'
)
)
AND c.published =1
AND c.pub_access <= (
SELECT gid
FROM jos_users
WHERE id =62 )
ORDER BY b.time DESC
LIMIT 50

MySQL retourneerde: Documentatie
#1064 - You have an error in your SQL syntax near 'SELECT gid FROM jos_users WHERE id = 62)
ORDER BY b.time DESC
LIMIT 50' at line 16

I have found the problem.
This is an incompatibility issue with MySQL versions below 4.1. The SearchBot uses a sub query for efficiency but that syntax is not supported on MySQL 4.0 and below. I am currently testing a MySQL 4.0 patched version and will release is as soon as possible.

Thank You,
vujsa

Good luck!! Glad I could help!<br><br>Post edited by: Samster, at: 2007/09/22 14:06

JoomlaBoard SearchBot 1.2.1 and FireBoard SearchBot 1.2.1 have been released.

These new versions have been rewritten to make them compatible with versions of MySQL 4.0 and below. While this has added a few more lines of code and another database query, this is the only practical way to overcome the compatibility issue.

If your server is using any version of MySQL below 5.0, you really should ask your web hosting service to upgrade. The MySQL software doesn't cost anything to obtain but they will want to hold off since the server has to be reconfigured and recompiled for the new version. In many cases, their server software is bundled like cPanel and they do have to buy an upgrade for that which is rather costly. If they are unwilling to upgrade, I suggest looking into other solutions and once you have one, inform your provider that you will be terminating your account if the cannot upgrade.

vujsa

I try to Download the new version since two hours.
Every time i get the message that this file is edit / Updated by an User.

The document is being edited/updated by an user and is unavailable at this moment.

same here