| 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
|
|
|
| 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
|
|
|
| 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.
|
|
|
| Re:DB function failed with error number 1054 5 Years ago |
|
I got the same problem, can anyone recommend any work-around?
|
|
|
| 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
|
|
|
| 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
|
|
|
| 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
|
|
|
| Re:DB function failed with error number 1054 4 Years, 12 Months ago |
|
Great it works. Thanks a lot
|
|
|
| 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:
|
|
|
| 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 =)
|
|
|
| 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.
|
|
|
|