CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Need help resolving this issue
Pages: [1]

Author Topic: Need help resolving this issue  (Read 1008 times)

joegodin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Wordpress
  • MySQL version: 5.5.25a
  • PHP version: 5.3.27
Need help resolving this issue
October 15, 2013, 05:44:43 am
I'm running 4.3 on PHP 5.3.27 (could that be an issue?, installation guide says 5.3.3 +) and MySQL MySQL 5.5.25a

"Unable to create temporary tables. This MySQL user is missing the CREATE TEMPORARY TABLES privilege.
Could not create a table."

CiviCRM Database Details : all ok except tables excerpt above

Requirements: PHP Configuration and File permissions all marked ok

Myphpadmin is 4.0 and doesn't seem to give me an option to grant user the "Create Temporary Tables" privilige in any obvious way. I've tried by using SQL query method but I may not using the right syntax.

Any of you encounter this and how might I resolve it?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Need help resolving this issue
October 15, 2013, 06:33:16 am

might be quicker and faster to go a google/mysql search on granting all permissions via command line and using that

i'm pretty sure the civicrm install wiki has the right syntax, so might want to check there

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

joegodin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Wordpress
  • MySQL version: 5.5.25a
  • PHP version: 5.3.27
Re: Need help resolving this issue
October 15, 2013, 05:29:44 pm
It turns out that the webhost restricts certain MySQL privileges ie: Create Temporary Tables so they opened a ticket. Thanks lobo. I did type away at the command line today and learned a bit about syntax though!  :)

joegodin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Wordpress
  • MySQL version: 5.5.25a
  • PHP version: 5.3.27
Re: Need help resolving this issue
October 16, 2013, 06:02:15 am
Got the grant privileges I needed and go the green light but when I hit the install I got a hundred lines that look like this:

"DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024
Code: [Select]
=> -1 [message] => DB Error: unknown error [userinfo] => CREATE TABLE `civicrm_option_value` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID', `option_group_id` int unsigned NOT NULL COMMENT 'Group which this option belongs to.', `label` varchar(255) NOT NULL COMMENT 'Option string as displayed to users - e.g. the label in an HTML OPTION tag.',  and the rest is here
 [url]http://loanfund.ca/blog/wp-content/uploads/2013/10/DB-ERROR.txt[/url]

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Need help resolving this issue
October 16, 2013, 06:21:07 am
"Specified key was too long; max key length is 1000 bytes"

You seem to have a rather limiting hosting provider. I'd suggest to go to a more "normal" one that has less restrictions, as no matter how cheap they are, it's not going to justify the amount of time you'll have to put in to work around their limitations.

Check with them for instance how many emails you can send. Another common problem with "restrictive" hosting providers.

X+

-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

joegodin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Wordpress
  • MySQL version: 5.5.25a
  • PHP version: 5.3.27
Re: Need help resolving this issue
October 16, 2013, 06:42:51 am
Seems like this is pretty identical to my issue - http://issues.civicrm.org/jira/browse/CRM-11163. It appears that type of tables are MyISAM and not InnoDB so I'll have to request them to enable that for me.

joegodin

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Wordpress
  • MySQL version: 5.5.25a
  • PHP version: 5.3.27
Re: Need help resolving this issue
October 16, 2013, 07:21:24 am
Looking for a new webhost! Thanks very much for reading my posts and making suggestions to help me. I learned alot over the past 24 hrs....

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Need help resolving this issue
October 16, 2013, 07:35:10 am

the few civi specific hosts who are also amazing community members include:

cividesk
civihosting
civisites

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Need help resolving this issue

This forum was archived on 2017-11-26.