Cyprich.com

Occasionally Relevant Insights from a Software Builder

By

Fixing Database Error 1054 in Fireboard

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.

14 Responses to Fixing Database Error 1054 in Fireboard

  1. Didn’t work for me. I still get the error.

  2. Johan says:

    Are you using the latest version of Fireboard (1.04)? Which version of Joomla are you using?

  3. Dan says:

    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.

  4. Johan says:

    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.

  5. ingeniousity says:

    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.

  6. ingeniousity says:

    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.

  7. Johan says:

    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.

  8. Aria says:

    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.

  9. Aria says:

    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.

  10. Johan says:

    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.

  11. werutzb says:

    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

  12. Jestine says:

    Hey would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 completely different browsers and I must say this blog loads a lot quicker then most. Can you recommend a good internet hosting provider at a reasonable price? Thanks a lot, I appreciate it!

Leave a Reply

Your email address will not be published. Required fields are marked *