I'm getting this in the watchdog on cron run, on D5, PHP 4.3.8, MSQL 4.0.26.

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 'SELECT uid FROM users WHERE login <> 0 AND uid <> 0 AND status query: DELETE FROM account_reminder WHERE uid IN (SELECT uid FROM users WHERE login <> 0 AND uid <> 0 AND status = 1) in /home/www/foobar.com/includes/database.mysql.inc on line 174.

Any idea what may be causing this? Thanks.

Comments

jaydub’s picture

jaydub CreditAttribution: jaydub commented
Status: Active » Closed (won't fix)

You are using MySQL 4.0 which does not support subselects. That is why the query is failing (as it uses a subselect). I hate to say it but you are really really out of date still running MySQL 4. Even if you just upgrade to 4.1 you will be able to run this. Better yet would be to upgrade to 5.0.

While you are at it, you really really should upgrade PHP to 5.2.x!

AppleBag’s picture

AppleBag CreditAttribution: AppleBag commented

Thanks, lol, I really wish I could upgrade both, but the guy I rent server space from absolutely refuses to upgrade. Says some php scripts on other sites on the server would break if we did. :/