CiviCRM Community Forums (archive)

DB was upgraded from 2.2.7 to 3.3.5 successfully but error upgrading to 4.0 ALPHA due to privelledges (NB the user changed in between so the need to check privelledges may not be new but core error rather than graceful error due to missing super)

/home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Core/Error.php, backtrace, 205 , handle, /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/PEAR.php, call_user_func, 931 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB.php, PEAR_Error, 968 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/PEAR.php, DB_Error, 564 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/common.php, raiseError, 1903 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/mysql.php, raiseError, 898 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/common.php, simpleQuery, 1216 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/DataObject.php, query, 2420 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/packages/DB/DataObject.php, _query, 1606 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Core/DAO.php, query, 145 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Core/I18n/Schema.php, query, 308 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Upgrade/Form.php, rebuildMultilingualSchema, 289 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Upgrade/Form.php, processLocales, 301 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Upgrade/Page/Upgrade.php, processSQL, 225 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/CRM/Core/Invoke.php, run, 224 /home/www-home/apps/civicrm-4.0.alpha2/civicrm/drupal/civicrm.module, invoke, 385 , civicrm_invoke, /home/www-home/drupal7/includes/menu.inc, call_user_func_array, 501 /home/www-home/drupal7/index.php, menu_execute_active_handler, 22
Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Error Details
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DROP TRIGGER IF EXISTS civicrm_contact_before_update [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
    [type] => DB_Error
    [user_info] => DROP TRIGGER IF EXISTS civicrm_contact_before_update [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TRIGGER IF EXISTS civicrm_contact_before_update [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]"]
)