CiviCRM Community Forums (archive)

[Error: Upgrade DB to 4.2.alpha1: SQL]
Error Field   Error Value
Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   DROP TRIGGER IF EXISTS civicrm_acl_before_insert [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
DebugInfo   DROP TRIGGER IF EXISTS civicrm_acl_before_insert [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
#   Function   Location
0   CRM_Core_Error::exceptionHandler(Object(DB_Error))   unknown:unknown
1   call_user_func(Array, Object(DB_Error))   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2   PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB.php:968
3   DB_Error->DB_Error(-1, 16, Array, 'DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4   PEAR->raiseError(null, -1, null, null, 'DROP TRIGGER IF …', 'DB_Error', true)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1903
5   DB_common->raiseError(-1, null, null, null, '1227 ** Access d…')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6   DB_mysql->mysqlRaiseError()   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7   DB_mysql->simpleQuery('DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8   DB_common->query('DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:2421
9   DB_DataObject->_query('DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:1613
10   DB_DataObject->query('DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:155
11   CRM_Core_DAO->query('DROP TRIGGER IF …', true)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:922
12   CRM_Core_DAO::executeQuery('DROP TRIGGER IF …')   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Logging/Schema.php:123
13   CRM_Logging_Schema->dropTriggers(null)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:1535
14   CRM_Core_DAO::triggerRebuild()   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:386
15   CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_runSql(Object(CRM_Queue_TaskContext), '4.2.alpha1')   unknown:unknown
16   call_user_func_array(Array, Array)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
17   CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
18   CRM_Queue_Runner->runNext(true)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
19   {closure}()   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
20   CRM_Queue_ErrorPolicy->call(Object(Closure))   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
21   CRM_Queue_Page_AJAX::runNext(Array)   unknown:unknown
22   call_user_func(Array, Array)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:185
23   CRM_Core_Invoke::invoke(Array)   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/admin.civicrm.php:87
24   civicrm_invoke()   /usr/local/www/htdocs/joomla/administrator/components/com_civicrm/admin.civicrm.php:40
25   require_once('/usr/local/www/h…')   /usr/local/www/htdocs/joomla/libraries/joomla/application/component/helper.php:388
26   JComponentHelper::executeComponent('/usr/local/www/h…')   /usr/local/www/htdocs/joomla/libraries/joomla/application/component/helper.php:357
27   JComponentHelper::renderComponent('com_civicrm')   /usr/local/www/htdocs/joomla/administrator/includes/application.php:152
28   JAdministrator->dispatch()   /usr/local/www/htdocs/joomla/administrator/index.php:46
29   {main}   


is it me, or is this not very descriptive?

I've hit the same problem.
I've checked logging is defiantly off
challenge seems to be that my cpanel doesn't let me add a superuser privilege (or even a trigger permission). Couple of questions
1) Anyone know a way round the cpanel issue (for someone with a moderate tech expertise)
2) when trying to find an answer to this I found a number of pages saying I should never grant superuser privileges to a production web application due to security implications? Any comments.
3) the site is still in maintenance mode but seems to be working ok - what's likely to happen if I just leave it (I'm more thinking do I need to keep the site off whilst I sort this)? To rerun the script I guess I need to restore the backup database first?

cheers Jon

FYI response from our host:

"Unfortunately it is not currently possible to grant TRIGGER access - This is a limitation with the 5.0 version of MySQL currently in use on our systems, we are however currently in the process of updating our systems to MySQL version 5.1 (which enables support for TRIGGER access to individual users) and would expect this to be available within the next few weeks at most."


Which on re-reading the update instruction is my own fault

"MySQL 5.0.x or higher with InnoDB support : CiviCRM is compatible the current generally available MySQL release. Note that MySQL 5.1 is recommended for new installations and for sites during upgrades as CiviCRM is beginning to use Triggers more (eg to support multi-lingual installations), which require SUPER privileges in MySQL 5.0."

wondered however if it is making this clearer e.g. if you do not have super privileges upgrade will fail

not as far as I am aware - was turned off when I checked before upgrade

Hi

I'm facing same issue using when installing CiviCRM Extensions, using the API in a Drupal Module and so.
My ISP doesn't allow me the set SUPER privileges to user in DB server.

Why this SUPER privileges are necessary? to install Extensions, using the API? I couldn't figure out where exactly these TRIGGER operations are called