Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I get the following error on my event nodes. it shows up on every node and I dont' know why. the node shows fine.
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 ')) LIMIT 0, 100' at line 1 query: SELECT DISTINCT(node.nid), signup_log.uid AS signup_log_uid FROM node node INNER JOIN signup_log signup_log ON node.nid = signup_log.nid WHERE (node.status = '1') AND (node.nid IN ()) LIMIT 0, 100 in /var/www/vhosts/beta.activelyOUT.com/httpdocs/includes/database.mysql.inc on line 172.
i had this problem before upgrading to signup2.6
C
Comments
Comment #1
dwwI don't support older releases when newer ones are available.
Comment #2
socialnicheguru commentedstill occurs on 5.27
deleted and unistalled all signup and anything signup related.
deleted events.
when i created new event i get a long list of errors:
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 81.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 16.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 201.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/modules/views_node.inc on line 801.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/calendar/calendar_ical.module on line 216.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_rss.module on line 56.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 81.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 16.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 201.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/modules/views_node.inc on line 801.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/calendar/calendar_ical.module on line 216.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_rss.module on line 56.
* warning: implode() [function.implode]: Invalid arguments passed in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/modules/views_node.inc on line 677.
* 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 ')) LIMIT 0, 100' at line 1 query: SELECT DISTINCT(node.nid), signup_log.uid AS signup_log_uid FROM node node INNER JOIN signup_log signup_log ON node.nid = signup_log.nid WHERE (node.status = '1') AND (node.nid IN ()) LIMIT 0, 100 in /var/www/vhosts/beta.mysite.com/httpdocs/includes/database.mysql.inc on line 172.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 81.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 16.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 201.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/modules/views_node.inc on line 801.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/calendar/calendar_ical.module on line 216.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_rss.module on line 56.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 81.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 16.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_query.inc on line 201.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/modules/views_node.inc on line 801.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/calendar/calendar_ical.module on line 216.
* warning: Invalid argument supplied for foreach() in /var/www/vhosts/beta.mysite.com/httpdocs/sites/all/modules/views/views_rss.module on line 56.
Comment #3
socialnicheguru commentedI am moving this to viewfield.
a had a link to viewfield to display a view of RSVPs.
i passed in the [nid] of the current node.
because of the recurssion restriction ie.
The fear is that if you pass in the nid of the current node into the argument of the view and the nid is already part of that view then an infinite loop is created.
in the argument code section of my view, I put in the line:
_viewfield_nodestack_pop();
Here is the REALLY smart person who found this out: http://drupal.org/node/165321#comment-1033909
doing so caused errors for the view that was referenced by the viewfield. (see above)
Ok but how do I get rid of the errors?
Thanks,
Chris
Comment #4
socialnicheguru commentedchanging because viewfiled causes the problem.
Chris
Comment #5
socialnicheguru commentedchanging title to better reflect new issue
Comment #6
sunI'm sorry, but there is no maintainer for Viewfield for Drupal 5 and D5 is EOL very soon (with the release of D7).