Hi.

I'm getting the following error when I try to register for an event after installing the CiviCRM GoToWebinar module. When the module is enable I cannot register for any events--even events that do not have the custom gotomeeting data.

My setup:

CiviCRM 3.4.5
Drupal 6.15
PHP 5.2.4
MySQL 5.0

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 'WHERE entity_id = 108 LIMIT 1' at line 3, 1064
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => 
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 108 LIMIT 1
   [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 'WHERE entity_id = 108 LIMIT 1' at line 3]
    [type] => DB_Error
    [user_info] => 
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 108 LIMIT 1
   [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 'WHERE entity_id = 108 LIMIT 1' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 108 LIMIT 1
   [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 'WHERE entity_id = 108 LIMIT 1' at line 3]"]
)

Comments

spinsheet’s picture

spinsheet commented

Did you ever get this issue solved? I'm running into the same identical problem. Any insight would be appreciated. I'm running Drupal 6.28, CiviCRM 4.3.5, and CiviCRM GoToWebinar 6.x-2.0. My code is as follows:

 [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => 
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 11 LIMIT 1
   [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 'WHERE entity_id = 11 LIMIT 1' at line 3]
    [type] => DB_Error
    [user_info] => 
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 11 LIMIT 1
   [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 'WHERE entity_id = 11 LIMIT 1' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    SELECT civicrm_gotowebinar_webinar_id_
    FROM 
    WHERE entity_id = 11 LIMIT 1
   [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 'WHERE entity_id = 11 LIMIT 1' at line 3]"]