Fixing Database Error 1054 in Fireboard
Posted by Johan Cyprich on 05 Sep 2007 | Tagged as: How To
I found another problem with Fireboard. After I installed it, I went to the Forum Administration option in the Fireboard Control Panel and got the following error:
—
DB function failed with error number 1054
Unknown column ‘g.group_id’ in ‘on clause’ SQL=SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup FROM jos_fb_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_core_acl_aro_groups AS g ON g.group_id = a.pub_access LEFT JOIN jos_core_acl_aro_groups AS h ON h.group_id = a.admin_access GROUP BY a.id ORDER BY a.ordering, a.name
—
I found the solution from terrox in the Fireboard forums. You can fix the problem by downloading admin.fireboard.zip and extracting it to the /administrator/components/com_fireboard folder in your Joomla installation. There is a folder called /components/com_fireboard that can easily be confused with the correct folder. Keep in mind that you are replacing the admin.fireboard.php file. If you are not prompted with a message asking to replace a file, your probably copying to the wrong folder.
The Forum Administration option should then work correctly and you can begin creating forums for your web site.
Tweet This Post!| Related posts: | |
|
|
Share this post:
Follow Me:
Did you find this post interesting and useful? You can keep up to date on this blog by subscribing to my RSS feed, or you can have new posts sent to you by e-mail. You can also follow me on Twitter.
12 Comments »
on 17 Feb 2008 at 8:35 am 1.Mike Addington said …
Didn’t work for me. I still get the error.
on 19 Feb 2008 at 4:50 am 2.Johan Cyprich said …
Are you using the latest version of Fireboard (1.04)? Which version of Joomla are you using?
on 20 Mar 2008 at 10:26 pm 3.Dan said …
I have Joomla 1.0.14 installed and FireBoard 1.0.4 Stable installed. I get the following error when I click the Fireboard Administrator button:
“DB function failed with error number 1054
Unknown column ‘g.id’ in ‘on clause’ SQL=SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup FROM thedoor_fb_categories AS a LEFT JOIN thedoor_users AS u ON u.id = a.checked_out LEFT JOIN thedoor_core_acl_aro_groups AS g ON g.id = a.pub_access LEFT JOIN thedoor_core_acl_aro_groups AS h ON h.id = a.admin_access GROUP BY a.id ORDER BY a.ordering, a.name”
I used the file above with no luck and I can’t find any solutions on the bestofjoomla website.
on 21 Mar 2008 at 12:32 am 4.Johan Cyprich said …
Can you setup a new web site with Joomla and Fireboard to see if it will work? There could be plugins interfering with Fireboard. Also, you might also want to use Joomla 1.0.15 for the test.
on 17 Apr 2008 at 7:19 pm 5.ingeniousity said …
I have exactly the same thing.
I was using Joomla 1.0.10, CB 1.1, and Fireboard 1.0.4 all newly installed. Maybe I’ve missed a component?
I have just installed Joomla 1.0.15 to see if that helps (it doesn’t) and received the following warning after logging in:
Following PHP Server Settings are not optimal for Security and it is recommended to change them:
* PHP register_globals setting is `ON` instead of `OFF`
* Joomla! “Register Globals Emulation” setting is `ON`. To disable Register Globals Emulation, navigate to Site -> Global Configuration -> Server, select `OFF`, and save.
Register Globals Emulation is `ON` by default for backward compatibility.
on 17 Apr 2008 at 7:29 pm 6.ingeniousity said …
Uninstalled fireboard, the SEF thing in case that was causing the problem, and also the mass mail thing.
Re-installed fireboard only, with no error messages but still can’t access the Admin panel for FB. Tried installing the file linked above, but still no good.
I’m going to delete the whole thing, including the database, and start again from zero. Will let you know if it works. If not, well I have nothing to lose by giving a password to anyone qualified to help. There seem to be a lot of people having this problem, but no answers forthcoming.
Thanks for any advice.
on 17 Apr 2008 at 8:43 pm 7.Johan Cyprich said …
If your still having problems with your installation, I can do a fresh installation on your server if you send me the appropriate login information (don’t post it here). I would recommend using Joomla 1.5 because it replaces the 1.0 version. The newest and best extensions and templates will be for 1.5.
on 02 May 2008 at 5:34 am 8.Aria said …
Hi,
Am a newbie to CMS, joomla and fireboard, but giving it a go.
I have Joomla 1.5 going, added Community Builder and finally installed fireboard 1.0.4. Joomla and CB seem to be running alright. Fireboard is there, with control panel and all, BUT… I cannot seem to add a category, hence no threads or forum. I am also not able to add sample data.. obviously something not right with adding to the database, but what? I’ve been scouring the forums and trying just about everything,including this idea of the file you offered.
Problem is… the error message I am getting is blank.. that is.. an alert pops up, but it just has the exclamation icon and no message, so I don’t know what is wrong. Any ideas? Really like the idea of fireboard otherwise gonna head to phpBB3. Any assist would be very much appreciated.
on 05 May 2008 at 4:05 pm 9.Aria said …
Hi!
Back to say that my fireboard woes are gone, and I am now able to happily explore the features of this message board. How? Well I couldn’t help but believe the problems had to do with save.session_path… errors kept popping up here and there pointing to it.
Finally, a rep at the hosting company suggested I write the following in .htaccess:
php_value session.save_path /tmp
That seemed to do the trick.
I’ve also learned to do anything that will enable access to the server and the database, so I think special care should be taken to make sure the database is using utf-8 coding, that your ftp is enabled in joomla, and that the target folders are writable.
Hope this will be of help.
on 05 May 2008 at 4:23 pm 10.Johan Cyprich said …
I find that many people are having difficult with installing web applications due to problems configuring .htaccess. I’m currently writing an e-book on how to effectively use .htaccess and I should expand it further to include PHP configuration commands.
Its usually a minor fix in .htaccess which solves most problems, but the trick is knowing what to fix which the typical webmaster doesn’t know due to poor documentation on the technology.
on 06 Oct 2008 at 4:59 pm 11.werutzb said …
Hi!
I would like extend my SQL capabilities.
I red really many SQL resources and still feel, that I am not a whise man
in SQL. What can you recommend?
Thanks,
Werutz
on 07 Oct 2008 at 10:28 am 12.Johan Cyprich said …
There is a good tutorial here: http://www.sqlcourse.com/.