+ Post New Thread
Results 1 to 2 of 2
EduGeek Joomla 1.5 Package Thread, problems deleting users in Projects:; I use the ldap plugin to auto create users from AD. when I go into the user manager and delete ...
  1. #1

    Join Date
    Jun 2008
    Posts
    91
    Thank Post
    8
    Thanked 4 Times in 4 Posts
    Rep Power
    14

    problems deleting users

    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.

    Code:
    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 =

  2. #2

    Join Date
    Jun 2008
    Posts
    91
    Thank Post
    8
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    As a second note i have added jfusion and a phpbb3 forum?

    any ideas guys or shall i hammer the jfusion boards about this?

SHARE:
+ Post New Thread

Similar Threads

  1. prevent users from deleting start menu items
    By techie211 in forum Windows Server 2000/2003
    Replies: 10
    Last Post: 1st September 2009, 03:58 PM
  2. Replies: 5
    Last Post: 10th February 2009, 05:33 PM
  3. Replies: 3
    Last Post: 10th September 2008, 04:43 PM
  4. Explaining the cause of problems to users
    By pete in forum General Chat
    Replies: 18
    Last Post: 7th November 2006, 10:16 AM
  5. Any problems with 'limited' users?
    By ajbritton in forum Windows
    Replies: 6
    Last Post: 16th April 2006, 04:09 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •