[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] Error on Usergroup delete if members exist
From: |
Dave Hall |
Subject: |
Re: [Phpgroupware-users] Error on Usergroup delete if members exist |
Date: |
Mon, 14 Apr 2003 20:11:10 +1000 |
Rüdiger Götz <address@hidden> wrote:
> Hello!
>
> Whenever I want to delete a user group that still has members, i
> am asked if I
> really want to delete the user gruop. Like this:
>
> -------------------------------------------------------------------
> -
> Are you sure you want to delete this group ?
>
> <phpdemo3> phpdemo3, phpdemo3
> Sorry, the above users are still a member of the group dummygroup.
> They must be removed before you can continue.
> Remove all users from this group?
> [Yes] [No]
> -------------------------------------------------------------------
> -
>
> If I click [YES] i get the following error:
>
> -------------------------------------------------------------------
> -
> Database error: Invalid SQL: DELETE FROM phpgw_app_sessions WHERE
> loginid = '8' AND
> app = 'phpgwapi' AND location = 'phpgw_info_cache'
> MySQL Error: 1100 (Table 'phpgw_app_sessions' was not locked with
> LOCK TABLES)
>
> Session halted.
> -------------------------------------------------------------------
> -
Can you try it again with this change:
Go into Admin->Site Configuration
Change cache phpgw_info_array from yes to no
Try again.
btw what happens if you select no at the prompt?
>
> ...however after that the user group has no more members, and so
> can be deleted next
> time without any warnings.
>
> I just co'ed via cvs, so I have the latest .014-branch version.
> -> SuSE Linux 8.1
> -> Apache 1.3.26-57
> -> PHP 4.2.2-168
> -> MySQL 3.23.52-44
>
>
>
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>