Data Base error when creating new user!!

[pityocamptes]

Originally Posted by ozzy47

Yeah you got some issues there, best bet is to ask at vb.com, they are more involved with this sort of thing.

Well that ain't gonna happen, my account expired. Can't post over there. ANYONE???? Really need help!!!

[snakes1100]

Originally Posted by 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
***

Originally Posted by snakes1100

Do a repair on the user table.

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

Originally Posted by pityocamptes

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...

Your first post doesnt state that you dont have hacks/addons installed.

A simple repair of the table will fix the dupe key issue.

If a repair in phpmyadmin dont work, run a myisamchk via the command line if you have shell access to the server.

But that is normally caused by hacks, its not a vbulletin issue causing that.

[ozzy47]

Hopefully someone more knowledgeable than me in this sort of thing can give you a hand here.

[pityocamptes]

Originally Posted by snakes1100

Your first post doesnt state that you dont have hacks/addons installed.

A simple repair of the table will fix the dupe key issue.

If a repair in phpmyadmin dont work, run a myisamchk via the command line if you have shell access to the server.

But that is normally caused by hacks, its not a vbulletin issue causing that.

The ONLY mods I installed are admin firewall and spam-o-matic.

In both the userfield and usertextfield tables I have 647 entries with multiple duplicates in some of the fields that keep repeating.

In the userlist table it is empty.

In the user table I have 134 entries which is what shows in the back end for the amount of users...

The errors were happening BEFORE I installed the mods, I did a merge over from phpbb3 and IMPEX kept crapping out, and VB.com told me to run IMPEX again. Now I don't have support from them, over a month ago... I wonder if the several times I ran impex created DUPLICATES in the tables? How do I fix this?

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

Good GOD!!! It looks like that is what happened!! Everytime I ran IMPEX it would give errors on importing from phpbb3. Had to keep running the options until it gave no errors.

http://www.vbulletin.com/forum/forum...database-error

OK, so what do I need to do to fix this cleanly?

Basically what I want to attempt to do is rerun the database import - fresh from my phpb3.

Do I need to uninstall the two VB mods I added, then upload my original db (backup) back to the server and run impex again?

I just got done with my temlate (custom) and do NOT want to have to start over on that...

Any help appreciated!! Thanks.

[snakes1100]

Once you complete the impex import, you should have it remove the session & the temp id's it used.

If your getting errors during the impex process, then certainly DONT rerun the import steps over and over, thats not going to fix the issue.

I would start over fresh & dont use the admincp firewall, simply use a htaccess protection, nothing more needed for it, but neither of those will protect you from a sql injection anyways.

[pityocamptes]

Originally Posted by snakes1100

Once you complete the impex import, you should have it remove the session & the temp id's it used.

If your getting errors during the impex process, then certainly DONT rerun the import steps over and over, thats not going to fix the issue.

I would start over fresh & dont use the admincp firewall, simply use a htaccess protection, nothing more needed for it, but neither of those will protect you from a sql injection anyways.

Thanks! Ok, last night I removed the three mod addons I had with vbulletin. I uploaded the old forum (phpbb3) files and database up to the server.

So, at this point, wipe the database through IMPEX and start over the import?

I know I have some large import files on my old forum. A couple were around 55 megs. How do I make sure that those files xfer to VBulletin? Also, I know last time when I was running certain imports like "users" it would show that most xferred over but I had errors. It never told me what the errors were and so I would rerun the import. Maybe someone can help me on this. What do you do when IMPEX shows an error? How do you know what the error is exactly?

Also, since I am bringing in the DB from my old forum software, do I need to upload the "install" folder for VBulletin that was removed after I installed the VBulletin software? Thanks again!

[snakes1100]

Yes you would start fresh

New Vb DB with a normal install
Fresh copy of the import DB
Then run Impex & stop when it errors, dont run it again.

You would need to post the actual errors if it produces a error, we dont know what they are.

[pityocamptes]

Originally Posted by snakes1100

Yes you would start fresh

New Vb DB with a normal install
Fresh copy of the import DB
Then run Impex & stop when it errors, dont run it again.

You would need to post the actual errors if it produces a error, we dont know what they are.

Ok, I don't know where to find the errors for impex. The upload screen (in the past) just showed that 100 users merged and 50, for example, did not, but I don't know why. I uploaded the old db and forum software onto the server. I wonder if I should go back into the old forum and make everyone a registered user and delete the custom ranks I had installed in phpbb3? Then create new ranks in vbulletin and change the users at that point? Thoughts on that? Or will I mess anything up? Also, what are the DEFAULT user settings offered in vbulletin that will hopefully merge with phpb3? Thx

[snakes1100]

Try enabling debug in the impex config file, my guess its going to be a bad email or blank email for those users.

[pityocamptes]

Originally Posted by snakes1100

Try enabling debug in the impex config file, my guess its going to be a bad email or blank email for those users.

Thanks. Assuming that that may be the issue, A) how do I fix this, and B) How do I get those users to import without having to redo the import and end up with duplicate entries in the DB??

Also, is there a method in IMPEX to allow very large imports of files? I noticed during the last time I did the merge, it crapped out on a couple of file (pdf) uploads that were between 40-50mb. Thanks again!