SQL error message
michelejohnston - March 15, 2007 - 15:48
| Project: | Recent Changes |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
Description
On my recent_changes page, I get this error message:
user warning: 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 COUNT(*) FROM default_node_revisions) + (SELECT COUNT(*) query: SELECT (SELECT COUNT(*) FROM default_node_revisions) + (SELECT COUNT(*) FROM default_comments) in /www/drupal5/includes/database.mysql.inc on line 172.You can see it here:
http://www.yourcarnegie.com/recent_changes
I just upgraded to the newest release and it was not fixed.
Thanks in advance.
#1
Can you tell me which MySQL version you have?
You find it under 'admin/logs/status'.
#2
I get this error message too when clicking on "recent changes", though I appear to get most of the output I expect as well. Here are some details:
Message is:
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 COUNT(*) FROM drupal_node_revisions) + (SELECT COUNT(*) query: SELECT (SELECT COUNT(*) FROM drupal_node_revisions) + (SELECT COUNT(*) FROM drupal_comments) in /homepages/0/d133612164/htdocs/drupal/includes/database.mysql.inc on line 172.
From admin/logs/statusreport:
Drupal 5.1
Configuration file Protected
Cron maintenance tasks Never run
Cron has not run. It appears cron jobs have not been setup on your system. Please check the help pages for configuring cron jobs. You can run cron manually.
Database schema Up to date
File system Writable (public download method)
MySQL database 4.0.27
PHP 4.4.4
Unicode library PHP Mbstring Extension
Web server Apache/1.3.33 (Unix)
Hope this helps,
David Herbert.
#3
See here: http://drupal.org/node/132854