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) »
  • Install problems -- tables not being created
Pages: [1]

Author Topic: Install problems -- tables not being created  (Read 2166 times)

ct9787

  • Guest
Install problems -- tables not being created
December 18, 2009, 04:55:21 am
I'm trying to install CiviCRM 3.0.3 on Drupal 6.15. I've followed the directions and put in all the information for the Database Version and Connection Settings and got all green. Then, whether or not I install sample data, when I click to Install CiviCRM the next page always says this:


Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...
Cannot execute -- * -- * -- * -- * CREATE TABLE civicrm_currency ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT ''Currency Id'', name varchar(64) COMMENT ''Currency Name'', symbol varchar(8) COMMENT ''Currency Symbol'', numeric_code varchar(3) COMMENT ''Numeric currency code'', full_name varchar(64) COMMENT ''Full currency name'' , PRIMARY KEY ( id ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: syntax error


I've searched and searched and can't figure out what I'm doing wrong. Please help!

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Install problems -- tables not being created
December 18, 2009, 07:27:43 am
Quote from: ct9787 on December 18, 2009, 04:55:21 am
I'm trying to install CiviCRM 3.0.3 on Drupal 6.15. I've followed the directions and put in all the information for the Database Version and Connection Settings and got all green. Then, whether or not I install sample data, when I click to Install CiviCRM the next page always says this:

Installing CiviCRM...

I am now running through the installation steps (this should take a few minutes)

If you receive a fatal error, refresh this page to continue the installation

Building database schema and setup files...
Cannot execute -- * -- * -- * -- * CREATE TABLE civicrm_currency ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT ''Currency Id'', name varchar(64) COMMENT ''Currency Name'', symbol varchar(8) COMMENT ''Currency Symbol'', numeric_code varchar(3) COMMENT ''Numeric currency code'', full_name varchar(64) COMMENT ''Full currency name'' , PRIMARY KEY ( id ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci: DB Error: syntax error


I've searched and searched and can't figure out what I'm doing wrong. Please help!

Just a quick check: did you chose a non-default installation language?
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

ct9787

  • Guest
Re: Install problems -- tables not being created
December 18, 2009, 07:48:13 am
Nope, just used the default English.

chillin411

  • I’m new here
  • *
  • Posts: 6
  • Karma: 1
Re: Install problems -- tables not being created
December 18, 2009, 08:04:01 am
If the forum didn't mess with the query at all... it looks like it's the comments that's causing the issue.  If they're a pair of single-quotes in a row, then it's seeing it as a blank comment, with bad syntax being what you want to be the comment.

What version of MySQL are you running, by chance?

ct9787

  • Guest
Re: Install problems -- tables not being created
December 18, 2009, 08:20:16 am
MySQL version 5.1.30

So you think I should edit some of the .mysql files? I looked at a few of them and only found '' for certain values within the civicrm_data.mysql file so far. There are some double quotes (") used in the comments in civicrm.mysql.

Btw, it installed just fine as a component of a Joomla 1.5 install on the same server.
« Last Edit: December 18, 2009, 12:56:05 pm by ct9787 »

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Install problems -- tables not being created
December 21, 2009, 06:47:16 am
Can you try installing 3.0.2 instead? That would at least tell us whether the problem is with CiviCRM or (possibly) something else.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Install problems -- tables not being created

This forum was archived on 2017-11-26.