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

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:
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.

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

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 :)

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

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.