Hi,

I'm having a problem with running boost crawler (all other boost functionality works perfectly!).
Log
testd 09/10/2010 - 21:45 http://job-rate-ru.1gb.ru/admin/reports/status/run-c ... admin
php 09/10/2010 - 21:45 You have an error in your SQL syntax; check the ... guest

Error message
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 'USING drupal_boost_cache AS ca WHERE cr.hash=ca.hash_url AND ca.expire BETWEEN 1' at line 1 query: DELETE cr FROM drupal_boost_crawler cr USING drupal_boost_cache AS ca WHERE cr.hash=ca.hash_url AND ca.expire BETWEEN 1 AND 434966399 OR ca.expire > 434966400 в файле /home/virtwww/w_job-rate-ru_60dda51b/http/sites/all/modules/boost/boost.module in line 5550.

Can it be connected with the latest fixes to PostgreSQL on Sep 09?

CommentFileSizeAuthor
#1 boost-907898.patch1.87 KBmikeytown2

Comments

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Active » Needs review
StatusFileSize
new boost-907898.patch1.87 KB

Appears to be very related to this fix #888816: Postgresql error in reports while prune_tables of the boot_crawler
I think I will have to select the query based off of what kind of database engine your using.

Georgii’s picture

Georgii CreditAttribution: Georgii commented

Thanks for so fast response!
I'll try to check this fix from an updated dev bundle of this module.
Thanks again!

mikeytown2’s picture

mikeytown2 CreditAttribution: mikeytown2 commented
Status: Needs review » Fixed

committed

Georgii’s picture

Georgii CreditAttribution: Georgii commented
Status: Fixed » Closed (fixed)

Verified. Thank you!