CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • My Contact Dashboard broken after upgrade to 4.1
Pages: [1]

Author Topic: My Contact Dashboard broken after upgrade to 4.1  (Read 849 times)

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
My Contact Dashboard broken after upgrade to 4.1
March 17, 2012, 02:47:15 am
Upgraded our site to 4.1 this morning with no installation/upgrade issues :) and completed the setting and testing of the new cron job(s)

However, when My Contact Dashboard is accessed, a non-recoverable error is generated! Details as follows:
Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [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 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]
    [type] => DB_Error
    [user_info] => SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [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 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count( DISTINCT  DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 1 AND civicrm_participant.is_test = 0 )  AND (contact_a.is_deleted = 0)     [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 'DISTINCT(civicrm_participant.id) )  FROM civicrm_contact contact_a LEFT JOIN civ' at line 1]"]
)

and in Drupal:
Code: [Select]
$backTrace = /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 205 , handle, /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/mysqli.php, raiseError, 928 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/mysqli.php, mysqliRaiseError, 402 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1614 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 166 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 944 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php, singleValueQuery, 3817 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/default/files/civicrm/ceed/scripts/CRM/Event/Selector/Search.php, searchQuery, 290 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php, getTotalCount, 238 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Event/Form/Search.php, __construct, 442 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Event/Form/Search.php, postProcess, 192 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/Form.php, preProcess, 329 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Event/Page/UserDashboard.php, run, 59 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Event/Page/UserDashboard.php, listParticipations, 72 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Contact/Page/View/UserDashBoard.php, run, 149 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Contact/Page/View/UserDashBoard.php, buildUserDashBoard, 212 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 227 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 352 , civicrm_invoke, /var/www/vhosts/ceed-scotland.com/httpdocs/crm/includes/menu.inc, call_user_func_array, 349 /var/www/vhosts/ceed-scotland.com/httpdocs/crm/index.php, menu_execute_active_handler, 17

Any idea?
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: My Contact Dashboard broken after upgrade to 4.1
March 17, 2012, 03:26:00 am
Edited Display Preferences and unchecked Events under the Contact Dashboard section. The error no longer occurs.
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: My Contact Dashboard broken after upgrade to 4.1
March 17, 2012, 03:42:28 am
Oversight on my part this time :-[. Noticed a little custom file that found it's way into my upgraded version. The code changes to this are no longer compatible with this version of CiviCRM :(

Apologies for posting without more research...
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • My Contact Dashboard broken after upgrade to 4.1

This forum was archived on 2017-11-26.