By fuzi on

I got lots database.mysql.inc on line 174.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 'SELECT MIN(eid) FROM notifications_queue)' at line 1 query: DELETE FROM notifications_event WHERE created < 1253355048 AND eid < (SELECT MIN(eid) FROM notifications_queue) in /homepages/htdocs/includes/database.mysql.inc on line 174.

The site is hosted at 1and1 which has been updated many times, MySQL database 4.0.27 , Drupal 5.19

Any help?

Regards

Fuzi

⋅ Categories: Drupal 5.x

Comments

matt_harrold’s picture

matt_harrold commented

What contributed modules have you installed?

It seems to be a problem with whichever module manages the notifications_queue table.

Try disabling that module, if the error goes away, post an issue on the project page. You'll likely find a quick answer if you know which module started the trouble.

darrylh’s picture

darrylh commented

The new query is using subselects (the bold bit below), which aren't supported by MySQL 4.0.

DELETE FROM notifications_event WHERE created < 1253355048 AND eid < (SELECT MIN(eid) FROM notifications_queue)

MySQL 4.0 is seriously out of date, and may even be out of support too - upgrade it to at least version 5.0.