vb.org Archive - DB error when a new user had been registred

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - DB error when a new user had been registred (https://vborg.vbsupport.ru/showthread.php?t=196739)

The4um

11-19-2008 11:17 PM

DB error when a new user had been registred

The error is shown when the user clicks the submit button to finish the register's process
I use vbulletin 3.7.4 and I updated from 3.6.8
how can I fix this trouble???:(
anyone can help me?:o

this is the error message

Code:

<!--

Database error in vBulletin 3.7.4:



Invalid SQL:

UPDATE user SET emailDate = '1227121576' AND emailSend = '1227121576' WHERE userid = '1457';



MySQL Error   : Unknown column 'emailSend' in 'field list'

Error Number  : 1054

Request Date  : Wednesday, November 19th 2008 @ 01:06:03 PM

Error Date    : Wednesday, November 19th 2008 @ 01:06:16 PM

Script        : http://www.****.com/register.php?do=addmember

Referrer      :

IP Address    : *x9.*x9.*x.*x9

Username      : error

Classname     : vB_Database

MySQ

SEOvB

11-19-2008 11:24 PM

Disable your plugins one by one to find which one is causing the problem.

AdrianH

11-20-2008 04:40 AM

Did you see this ?

http://www.vbulletin.com/forum/showthread.php?t=290128

Quote:

Somehow, a serious, but not destructive bug worked its way into 3.7.4. After modifying a user in the UserCP, you will receive a database error when saving the user. I have updated the affected file, includes/class_dm_user.php, in the 3.7.4 download. If you downloaded 3.7.4 previous to this message, please download it again and replace the file.

I had database errors when trying to update usernames via vB maintenance and in registration ,changing the mentioned file cures the problem.

The4um

11-20-2008 08:41 PM

yes I did, on vbulletin.com told me that an add-on is causing the error but I don't know wich one could be
finally, I updated my forum to 3.7.4 last week :(

Lynne

11-20-2008 08:56 PM

I'd venture to guess it is an addon using one of the hooks found in the register.php page.

If you don't want to look those up, then try disabling one product at a time and see if this error goes away.

Another idea is to do a search for "emailSend" ("all forums" "all posts") and see if a Modification comes up or another thread about this comes up. Perhaps if a Modification comes up in the results, then it is one you have installed and it's the problem.

The4um

11-20-2008 09:25 PM

I'd searched into the DB and I found some 'stuffs ' with "emailSend" but I'm afraid to delete it but I dont know if those stuffs could my db crash

Lynne

11-20-2008 09:39 PM

Then don't search the database. Do it using one of the methods I suggested.

The4um

11-20-2008 10:02 PM

I'll try it, thank you

SEOvB

11-21-2008 01:30 AM

Do you have the automatically add a friend modification installed?

Turn email confirmation off, then try registering and see if the problem persists.

The4um

11-22-2008 02:05 AM

I don't have that modification installed, but I disabled the Plugin/Hook system and I didn't have any error with register

All times are GMT. The time now is 06:30 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01643 seconds Memory Usage 1,728KB 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)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: