Registration dbase error

When I turn email-verification (user needs to activate upon receiving email) on, after hitting submit on a registration, a database error shows. If i disable it, everything works fine. I did do a number of hacks but everything else works fine so I doubt it is directly related.

Is there anything specific I should be looking at?

thx

[Lesane]

Well, what's the error?

[DiscussAnything]

it doesnt say, it just says 'Oops, it seems there has been a slighter error'...

[Lesane]

Look at the source when you see that error

[DiscussAnything]

It's this:

<!-- Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'11','1056925402','84189185',0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

[Lesane]

Could you execute this query below and post the results here?

PHP Code:

SHOW FIELDS from useractivation 


[Lesane]

Nevermind, i already see it.

The error:

PHP Code:

INSERT INTO useractivation VALUES (NULL,'11','1056925402','84189185',0) 


shows us that it has 5 fields while it should contain 6 fields (originally in 2.3.0).

And you are using 2.3.0, so i guess that there is a hack for <2.3.0 and that you changed some lines in it wich aren't compatible with 2.3.0. If you did not made any changes in root/register.php then i'd suggest you to re-upload the original root/register.php from 2.3.0.

[DiscussAnything]

The fields for that table are:

useractivationid
userid
dateline
activationid
type
usergroupid

[DiscussAnything]

i actually did try it with the original, but that didn't work. I'll go over the hacks I did that use register.php and/or that table and see if I missed out on a field.

thanks for the help. For now I just have the email-activation disabled...

Which 6 are there supposed to be in 2.3.0 ?

[Lesane]

I can give a look at it if you want, just pm me with the file.