BlastChat
 arrowHome arrow Support Forum Thursday, 08 January 2009 

 
Login Form





Lost Password?
No account yet? Register

BlastChat
Welcome, Guest
Please Login or Register.    Lost Password?
DB function failed with error number 1054 (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: DB function failed with error number 1054
#4547
mayerlink (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
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.

very grateful for help
mayerlink
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4548
Prutkar (Admin)
Admin
Posts: 1797
graph
User Offline Click here to see the profile of this user
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.
 
Report to moderator   Logged Logged  
 
Peter Saitz
www.blastchat.com
  The administrator has disabled public write access.
#4549
mayerlink (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
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
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4551
Prutkar (Admin)
Admin
Posts: 1797
graph
User Offline Click here to see the profile of this user
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)
 
Report to moderator   Logged Logged  
 
Peter Saitz
www.blastchat.com
  The administrator has disabled public write access.
#4553
mayerlink (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
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.

all the best
mayerlink
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
BC CSS templates
  • BlastChat CSS tempplates Image Rotator
  • BlastChat CSS tempplates Image Rotator
  • BlastChat CSS tempplates Image Rotator
  • BlastChat CSS tempplates Image Rotator
  • BlastChat CSS tempplates Image Rotator

BC Module 3.0
We have 178 guests and 7 members online
We have 5 guests chatting
tooltip  openthem
tooltip  Royal Trude
tooltip  christophe95
tooltip  nice annonces
tooltip  Fat Cat
tooltip  limpid
tooltip  harodj
Statistics
Visitors: 21060684

Logotyp
Page loaded in 0.709 seconds.