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!
Re:DB function failed with error number 1054 (1 viewing) (1) Guest
Go to bottom Favoured: 1
TOPIC: Re:DB function failed with error number 1054
#57579
Re:DB function failed with error number 1054 2 Months, 2 Weeks ago  
Unless you want to delete the menu section (on the left hand column) then i suggest amending the php file itself:

admin.fireboard.php

This can be found in Joomlaadministratorcomponentscom_fireboard (if you installed joomla in a folder called "Joomla"

around line 382 (ish) you should make the following amendment:



$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";
/*/what the code said before the edit below
// $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 #__users AS u ON u.id = a.checked_out"
. "nLEFT JOIN #__core_acl_aro_groups AS g ON g.".((FBTools::isJoomla15())?"":"group_"."id = a.pub_access"
. "nLEFT JOIN #__core_acl_aro_groups AS h ON h.".((FBTools::isJoomla15())?"":"group_"."id = a.admin_access"
. "n GROUP BY a.id"
. "n ORDER BY a.ordering, a.name";*/




Its caused me some problems one way or another, why can't fire board get rid of bugs to begin with!?
jamescveale (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.  
Go to top