Hi, After installing and registering and LOGGING IN AS A REGISTERED MEMBER IN MY WEBSITE I still am getting this error in the USER section:
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 am frustrated as anything. I am trying to buy modules and spend money with BlastChat but cannot assign a Super Administrator or even see any registered users in the users section of the backend.

How do I get rid of this error? Any help would be greatly appreciated.
www.LasikUniversity.com

Matt Beaty

To solve the error, please read topic Errors in front- and backend. It is Joomla 1.5 new change that our client 2.3 does not handle correctly, removal of group_id from database.

After you make adjustments from above mentioned topic your chat will work correctly and you will have access to subscriptions (username database integration is available after you subscribe to one of available "Chatters limit" ).

Our new client 2.3 is in final testing stage, it will take care of this error as well.