Please help me! DB Error when register

[vbrocks]

Hello,

When you go to MotoX.info/forum/register.php and complete the forms and hit complete, I get a DB error.

The user is still added to the DB, but they get the DB error page.

Can someone please help me with this?

Here is the error

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE user SET emailDate = '1207201863' WHERE userid = '130186';

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

I had a thread about this over at http://www.vbulletin.com/forum/showthread.php?t=265668

I also made a support ticket with vb and I was told I need to come here for help with this.

Please help me get this resolved as it has been a problem for over a month now.

Thanks
Anthony

[Opserty]

Looks like a problem caused by a modification, disable all your modifications and see if this resolves the issue. Disabling modifications related to registration would be a good place to start.

[Lynne]

There is not column "emailDate" in the user table. So, you have added a modification which is doing this. You need to disable your plugins, or get rid of a file you uploaded which is adding this to the query. Perhaps do a global search in your files for the word "emailDate" and you will find which file you modified, if it was a file modification.

[vbrocks]

How can I find what addon it is???

I've looked to see if I could find one related to registration, but only ones I have are the ones that have been there.

[Lynne]

I would look through the plugins you have for anything that says "emailDate". I'd also run Maintenance > Diagnotics > Suspect Files and check in any of the files listed there for that word.

[vbrocks]

Got it working!!!!

Thanks guys!