Migration fails

[BjBue]

Hello, I try to install teh datadirector. I figured out some failures, now i have another one: The error says:

[error] Migration Blackbit\DataDirectorBundle\Migrations\Version20230206093252 failed during Execution. Error: "An exception occurred while executing 'ALTER TABLE plugin_pim_importstatus DROP INDEX `fk_importstatus_dataport`':

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `fk_importstatus_dataport`; check that it exists"

In AbstractMySQLDriver.php line 128:

  An exception occurred while executing 'ALTER TABLE plugin_pim_importstatus DROP INDEX `fk_importstatus_dataport`':         

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `fk_importstatus_dataport`; check that it exists  

In Exception.php line 18:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `fk_importstatus_dataport`; check that it exists  

In PDOConnection.php line 55:

  SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `fk_importstatus_dataport`; check that it 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] [--prefix [PREFIX]] [--] [<version>]

 [OK] Bundle "BlackbitDataDirectorBundle" was successfully installed                                                    

My table got these indexes: fk_importstatus_dataport_resource where this is a foreign key and fk_importstatus_dataport_startDate

It seems to be installed, i see the app-icon, but i think that there are 5 missing migrations so the app would not react correctly.

What can i do to get the datadirector installed? Any help is welcome, thank you for helping me

[BlackbitDevs]

Which version?

Actually I thought this bug has been fixed since 3.3.5.

[BjBue]

I followed the readme and the help from composer. Because everything else fails, i installed the datadirector with: composer require blackbit/data-director:* I am sorry but it installs the datadirector version 3.3.1 My PO already ask for a newer version, currently i have only this as a zip.

And another questeion, how can i install a new datadirector bundle when the whole pimcore-installation will not be compatible? I havent installed this pimcore version (basilicom was the one and i am not statisfied with the result), but composer outdated shows me a lot of packages (160) that where old, too old and abandoned. Because i havent installed this, i am not really sure how to update/upgrade the complete installation of pimcore. For now every composer update will downgrade the packages and thats not what i want ;-)

[BlackbitDevs]

Which company are you working for? Then we will send you the latest version again.

Concerning your other question: What exactly is not compatible? Data Director should be compatible with all Pimcore versions >= 5.4. If something is not compatible, then the requirement comes from other libraries. Of course you can update the whole Pimcore installation via composer update but please check https://pimcore.com/docs/pimcore/current/Development_Documentation/Installation_and_Upgrade/Upgrade_Notes/index.html first.

If you want, we can also look at this problem together to get your system to a stable, updatable state again. Please write to info@blackbit.de in this case.

[BjBue]

Thank you very much for the offer, but i can not skip my ProductOwner. He is already on it. Thank you very much, i think i have to wait.