CiviCRM Community Forums (archive)

CiviCRM's backend seems to work and I can edit various bits of the configuration, set tabs, create groups etc. However, whenever I try to create any sort of contact (organisation, individual etc) I get a database error report (this one on a "check for matching contacts" when putting in my name, but similar output when trying to create a contact). Obviously I've had to change the name and password a bit..

Sorry. A non-recoverable error has occurred.


DB Error: insufficient permissions

Database Error Code: Access denied for user 'xxx-x-xxx-xxx'@'%' to database 'xxx-x-xxx-xxx', 1044

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [JUST_ADDED_TO_STOP_FORUM_READING_THIS_TAG_WRONGcode] => -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 = 'ed' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'xxxxxxxx' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user 'xxxxxx-x-xxx-xxx'@'%' to database 'xxxxxx-x-xxx-xxx']
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = 'xxxxxx' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'xxxxxxxx' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user 'xxxxxx-x-xxx-xxx'@'%' to database 'xxxxxx-x-xxx-xxx']
    [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 = 'xxxxxx' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'xxxxxxxx' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user 'xxxxxx-x-xxx-xxx'@'%' to database 'xxxxxx-x-xxx-xxx']"]
)
Any ideas? The database is on 'localhost' but shows as '@'%' on this. The database name, password and format all look right in the config files that I have found, and clearly it can access them for the other functionality.

Thanks. I took this up with my hosting provider and was told that they only grant the following rights:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES
by default and will grant the following if asked, but no others.
CREATE TEMPORARY TABLES, CREATE VIEW, and CREATE ROUTINE

I've now asked for CREATE TEMPORARY TABLES
but am I likely to have any problems with this set of commands?

Thanks.