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.