Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
DB function failed with error number 1054
TOPIC: DB function failed with error number 1054
#6742
DB function failed with error number 1054 5 Years ago  
I tried installing this in a clean Joomla 1.5 environment with no other components installed.

Legacy was turned on.

I choose a clean install and loaded sample data.

When I click \"Forum Administration\" I get this message:

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

Any clues?

Kind regards
Webtytte
#6742
DB function failed with error number 1054 5 Years ago  
I tried installing this in a clean Joomla 1.5 environment with no other components installed.

Legacy was turned on.

I choose a clean install and loaded sample data.

When I click \"Forum Administration\" I get this message:

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

Any clues?

Kind regards
Webtytte
#6942
Re:DB function failed with error number 1054 5 Years ago  
Hi,
I met the same problem.In the database, I found that joomla1.5 had a field named by \"id\" in the table of jos_core_acl_aro_groups,whereas the field was called to \"group_id\".So the problem came out.Now the problem need fixing neither by joomla1.5 new verion or by fireboard new verion.
#7015
Re:DB function failed with error number 1054 5 Years ago  
I got the same problem, can anyone recommend any work-around?
#7070
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
Same problem here

It\'s al;so listed on the bug tracker
http://joomlacode.org/gf/project/fireboard/tracker/?action=TrackerItemEdit&tracker_item_id=4800
#7271
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
[b]gerri28 wrote:[/b]
[quote]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 [file name=admin-896edf688200cbbebef5accaaedb6770.zip size=16238]http://www.bestofjoomla.com/components/com_fireboard/uploaded/files/admin-896edf688200cbbebef5accaaedb6770.zip[/file]<br><br>Post edited by: gerri28, at: 2007/05/05 16:13[/quote]

Worked for me
#7272
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
[b]gerri28 wrote:[/b]
[quote]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 [file name=admin-896edf688200cbbebef5accaaedb6770.zip size=16238]http://www.bestofjoomla.com/components/com_fireboard/uploaded/files/admin-896edf688200cbbebef5accaaedb6770.zip[/file]<br><br>Post edited by: gerri28, at: 2007/05/05 16:13[/quote]

Worked for me
#7280
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
Great it works. Thanks a lot
#7282
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
It was like magic !

thanks, now I must play with my new forum :laugh:
#7340
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
can you tell me what you did with the file?
I uploaded it to the exact location through smartftp but it didnt fix the problem...thanks =)
#7350
Re:DB function failed with error number 1054 4 Years, 12 Months ago  
all I did was copy the extracted file to the location they specified.

I have direct access to my server so it was no big deal... no ftp for me. You might do a diff on the file to make sure that it made it ok - if you can log in to your server.
Page: 123... 4