PLEASE HELP! SQL error in forgot password / member.php

[007]

First of all, I originally posted this here so sorry if I'm not supposed to post it again, but I REALLY need help with this. Here's my error message:

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

mysql error number: 1136

It said this was in my member.php and here is what I have:

PHP Code:

$DB_site->query("INSERT INTO useractivation VALUES (NULL,'$user[userid]','".time()."','$user[activationid]',1)"); 


What should I do now? Can somebody help please?

Also, how do I reset the userid's

I have 11 users that show up. I made another user (would have had userid 12) but before that I had changed one user to 99 temprarily so I could switch two id's. the user that was supposed to be #12 was then made to 100. how do I reset this so this user is 12, and that he shows up in the lsit of users in admin cp? I have changed his id to 12 in phpMyAdmin and now he does not show up at all in admin cp... I want it so the next person who signs up will be #13, and non 101. Any help here would also be appreciated. Thank you.

[Xenon]

reupload the original member.php

since the useractivation part has changed within 2.3.0 you have to do so..

id question: it doesn't hurt as it is, just remeber it.
there is an sql query to reset the autoincrese (search around a bit, i don't know it from mind now..)

if you change an userid in usertable, you have to change his id in unserfield table, too or you cant edit him anymore

[007]

Thanks Xenon. That ID thing worked great.

As for my other problem.. I actually started to upgrade to 3.0 and I decided not to for now because I wouldn't have time right now to reinstall all my hacks.

So I am supposedly back to 2.2.9, although my version number is still 3.0.. I screwed something up.. Anyway, I still get the same SQL error when reuploading the 2.2.9 member.php

Would it help if I attached it? You can remove it once you look at it if that would help. Thanks a lot for helping me out

[Xenon]

well, you had already run the upgradeXX.php so you have to upload th 2.3.0 member.php not the 229 one

[007]

cool, thanks. Actually, I just restored from my last 2.2.9 backup (which was only like a day old) and everything is fine now. I'll probably upgrade once I get that araxis merge software.