![]() |
Register error Data Bases
Good morning
I have installed Vbulletin 4.2.2 and to register a new user with all data ok, but when you press the button register, throws me an error in the database. The user is registered ok, but I did not throw the welcome message which tells me that is registered. Please help https://vborg.vbsupport.ru/external/2014/04/5.jpg |
Check server error logs they should be emailed to the email that is in the config.php
|
As ForceHSS said, the database error should be emailed to the email you entered into the config.php file. We need to see the actual database error in order to help you.
|
Thanks for your answers, the error it throws me the vbulletin is :
/Home/u265935853/public_html/includes/class_mail.php: 403 Thanks |
That isn't the database error. What is being emailed to you?
|
Post the full email error message you are getting
|
Hello:
The problem is that any email sent to me that I have assigned box in config.php I send a test email from vbulletin in the section where I can send an email to an address to test and it works perfect, comes aa mail address to send. |
No idea what you are trying to say
|
My apologies but I found the error mail:
This is the error message that you send me mail: Database error in vBulletin 4.2.2: Invalid SQL: INSERT INTO userfield (userid) VALUES (114); MySQL Error : Duplicate entry '114' for key 'PRIMARY' Error Number : 1062 Request Date : Thursday, May 1st 2014 @ 02:35:25 PM Error Date : Thursday, May 1st 2014 @ 02:35:25 PM Script : http://www.latino-fta.com/register.php?do=addmember Referrer : http://www.latino-fta.com/register.php? IP Address : 200.112.70.167 Username : prueba1 Classname : vB_Database MySQL Version : |
Its trying to set a user id of 114 when it says it already has this. Find out what user has this id or if it is even in use
|
Run Repair/Optimize on the userfield table and see if that fixes the issue.
How many rows in your user table and how many rows in your userfield table? And, if you click the Operations tab when viewing the user table (I assume you are looking at the tables via phpMyAdmin), what is the AUTO_INCREMENT set to? And, if you go to the usertextfield table and sort by userid, what is the max userid? |
Do as lynne said if the userid is 113 then set it to 114 this way next registered user will get id 115
|
Good morning:
Thanks to everyone for their help, it was actually an error in what I expressed, and solve the problem. Thanks again to everyone who gave me their selfless help. - |
All times are GMT. The time now is 06:07 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|