CiviCRM Community Forums (archive)

Sometimes I run in to error messages in the front-end Civi user interface, and they always seem to appear in my log file as well (located at drupal/sites/default/files/civicrm/upload/CiviCRM.log ). Now I have run in to an error message, and there is nothing in the log file. The issue that generated the error message is probably a separate issue. I do need to figure that out obviously, but I feel like first I should figure out why Civi didn't write to the log, because if I can get Civi to log a backtrace (as Civi usually does), then it will be easier to fix the immediate issue I'm having.

The immediate issue is:
I tried registering a dummy user for a new event I created. (I've tried this in test mode and live mode). After clicking continue to proceed to PayPal (using PayPal standard), I received the following non-recoverable error:

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

[c0de] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
  SELECT  participant.id, participant.contact_id
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=5781 AND participant.status_id !=  [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 '' at line 3]
    [type] => DB_Error
    [user_info] =>
  SELECT  participant.id, participant.contact_id
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=5781 AND participant.status_id !=  [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 '' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
  SELECT  participant.id, participant.contact_id
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=5781 AND participant.status_id !=  [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 '' at line 3]"]
)

After this mess, I've checked the data, and: the new dummy user was created but no event participation was recorded for the new user.

I'm running CiviCRM 3.1.1 with Drupal 6.9.

If anyone can help me figure out how to get Civi to write to the log file, that would be really great. I've verified my resource URLs and directories, and the log file is writable by all users.

the log files have been moved, they are now at:

drupal/sites/default/files/civicrm/templates_c/LOCALIZATION_DIR/ConfigAndLog/

lobo