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 »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Drupal 6.8/CivicCRM 2.1.4 on XAMPP
Pages: [1]

Author Topic: Drupal 6.8/CivicCRM 2.1.4 on XAMPP  (Read 3535 times)

mocolvin

  • I’m new here
  • *
  • Posts: 23
  • Karma: 0
Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 21, 2008, 05:02:28 pm
I have been trying to install CivicCRM with Drupal on a test platform using XAMPP.  I have worked through all of the errors but one which says "Unable to create temporary tables. This MySQL user is missing the CREATE TEMPORARY TABLES privilege."  The user ("root") in question is the same as the user for the drupal MySQL database, and I have made sure that "root" has universal privileges for CivicCRM and the drupal database.  I have even refreshed the privileges a couple of times to make sure that the changes I made were in the MySQL data.  What am I missing?  This has to be something incredibly simple, but I'm totally flummoxed at this point.

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: Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 21, 2008, 05:15:20 pm

Sorry, there was a bug we introduced when we added the temporary table check (in 2.1.2 i think). We need the CiviCRM DB to be created before the install process. I'll edit the documentation to reflect this

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

mocolvin

  • I’m new here
  • *
  • Posts: 23
  • Karma: 0
Re: Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 21, 2008, 06:51:56 pm
Does that mean that I'm good to go--that the installation has been successful?  Or is there something else I need to do before I can begin configuring CivicCRM?

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: Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 21, 2008, 06:58:20 pm

please create the civicrm db before you start the install process and hopefully the error will disapper

let me know if that works. if so, i'll backport the fix to 2.1.5

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

mocolvin

  • I’m new here
  • *
  • Posts: 23
  • Karma: 0
Re: Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 21, 2008, 07:32:55 pm
I did create civiccrm before the installation.  Now, when I look at the Drupal modules, the 4 CivicCRM modules are there.  The civiccrm database shows no tables having been created.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Drupal 6.8/CivicCRM 2.1.4 on XAMPP
December 22, 2008, 09:55:31 pm
If you ran the install script after creating that DB - and there are still no tables in that DB - then something went wrong?? You could try running the install script again (maybe drop and create the DB again before running it). If still no joy, then you could try going through the manual installation procedures here (they're officially for 2.0, not 2.1 but I think the steps are the same):

http://wiki.civicrm.org/confluence/display/CRMDOC/Install+2.0+for+Drupal+Manually
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Drupal 6.8/CivicCRM 2.1.4 on XAMPP

This forum was archived on 2017-11-26.