Jump to content

Recommended Posts

Posted

I use the ldap plugin to auto create users from AD.

 

when I go into the user manager and delete somone i get the following error.

 

phpbb3 User Delete: Error Could not retrieve reported posts/topics by user : DB function failed with error number 1064
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 p.post_id = r.post_id' at line 4 SQL=SELECT r.post_id, p.topic_id FROM phpbb_reports r, phpbb_posts p WHERE r.user_id = AND p.post_id = r.post_id 
phpbb3 User Delete: Error Could not delete reports by user : DB function failed with error number 1064
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 '' at line 1 SQL=DELETE FROM phpbb_reports WHERE user_id = 
phpbb3 User Delete: Error Could not update forum last poster for user : DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_forums SET forum_last_poster_id = 1, forum_last_poster_name = 'Guest', forum_last_poster_colour = '' WHERE forum_last_poster_id = 
phpbb3 User Delete: Error Could not update posts by user : DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_posts SET poster_id = 1, post_username = 'Guest' WHERE poster_id = 
phpbb3 User Delete: Error Could not update edited posts by user : DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_posts SET post_edit_user = 1 WHERE post_edit_user = 
phpbb3 User Delete: Error Could not update topics by user : DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_topics SET topic_poster = 1, topic_first_poster_name = 'Guest', topic_first_poster_colour = '' WHERE topic_poster = 
phpbb3 User Delete: Error Could not update last topic poster for user : DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_topics SET topic_last_poster_id = 1, topic_last_poster_name = 'Guest', topic_last_poster_colour = '' WHERE topic_last_poster_id = 
phpbb3 User Delete: Error Could not delete records from users for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_users WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from user_group for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_user_group WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from topics_watch for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_topics_watch WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from forums_watch for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_forums_watch WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from acl_users for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_acl_users WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from topics_track for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_topics_track WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from topics_posted for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_topics_posted WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from forums_track for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_forums_track WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from profile_fields_data for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_profile_fields_data WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from moderator_cache for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_moderator_cache WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from drafts for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_drafts WHERE user_id = 
phpbb3 User Delete: Error Could not delete records from bookmarks for user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_bookmarks WHERE user_id = 
phpbb3 User Delete: Error Could not retrieve undeliverd messages to user : DB function failed with error number 1064
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 folder_id = -3' at line 4 SQL=SELECT msg_id, user_id FROM phpbb_privmsgs_to WHERE author_id = AND folder_id = -3 
phpbb3 User Delete: Error Could not delete private messages that are in no folder from user : DB function failed with error number 1064
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 folder_id = -3' at line 3 SQL=DELETE FROM phpbb_privmsgs_to WHERE author_id = AND folder_id = -3 
phpbb3 User Delete: Error Could not delete private messages to user : DB function failed with error number 1064
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 '' at line 2 SQL=DELETE FROM phpbb_privmsgs_to WHERE user_id = 
phpbb3 User Delete: Error Could not update rest of private messages for user to anonymous: DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_privmsgs_to SET author_id = 1 WHERE author_id = 
phpbb3 User Delete: Error Could not update rest of private messages for user to anonymous: DB function failed with error number 1064
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 '' at line 3 SQL=UPDATE phpbb_privmsgs SET author_id = 1 WHERE author_id =

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...