I get this when I install

SocialNicheGuru - February 17, 2009 - 21:58
Project:Media Mover
Version:6.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Description

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

plasticlax - February 26, 2009 - 01:14

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

romansta - February 27, 2009 - 08:54

Got the the same reaction as plasticlax. Drupal is up to date. Going back to RC3 fix it also for me.

#3

arthurf - February 27, 2009 - 21:19
Status:active» fixed

fix is in CVS for this, also fixed D6

#4

System Message - March 13, 2009 - 21:20
Status:fixed» closed

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

#5

cem kaan - August 28, 2009 - 18:20
Version:5.x-1.0-rc4» 6.x-1.x-dev

I get same error in 6.13
It was because of cookies. I disabled my cookiesafe extention. and it is solved.

 
 

Drupal is a registered trademark of Dries Buytaert.