CiviCRM Community Forums (archive)

Hello everyone,

i hope someon can shine some light on the following problem.

Some information at first:
On this server there is MySQL version 5.1.66 and
And  php5 -version
PHP 5.3.3-7+squeeze15 with Suhosin-Patch (cli) (built: Mar  4 2013 14:05:25)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
    with Xdebug v2.1.0, Copyright (c) 2002-2010, by Derick Rethans
    with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH

We have a policy on database servers to exclude the rights "execute" and "grant" to users. The server admin does not want this.
Recently we added the Dutch translation to the website. And now it gives a database error each time there is a contact update in the specific field "telephone".

After reading the backtrace (I inculded the backtrace underneath) i noticed in #6 That the user "demoeeatworknl" has no execute rights. After i gave the user this right there was no more errors. And everything went smooth and super.

Case closed i would think, where it not that our policy doesn't want to give these users execute rights.
So my question is the following:
Why does it need "execute" rights for the db user and is there a way to save a contact without use of the "execute" for a db user?


thnx in advance,
Klaas

------------
backTrace
-------------
#0 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
#4 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
#5 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...", "DB_Error", TRUE)
#6 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1370 ** execute command denied to user 'demoeeatworknl'@'%' for routine 'civi...")
#7 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
#9 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
#10 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_phone (contact_id , location_type_id , is_primary , is_bi...")
#11 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/BAO/Phone.php(74): CRM_Core_DAO->save()
#13 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(361) : eval()'d code(1): CRM_Core_BAO_Phone::add((Array:8))
#14 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(361): eval()
#15 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(66) : eval()'d code(1): CRM_Core_BAO_Block::create("phone", (Array:39), NULL)
#16 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(66): eval()
#17 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php(353): CRM_Core_BAO_Location::create((Array:39), TRUE)
#18 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Contact/Form/Contact.php(986): CRM_Contact_BAO_Contact::create((Array:39), TRUE, FALSE, TRUE)
#19 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Form.php(246): CRM_Contact_Form_Contact->postProcess()
#20 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(151): CRM_Core_Form->mainProcess()
#21 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contact_Form_Contact), "upload")
#22 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Contact), "upload")
#23 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Contact), "upload")
#24 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("upload")
#25 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#26 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Invoke.php(266): CRM_Utils_Wrapper->run("CRM_Contact_Form_Contact", "Nieuw contact", (Array:1))
#27 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#28 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#29 /var/www/html/ee-atwork/demo.ee-atwork.nl/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:3))
#30 [internal function](): civicrm_invoke("contact", "add")
#31 /var/www/html/ee-atwork/demo.ee-atwork.nl/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#32 /var/www/html/ee-atwork/demo.ee-atwork.nl/index.php(21): menu_execute_active_handler()
#33 {main}

Excuus maar we kunnen dit nu niet leveren.
DB Error: unknown error
------------