[Phpgroupware-tracker] [bug #5996] Problem with authentification in LDAP ( in mysql :)

[nobody]

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

Submitted by: Caeies                  Project: phpGroupWare                 
Submitted on: Thu 10/16/03 at 14:29
Category:  API - phpGWapi             Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  Problem with authentification in LDAP ( in mysql :)

Original Submission:  This is the result :

Warning: Missing argument 2 for equal() in 
phpgroupware/phpgroupware/phpgwapi/inc/class.sql.inc.php on line 56

Database error: Invalid SQL: SELECT contact_person.person_id AS person_id, 
contact_person.first_name AS per_first_name, contact_person.last_name AS 
per_last_name, contact_person.initials AS per_initials, contact_person.title AS 
per_title, contact_person.department AS per_department, contact_person.pubkey 
AS per_pubkey FROM phpgw_contact_person AS contact_person INNER JOIN 
phpgw_contact AS contact_central ON contact_central.contact_id = 
contact_person.person_id WHERE (contact_central.contact_type_id = AND 
contact_central.contact_id = 5)

MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 'AND 
contact_central.contact_id = 5)' at line 1)



File:    phpgroupware/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php

Line: 990



Session halted.



After looking at the line 990, it seems that the LDAP use the ->get_persons 
function, which don't provided one argument ( don't know why 
contact_central.contact_type_id is empty !)



I'll will try to investigate where is the problem.

To reproduce the bug :

>From a fresh install, configure your application and choose LDAP has protocol 
>to authentification.

Fill in the right values into the context/rootdn/...

save.

Then choose to create a new admin account (4th option in the next screen) fill 
in the fields and submit.

The error occurs here.



Hope this help.

Please fill free to contact me.



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=5996&group_id=509

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