Tech
Joomla, Fireboard and Serious Database Problem - I have the solution PDF Print E-mail
Written by Sachin Devand   
Saturday, 09 February 2008

Did you install the latest version of Fireboard - 1.0.4 on Joomla 1.0.13?
The screen shots looked very promising and the installation flawless. The problem started when I wanted to make my first post. I got the following error:

"fireboard Serious db problem:You have an error in your SQL" this was followed by a big SELECT statement.

There were lots of suggestions I found on the web starting from changing to latest version of MySQL to downgrading a version of Fireboard and Joomla. But here is a simple solution that I saw that worked for me:

All you have to do is modify line # 220 in following file:

$JOOMLA_INSTALLATION/components/com_fireboard/template/default/post.php

The line looks something like this:

$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'");

Just change the 'JOIN' to 'LEFT JOIN' and you are done. You will now be able to save posting. You can see it in action on my site here

Last Updated ( Thursday, 21 February 2008 )