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]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              ryan ryan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: