DB error when a new user had been registred

[The4um]

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

<!--
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]

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

[AdrianH]

Did you see this ?

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

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]

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]

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]

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]

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

[The4um]

I'll try it, thank you

[SEOvB]

Do you have the automatically add a friend modification installed?

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

[The4um]

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

[Alex LD]

Maybe try updating your vBulletin that could replace or change the bad quarry within the SQL

Good luck!

[Lynne]

Doing a search on "emailSend" "all mods" gives me this mod Email reminder for inactive users 1.1.3 (https://vborg.vbsupport.ru/showthread.php?t=180025&highlight=emailSend)

[The4um]

I have this add-on installed :eek: I'll disable this add-on thank you :)

--------------- Added 1227335991 at 1227335991 ---------------

Doing a search on "emailSend" "all mods" gives me this mod Email reminder for inactive users 1.1.3 (https://vborg.vbsupport.ru/showthread.php?t=180025&highlight=emailSend)
thank you so much, I' disabled that add-on and there isn't any error