Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
Community FireBoard Forum Latest Release Previous Releases Fireboard 1.0.0
DB function failed with error number 1054 (1 viewing) (1) Guest
Go to bottom Favoured: 1
TOPIC: DB function failed with error number 1054
#6742
DB function failed with error number 1054 1 Year, 6 Months 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:

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

Any clues?

Kind regards
Webtytte
webtytte (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#6942
Re:DB function failed with error number 1054 1 Year, 6 Months 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.
reallio (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7015
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
I got the same problem, can anyone recommend any work-around?
Louis (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7070
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
Same problem here

It's al;so listed on the bug tracker
joomlacode.org/gf/project/fireboard/trac...tracker_item_id=4800
terox (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7271
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
gerri28 wrote:
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 Attachment:
File Name: admin-896edf688200cbbebef5accaaedb6770.zip
File Size: 16238
<br><br>Post edited by: gerri28, at: 2007/05/05 16:13

Worked for me
terox (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7272
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
gerri28 wrote:
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 Attachment:
File Name: admin-896edf688200cbbebef5accaaedb6770.zip
File Size: 16238
<br><br>Post edited by: gerri28, at: 2007/05/05 16:13

Worked for me
terox (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7280
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
Great it works. Thanks a lot
Louis (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7282
Re:DB function failed with error number 1054 1 Year, 6 Months ago  
It was like magic !

thanks, now I must play with my new forum
steveberry (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7340
Re:DB function failed with error number 1054 1 Year, 6 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 =)
bluebladeakirai (User)
Fresh Boarder
Posts: 16
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#7350
Re:DB function failed with error number 1054 1 Year, 6 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.
steveberry (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top
Powered by FireBoardget the latest posts directly to your desktop