Closed (fixed)
Project:
Media Mover
Version:
5.x-1.0-rc4
Component:
User interface
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Mar 2009 at 12:58 UTC
Updated:
25 Mar 2009 at 17:09 UTC
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 'AND status = 8 ORDER BY cid' at line 1 query: SELECT mmfid, cid FROM media_mover_files WHERE nid= 6 AND status = AND status = 8 ORDER BY cid in /var/www/html/drupal5/includes/database.mysql.inc on line 174.
Comments
Comment #1
neopoet commentedChanging line 2535 in media_mover_api.module from:
if ($status) {
$status = " AND status = ". msql_escape_string($status) .' ';
}
to:
if (is_numeric($status)) {
$status = " AND status = ". msql_escape_string($status) .' ';
}
seems to at least stop the log entry, however it doesn't seem to fix the underlying problem (the harvesting function not working)
Comment #2
arthurf commentedPlease give the dev release a try- that should solve your issue.
Comment #3
arthurf commented