[META] AdvAgg D7 - Cron [#1805548]

Getting this error on cron runs:

WD cron: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for   [error]
the right syntax to use near '%d' at line 1: 
    SELECT COUNT(DISTINCT bundle_md5) AS advagg_count
    FROM advagg_bundles
    WHERE timestamp < %d
  ; Array
(
    [0] => 1345939666
)
 in advagg_cron() (line 310 of advagg.module).

Comments

Comment #1

AlvaroDeMendoza CreditAttribution: AlvaroDeMendoza commented 5 November 2012 at 23:09

It seems like a mistake on syntax porting on advagg.module at line 305+-. I don't know how to roll the patch. Change

// Prune old bundles
  $bundles_removed += db_query("
    SELECT COUNT(DISTINCT bundle_md5) AS advagg_count
    FROM advagg_bundles
    WHERE timestamp < %d
  ", array($max_bundle_time))->fetchField();

for this

 // Prune old bundles
  $bundles_removed += db_query("SELECT COUNT(DISTINCT bundle_md5) AS advagg_count FROM {advagg_bundles} WHERE timestamp = :timestamp", array(':timestamp' => $max_bundle_time))->fetchField();

Comment #2

shunting CreditAttribution: shunting commented 25 November 2012 at 23:07

This made the error go away for me. Thanks.

Comment #3

markhalliwell

English

CreditAttribution: markhalliwell commented 13 January 2013 at 09:41

Title:	MySQL error on cron run	» [META] AdvAgg D7 - Cron
Assigned:	Unassigned	» markhalliwell
Status:	Active	» Needs review

I'll review this once a few other issues have been settled.

I'm renaming this issue to become the meta issue for #1171546: AdvAgg - D7 Port/Re-write and placing it on the issue summary of that issue. This will need to be fixed before a stable release can be made.