| Author |
 Topic  |
|
|
trevally
Starting Member
46 Posts |
 Posted - 19 September 2006 : 10:46:52
|
I created a second "Allowed Member List(Hidden Room)" and when I tried to add in members I received the following error message:
There has been a problem!
Duplicate entry '1668' for key 1
Go back to correct the problem.
I only encounter this message if I add in members who were previously from another Hidden Room. If I add in members who were never in a Hidden Room before, then it is okay.
Any ideas on overcoming this?
Oh, yes I am using MySQL for my database.
Regards,
Vincent
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 19 September 2006 : 11:39:30
|
| maybe a problem with your allowed_member table, any idea if the same thing happens if yoou try to manually add a record to the table ? |
 |
|
|
trevally
Starting Member
46 Posts |
Posted - 19 September 2006 : 11:42:28
|
To be honest, I am not familiar with MySQL. Do you mean that I manually insert records via the PhpMyadmin?
Cheers,
Vincent |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 19 September 2006 : 12:16:23
|
quote:
Do you mean that I manually insert records via the PhpMyadmin
yes, just to see if it works, if it doesn't it is a problem with the table, if it does then it s a problem with the code |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 19 September 2006 : 21:36:49
|
Ok instead this is what I did.
I removed the original user from the first hidden room and then placed them to the new hidden room, IT WORKS!
So it looks like a forumer cannot be in 2 hidden rooms at the same time.
Regards,
Vincent |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 20 September 2006 : 03:47:51
|
well, a member can be in more than one hidden room  so we still don't know whether it is the code or your db that is the problem |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 20 September 2006 : 04:01:50
|
I would suggest that you check the forum_allowed_members table in PhpMyAdmin and check that the primary key is set correctly, it should be set so that both the member_id and forum_id are part of the primary key, if it is set so that only the member_id is the primary key, then you will get the problem you describe.
If you are unable or not sure how to do this, you could email myself or one of the other Admins the login details to access your database and we will check it for you. |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 20 September 2006 : 12:22:19
|
HuwR,
Thanks for your advice. Lemme have a shot at it via the PhpMyadmin first.
Will update you.
Cheers,
Vincent |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 20 September 2006 : 12:47:05
|
| Ok, let us know if you still need any assistance |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 23 September 2006 : 04:52:16
|
Dear HuwR,
I entered my PHPmyAdmin and checked the forum_allowed_members table as advised. Yes, you're right. Only the Member_ID is the primary key.
However when I check on the Forum_ID to set the primary key also, it asked whether do I want to drop the former key? Hence, I am unable to set both fields as Primary Key as suggested.
Can we set 2 primary keys at once?
Regards,
Vincent |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 September 2006 : 05:03:00
|
| you should drop the existing primary key and then set it so that BOTH columns are the primary key, you can't have two primary keys, but a primary key CAN be set on more than one column |
|
|
|
trevally
Starting Member
46 Posts |
Posted - 23 September 2006 : 05:29:59
|
Got it! Thanks all working fine! You're awesome!
Vincent |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 23 September 2006 : 05:34:42
|
| you're welcome |
|
|
| |
Topic |
|
Topic Locked
