BP 1.2 r2246 – Database error on Friends tab in Profile page
-
Last time I posted an error with the default theme on the Members page if Friends is disabled. Now, enabling the Friends feature gave another error, this time it’s with mySQL.
This error message shows up on the ‘Friends (0)’ tab within my user profile page:
WordPress database error 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 FROM_UNIXTIME(um.meta_value) DESC LIMIT 0, 10' at line 1 for query SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND u.ID IN () ORDER BY FROM_UNIXTIME(um.meta_value) DESC LIMIT 0, 10 made by include, require, require_once, do_action, call_user_func_array, bp_core_do_catch_uri, load_template, require_once, locate_template, load_template, require_once, bp_has_members, BP_Core_Members_Template->bp_core_members_template, BP_Core_User->get_users WordPress database error 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 FROM_UNIXTIME(um.meta_value) DESC' at line 1 for query SELECT COUNT(DISTINCT u.ID) FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND um.meta_key = 'last_activity' AND u.ID IN () ORDER BY FROM_UNIXTIME(um.meta_value) DESC made by include, require, require_once, do_action, call_user_func_array, bp_core_do_catch_uri, load_template, require_once, locate_template, load_template, require_once, bp_has_members, BP_Core_Members_Template->bp_core_members_template, BP_Core_User->get_users
I really am not sure what this is about. Is it to do with mySQL version that I’m running?
- The topic ‘BP 1.2 r2246 – Database error on Friends tab in Profile page’ is closed to new replies.