[Delphiprogrammi]

Originally Posted by dai-kun

I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

should be:

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/

1)you are right about the MySQL query that's a typo.I have updated the zip package

2)i think that problem is caused by the username cache vbulletin uses the system isn't yet implemented to use that.I have no experience with it so kinda scared i mess up hehe