In the page ?q=admin/settings/facebook_status
When I go to Miscellaneous, and choose "all but the latest status update for each user I get this warning.

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 'ORDER BY sid ASC' at line 1 query: DELETE FROM facebook_status WHERE ORDER BY sid ASC in /var/www/pares/includes/database.mysql.inc on line 174.

Thanks

Oskar

Comments

icecreamyou’s picture

icecreamyou commented
Title: I found a sql error. » SQL error on status deletion
Component: User interface » Code - Functionality
Assigned: Unassigned » icecreamyou
Priority: Normal » Minor
Status: Active » Postponed (maintainer needs more info)

That only happens when you have no statuses in your database, and I don't know why you would want to delete statuses if you don't have any to start with. That setting is a one-time-use option to clear old statuses, not a permanent option that only saves the most recent status.

I'll look at getting rid of the error anyway and improving the description of that setting next week.

By the way, whenever you're reporting an SQL error, you should include what version of SQL you have. MySQL 5 is the most common. If you don't know, check ?q=admin/logs/status.

icecreamyou’s picture

icecreamyou commented
Status: Postponed (maintainer needs more info) » Fixed

Fixed locally. I'll try to get a dev out later this week.

Status: Fixed » Closed (fixed)

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