Hello,
I ve installed Facebook Event module with FBconnect.. (using Drupal 7.10)
after created (as documentation the field , the event etc..) when i try to see the node i get the following SQL error :
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 the right syntax to use near '))' at line 1: SELECT u.uid AS uid, u.fbuid AS fbuid FROM {fbconnect_users} u WHERE (u.fbuid IN ()) ; Array ( ) in fb_event_update_event_members_rsvp() (line 420 of/....../sites/all/modules/fb_event/fb_event.module).

... so the error refers to this : 

    $result = db_select('fbconnect_users', 'u')
    ->fields('u', array(
      'uid',
      'fbuid',
    ))
    ->where('u.fbuid IN (:fbus)', array(':fbus' => array_keys($members)))
    ->execute();

PHP 5.3.3
MySQL : 5.0.77
finally trying to check the array $members ... its obviously empty...
Any help would be great ,
Thanks

Comments

vinoth.3v’s picture

vinoth.3v commented
Status: Active » Fixed

add this empty check statement to that function. 


  $fb_members = fb_event_get_event_members_from_facebook($eid);
  
  if (empty($fb_members)) {
    return  $members;
  }

fix is updated to git.

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

(not verified) commented
Issue summary: View changes

server specs