A new day, a new error ... Can't figure out what I did wrong here. My app is working better today, so long as I set the fb app NOT to create a new local account when a fb user adds the application. When I set it to add a new account, I get this error on the facebook page:

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 realm = 'fb_friend') OR (gid = 831308770 AND realm = 'fb_friend')) AND grant' at line 1 query: SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = AND realm = 'fb_friend') OR (gid = 831308770 AND realm = 'fb_friend')) AND grant_view >= 1 in /home/travelc/public_html/includes/database.mysql.inc on line 172.

The facebook URL is:

http://apps.facebook.com/gadgetoftheday/

Comments

Dave Cohen’s picture

Dave Cohen commented
Assigned: Unassigned » Dave Cohen

I need to fix this. It only occurs when your facebook user has no friends. Is that the case here?

nk126’s picture

nk126 commented

Yes! Awesome. I mean, not awesome that you need to fix, but awesome that that's the case. My poor dummy tester account users have no friends, but my real account and the couple of real people I got to test *do* have friends and didn't get the error. Thanks, Dave.

Dave Cohen’s picture

Dave Cohen commented
Status: Active » Fixed

If just checked in a fix.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

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