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

[nobody]

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

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:  None                     Assigned to:  None                    
Status:  Open                         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.



No Followups Have Been Posted


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/