PDA

View Full Version : Error adding multiple moderators to forum


dayve
Mon 28th Jan '08, 10:07pm
I separated all the moderators with a semi-colon as instructed, example:

sinner; onyxwolf; ender; dayvesgirl

Upon submitting I get the following error:


Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
INSERT INTO bsf_moderator
(userid, forumid, permissions, permissions2, moderatorid)
VALUES
('17', 1, 1279, 47883, 12);
MySQL Error : Duplicate entry '12' for key 1
Error Number : 1062
Date : Monday, January 28th 2008 @ 08:59:15 PM
Script : http://www.burningsoulsforum.com/vb/admincp/moderator.php?do=update
Referrer : http://www.burningsoulsforum.com/vb/admincp/moderator.php?do=add&f=1&s=
IP Address :
Username : dayve
Classname : vb_database
MySQL Version : 4.1.12


When I select to show all moderators, all the moderators were added to the group except dayvesgirl. If I add this person by themselves it works. I tried this 3 times and all 3 times received the same error.

dayve
Mon 28th Jan '08, 10:13pm
Quick update:

1. Tested to see if it was happening due to trying to add 4 moderators, same thing happens when adding more than 1.

2. Tested sequence of members to see if problem with members account, fails regardless of which member name is used last.

dayve
Tue 29th Jan '08, 11:19pm
Is no one else experiencing this problem?:confused:

Onimua
Tue 29th Jan '08, 11:34pm
I can replicate this; put it in the bug tracker. :)