Page 1 of 1

SQL Error

PostPosted: Wed Sep 06, 2006 6:37 am
Author: ayasha
ok, i have searched the forums and the archives, maybe someone knows if this error has been talked about before and i just cannot find it.

i am trying to clean up my member list, and when i go to delete a member, i get this error, but it seems to delete the member as i wanted.
Could not delete group for this user

DEBUG MODE

SQL Error : 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

DELETE FROM phpbb_groups WHERE group_id =

Line : 317
File : admin_userlist.php


i also want to ask, why does it talk about groups? the 2 deletetions that gave me this error, the members were not in a group.

thanks in advance for any help.

PostPosted: Sat Sep 09, 2006 10:52 pm
Author: computerz
Sounds like you have a syntax distortion in your code, most likely due to a bad edit you made at some point.

Go to your admin/admin_userlist.php file and find the line that begins like this:

$sql = "DELETE FROM " . GROUPS_TABLE . "


Post that and a few lines below that so I can see what you have.

Do the same thing for your admin/admin_users.php file.

Also state the method you're using to delete the user so that we can reproduce your problem.