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!
DB Error (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: DB Error
#27764
DB Error 1 Year, 1 Month ago  
After installation this is what I get when I go to Forum-administration:

DB function failed with error number 1054
Unknown column 'g.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.id = a.pub_access LEFT JOIN jos_core_acl_aro_groups AS h ON h.id = a.admin_access GROUP BY a.id ORDER BY a.ordering, a.name

Any help would be very welcome!
Thanks
Mordice
mordice (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#27779
Re:DB Error 1 Year, 1 Month ago  
Did you COMPLETE the install in the control panel?
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#27780
Re:DB Error 1 Year, 1 Month ago  
Yes I did. I now have (after I deleted the jos_fb tables and reïnstalled FB ) imported the Joomlaboard-data and still have this error...
mordice (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/10/15 22:48 By mordice.
 
The administrator has disabled public write access.  
#27781
Re:DB Error 1 Year, 1 Month ago  
Joomla 1.5 by any chance?
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#27783
Re:DB Error 1 Year, 1 Month ago  
Oh sorry. No 1.0.11 is my version.
mordice (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#27784
Re:DB Error 1 Year, 1 Month ago  
Have a look at this thread. It is older but may help.
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
Last Edit: 2007/10/15 22:55 By grumblemarc.
 
The administrator has disabled public write access.  
#27785
Re:DB Error 1 Year, 1 Month ago  
I've read it over, but it says something about placing a file somewhere, but this file isn't there anymore...
mordice (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#27787
Re:DB Error 1 Year, 1 Month ago  
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
#27789
Re:DB Error 1 Year, 1 Month ago  
Ha grumblemarc thanks! Something has changed... Now this is the message:

DB function failed with error number 1054
Unknown column 'g.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.id = a.pub_access LEFT JOIN jos_core_acl_aro_groups AS h ON h.id = a.admin_access GROUP BY a.id ORDER BY a.ordering, a.name
mordice (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#27791
Re:DB Error 1 Year, 1 Month ago  
Looks like the same error?
grumblemarc (User)
Platinum Boarder
Posts: 3559
graph
User Offline Click here to see the profile of this user
Gender: Male
Logged Logged
 
The administrator has disabled public write access.  
Go to top