bugphpGroupWare - Bugs: bug #8048, SQL LOCK problem when adding new...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #8048: SQL LOCK problem when adding new account

Submitter:  Dirk Schaller <dschaller>
Submitted:  Mon 08 Mar 2004 12:56:48 PM UTC
   
 
Category:  API - phpGroupware API Item Group:  SVN trunk (dev code)
Severity:  6 - Security Priority:  9 - Immediate
Status:  Fixed Privacy:  Public
Assigned to:  jarg Open/Closed:  Closed
Component Version:  SVN Operating System:  GNU/Linux - SuSE
Reproducibility:  None Planned Release:  None
Fixed Release: 

Sun 21 Mar 2004 12:47:34 AM UTC, comment #3: 

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.

Jonathan Rivera <jarg>
Fri 12 Mar 2004 08:36:37 AM UTC, comment #2: 

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.

DG <dgraver>
Fri 12 Mar 2004 04:49:21 AM UTC, comment #1: 

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,

Jonathan Rivera <jarg>
Mon 08 Mar 2004 12:56:48 PM UTC, 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.

Dirk Schaller <dschaller>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 6 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-05-12 jarg Open/ClosedOpen Closed
2004-03-12 Albertane Carbon-CopyRemoved rmcardle --AT-- sheapc --DOT-- com -
2004-03-12 Albertane Carbon-Copy- Added rmcardle --AT-- sheapc --DOT-- com
2004-03-12 dgraver Carbon-Copy- Added dgraver
2004-03-12 jarg StatusNone Fixed
2004-03-11 jarg Assigned toalexbsa jarg

Back to the top

Powered by Savane 3.13-bb6a.
Corresponding source code