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?
Community FireBoard Forum Latest Release Previous Releases Fireboard 1.0.0
can't create any categories "db error" (1 viewing) (1) Guest
Go to bottom Favoured: 1
TOPIC: can't create any categories "db error"
#4496
can't create any categories "db error" 1 Year, 4 Months ago  
hi all

i got a problem after installing the Fireboard.

below the error

Code:
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


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
Phosphorus (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4517
Re:can't create any categories "db error" 1 Year, 4 Months ago  
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...
B@NE (User)
Joomla Rulz
Junior Boarder
Posts: 36
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Portal013 Location: Velika Greda - Vojvodina Birthdate: 1991-02-07
Logged Logged
 
Joomla 4ever
  
The administrator has disabled public write access.  
#4525
Re:can't create any categories "db error" 1 Year, 4 Months ago  
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
Phosphorus (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4769
Re:can't create any categories "db error" 1 Year, 4 Months ago  
any help ? im not alone with that probs...
Phosphorus (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#4803
Re:can't create any categories "db error" 1 Year, 4 Months ago  
i think is cause of MySQL5.0
Phosphorus (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#5161
Re:can't create any categories "db error" 1 Year, 4 Months ago  
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


Post edited by: gerri28, at: 2007/05/05 16:13
gerri28 (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.  
#7239
Re:can't create any categories "db error" 1 Year, 3 Months ago  
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
darkhelmet (User)
Junior Boarder
Posts: 35
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#17236
Re:can't create any categories "db error& 1 Year, 1 Month ago  
My understanding is that the .zip file above contains this code STARTING AT LINE 417 >>>

Code:
    $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"«»);
    


Which replaces the following code in the current admin.fireboard.php file AT "APPROXIMATELY" LINE 371 (depending on build date):

Code:
    $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"«»);


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.
wwvine (User)
Mark 16:15
Senior Boarder
Posts: 51
graphgraph
User Offline Click here to see the profile of this user
Gender: Male wwvine[at]gmail[dot]com wwvine[at]msn[dot]com Location: United States
Logged Logged
 
Last Edit: 2007/08/07 06:39 By wwvine.
 
always to the glory of God
  
The administrator has disabled public write access.  
#18621
Re:can't create any categories 1 Year ago  
gerri28 wrote:
I think I have solved this issue, at least it seems to work for me.

Worked for me too! Many thanks
Adamski_NZ (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#18731
Re:can't create any categories 1 Year ago  
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
vincentbaines (User)
Fresh Boarder
Posts: 8
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 FireBoard - Creditsget the latest posts directly to your desktop