[Phpgroupware-tracker] [bug #6114] adding an contact to an org results in a SQL error

[nobody]

=================== BUG #6114: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6114&group_id=509

Changes by: Hsing-Foo Wang <address@hidden>
Date: Sat 11/01/2003 at 22:54 (GMT)

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


------------------ Additional Follow-up Comments ----------------------------
This has been fixed in CVS and should be available in the next

release.



=================== BUG #6114: FULL BUG SNAPSHOT ===================


Submitted by: pooh_                   Project: phpGroupWare                 
Submitted on: Wed 10/22/2003 at 09:11
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Immediate                  
Resolution:  Fixed                    Assigned to:  pooh_                   
Status:  Closed                       Component Version:  CVS               
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  adding an contact to an org results in a SQL error

Original Submission:  This is the error that appears when trying to add a 
contact to an org (new org as well as existing org):



-----------



Database error: Invalid SQL: SELECT contact_org_person.person_id AS 
my_person_id, contact_org_person.org_id AS my_org_id FROM 
phpgw_contact_org_person AS contact_org_person WHERE (( 
(contact_org_person.preferred = 'Y' OR contact_org_person.preferred IS NULL) 
AND (contact_org_person.person_id = 4)))

MySQL Error: 1100 (Table 'contact_org_person' was not locked with LOCK TABLES)



File: 
/home/e-smith/files/ibays/test/html/phpgwapi/inc/class.contacts_sql.inc.php

Line: 2556



Session halted.

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

-------------------------------------------------------
Date: Sat 11/01/2003 at 22:54       By: pooh_
This has been fixed in CVS and should be available in the next

release.

-------------------------------------------------------
Date: Wed 10/29/2003 at 07:24       By: eald
Ok, then close you close it when you believe is ok.

I'll assign to you for this, if it becomes a bug again, assign to me (this way 
I wont see the bug while is yours).



Regards

-------------------------------------------------------
Date: Tue 10/28/2003 at 11:01       By: pooh_
seems fixed in latest cvs of october 28th.



Let's wait a few days before closing this one ok?

-------------------------------------------------------
Date: Fri 10/24/2003 at 08:10       By: pooh_
Yes it is still there .. latest cvs applied

-------------------------------------------------------
Date: Fri 10/24/2003 at 04:01       By: eald
Is this still a problem?


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6114&group_id=509

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