Module throws an Exception upon install:

exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1072 Key column '100' doesn't exist in table' in \includes\database\database.inc:2227

leaving module enabled, but no database-table nor configuration settings form created.

CommentFileSizeAuthor
#3 Exception_1072_Key_column_100_doesnt_exist_in_table-2865088-3.patch581 bytesspokje

Comments

Spokje created an issue. See original summary.

spokje’s picture

spokje
Primary language Dutch
commented
Title: 'SQLSTATE[42000]: Syntax error or access violation: 1072 Key column '100' doesn't exist in table' » Exception 'SQLSTATE[42000]: Syntax error or access violation: 1072 Key column '100' doesn't exist in table' thrown at installation
spokje’s picture

spokje
Primary language Dutch
commented
StatusFileSize
new Exception_1072_Key_column_100_doesnt_exist_in_table-2865088-3.patch581 bytes

This patch should fix it.

spokje’s picture

spokje
Primary language Dutch
commented
Issue summary: View changes
Status: Active » Needs review
spokje’s picture

spokje
Primary language Dutch
commented
Issue summary: View changes
spokje’s picture

spokje
Primary language Dutch
commented
Assigned: spokje » Unassigned
caesius’s picture

caesius commented
Priority: Normal » Major
Status: Needs review » Reviewed & tested by the community

Thanks, patch works.

minoroffense’s picture

minoroffense commented

I can also confirm the patch works as expected

spokje’s picture

spokje
Primary language Dutch
commented
Status: Reviewed & tested by the community » Needs work

No changes, but trying to see if this triggers the test-bots.

spokje’s picture

spokje
Primary language Dutch
commented
Status: Needs work » Reviewed & tested by the community

Didn't trigger testbot, reverting to original RTBC-status.

To be clear: No code was changed (or indeed harmed) in the original patch.
Just changed the status of the issue.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Reviewed & tested by the community » Fixed

I discovered this with a different issue and fixed it there. Thanks for the patch.

Status: Fixed » Closed (fixed)

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

feelcreative’s picture

feelcreative commented

Patch works! Whats the process of getting this integrated into the module code?

C

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

It's already in the Dev version

3li’s picture

3li
he/him
Primary language English
Location U.K. 🇬🇧
commented

The patch works, it would be great if it could be moved into the next stable version at some point. As without this fix the module did not install at all for me,

Rus5555’s picture

Rus5555 commented

Please help fix Drupal 7 Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'cid' doesn't exist in table: ALTER TABLE {metatag_config} ADD UNIQUE KEY `temp_key` (`cid`, `instance`); Array() in db_add_unique_key() function