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 |
Comment | File | Size | Author |
---|---|---|---|
#25 | beta2-install-options.JPG | 100.1 KB | silkogelman |
#25 | beta2-installed-demo-content.JPG | 128.17 KB | silkogelman |
#19 | beta1-no-demo-additional-functionality2.JPG | 53.58 KB | silkogelman |
#18 | beta1-integrity-constraint-violation.JPG | 114.26 KB | silkogelman |
#17 | installation-no-demo-no-additional-content-euro-vat.JPG | 122.4 KB | silkogelman |
Comments
Comment #0.0
silkogelman CreditAttribution: silkogelman commentedadded clean install
Comment #1
silkogelman CreditAttribution: silkogelman commentedWhen 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.
Comment #2
silkogelman CreditAttribution: silkogelman commentedAlso 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)
Comment #3
bojanz CreditAttribution: bojanz commentedThat'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)?
Comment #4
silkogelman CreditAttribution: silkogelman commentedQuickstart 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:
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.
Comment #4.0
silkogelman CreditAttribution: silkogelman commentedupdated with demo content message
Comment #5
silkogelman CreditAttribution: silkogelman commentedTested 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.
Comment #6
silkogelman CreditAttribution: silkogelman commentedUpdate
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.
Comment #7
vasikei couldn't reproduce it.
Comment #8
GuGuss CreditAttribution: GuGuss commentedHaha, 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...
Comment #9
silkogelman CreditAttribution: silkogelman commentedThe 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 ;)
Comment #10
bojanz CreditAttribution: bojanz commentedI'll look into this tomorrow.
The error message sounds familiar.
Comment #10.0
bojanz CreditAttribution: bojanz commentedadded commerce_kickstart-7.x-2.x-dev-core (2012-Jul-21) test results
Comment #11
silkogelman CreditAttribution: silkogelman commentedWith 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
Comment #12
bojanz CreditAttribution: bojanz commentedOkay, 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.
Comment #13
silkogelman CreditAttribution: silkogelman commentedSweet, I'll test it first thing in the morning!
Comment #14
silkogelman CreditAttribution: silkogelman commentedUnfortunately 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.
Comment #15
silkogelman CreditAttribution: silkogelman commentedInstalling without demo content but with additional functionality gives 'an error'.
I will wait for #1691422: Re-export all features before trying again.
Comment #15.0
silkogelman CreditAttribution: silkogelman commentedadded test results for commerce_kickstart-7.x-2.x-dev-core (2012-Jul-26)
Comment #15.1
silkogelman CreditAttribution: silkogelman commentedadded commerce_kickstart-7.x-2.x-dev-core (2012-Jul-30) test results
Comment #15.2
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Jul-31) test results
Comment #15.3
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-01) test results
Comment #15.4
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-02) test results
Comment #16
silkogelman CreditAttribution: silkogelman commentedok, 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
Comment #17
silkogelman CreditAttribution: silkogelman commentedcommerce_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:
Comment #17.0
silkogelman CreditAttribution: silkogelman commentedupdated with circular dependencies info dev(2012-Aug-02)
Comment #17.1
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-03) test results
Comment #17.2
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-09) test results
Comment #18
silkogelman CreditAttribution: silkogelman commentedinstalling 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).
Comment #18.0
silkogelman CreditAttribution: silkogelman commentedupdated with commerce_kickstart-7.x-2.x-dev-core (2012-Aug-09) additional functionality test results
Comment #18.1
silkogelman CreditAttribution: silkogelman commentedadded beta1 results and added the table of test results
Comment #19
silkogelman CreditAttribution: silkogelman commentedBeta1 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'.
Comment #19.0
silkogelman CreditAttribution: silkogelman commentedupdated with beta1 with additional functionality install option test results
Comment #20
bojanz CreditAttribution: bojanz commentedExamination 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.
Comment #21
DamienMcKennaUgh. I suppose it'd be too much to have core changed to use the vocabulary's machine_name for permissions instead of the vid?
Comment #22
silkogelman CreditAttribution: silkogelman commentedMan 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.
Comment #23
bojanz CreditAttribution: bojanz commentedI've removed the problematic permissions from Kickstart, so you should be able to install beta2 / latest -dev just fine.
Comment #24
silkogelman CreditAttribution: silkogelman commentedSweet, thanks!!
I'll test and post results once beta2 is freshly baked tomorrow(?) morning.
Comment #25
silkogelman CreditAttribution: silkogelman commentedbeta 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)
Comment #26.0
(not verified) CreditAttribution: commentedupdated