The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Hi there,
Does anyone know if the standard MySQL user provided with the Freeola VIP hosting + MySQL has the privilege to "CREATE TEMPORARY TABLE". I've installed a component for Joomla called CiviCRM (contact database). Installing and configuring the component seemed to go fine but as soon as I tried to add data, I got an error message through the Joomla interface saying:
[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 ....
Searches on other sites suggest that the database user must have the privilege to create temporary tables and that this might not be standard in some hosts.
cheers
Does anyone know if the standard MySQL user provided with the Freeola VIP hosting + MySQL has the privilege to "CREATE TEMPORARY TABLE". I've installed a component for Joomla called CiviCRM (contact database). Installing and configuring the component seemed to go fine but as soon as I tried to add data, I got an error message through the Joomla interface saying:
[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 ....
Searches on other sites suggest that the database user must have the privilege to create temporary tables and that this might not be standard in some hosts.
cheers
HI StigMil there,
I am also facing the same error in CIVICRM,
can you please tell me. according to your research how to solve this problem. ??
thanks
I am also facing the same error in CIVICRM,
can you please tell me. according to your research how to solve this problem. ??
thanks
Just solved by Robert in Support - reloaded user privileges. Really quick response, great service. Happy customer.
Thanks Eccles - unfortunately have just tried again and received same error message (below). This is from CiviCRM 2.2.2, a component to my Joomla 1.5.10 installation, which works fine. I can configure CiviCRM fine, but get this error whenever I try to add data. I have removed user/db name below but they are correct.
Error Details:
Array
(
[callback] => Array
(
[0] => 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 = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$$_$$$$$'@'localhost' to database '$$$$_$$$$']
[type] => DB_Error
[user_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$_$$$$'@'localhost' to database '$$$$_$$$$']
[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 = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$_$$$$'@'localhost' to database '$$$$_$$$$']"]
)
Error Details:
Array
(
[callback] => Array
(
[0] => 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 = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$$_$$$$$'@'localhost' to database '$$$$_$$$$']
[type] => DB_Error
[user_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 5 weight FROM civicrm_contact WHERE first_name = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$_$$$$'@'localhost' to database '$$$$_$$$$']
[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 = 'Simon' UNION ALL SELECT id id, 7 weight FROM civicrm_contact WHERE last_name = 'Milner' UNION ALL SELECT contact_id id, 10 weight FROM civicrm_email WHERE email = 'NULL' [nativecode=1044 ** Access denied for user '$$$$_$$$$'@'localhost' to database '$$$$_$$$$']"]
)
Ticket replied to. Should work now!
The database was indeed created more than a week ago, so I'll raise the support ticket as you suggest - great stuff, many thanks!
The privileges to create temp tables were add to the process that create VIP MySQL accounts a week or so ago at the request of a customer (possibly you?). As the GRANT statement is run when you create a new database and user, if you had already created your database then the user who has access to it will not have gained these privileges. If this is the case the please send in a support ticket requesting the the CREATE TEMPORARY TABLES option is added to your database user. Please detail your VIP account number, and the name of the database and user. Also reference this post so whoever picks up your ticket can pass it onto me.
Hi there,
Does anyone know if the standard MySQL user provided with the Freeola VIP hosting + MySQL has the privilege to "CREATE TEMPORARY TABLE". I've installed a component for Joomla called CiviCRM (contact database). Installing and configuring the component seemed to go fine but as soon as I tried to add data, I got an error message through the Joomla interface saying:
[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 ....
Searches on other sites suggest that the database user must have the privilege to create temporary tables and that this might not be standard in some hosts.
cheers
Does anyone know if the standard MySQL user provided with the Freeola VIP hosting + MySQL has the privilege to "CREATE TEMPORARY TABLE". I've installed a component for Joomla called CiviCRM (contact database). Installing and configuring the component seemed to go fine but as soon as I tried to add data, I got an error message through the Joomla interface saying:
[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 ....
Searches on other sites suggest that the database user must have the privilege to create temporary tables and that this might not be standard in some hosts.
cheers