email password

i keep having problems with the email the user thir password any body know how i can fix it

[Boofo]

It kind of helps to know what problems you are having.

[monstergamer]

oh sorry
it give me a database error

Database error in vBulletin 2.3.0:

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

mysql error number: 1136

[Boofo]

Ok, now we need the query that that is coming from. You forgot to add something when you installed a hack in the value area.

[monstergamer]

i install the newest ver.. of the lesser admin
and now the email password dont work

[Boofo]

What did it tell you to add to that query? You forgot the second part of it.

[monstergamer]

i dont know what query your talking about

this is all it gives me
Database error in vBulletin 2.3.0:

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

mysql error number: 1136

Date: Friday 06th of June 2003 09:12:00 PM
Script: http://www.monstergamer.net/vb/vb/member.php
Referer: http://www.monstergamer.net/vb/member.php?action=lostpw

[Boofo]

This is the query in an unhacked member.php file. What does yours look like in that file?

PHP Code:

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


[filburt1]

It also sounds like a bad upgrade. Make sure you followed all of the upgrade steps correctly.

[monstergamer]

what line is it close to
i dont have it