vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Register error Data Bases (https://vborg.vbsupport.ru/showthread.php?t=310888)

jclf 04-29-2014 01:03 PM

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

ForceHSS 04-29-2014 03:51 PM

Check server error logs they should be emailed to the email that is in the config.php

Lynne 04-29-2014 03:57 PM

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.

jclf 04-30-2014 02:48 AM

Thanks for your answers, the error it throws me the vbulletin is :
/Home/u265935853/public_html/includes/class_mail.php: 403

Thanks

Lynne 04-30-2014 03:07 AM

That isn't the database error. What is being emailed to you?

ForceHSS 04-30-2014 12:22 PM

Post the full email error message you are getting

jclf 05-01-2014 03:02 AM

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.

ForceHSS 05-01-2014 03:05 AM

No idea what you are trying to say

jclf 05-01-2014 01:44 PM

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 :

ForceHSS 05-01-2014 04:09 PM

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

Lynne 05-01-2014 04:25 PM

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?

ForceHSS 05-01-2014 04:27 PM

Do as lynne said if the userid is 113 then set it to 114 this way next registered user will get id 115

jclf 05-05-2014 11:26 AM

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
  • Page Generation 0.01223 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (13)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete