mySQL error on emailing users password

[dodgy]

I'm having sum problems when emailing users their passwords:

users are getting their e-mail but password area is clear


Username = Artur
Password =

Don't forget that they are case sensitive!


and when doing it through admin then this error shows:


Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'1','1051515766','42124146',1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Monday 28th of April 2003 10:42:46 AM
...


im running vbulletin 2.3 and vbportal

thanks

[dodgy]

hmm tried to run repair.php with ?html=1&check=1

and got this:


Database error in vBulletin 2.3.0:

Invalid SQL: CHECK TABLE access
mysql error: You have an error in your SQL syntax near 'CHECK TABLE access' at line 1

mysql error number: 1064

[Erwin]

Run this query:

REPAIR TABLE useractivation;

Please backup your db first.

[Xenon]

"Column count doesn't match value count at row 1"

you can runs infinit repair queries and that won't help you.

there are two possibilities:
1) you have wrongly hacked a file. (register.php)
2) you have made a mistake while upgrading.

i think it's 2, because the old email password template is showing, that you haven't made the template changes needed for the upgrade...

[dodgy]

REPAIR TABLE useractivation; didn?t work

>1) you have wrongly hacked a file. (register.php)
didn?t touch it. Didn?t touch anything

>2) you have made a mistake while upgrading.

I was running v2.23 I think and it happened after some weird user registered. After I was informed that new people cant register coz of sum error, I upgraded it to 2.3 without any problems.

I noticed that Templates are looking weird from admin page (I've attached screenshot). Basically most of the default templates are empty. Except few now and then. When I click on "change original" its empty.

Otherwise forum is working fine.. just that new registration and sending passwords out:(

[dodgy]

and thats how templates looks through phpmyadmin (screenshot attached)

all '-1' dont show up. some that have '1' do show up but changing them to '1' didnt help

forum is at http://artur.bluemoon.ee/forums

[Xenon]

you have made a mistake while upgading as i said.

this problem was resolved during vb2.2.6
reupload the original vb2.3.0 files again and redo the upgrade

[dodgy]

thanks Xenon! just re-uploading files fixed the problem :)