This problem first occurred following an update. I skipped a Drupal version, which created numerous problems with MySQL. All but this one have been resolved. Most current version of Drupal 5.2 is installed, amazontools was deleted, then reinstalled. I have enabled the module and set permissions. When I enable block to the front page I get the following error:

user warning: You have an error in your SQL syntax near 'OFFSET 11' at line 1 query: SELECT * from amazonitem LIMIT 1 OFFSET 11 in /home/critcrim/includes/database.mysql.inc on line 172.

I get a similar error (x10 - one for each item) when searching with amazon item import:

user warning: You have an error in your SQL syntax near 'ON v.vid = vnt.vid WHERE vnt.type = 'amazon_node' ' at line 2 query: SELECT v.* FROM vocabulary_node_types vnt JOIN vocabulary v ON v.vid = vnt.vid WHERE vnt.type = 'amazon_node' ORDER BY weight, vid LIMIT 1 in /home/critcrim/includes/database.mysql.inc on line 172.

Clicking on manage, when in amazon item import, gives the following error:

user warning: You have an error in your SQL syntax near 'UNION SELECT 'stale' as counttype, count(asin) FROM amazonitem WHERE pricedate' at line 2 query: SELECT 'total' as counttype, count(asin) AS count from amazonitem UNION SELECT 'stale' as counttype, count(asin) FROM amazonitem WHERE pricedate <= '2007-09-01' in /home/critcrim/includes/database.mysql.inc on line 172.

My database includes amazonitem and amazonnode. I repaired these tables with no error. All errors refer to includes/database.mysql.inc on line 172. I don't see anything on this line that is an obvious error.

Any suggestions?

Comments

mentor’s picture

I solved my own problem by updating to the most recent version of MySQL.

mentor’s picture

Status: Active » Closed (fixed)