[support] Odd 'fatal error' but no problems in database and no changes to drupal files

[Chris Johnson]

Nick Holden wrote:

>  Fatal 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 '' 
> at line 1 query: SELECT title FROM node WHERE nid= 
> in /home/newawl/www/includes/database.mysql.inc on line 97

> I stopped MySQL and checked all the tables. Nothing wrong, even on extended 
> check. The error appears on every possible URL within the site, and seems to 
> suggest that drupal is sending a malformed query to the database.
> 
> Drupal is 4.4.1 (yeah, I know, we've been meaning to upgrade for a while), php 
> is 4.3.10-15 and MySQL is Ver 12.22 Distrib 4.0.24 - nothing has changed in 
> recent days, yet suddenly this lot won't talk to each other.

I think you are right that Drupal is sending a malformed query.  It appears to 
be specifically the book.module that is generating it (or possibly a 
contributed module).

The next step is kind of tough.  It's being generated on your home page, so 
among the questions I have is what you have as a setting for your default 
front page in the admin->settings menu (try 
http://www.workersliberty.org/admin/settings or umm, 
http://www.workersliberty.org/?q=admin/settings) to see if you can look at it.

Also, it might be useful to see the error log, if you can get to it.  Try 
http://www.workersliberty.org/admin/logs/error or 
http://www.workersliberty.org/?q=admins/logs/error).

I hope I have those non-clean URLs right, with the ?q= bits.

You might try disabling the book module, if you can get there: 
http://www.workersliberty.org/admin/modules or 
http://www.workersliberty.org/?q=admin/modules.

..chrisxj