I just upgraded to 1.0.4 from 1.0.3. The forum is working fine except for the following message that I get when trying to post a new topic:

Serious db problem:You have an error in your SQL syntax near 'ON id=mesid WHERE userid=64 AND name='Glente' AND email=' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it ' AND s' at line 1 SQL=SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=64 AND name='Glente' AND email=' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it ' AND subject='test' AND ip='213.185.22.87' AND message='test' AND time>='1198975003'

I had the same problem and I did 2 things to fix it. I don't know which one actually did the trick, but assume it was 2):
1) I uploaded the update files again to ensure everything got there correctly.
2) I updated the SQL DB from 3.x to 4.x

I have the same problem - who can help us?

I cannot upgrade the DB since I don't have admin rights on the server.

I tried to uninstall FB and then do an install of the full version of FB 1.0.4.

The problem persisted...

Any ideas?

You will need to get acces to the database to performs a proper upgrade or clean install. There's no way around it. Perhaps you can install a component in Joomla that will allow it. EasySQL comes to mind first. There are others. Check extentions.joomla.org.

Hi, I just did a clean install of Joomla 1.3 and the Firebird 1.4 and is getting the same error. Where do I look?

OK, I uninstall 1.4 install 1.3 and all is well. Will just stay with 1.3 unless you guys believe its necessary to upgrade

I think this problem can be found with older version of MySQL DB then 4.x

I solved this problem in /components/com_fireboard/template/default/post.php on line 220 :
modify in SQL query JOIN to LEFT JOIN

$database->setQuery("SELECT id FROM #__fb_messages LEFT JOIN #__fb_messages_text ON id=mesid WHERE userid={$my->id} AND name='$fb_authorname' AND email='$email' AND subject='$subject' AND ip='$ip' AND message='$message' AND time>='$duplicatetimewindow'";

I tested it on multiple sites and it seems to be working good

perfect! that did it for me. Just had to figure out that i should not search for "SQL JOIN" on line 220, but just for "JOIN"

thx a million!

I'm happy that's working also for others