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

Submitted by:  Dirk Schaller <dschaller>
Submitted on:  Mon 08 Mar 2004 12:56:48 PM UTC  
 
Item Group: SVN trunk (dev code)Category: API - phpGroupware API
Severity: 6 - SecurityPriority: 9 - Immediate
Status: FixedPrivacy: Public
Assigned to: Jonathan Rivera <jarg>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - SuSE
Reproducibility: NonePlanned 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>In charge of this item.
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>In charge of this item.
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>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 6 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Wed 12 May 2004 08:55:19 PM UTCjargOpen/ClosedOpen=>Closed
Fri 12 Mar 2004 02:57:55 PM UTCAlbertaneCarbon-CopyRemoved rmcardle --AT-- sheapc --DOT-- com=>-
Fri 12 Mar 2004 02:34:27 PM UTCAlbertaneCarbon-Copy-=>Added rmcardle --AT-- sheapc --DOT-- com
Fri 12 Mar 2004 08:29:24 AM UTCdgraverCarbon-Copy-=>Added dgraver
Fri 12 Mar 2004 04:49:21 AM UTCjargStatusNone=>Fixed
Thu 11 Mar 2004 08:30:54 PM UTCjargAssigned toalexbsa=>jarg

Back to the top


Powered by Savane 3.1-cleanup1