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?
Re:combining user database with joomla (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:combining user database with joomla
#3176
beduyin (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
combining user database with joomla 1 Year, 2 Months ago Karma: 0  
hi, I have just install this chat componant. And its really nice. The only problem I m having is, I cant use my joomla user daabase as its user database. Coz, I only can log in when i log in my site with the blastchat user ID. Please help me to solve this problem. When any other user logs in he cant se the chat. It shows an error massage. Plz help me.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3178
Prutkar (Admin)
Admin
Posts: 1797
graph
User Offline Click here to see the profile of this user
Re:combining user database with joomla 1 Year, 2 Months ago Karma: 52  
BlastChat automatically integrates into your joomla database, user logged into your website can enter chat and his username will be automatically used inside chat as well (client does not work under Joomla 1.5, yet).

What error message do you see? When you are reporting problem, please provide as much information as you can.
 
Report to moderator   Logged Logged  
 
Peter Saitz
www.blastchat.com
  The administrator has disabled public write access.
#3214
RJJMVB (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Re:combining user database with joomla 1 Year, 1 Month ago Karma: 0  
I have the same problem. A registered user gets the folowing errormessage when he enter the chatmodule:

Error 0005 : Er deed zich een error voor, contacteer de webmasterDB function failed with error number 1062
Duplicate entry '9d03f2e46b2702910d9c4c75a8ecacac' for key 2 SQL=INSERT INTO jos_blastchatc_users (userid, serverid, sec_code, logged, last_update, session_id) VALUES ('64', '0', '9e4e42f960b59e53d5af7d691f3237ab', 1, '1195237686', '9d03f2e46b2702910d9c4c75a8ecacac'
SQL =
INSERT INTO jos_blastchatc_users (userid, serverid, sec_code, logged, last_update, session_id) VALUES ('64', '0', '9e4e42f960b59e53d5af7d691f3237ab', 1, '1195237686', '9d03f2e46b2702910d9c4c75a8ecacac'

What's the problem and the solution?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3215
Prutkar (Admin)
Admin
Posts: 1797
graph
User Offline Click here to see the profile of this user
Re:combining user database with joomla 1 Year, 1 Month ago Karma: 52  
which Joomla version are you running?

There are two unique keys for that table:
UNIQUE KEY `sec_code` (`sec_code`),
UNIQUE KEY `session_id` (`session_id`),

Can you check blastchatc_users table if sec_code 9e4e42f960b59e53d5af7d691f3237ab isn't there but is assigned to other userid then 64 ?

(You can always identify problematic username and remove it from table, then delete that user as well in blastchat website configuration.
 
Report to moderator   Logged Logged  
 
Peter Saitz
www.blastchat.com
  The administrator has disabled public write access.
#3216
dragontje124 (User)
Moderator
Posts: 133
graphgraph
User Offline Click here to see the profile of this user
Gender: Male rik_dragon[at]hotmail[dot]com Location: Netherlands Birthdate: 1993-05-26
Re:combining user database with joomla 1 Year, 1 Month ago Karma: 6  
Ik zal het in het nederlands uitleggen
ga naar de tabel: blastchatc_users.
zoek daar naar het id: 64
(maak even een backup van de tabellen voor de zekerheid )
als die er niet is: delete dan de row waar de sec_code: 9e4e42f960b59e53d5af7d691f3237ab is.
probeer dan opnieuw naar de chat te gaan
 
Report to moderator   Logged Logged  
 
Need help?
click here and get into a direct conversation
  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 96 guests and 4 members online
We have 2 guests chatting
tooltip  aliosmanim
tooltip  aena
tooltip  Fat Cat
tooltip  Heladerias
Statistics
Visitors: 21056602

Logotyp
Page loaded in 0.352 seconds.