CiviCRM Community Forums (archive)

Hello,

I am using civicrm on Joomla. It was working fine until yesterday. I created an event. Added several people to the event.

This morning, when I tried to get to civicrm, from the dash board showing activity report, I get this error:

Sorry. A non-recoverable error has occurred.

DB Error: syntax error

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 ') INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_conta' at line 7, 1064

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_temp_target_contact_71cefb7c9fb3dc694d76a1297af2cd60 ( activity_id, target_contact_id, target_contact_name )
                  SELECT at.activity_id,
                  at.target_contact_id ,
                  c.sort_name
                  FROM civicrm_activity_target at
                  INNER JOIN civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60 ON ( at.activity_id = civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_id
                    AND civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_type_id <>  )
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_contact_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 ')
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_conta' at line 7]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_temp_target_contact_71cefb7c9fb3dc694d76a1297af2cd60 ( activity_id, target_contact_id, target_contact_name )
                  SELECT at.activity_id,
                  at.target_contact_id ,
                  c.sort_name
                  FROM civicrm_activity_target at
                  INNER JOIN civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60 ON ( at.activity_id = civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_id
                    AND civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_type_id <>  )
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_contact_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 ')
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_conta' at line 7]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_temp_target_contact_71cefb7c9fb3dc694d76a1297af2cd60 ( activity_id, target_contact_id, target_contact_name )
                  SELECT at.activity_id,
                  at.target_contact_id ,
                  c.sort_name
                  FROM civicrm_activity_target at
                  INNER JOIN civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60 ON ( at.activity_id = civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_id
                    AND civicrm_temp_activity_details_71cefb7c9fb3dc694d76a1297af2cd60.activity_type_id <>  )
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_contact_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 ')
                  INNER JOIN civicrm_contact_ja_JP c ON c.id = at.target_conta' at line 7]"]
)
[/quote]

Mysql version 5.0.89 Community

Any suggestions?

Thanks.


Thank you.

Exactly that was the reason. I was able to come back without any error afterward.

Cheers!