email password

[monstergamer]

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?

$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

[Boofo]

Look for this:

INSERT INTO useractivation

[monstergamer]

i found it 2 times
then do what

[Boofo]

Post that code here so I can see what the problem is.

[monstergamer]

Database error in vBulletin 2.3.0:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 1, 1054954949, '10887819', 1, )

mysql error: You have an error in your SQL syntax near ')
' at line 5

mysql error number: 1064

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

[monstergamer]

this is what i had before i replaced it

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

[monstergamer]

i just replaced it with original
i did not lose but one hack
kept it just in case
so far every thing is working

thanx for helping

[Boofo]

What did you replace it with?

[TECK]

06-06-03 at 10:14 PM monstergamer said this in Post #3 (https://vborg.vbsupport.ru/showthread.php?postid=405305#post405305)
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
https://vborg.vbsupport.ru/showthread.php?postid=406108#post406108

[monstergamer]

did not work for me