DB column missing

[rostockahoi]

Hi there,
I required and installed the plugin in a project on machine A. Everything works as expected. After committing and pushing the composer JSON and lock file, pulling it on machine B, running composer insall, then ./craft migrate/all it seems the database migration was not executed. It says No new migrations found. Your system is up to date..

When hitting the "Create entry" button for an entry type that uses one of the plugin methods in its fields an exception is thrown:

[yii\db\Exception] PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'metadata' in 'field list' in /var/www/site/vendor/yiisoft/yii2/db/Command.php:1302

My workaround was to uninstall and reinstall the plugin.

[matfish2]

The metadata column is not added on Craft's migrations. It is part of the Install migration that instantiates the plugin. The Install migration is checking that the plugin doesn't already exist in the project config, to avoid a duplicate attempt to create the column. I am indeed puzzled as to how this should work when plugin was already installed locally and now pushed to a different environment. Will have to do some research and maybe turn to Craft for help. Will revert once I know more.

[matfish2]

Craft's response:

It looks like his deploy is missing ./craft project-config/apply.
If the plugin is already installed on one environment, it's project config that will install it on subsequent environment.
Can you ask him to try that, please?

[rostockahoi]

Sorry, I omitted that part. Of course I did a ./craft project-config/apply after running the migrations. Here is the terminal output for all 3 commands.

You see that I did composer install, migrate all and project config apply. It installed your plugin when applying. After that, the error occurred.

In the second screenshot you'll see what I did next:

• migrate again: nothing
• install entry-meta
• install entry-meta again (why though? :D)
• uninstall entry-meta
• install entry-meta: now it runs the migration

My best guess is that you should not query for plugin existence in:

craft-entry-meta/src/migrations/Install.php

Line 13 in 9ce2356

if (!$this->_pluginExistsInProjectConfig() && !$this->_columnExists()) {

Querying for column existence is probably fine: While Craft takes care of migrations that were already applied via the migrations table, nobody can guarantee that this very column does not already exist on the entries table (created by someone else).

My commands

... here comes a lot of project config bla bla

[matfish2]

Thanks again :) I have removed the check and deployed a new release (1.0.1)