I get this when I install
| Project: | Media Mover |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
I don't understand why.
* 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= 1 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 40 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 38 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 80 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 39 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 72 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 10643 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 38 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 38 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 562 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 10343 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 10761 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.
* 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= 10766 AND status = AND status = 8 ORDER BY cid in beta/includes/database.mysql.inc on line 174.

#1
i just updated to drupal 5.16 and mm rc4 and now i get a similar issue but only with less items. i have disabled and then uninstalled the mm api and then reactivated the module but the error persists. returning to rc3 fixed it.
#2
Got the the same reaction as plasticlax. Drupal is up to date. Going back to RC3 fix it also for me.
#3
fix is in CVS for this, also fixed D6
#4
Automatically closed -- issue fixed for 2 weeks with no activity.
#5
I get same error in 6.13
It was because of cookies. I disabled my cookiesafe extention. and it is solved.