The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.Hi friends of Drupal Commerce,
Drupal Commerce installation fails when using POSTGRESQL database.
Here is my configuration:
commerce_kickstart-7.x-1.6 (tested with manual modul installation as well with the same error)
PostgreSQL 8.3
PHP 5.3.2
Lighttpd 1.4.20
The
Set up database
step is passed without errors.
The error occures during the
install profile
step at round about 15% and looks like this:
An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows.
...some unimportant linies...
Configure siteExample storeFinished SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "commerce_kickstart_field_data_commerce_customer_address_entity_" already exists
This error is not only related to the automated Drupal Commerce Kickstart installation process it occures when you add the Drupal Commerce Modules to an existing Drupal installation, too.
By the way I have not seen any database specific problems when using
Drupal 7.x
and
ubercart-7.x-3.0
with a PostgresSQL 8.3 database yet.
greetings
Metulski
Comments
Comment #1
rszrama commentedLooks to me like some sort of index added by the Field module for an address field is too long for Postgres. I bet if you weren't using database prefixing it'd work just fine. Perhaps your prefix wasn't as long when you were testing Ubercart?
Comment #2
Metulski commentedYes the suggested table prefix "commerce_kickstart_" in the "Set up database" step seems to be too long (especially for PostgreSQL databases, I have not tested MySQL databases)
Today I used a shorter prefix "c_" and the installation was successfull.
Thanx for your workaround.
Comment #3
rszrama commentedExcellent, glad it worked. There may be some other funny limitations like that, so I'd also advise you to keep your custom field names short just in case. : )