|
Joomla, Fireboard and Serious Database Problem - I have the solution |
|
|
|
|
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 )
|