Upgrade failure - Integrity constraint violation: 1048 Column 'module' cannot be null [#1905464]

recruiter-7.x-1.0-rc3-core.tar.gz does not contain any .info files.

Upgrade eventually ends with an ugly fatal list of errors and the upgrade fails.

Notice: Undefined index: content_type in flag_flag::factory_by_array() (line 209 of /home/aaatrade/public_html/profiles/recruiter/modules/flag/flag.inc).
Notice: Undefined index: handler in flag_create_handler() (line 105 of /home/aaatrade/public_html/profiles/recruiter/modules/flag/flag.inc).
Notice: Undefined index: content_type in flag_flag::factory_by_array() (line 209 of /home/aaatrade/public_html/profiles/recruiter/modules/flag/flag.inc).
Notice: Undefined index: handler in flag_create_handler() (line 105 of /home/aaatrade/public_html/profiles/recruiter/modules/flag/flag.inc).
Notice: Undefined index: flag job_bookmarks in user_role_grant_permissions() (line 3056 of /home/aaatrade/public_html/modules/user/user.module).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null: INSERT INTO {role_permission} (rid, permission, module) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 30037204 [:db_insert_placeholder_1] => flag job_bookmarks [:db_insert_placeholder_2] => ) in user_role_grant_permissions() (line 3058 of /home/aaatrade/public_html/modules/user/user.module).

That's the ugly detail. Unravel as you desire. It's a mystery to me.

Comments

Comment #1

SocialNicheGuru CreditAttribution: SocialNicheGuru commented 6 February 2013 at 00:50

I get the pdo error when I try to install too:
Column 'module' cannot be null [

Comment #2

dasjo

he/him

German

Zurich

CreditAttribution: dasjo commented 6 February 2013 at 08:20

this kind of error occurs when installing the current version of Recruiter with drush and has also seen to appear in certain cases when using the web installer
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'module' cannot be null: INSERT INTO {role_permission} (rid, permission, module)

we were able to solve the problem by applying this D7 core patch: #737816-26: user_role_grant_permissions() throws PDOException when used with non-existent permissions (e.g. a permission for a disabled/uninstalled module)
it has been added to the make file: http://drupalcode.org/project/recruiter.git/commitdiff/6947509

note that there is a related issue within the features queue, but the patches there didn't seem to fix the problems on our side #1063204: Adding a new permission causes integrity constraint violation

in addition, after installing #1888378: Permissions have to be reverted manually after installation