When doing a clean install of commerce_kickstart-7.x-2.x-dev-core (2012-Jul-20) I get this message at the point of 'install demo store' (screenshot 1)

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null

The weird thing is it installs fine on a Drupal Quickstart virtual machine, but it fails on my hosted solution. Not sure what the differences are between the two.
If I click to 'the error page' it continues the install but gives me the same error on a different screen (screenshot 2)
I'm installing all demo content.
After installation it gives me an internal server error (500) when visiting the root domain (www.example.com).

Could this have to do with the database information schema?
Any ideas? Suggestions are very welcome, thanks.

Updates
commerce_kickstart-7.x-2.x-dev-core (2012-Jul-21) doesn't fix this
commerce_kickstart-7.x-2.x-dev-core (2012-Jul-26) doesn't fix this
commerce_kickstart-7.x-2.x-dev-core (2012-Jul-30) doesn't fix this (same 'an error' persists when not installing demo content)
commerce_kickstart-7.x-2.x-dev-core (2012-Jul-31) doesn't fix this (tested with Demo content option, not without)
commerce_kickstart-7.x-2.x-dev-core (2012-Aug-01) doesn't fix this (tested with Demo content option, not without)
commerce_kickstart-7.x-2.x-dev-core (2012-Aug-02) doesn't fix this (tested Demo content - clicking error page gives 'circular dependencies error)
commerce_kickstart-7.x-2.x-dev-core (2012-Aug-03) installs fine without demo content (both with and without additional functionality). 'Demo content: yes' results in the 'SQLSTATE[23000]: Integrity constraint violation' error.
commerce_kickstart-7.x-2.x-dev-core (2012-Aug-09) demo content install fails, install fine without demo content (and all additional functionality)

7.x-2.0-beta1
icv = Integrity constraint violation
ae = 'an error'
ok = installs without errors

Release Demo + Translatable Demo - Translatable Additional functionality
7.x-2.x-dev-core (2012-Jul-21) icv
7.x-2.x-dev-core (2012-Aug-02) icv
7.x-2.x-dev-core (2012-Aug-03) icv ok
7.x-2.x-dev-core (2012-Aug-09) icv ok
7.x-2.0-beta1 icv ae ae (continues install after clicking it [result]
7.x-2.x-dev-core (2012-Aug-10) Pending Pending Pending
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

silkogelman’s picture

Issue summary: View changes

added clean install

silkogelman’s picture

When installing with maintenance account settings left to the default admin/admin it results in this error:
Failure to sort migration list - most likely due to circular dependencies involving CommerceKickstartNodebags_cases,CommerceKickstartNodedrinks,CommerceKickstartNodehats,CommerceKickstartNodeshoes,CommerceKickstartNodestorage_devices,CommerceKickstartNodetops
not sure if this is related or a separate issue.

silkogelman’s picture

Also on the hosted server changing the admin password is not allowed when using the default admin/admin maintenance account setting.
(It works fine on my Quickstart environment)

bojanz’s picture

That's super odd.

The main error is because importing permissions from the feature fails.
The migrate one is because some modules haven't been enabled correctly (or the caches haven't been built correctly) since the base migrations weren't found, Migrate searches for them until it gives up.

Can you make sure you uploaded everything correctly? And try to find info about the hosting environment (PHP version, MySQL variant and version, etc)?

silkogelman’s picture

Quickstart environment
PHP 5.3.5-1ubuntu7.10
MySQL 5.1.63
PHP memory limit 128M

Hosted solution
PHP 5.3.2-1ubuntu4.17
MySQL 5.1.63
PHP memory limit 128M
APC 3.1.6
memcache 3.0.4
Varnish

The next steps I'm taking:

  • delete and Git push the files to make sure the files are ok
  • clear Varnish cache before doing a new clean install

The testsite on the hosted solution does run on a subdomain (http://sub.example.com), but that shouldn't make any difference right?

Update: Clearing Varnish and deleting + pushing the files before doing another clean install did not help.

silkogelman’s picture

Issue summary: View changes

updated with demo content message

silkogelman’s picture

Tested a clean Drupal 7.14 install (no Kickstart) on the hosted environment: that works fine.
Next step is to test with the Drupal core version in Kickstart (core + the patches), but without installing the Kickstart profile.

Update
Kickstart core (core + the patches) without the Kickstart profile works fine (unhid standard profile).

Next step is clean installing Kickstart without all demo content.

silkogelman’s picture

Update
Installation works fine on the hosted solution if 'install the demo store' = No

I also installed all the additional functionality, it seems fine.

The problem seems only to be triggered when choosing to install the demo store.

vasike’s picture

i couldn't reproduce it.

GuGuss’s picture

Haha, And I really can't set the status of that issue to : "Postponed (maintainer needs more info", since s1l already provided all the needed information...

silkogelman’s picture

The Open Deals Distribution might have had a same kind of problem
#3 might contain a clue (not sure):
#1410918: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null

if this problem is limited to my setup only please let this be, I can do without the demo content.
And if one of you wants to have a go at it on my hosted environment, send me a PM and I'll send you the login details.

I'll update this issue with test results once new alphas/betas/rc's come out.
Hopefully it magically solves itself ;)

bojanz’s picture

I'll look into this tomorrow.
The error message sounds familiar.

bojanz’s picture

Issue summary: View changes

added commerce_kickstart-7.x-2.x-dev-core (2012-Jul-21) test results

silkogelman’s picture

With the latest dev (commerce_kickstart-7.x-2.x-dev-core (2012-Jul-26) I'm also getting an 'error' when I am NOT installing all demo content (but do select all the additional extras). Attached is a screenshot.

Not sure if this is related to the Integrity constraint violation error.

When clicking on the error page it continues install, but after a while it generates an internal server error (500) when attempting to go to admin/help/first-steps

bojanz’s picture

Okay, turns out our features were a mess, and that's the reason for these problems.
I've worked on them today in #1691422: Re-export all features, and fixed most of the problems. That has been merged, so please try tomorrow's -dev release and see if anything changed.

If not, I'll access your server during the weekend and debug it there directly.

silkogelman’s picture

Sweet, I'll test it first thing in the morning!

silkogelman’s picture

Unfortunately 7.x-2.x-dev 2012-Jul-28 also generates the error when installing demo content.

Currently installing without demo content, I'll update this comment with the results.

silkogelman’s picture

Installing without demo content but with additional functionality gives 'an error'.

I will wait for #1691422: Re-export all features before trying again.

silkogelman’s picture

Issue summary: View changes

added test results for commerce_kickstart-7.x-2.x-dev-core (2012-Jul-26)

silkogelman’s picture

Issue summary: View changes

added commerce_kickstart-7.x-2.x-dev-core (2012-Jul-30) test results

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Jul-31) test results

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-01) test results

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-02) test results

silkogelman’s picture

ok, I admit I could not resist to test the latest dev (every day :)

It still gives the error (commerce_kickstart-7.x-2.x-dev-core 2012-Aug-02), and clicking to the error page gives this error information:
Failure to sort migration list - most likely due to circular dependencies involving CommerceKickstartNodebags_cases,CommerceKickstartNodedrinks,CommerceKickstartNodehats,CommerceKickstartNodeshoes,CommerceKickstartNodestorage_devices,CommerceKickstartNodetops

silkogelman’s picture

commerce_kickstart-7.x-2.x-dev-core (2012-Aug-03) installs fine without demo, without additional functionality (and Euro and VAT).
Currently testing 'demo:no, additional functionality:all' and 'demo: yes'

Update
Test results:

  • 'demo:no, additional functionality:all' -> installs fine! (no errors during install process)
  • 'demo: yes' ->error -> SQLSTATE[23000]: Integrity constraint violation
silkogelman’s picture

Issue summary: View changes

updated with circular dependencies info dev(2012-Aug-02)

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-03) test results

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-09) test results

silkogelman’s picture

installing beta 1 with demo content and ability to translate generates a notice accompanying the integrity constraint violation.
Notice: Undefined index: delete terms in 10 in user_role_grant_permissions() (line 3041 of /var/www/clients/client58/site187/docroot/modules/user/user.module).

silkogelman’s picture

Issue summary: View changes

updated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-09) additional functionality test results

silkogelman’s picture

Issue summary: View changes

added beta1 results and added the table of test results

silkogelman’s picture

Beta1 generates 'an error' in the case of not installing demo content, but installing all additional functionality.
This error did not occur in in this case with 7.x-2.x-dev-core (2012-Aug-03) and (2012-Aug-09).
Attached is a result of the install after continuing installation by clicking 'an error'.

silkogelman’s picture

Issue summary: View changes

updated with beta1 with additional functionality install option test results

bojanz’s picture

Category: bug » support
Status: Active » Fixed

Examination of s1l's server showed that the server configuration is to blame.

The error from the issue title comes from the fact that his mysql server is configured to autoincrement by 2 (auto increment increment = '2'), so the ids in a table are 1, 3, 5, 7, 9, 11... instead of 1, 2, 3, 4, 5, 6... Features exports vocabulary permissions using the vocabulary id, and since the ids are wrong, the permission can't be mapped and the error gets thrown.

The problem with using IDs in the permission name comes from Drupal core itself. Features could implement a workaround, opened an issue for that: #1722524: Export vocabulary permissions using the machine name.

DamienMcKenna’s picture

Ugh. I suppose it'd be too much to have core changed to use the vocabulary's machine_name for permissions instead of the vid?

silkogelman’s picture

Man I was hoping to get Kickstart working by the time of DrupalCon
I'm not into Features' code well enough to be able to produce a patch for
#1722524: Export vocabulary permissions using the machine name
but in return for a fix I can create a tutorial video on how to apply Commerce Kickstart in the Dutch market, expaining what settings to use, what payment modules are available for the Dutch market etc.

bojanz’s picture

I've removed the problematic permissions from Kickstart, so you should be able to install beta2 / latest -dev just fine.

silkogelman’s picture

Sweet, thanks!!
I'll test and post results once beta2 is freshly baked tomorrow(?) morning.

silkogelman’s picture

beta 2 with demo content installs without errors!
I'll do some testing without demo content next.
Thanks again!

Update: install works perfectly without demo content too (installed with all additional functionality, Euro, Netherlands, VAT)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

updated