On cron runs, I get php errors in my dblog:

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 'LIMIT 0, 0' at line 1 query: SHOW TABLES LIKE '' LIMIT 0, 0 in boost.module on line 1471.

It seems that $table is somehow lost in db_query_range(), which happens on this line in boost.module:

if (db_result(db_query_range("SHOW TABLES LIKE '%s'", $table))) {

Should it perhaps be like this?

if (db_result(db_query_range("SHOW TABLES LIKE '%s'", $table, 0, 1))) {

CommentFileSizeAuthor
#4 boost-549126.patch775 bytesmikeytown2

Comments

Anonymous’s picture

Anonymous (not verified) commented

Ahh, you cant use LIMIT statement with SHOW TABLES, so I think this is the answer:

if (db_result(db_query("SHOW TABLES LIKE '%s'", $table))) {

drop _range

Anonymous’s picture

Anonymous (not verified) commented
Title: boost_get_time() misses $table » db_query_range() should be db_query() on line 1417
Anonymous’s picture

Anonymous (not verified) commented
Title: db_query_range() should be db_query() on line 1417 » db_query_range() should be db_query() on line 1471
mikeytown2’s picture

mikeytown2 commented
Status: Active » Needs review
StatusFileSize
new boost-549126.patch775 bytes

thanks for the bug report!

mikeytown2’s picture

mikeytown2 commented
Status: Needs review » Fixed

committed

Status: Fixed » Closed (fixed)

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