Add Contact Permission Error Message (joomla!)

[aspagarino]

I have a fresh install of Joomla 1.5.6 with CiviCRM 2.1.alpha4. The Events section seems to be working fine, but I am getting a Permission problem for any Add Contacts function from CiviCRM

backTrace

/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2390
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1583
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 144
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Dedupe/Finder.php, query, 100
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Contact/Form/Individual.php, dupesByParams, 262
, formRule,
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm.php, call_user_func, 1591
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, validate, 289
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php, validate, 148
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 232
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 114
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 169
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/admin.civicrm.php, invoke, 46
/home/user88/ohewear.com/html/joomla/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 23
/home/user88/ohewear.com/html/joomla/libraries/joomla/application/component/helper.php, require_once, 162
/home/user88/ohewear.com/html/joomla/administrator/includes/application.php, renderComponent, 130
/home/user88/ohewear.com/html/joomla/administrator/index.php, dispatch, 67
/home/user88/ohewear.com/html/joomla/administrator/index2.php, include, 14

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: insufficient permissions

    Database Error Code: Access denied for user 'joomla_187166798'@'localhost' to database 'joomla_1871667985', 1044

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )
    /code] => -26
   

[message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = '' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = '' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = '' [nativecode=1044 ** Access denied for user 'joomla_187166798'@'localhost' to database 'joomla_1871667985']
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = '' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = '' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = '' [nativecode=1044 ** Access denied for user 'joomla_187166798'@'localhost' to database 'joomla_1871667985']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = '' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = '' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = '' [nativecode=1044 ** Access denied for user 'joomla_187166798'@'localhost' to database 'joomla_1871667985']"]
)

Any suggestions? Thanks in advance

[Donald Lobo]

the civicrm db user needs permission to create temporary tables. we've started using temporary tables for dupe match check. your civicrm db user does not have that permission (check the error message at the end)

lobo

[aspagarino]

Thanks Lobo ... you solved the problem ... permissions are always a pain to deal!

Just in case someone else get this message I created a brand new userid and password for mysql and change the files in:

civicrm.settings.php

Since I am in a Joomla these files are located in two places:

/administrator/components/com-civicrm/civicrm.settings.php

and

/components/com-civicrm/civicrm.settings.php

[sypl]

Sorry, I'm really clear what you did here. I'm trying to install CiviCRM 2.1 on Drupal 6 and the install won't go through fully as the last prerequisite is that I have the create temporary tables privilege. My web host says that I shouldn't have a problem with this, but I clearly do.

Just in case someone else get this message I created a brand new userid and password for mysql and change the files in:

Can you walk me through what you did here? I've already created a storage database for CiviCRM with a username and password. How do you change the database user's privileges? I am not root admin by the way, just on a shared hosting environment.

[aspagarino]

I am in a virtual server which allows to change permissions to the root level... the hosting is eapps.com, it allows you also to change your php.ini files