Sql error

That error should be impossible. It would only happen if the facebook_status_views_handler_argument_rels_and_me Views argument handler was used, but that handler only gets used if the User Relationships module exists. Anyway, committed a change to dev that should probably fix this -- it just makes extra-sure that the UR module is installed before trying to use it.

Greetings,

I too was getting the same error with 6.x-3.0-rc3, I uninstalled it and installed the dev version (and ran update.php) with UR installed and am still getting this SQL error.

I got the same error too with latest DEV version. I have the User Relationship module. Any help please?

Had the same problem. Then enabled the UR-Views part of the the User Relationships module and everything worked fine.

Ah, that's probably it. I changed the module (6.x, 7.x) so that it won't use the UR view unless UR Views is enabled.

I'm getting a similar error. Don't know what I'm looking at but will post it anyway. I just upgraded from an earlier version. I simply pasted the new version into my modules folder. I'm going to uninstall everything and re-do this and post my results. I currently have UR-Views enabled. But I'm using 6.x-3.0.

UPDATE

I uninstalled old version, re-installed, update.. but still get this error upon viewing my blocks 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 'FROM users users INNER JOIN facebook_status facebook_status ON users.uid = fac' at line 13 query: SELECT COUNT(*) FROM (SELECT users.uid AS uid, facebook_status.sid AS facebook_status_sid, users.picture AS users_picture, users.name AS users_name, users.mail AS users_mail, facebook_status.message AS facebook_status_message, facebook_status.sender AS facebook_status_sender, facebook_status.recipient AS facebook_status_recipient, facebook_status.type AS facebook_status_type, facebook_status.created AS facebook_status_created, content_id, FROM users users INNER JOIN facebook_status facebook_status ON users.uid = facebook_status.sender LEFT JOIN location_instance location_instance ON users.uid = location_instance.uid LEFT JOIN location location ON location_instance.lid = location.lid WHERE ((facebook_status.message) != ('')) AND (facebook_status.type in ('user')) AND (location.latitude > 39.3992765417 AND location.latitude < 42.2948434583 AND location.longitude > -98.6816280496 AND location.longitude < -94.8535279504) GROUP BY facebook_status.sid, uid, facebook_status_sid, users_picture, users_name, users_mail, facebook_status_message, facebook_status_sender, facebook_status_recipient, facebook_status_type, facebook_status_created, content_id, ORDER BY facebook_status_sid DESC ) count_alias in /Users/Cale/Sites/acquia-drupal/sites/all/modules/views/includes/view.inc on line 805.

• 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 'FROM users users INNER JOIN facebook_status facebook_status ON users.uid = fac' at line 13 query: SELECT users.uid AS uid, facebook_status.sid AS facebook_status_sid, users.picture AS users_picture, users.name AS users_name, users.mail AS users_mail, facebook_status.message AS facebook_status_message, facebook_status.sender AS facebook_status_sender, facebook_status.recipient AS facebook_status_recipient, facebook_status.type AS facebook_status_type, facebook_status.created AS facebook_status_created, content_id, FROM users users INNER JOIN facebook_status facebook_status ON users.uid = facebook_status.sender LEFT JOIN location_instance location_instance ON users.uid = location_instance.uid LEFT JOIN location location ON location_instance.lid = location.lid WHERE ((facebook_status.message) != ('')) AND (facebook_status.type in ('user')) AND (location.latitude > 39.3992765417 AND location.latitude < 42.2948434583 AND location.longitude > -98.6816280496 AND location.longitude < -94.8535279504) GROUP BY facebook_status.sid, uid, facebook_status_sid, users_picture, users_name, users_mail, facebook_status_message, facebook_status_sender, facebook_status_recipient, facebook_status_type, facebook_status_created, content_id, ORDER BY facebook_status_sid DESC LIMIT 0, 5 in /Users/Cale/Sites/acquia-drupal/sites/all/modules/views/includes/view.inc on line 810.

As of now, looks like my problem was not enabling Facebook-style Statuses Flags along with FBSS and Comments. I had enabled only those three boxes on previous versions. But like I said I disabled, uninstalled and deleted the folder.. So guess there's still a connection. Anyway, no more error for the time being.