Active
Project:
Yahoo Terms
Version:
6.x-7.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 May 2011 at 17:15 UTC
Updated:
12 May 2011 at 17:15 UTC
I run Yahoo Terms Batch Processing. I get the following error:
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 'OFFSET 0 LIMIT 10' at line 1 query: SELECT nid FROM node WHERE type = 'book' ORDER BY nid ASC OFFSET 0 LIMIT 10 in /org/apache2/htdocs/sites/all/modules/yahoo_terms/yahoo_terms.module on line 558.
I checked the MySQL manual and it indicates the correct syntax is 'LIMIT 10 OFFSET 0'. I replaced the existing code with code conforming to this syntax and batch processing runs without generating this error.