DB function failed with error number 1054 2 Months, 4 Weeks ago
Karma: 0
In back-end sub users I get this error:
DB function failed with error number 1054
Unknown column 'g.group_id' in 'on clause' SQL=SELECT a.*, g.name AS groupname , bcu.sec_code AS bc_sec_code , bcu.logged AS bc_logged , bcu.last_entry AS bc_last_entry , bcu.last_update AS bc_last_update , bcu.idle AS bc_idle , bcu.roomid AS bc_roomid , bcu.roomname AS bc_roomname FROM jos_users AS a INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = a.gid LEFT JOIN jos_blastchatc_users AS bcu ON bcu.userid = a.id WHERE bcu.serverid = 1 GROUP BY a.id LIMIT 0, 20
I cannot add a super administrator (no user shown). note that I first login in front-end as super administrator of the site and than enter the chat and leave messages.
Re:DB function failed with error number 1054 2 Months, 4 Weeks ago
Karma: 52
to fix "group_id" problem with Joomla 1.5 - read and implement this: group_id error
To be able to add superadmin you need "username database integration" feature, which at the moment belongs to premium features. Once you subscribe to one of the "Chatters limit" plans, you get "username database integration" automatically with it.
Re:DB function failed with error number 1054 2 Months, 4 Weeks ago
Karma: 0
I see, ok thanks.
Furthermore I think to understand that I have to subscribe something in order to change styles and use different css templates: if I'm wrong please let me know how to do it.
Will you please confirm this? Just for clearness and not to loose time in trying to do what I cannot do.
Thanks
mayerlink
Re:DB function failed with error number 1054 2 Months, 4 Weeks ago
Karma: 52
You can change CSS styles at any time, no subscription needed (download some examples from our downloads area, adjust them, create your own.) You can change style settings in Server side Configuration - "Config' icon (to change from default to your own file)
You can read about features that need subscription in our "Pricing" page. (left menu)
Re:DB function failed with error number 1054 2 Months, 4 Weeks ago
Karma: 0
Firstly thanks a lot for your solicitude and then sorry for my wrong question, but I couldn't enter server-side config for a problem in managing the component.
Now all is working good.