I get many of error saving a views:
# 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 'WHERE type = 'xxxxxxxxxxxx' AND id = 'views' AND name = '34'' at line 1 query: SELECT * WHERE type = 'xxxxxxxxxxxxxxxxxxxxxxxxxx' AND id = 'views' AND name = '34' in xxxxxxxxxxxxxxxxxxx\sites\all\modules\nodewords\nodewords.module on line 1023.

Line 1023:
$result = db_fetch_object(db_query("SELECT * WHERE type = '%s' AND id = '%s' AND name = '%s'", $content, $type, $id, $name));

$result = db_fetch_object(db_query("SELECT * FROM {nodewords} WHERE type = '%s' AND id = '%s' AND name = '%s'", $type, $id, $name));

Comments

avpaderno’s picture

Title: DB error saving views » Syntax error in SQL query
Status: Active » Fixed

The error has been fixed, and the code committed in CVS.
Thanks for your report.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.