Data Base error when creating new user!!

[pityocamptes]

Not sure what is going on. I get this message after creating a user or when a user is registering. However, the registration actually goes through if you check users in admincp. How can I fix this?

***
Database error in vBulletin 4.2.1:

Invalid SQL:
INSERT INTO userfield
(field1, field2, field3, field4, userid)
VALUES
('', '', '', '', 138);

MySQL Error : Duplicate entry '138' for key 1
Error Number : 1062
Request Date : Sunday, September 22nd 2013 @ 07:48:45 PM
Error Date : Sunday, September 22nd 2013 @ 07:48:46 PM
Script : XXXXXXXXXXXXXXXX/user.php?do=update
Referrer : XXXXXXXXXXXXXXXXXXXXX/user.php?do=add
IP Address : XXXXXXXXXXXXXXXXXX
Username : XXXXXXXXXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.96-log
***

[snakes1100]

Do a repair on the user table.

Its most likely a hack causing it to create that issue tho.

[pityocamptes]

Originally Posted by snakes1100

Do a repair on the user table.

Its most likely a hack causing it to create that issue tho.

No it started before I added any mods. I did merge over from phpbb3. I have tried to repair the tables and it comes back saying its fine. Now, it seems I am getting this error (looks like it happened after I created an admin account on the back end_ - never saw before...

Warning: Invalid argument supplied for foreach() in [path]/login.php(119) : eval()'d code on line 4

When I reload the page it goes away...

[ozzy47]

What php version are you running?

[pityocamptes]

Originally Posted by ozzy47

What php version are you running?

PHP Version: 5.2.17

Here are some additional errors logged to my email:

Database error in vBulletin 4.2.1:

Invalid SQL:
INSERT INTO userfield
(userid)
VALUES
(136);

MySQL Error : Duplicate entry '136' for key 1
Error Number : 1062
Request Date : Tuesday, September 10th 2013 @ 09:12:46 PM
Error Date : Tuesday, September 10th 2013 @ 09:12:46 PM
Script : XXXXXXXXXXXXXXXXX/register.php?do=addmember
Referrer : XXXXXXXXXXXXXXXXXXX/register.php
IP Address : XXXXXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database
MySQL Version :


Database error in vBulletin 4.2.1:

Invalid SQL:
INSERT INTO userfield
(userid)
VALUES
(135);

MySQL Error : Duplicate entry '135' for key 1
Error Number : 1062
Request Date : Tuesday, September 10th 2013 @ 08:29:22 PM
Error Date : Tuesday, September 10th 2013 @ 08:29:22 PM
Script : XXXXXXXXXXXXXXXX/register.php?do=addmember
Referrer : XXXXXXXXXXXXXXXXXXXXX/register.php
IP Address : XXXXXXXXXXXXX
Username : XXXXXXXXXXXXXXX
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.2.1:

Invalid SQL:
INSERT INTO userfield
(userid)
VALUES
(134);

MySQL Error : Duplicate entry '134' for key 1
Error Number : 1062
Request Date : Tuesday, September 10th 2013 @ 06:35:31 PM
Error Date : Tuesday, September 10th 2013 @ 06:35:31 PM
Script : XXXXXXXXXXXXXXX/register.php?do=addmember
Referrer : XXXXXXXXXXXXXXXXXXX/register.php
IP Address : XXXXXXXXXXXXXXX
Username : XXXXXXXXXXXXXX
Classname : vB_Database
MySQL Version :

[ozzy47]

So you are not running this mod? https://vborg.vbsupport.ru/showthread.php?t=296383

[pityocamptes]

Warning: Invalid argument supplied for foreach() in [path]/login.php(119) : eval()'d code on line 4

Ok I fixed this part, it was the firewall mod, forgot to put in an ip address...

However, the database error continues, and started from the very beginning... help...

--------------- Added [DATE]1379989223[/DATE] at [TIME]1379989223[/TIME] ---------------

Originally Posted by ozzy47

So you are not running this mod? https://vborg.vbsupport.ru/showthread.php?t=296383

Yea, fixed the warning. The big thing is my sql error... thx

[ozzy47]

Maybe this will help you, http://www.vbulletin.com/docs/html/mysql_duplicatekey

[pityocamptes]

Originally Posted by ozzy47

Maybe this will help you, http://www.vbulletin.com/docs/html/mysql_duplicatekey

Ok, so I just copy that list and run them in sql? Should I back up my db before doing this? Thx

[ozzy47]

Yeah I would defiantly do a backup before running those, just to be on the safe side.