kscearce Posted November 11, 2004 Posted November 11, 2004 Ok, I know enough to be dangerous here, so please bear with me. I installed a great little chat program called FlashChat (www.tufat.com) and it's working great. I integrated it with my BB, and tested it quite a bit. I had everything up and running, so I thought (BAD MOVE!!) I would go in and delete all the test members I'd registered in my BB through the MySQL database through phpAdmin. I went into the DB, went to Ibf_members, clicked on Browse, selected the users I wanted to remove from the database and clicked the X (delete) button. They were removed successfully. So I then went back to the BB (after closing all browser instances) and tried to register under a new user name. It gave me the following error. mySQL query error: INSERT INTO ibf_member_extra (id) VALUES (3) mySQL error: Duplicate entry '3' for key 1 mySQL error code: Date: Thursday 11th of November 2004 08:57:34 AM Interestingly enough, it did take the registration, and I can get into the BB if I go back and login, but I've got users who won't think to do that, and I want it to be seamless. Does anyone have any suggestions as to how I can fix this? Do I have to reinstall the entire BB? (Oi!!) Thanks, Monica "I became insane with long intervals of horrible sanity." ---Edgar Allan Poe Quote
borfast Posted November 11, 2004 Posted November 11, 2004 (edited) That means that the system keeps information about each user in more than one table. You need to find which tables it uses and delete all the references to the users you removed. As a starting point, you already know that ibf_members (the one you mentioned) and ibf_member_extra (the table where the error is occurring) contain member information. If there are any other tables containing members data, it's probably named "ibf_member_something". Edited November 11, 2004 by TCH-Raul Quote
kscearce Posted November 11, 2004 Author Posted November 11, 2004 THAT! Solved my problem!!! Thank you so much!!! I love you guys!! Monica "I became insane with long intervals of horrible sanity." ---Edgar Allan Poe Quote
TCH-Bruce Posted November 11, 2004 Posted November 11, 2004 Glad that solved your problem Monica Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.