[Phpgroupware-tracker] [bugs #8048] SQL LOCK problem when adding new account

[Jonathan Rivera]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #8048] Latest Modifications:

Changes by: 
                Jonathan Rivera <address@hidden>
'Date: 
                Wed 05/12/04 at 20:55 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
              Status | Open                      | Closed







/**************************************************************************/
[bugs #8048] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8048>
Project: phpGroupWare
Submitted by: Dirk Schaller
On: Mon 03/08/04 at 12:56

Category:  API - phpGWapi
Item Group:  devel cvs
Severity:  9 - Blocker
Priority:  Immediate
Resolution:  Fixed
Assigned to:  jarg
Status:  Closed
Component Version:  CVS
Platform Version:  GNU/Linux - SuSE
Reproducibility:  None


Summary:  SQL LOCK problem when adding new account

Original Submission:  I made a new installation and get an error when create 
the second new user account. Creating the first account runs well but all next 
creations fail with the following message:

Database error: Invalid SQL: SELECT contact_comm_descr.comm_descr_id AS 
comm_descr_id, contact_comm_descr.descr AS comm_description, 
contact_comm_descr.comm_type_id AS comm_type FROM phpgw_contact_comm_descr AS 
contact_comm_descr
MySQL Error: 1100 (Table 'contact_comm_descr' was not locked with LOCK TABLES)

File: 
/usr/local/httpd/htdocs/phpgw-projects/phpgwapi/inc/class.contacts_sql.inc.php
Line: 1319
Session halted. 


Follow-up Comments
------------------


-------------------------------------------------------
Date: Sun 03/21/04 at 00:47         By: jarg
dum da da dum, i try to reproduce this problem but i can't, please send me more 
info about your configuratios in phpgw and your software versions.

thanks.

-------------------------------------------------------
Date: Fri 03/12/04 at 08:36         By: dgraver
After the latest CVS update ( class.contacts_sql.inc.php,v 1.17.2.2.2.58 
2004/03/12 00:22:05 ), I am now getting the following SQL Lock error when 
adding a user:

Database error: Invalid SQL: SELECT count(contact_id) AS count_contacts FROM 
phpgw_contact AS contact_central WHERE ((contact_central.contact_id = 69))
MySQL Error: 1100 (Table 'contact_central' was not locked with LOCK TABLES)

File: 
/srv/www/htdocs/ciscoinv/channels-de-cvs/phpgwapi/inc/class.contacts_sql.inc.php
Line: 3100

Session halted.

-------------------------------------------------------
Date: Fri 03/12/04 at 04:49         By: jarg
This has been corrected in CVS.

To grab a complete update of all fixes:

1)  Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite 
distro.

2)  Then just type:
    'cd <your phpgroupware dir>; cvs update -dP'.

You can do step 2 as many times in a day as you wish, and 
will always get the most current bug fixes.

Thanks,





CC List
-------

CC Address                          | Comment
------------------------------------+-----------------------------
dgraver                             | 









For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8048>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/