email password

i keep having problems with the email the user thir password any body know how i can fix 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

PHP Code:

$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
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/showthrea...108#post406108

[monstergamer]

did not work for me