CODEWITHSUNDEEP
database-migrationshopwareshopware6
NixH
NixH

Reputation: 539

Shopware 6: Can't migrate database

I've followed the following tutorial for creating a custom entity on my own in shopware 6:

https://www.youtube.com/watch?v=mTHTyof4gPk

I created a migration by using

bin/console database:create-migration

and added the following code:

$sql = <<<SQL
CREATE TABLE IF NOT EXISTS  'applicationmanagement' (
    'id' BINARY(26) NOT NULL,
    'name' VARCHAR (255) COLLATE utf8mb4_unicode_ci,
    'created_at' DATETIME(3) NOT NULL,
    'update_at' DATETIME(3),
    PRIMARY KEY ('id')
)
    ENGINE = InnoDB
    DEFAULT CHARSET = utf8mb4
    COLLATE = utf8mb4_unicaode_ci;
SQL;

$connection->executeUpdate($sql);

When I try to execute the migration by using

bin/console database:migrate PluginName --all

I get the following note

Get collection for identifier: "PluginName"

 ! [NOTE] No collection found for identifier: "PluginName", continuing

I tried reinstall and refresh the plugin but it didn't do anything.

Can someone help me fix this problem?

Upvotes: 8

Views: 2844

Answers (3)

Ambrozy Pala
Ambrozy Pala

Reputation: 31

There is probably a wrong command creating migration because you didn't add Plugin name so your migration was created in shopware core - look at this Creating migration... Creating legacy core migration ... Migration created: "/app/shopware/dev/platform/src/Core/Migration/Migration1674222844.php" Creating core-migration ... Migration created: "/app/shopware/dev/platform/src/Core/Migration/V6_4/Migration1674222844.php" Look at documentation how to create migration for plugin: https://developer.shopware.com/docs/guides/plugins/plugins/plugin-fundamentals/database-migrations command- $ ./bin/console database:create-migration -p SwagBasicExample --name ExampleDescription

Upvotes: 0

MilMike
MilMike

Reputation: 12831

I just had the same problem. What helped me was to clear the cache

bin/console cache:clear

Upvotes: 12

NixH
NixH

Reputation: 539

I solved it by uninstalling the plugin, refreshing the plugins and after that installing and activating my plugin

Upvotes: 5

Related Questions