CiviCRM Community Forums (archive)

I was testing and have created an event and cancelled some of the people that did not attend. I noticed a couple of things:

1) The 'to' time does not seem to be localized in the email. I had this problem also with another screen which was fixed, but here it still seems to be wrong. (also in the contact dashboard, but that doesn't seem to be consistant.. see screen shot)
2) When I changed to status the checkbox for 'send email' was unchecked, but still the system send out an email to the participant (this actually happend with live data.. I had to email the people that it was only a test)
3) Then I disabled the email handler under the email settings and cancelled another participant. The system didn't like that and gave me a warning. But I figured 'no outgoing email' should notify the system that no email should go out (so why that warning and the 'tip' to correct the settings).
4) When changing the status the dropdown is not localized. I know I can change the label, but that only shows in the overviews, not in the drop down. The name itself I cannot change because it is reserved (unless I go at database level). So I still think this is an error (I reported this in a seperate post, but that is locked now).

Could anyone comment if 2 & 3 are intended behaviour?

When changing the participant status of an event I get the following error. I got this after upgrading to 3.01 (didn't have this before). The participant status is however changed after checking the participant again.

Edit: Actually the error below pops up at several places related to an event. It shows up when registering and when deleting an event also.


--------------------------------------------------------------------------------

DB Error: syntax error

Database foutcode: 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, 1064

Terug naar home page

Error Details:


Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
  SELECT  participant.id
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=109 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
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=109 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
    FROM  civicrm_participant participant
   WHERE  participant.registered_by_id=109 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]"]
)


tried to replicate the problem on the demo site. Unfortunately not able to 

not sure... I put the localization back to english, but the problem still persists. Also it started after upgrading to 3.01.

I'll try to downgrade back to 3.0 and see if the problem is still there

indeed, when I put the label (name) back to cancelled it seems to work again.

I'll wait for the formal patch (in 3.02?) to solve the issue.

Thanks!!