I installed the component, finished the installation (clean install), and installed the sample data. I get this error when I try to access the "Forum Administration" page:

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

Did I miss something?

Joomla 1.5 Beta 2
Fireboard 1.0.1

I am not sure that FB works with Joomla 1.5 yet.

In the README that I got with the download, it said it supports Joomla 1.5.

Just sent you a message -

Please make sure you are running 1.5 in compatibility mode. Also Fireboard will not fully support 1.5 until this fall.

Ahh ok. I'll see how I can help from my end.

joomla 1.5 beta 2
fireboard 1.0.1 beta
install clean complete.

I recieve the same problem :

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

Please help me !!!

Same problem here. Anyony found a fix yet

Got the same error on my 1.5 joomla installation. It's a clean installation without anny other modifications. Is there allready a solution, or is it best to look to some other forum software ?


[code:1]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[/code:1]

Hi,

I ran across this error, too. This is because there was a small schema change in the database around some of the access table--the column called "group_id" in #__core_acl_aro_groups got changed to "id". So you can edit the offending database call in administrator/components/com_fireboard/admin.fireboard.php.

It's at line 400, and you need to change two items: g.group_id to g.id, and h.group_id to h.id.

That fixes this admin error. I'm still having trouble, though, with line 437 in this file... apparently mosTreeRecurse() went away, or changed somehow--it's returning NULL which makes it so you can't administer forums and categories... haven't had a chance to track this issue down.