hi all

i got a problem after installing the Fireboard.

below the error

[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]

i think is a problem on db .. im not a expert ..

can you post below the db query to do for fix that ?

thx in advance.

Post edited by: Phosphorus, at: 2007/05/02 11:46

Maybe u fix problem if reinstall FB. Check your MySql to work properly, if u do not do about her, call your hosting provider and explain him problem. This error is not so popular...

all work fine and re install dont fix that probs.

the code part prob is on file "admin.fireboard.php"

btw i found that (below) on joomla forum.

Basically what has happened is that the phpGACL library has been updated in the current release compared to 1.0. During this update the database has changed that phpgacl uses. There is a way to do permissions using the phpGacl library. The fireboard author hasn't used the library methods.

Post edited by: Phosphorus, at: 2007/05/02 14:25

any help ? im not alone with that probs...

i think is cause of MySQL5.0

I think I have solved this issue, at least it seems to work for me.

It has been a slight change in table structure in Joomla 1.5, and the legacy support for mosTreeRecurse dosen't seem to work correctly or at least not for Fireboard.

extract attatched file to: /administrator/components/com_fireboard

Post edited by: gerri28, at: 2007/05/05 16:13

Has this worked for anyone cuz it didn't work for me?

CORRECTION:

IT WORKS!!!

Thank you.

Post edited by: darkhelmet, at: 2007/05/20 08:22

My understanding is that the .zip file above contains this code STARTING AT LINE 417 >>>

[code:1] $database->setQuery("SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup" . "nFROM #__fb_categories AS a"
// . "nLEFT JOIN #__fb_categories AS b ON b.id = a.parent"
. "nLEFT JOIN #__users AS u ON u.id = a.checked_out" . "nLEFT JOIN #__core_acl_aro_groups AS g ON g.id = a.pub_access"
. "nLEFT JOIN #__core_acl_aro_groups AS h ON h.id = a.admin_access" . "n GROUP BY a.id" . "n ORDER BY a.ordering, a.name"«»);
[/code:1]

[color=#FF0000]Which replaces the following code in the current admin.fireboard.php file AT "APPROXIMATELY" LINE 371 ([i]depending on build date[/i]):[/color]

[code:1] $database->setQuery("SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup" . "nFROM #__fb_categories AS a"
/* . "nLEFT JOIN #__fb_categories AS b ON b.id = a.parent"*/
. "nLEFT JOIN #__users AS u ON u.id = a.checked_out"
. "nLEFT JOIN #__core_acl_aro_groups AS g ON g.group_id = a.pub_access" . "nLEFT JOIN #__core_acl_aro_groups AS h ON h.group_id = a.admin_access" . "n GROUP BY a.id" . "n ORDER BY a.ordering, a.name"«»);[/code:1]

This worked for me on 8-06-2007 with FireBoard 1.0.2 SVN nightly and Joomla 1.5 nightly. Substituting only this section retains the newest FireBoard admin development work accomplished since this "very welcome" adjustment was published some months ago. For me, this was a preferred alternative to completely replacing admin.fireboard.php with the older file.

gerri28 wrote:
I think I have solved this issue, at least it seems to work for me.

Worked for me too! Many thanks

sorry how do i do this?

i have tried to installed the zipped file and it said:

"Error! Could not find an XML setup file in the package."

how do "extract attatched file to: /administrator/components/com_fireboard"?

many many thanks for any help