Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/....public_html/subdomains/....../sites/all/modules/fb/facebook-platform/footprints/lib.php on line 13

While this is a great module and has great potential I am trying to figure out and make an application. After having some trouble I tried to set up the included footprints example. I keep getting sql errors. I have re read everything several times. Downloaded the latest versions and double checked the code.

The above code points to

function get_prints($user) {
  $conn = get_db_conn();
  $res = mysql_query('SELECT `from`, `to`, `time` FROM footprints WHERE `to`=' . $user . ' ORDER BY `time` DESC', $conn);
  $prints = array();
  while ($row = mysql_fetch_assoc($res)) {
    $prints[] = $row;
  }

with line 13 being while ($row = mysql_fetch_assoc($res)) {
Can anyone help?

Comments

stieglitz’s picture

When I click on the "kick" button in the application I then get these errore

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/******/public_html/subdomains/******/sites/all/modules/fb/facebook-platform/kickers/lib.php on line 13

Warning: Missing argument 3 for FacebookRestClient::notifications_send(), called in /home/******/public_html/subdomains/morethanthethought/sites/all/modules/fb/facebook-platform/kickers/lib.php on line 52 and defined in /home/*****/public_html/subdomains/*******/sites/all/modules/fb/facebook-platform/php/facebookapi_php5_restlib.php on line 1412

Fatal error: Call to undefined method FacebookRestClient::feed_publishActionOfUser() in /home/******/public_html/subdomains/******/sites/all/modules/fb/facebook-platform/kickers/lib.php on line 58
Dave Cohen’s picture

Status: Active » Closed (won't fix)

You're trying to use facebook's example application. Which really has nothing to do with Drupal or Drupal for Facebook modules.

If you figure it out let us know. But that's all code you downloaded from facebook, not from these modules.