php bin/console app:convert-bbcode about part-db-server

[jbtronics]

Has you run php bin/console doctrine:migrations:migrate before? and was it successful?

This looks like it has something to do with a wrong (or a not up-to-date) database.

[UtechtDustin]

@jbtronics
We also have the issue, currently we are using Part-DB Version 0.5.9
I duplicated the database and tried to upgrade, but i get the following error if i run php bin/console doctrine:migrations:migrate

 WARNING! You are about to execute a migration in database "partdb-live-up" that could result in schema changes and data loss. Are you sure you wish to continue? (yes/no) [yes]:
 > yes

[notice] Migrating up to DoctrineMigrations\Version20200502161750
[warning] Old Part-DB Database detected! Continue with upgrade...
[warning] Migration DoctrineMigrations\Version1 was executed but did not result in any SQL statements.
[warning] [!!!] Permissions were updated! Please check if they fit your expectations!
[error] Migration DoctrineMigrations\Version20190902140506 failed during Execution. Error: "An exception occurred while executing 'ALTER TABLE parts DROP FOREIGN KEY parts_id_footprint_fk':

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists"
15:00:59 CRITICAL  [console] Error thrown while running command "doctrine:migrations:migrate". Message: "An exception occurred while executing 'ALTER TABLE parts DROP FOREIGN KEY parts_id_footprint_fk':\n\nSQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists" ["exception" => Doctrine\DBAL\Exception\DriverException^ { …},"command" => "doctrine:migrations:migrate","message" => """  An exception occurred while executing 'ALTER TABLE parts DROP FOREIGN KEY parts_id_footprint_fk':\n  \n  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists  """]

In AbstractMySQLDriver.php line 128:

  An exception occurred while executing 'ALTER TABLE parts DROP FOREIGN KEY parts_id_footprint_fk':

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists


In Exception.php line 18:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists


In PDOConnection.php line 137:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'parts_id_footprint_fk'; check that column/key exists


doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]

I tried to remove the DROP FOREIGN KEY-Part, after i removed 5 DROP FOREIGN KEY i stopped because there are more and more errors.

If i skip php bin/console doctrine:migrations:migrate and run php bin/console app:convert-bbcode directly i get the same issue as @OrionAC.

[jbtronics]

You have to do the database migrations before attempting to do BBCode conversion.