Author Topic: Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled (Read 695 times)

richardprice · June 22, 2010, 07:56:37 am

CiviCRM is perfect for my needs and there is no other tool out there that compares, open source or comercial!

I have run into a big problem and need a little advice please.

CiviCRM installed using the 'alt' version and I was able to adjust all the settings. However when I came to enter some data I keep getting the following error

Code: [Select]

Sorry. A non-recoverable error has occurred.
DB Error: insufficient permissions
Database Error Code: Access denied for user 'dsscacom88295110'@'%' to database 'site_dssca_com', 1044
Return to home page.

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, 10 .....
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE dedupe SELECT id id, 10 .....

After some research I found out is was due to the CREATE_TEMPORARY_TABLES option not being active in MySQL.

I spoke to my hosting provider and have since been told that they cannot activate this option as I am on a shared server and it would be a security risk.

I do not really want to have to go to a new host (just yet!) so was wondering if there is a way to run CiviCRM without the CREATE_TEMPORARY_TABLES option enabled?

Thanks for advice in advance.

Richard[/code]

Kurund Jalmi · June 22, 2010, 08:12:07 am

Richard:

If you think CiviCRM suits your needs, then I would recommend migrating to server that support temporary table creation etc. This way you will be able to use most of the feature of CiviCRM without having need to modify the code base.

HTh
Kurund

richardprice · June 28, 2010, 11:44:11 am

The problem is that I can only find dedicated servers that allow this feature, which are too expensive for the size of the website. I cannot find any shared hosting that allows it?

xavier · June 28, 2010, 02:07:27 pm

Check on the forum, seems to be plenty on vps or shared hosting that work with civicrm.

This being said, you will have problems if you want to host civicrm, or any powerful software on a few bucks per month kind of offer.

The financial gain you might get by going for the cheapest won't be offset by the cost of the time you spend on it, nor the hours your users will lost when cheaposhosting decided to go dark because one of the 1000th of other domain name hosted on the box killed it and there is no one on their side to reboot it until whenever.

Good luck!

X+

CiviCRM Community Forums (archive)

News:

Author Topic: Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled (Read 695 times)

richardprice

Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled

Kurund Jalmi

Re: Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled

richardprice

Re: Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled

xavier

Re: Use CiviCRM without CREATE_TEMPORARY_TABLES Enabled