Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.1
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
the profile listings are working great, but unfortunately the error on registration persists. i've loaded 2771 but didn't do anything to the mysql tables. php 4.3.10 and MySQL version 4.0.23-standard-log.
peace.
-ryan
Sorry. A non-recoverable error has occurred.
Database Error Code: 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 civicrm_contact.id IN ( )' at line 2, 1064
Return to CiviCRM menu.
error
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_custom_value ON ( civicrm_custom_value.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_custom_value.entity_id ) WHERE civicrm_contact.id IN ( ) AND civicrm_contact.id IN ( ) [nativecode=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 civicrm_contact.id IN ( )' at line 2]
[type] => db_error
[user_info] => SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_custom_value ON ( civicrm_custom_value.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_custom_value.entity_id ) WHERE civicrm_contact.id IN ( ) AND civicrm_contact.id IN ( ) [nativecode=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 civicrm_contact.id IN ( )' at line 2]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT civicrm_contact.id as id FROM civicrm_contact LEFT JOIN civicrm_custom_value ON ( civicrm_custom_value.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_custom_value.entity_id ) WHERE civicrm_contact.id IN ( ) AND civicrm_contact.id IN ( ) [nativecode=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 civicrm_contact.id IN ( )' at line 2]"]
)