Major Problem

G

Gurugeak

New Member
Hello i need help when my members try to register on my site they get this error:

dataerror.jpg


And when they get this error my email gets this:


Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO bulletinuserfield
(userid)
VALUES
(24669);

MySQL Error : Duplicate entry '24669' for key 1
Error Number : 1062
Request Date : Friday, May 29th 2009 @ 09:52:15 AM
Error Date : Friday, May 29th 2009 @ 09:52:15 AM
Script : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
Referrer : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
IP Address : 66.98.82.95
Username : Rokemo
Classname : vB_Database_MySQLi
MySQL Version :

So please somebody help me
 
A

absinth

New Member
Gurugeak said:
Hello i need help when my members try to register on my site they get this error:

dataerror.jpg


And when they get this error my email gets this:


Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO bulletinuserfield
(userid)
VALUES
(24669);

MySQL Error : Duplicate entry '24669' for key 1
Error Number : 1062
Request Date : Friday, May 29th 2009 @ 09:52:15 AM
Error Date : Friday, May 29th 2009 @ 09:52:15 AM
Script : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
Referrer : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
IP Address : 66.98.82.95
Username : Rokemo
Classname : vB_Database_MySQLi
MySQL Version :

So please somebody help me
Click to expand...

First hide adress wtf are you doing!!!!!!!
do not watch post to dont show address?
reupload all the vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
 
G

Gurugeak

New Member
Um how? my friend setup my Vb site for me and he is never on anymore so any chance you can give me detailed instructions?
 
M

mallee

New Member
You have to login to your FTP or cpanel and upload all .php files, overwriting the current files!!!
 
M

mallee

New Member
Download the vbulletin version you are using from HERE at vbteam..... then unzip and upload all php files.

Come on how hard can that be?
 
G

Gurugeak

New Member
Okay but are there specific ones that have to do wit registration? cause i have alot of custom stuff and if i replace "ALL" of the files alot of it will be lost. I tryied replacing the register.php and the same problem persists.
 
B

bluedevil

New Member
upload alll .php files and overwrite the existing files.. the remain files wont be disturbed.. just try...only the vb files are overwritten not the others
 
T

TheProphet

New Member
Gurugeak said:
okay then i trust u guys on this but ima save all the files to my desktop incase anything happens
Click to expand...

Always saves your current m8.... if not, the bigger your problem grows and will endup a fresh clean install.
 
G

Gurugeak

New Member
Okay i replaced ALL of the .php files with bran new 1's and i still get the same database error. So any ideas?

This is the message that gets sent to my email:

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO bulletinuserfield
(userid)
VALUES
(25198);

MySQL Error : Duplicate entry '25198' for key 1
Error Number : 1062
Request Date : Monday, June 1st 2009 @ 02:22:45 PM
Error Date : Monday, June 1st 2009 @ 02:22:45 PM
Script : [hid link]
Referrer : [hid link]
IP Address : 190.4.153.112
Username : sshelSS
Classname : vB_Database_MySQLi
MySQL Version :

Is somethign wrong with my SQL?

Please somebody help
 
G

Gurugeak

New Member
Okay i have a problem i replaced all of them with bran new 1's my site is the same nothing is different and the registration still consists with the same problem.

I get this message in my email:

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO bulletinuserfield
(userid)
VALUES
(25232);

MySQL Error : Duplicate entry '25232' for key 1
Error Number : 1062
Request Date : Monday, June 1st 2009 @ 06:08:05 PM
Error Date : Monday, June 1st 2009 @ 06:08:05 PM
Script : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
Referrer : GuruHacks.Net - For All Gaming Needs - Powered by vBulletin
IP Address : 76.94.71.191
Username : levonski1
Classname : vB_Database_MySQLi
MySQL Version :

Is something wrong with my SQL?

Somebody HELP!
 
T

Trinity_vbulletin3_import39467

New Member
You fix the config.php file through your ftp program once logged into your site you go to forums folder / includes folder and locate config.

Did you get this error after installing a new mod? It looks like the mod from guruhacks.net is not working with your db. You can turn off the hooks/plugins in your vbulletin options and then uninstall the mod.
 
G

Gurugeak

New Member
Yeah but i don't know how long this has been happening for, i was informed about it like 2 weeks ago and i have ALOT of mods. None of them have to do with the registry so i don't know whats wrong.
 
G

Grinderhand

New Member
Are you sure your database type is MySQLi?

Undeleteable users is supposed to be a user NUMBER, as in '1,136', not a user name.

Hope that helps.
 
G

Gurugeak

New Member
I am bad with vB and html and php and stuff so i have to have a noob friendly tutorial to change anything so please somebody help me.
 
You must log in or register to reply here.
Top