[TalkVirginia]

Originally Posted by doobiefillin

is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

PHP Code:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate = UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options & 16 AND usergroupid IN ('6','2','') AND rmoptout = 0 LIMIT 10;;

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 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number  : 1064
Request Date  : Friday, May 20th 2011 @ 01:30:51 AM
Error Date    : Friday, May 20th 2011 @ 01:30:51 AM
Script        : http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer      : http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version : 


Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.

PHP Code:

"SET rmEmailDate = UNIX_TIMESTAMP(), "; 


3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim