Error during aimeos setup / upgrade

[krzysiekp]

https://prnt.sc/l6k7we0dMAQw

Code: Select all

C:\xampp\htdocs\giftcards-portal-new>php8artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "pl"
64 // vendor\aimeos\aimeos-core\Setup.php:197  

[aimeos]

Can you execute and post the relevant output including the last SQL query executed?:

Code: Select all

php artisan aimeos:setup -vvv

[krzysiekp]

Code: Select all

C:\xampp\htdocs\giftcards-portal-new>php8artisan aimeos:setup -vvv
Initializing or updating the Aimeos database tables for site "pl"
Migrating: \vendor\aimeos\aimeos-core\setup\AttributeMigrateKey.php

   Doctrine\DBAL\Exception\InvalidColumnDeclaration 

  Column "type" has invalid type

  at vendor\doctrine\dbal\src\Exception\InvalidColumnDeclaration.php:16                                                                                                                                                             
     12▕ final class InvalidColumnDeclaration extends LogicException implements Exception
     13▕ {
     14▕     public static function fromInvalidColumnType(string $columnName, InvalidColumnType $e): self
     15▕     {
  ➜  16▕         return new self(sprintf('Column "%s" has invalid type', $columnName), 0, $e);
     17▕     }
     18▕ }
     19▕

  1   vendor\doctrine\dbal\src\Platforms\AbstractPlatform.php:206
      Doctrine\DBAL\Exception\InvalidColumnDeclaration::fromInvalidColumnType()                                                                                                                                                     

  2   vendor\doctrine\dbal\src\Exception\InvalidColumnType\ColumnLengthRequired.php:22
      Doctrine\DBAL\Exception\InvalidColumnType\ColumnLengthRequired::("Doctrine\DBAL\Platforms\MySQL84Platform requires the length of a VARCHAR column to be specified")                                                           

  3   vendor\doctrine\dbal\src\Platforms\AbstractPlatform.php:337
      Doctrine\DBAL\Exception\InvalidColumnType\ColumnLengthRequired::new()                                                                                                                                                         

  4   vendor\doctrine\dbal\src\Platforms\AbstractPlatform.php:204
      Doctrine\DBAL\Platforms\AbstractPlatform::getVarcharTypeDeclarationSQLSnippet()                                                                                                                                               

  5   vendor\doctrine\dbal\src\Types\StringType.php:19
      Doctrine\DBAL\Platforms\AbstractPlatform::getStringTypeDeclarationSQL()                                                                                                                                                       

  6   vendor\doctrine\dbal\src\Platforms\AbstractPlatform.php:1500
      Doctrine\DBAL\Types\StringType::getSQLDeclaration()                                                                                                                                                                           

  7   vendor\doctrine\dbal\src\Platforms\AbstractPlatform.php:2418
      Doctrine\DBAL\Platforms\AbstractPlatform::getColumnDeclarationSQL()                                                                                                                                                           

  8   vendor\doctrine\dbal\src\Schema\Comparator.php:450
      Doctrine\DBAL\Platforms\AbstractPlatform::columnsEqual()                                                                                                                                                                      

  9   vendor\doctrine\dbal\src\Schema\Comparator.php:196
      Doctrine\DBAL\Schema\Comparator::columnsEqual()                                                                                                                                                                               

  10  vendor\doctrine\dbal\src\Platforms\MySQL\Comparator.php:40
      Doctrine\DBAL\Schema\Comparator::compareTables()                                                                                                                                                                              

  11  vendor\doctrine\dbal\src\Schema\Comparator.php:62
      Doctrine\DBAL\Platforms\MySQL\Comparator::compareTables()                                                                                                                                                                     

  12  vendor\aimeos\upscheme\src\Schema\DB.php:821
      Doctrine\DBAL\Schema\Comparator::compareSchemas()                                                                                                                                                                             

  13  vendor\aimeos\upscheme\src\Schema\Table.php:771
      Aimeos\Upscheme\Schema\DB::up()                                                                                                                                                                                               

  14  vendor\aimeos\upscheme\src\Schema\Column.php:417
      Aimeos\Upscheme\Schema\Table::up()                                                                                                                                                                                            

  15  vendor\aimeos\aimeos-core\setup\AttributeMigrateKey.php:38
      Aimeos\Upscheme\Schema\Column::up()                                                                                                                                                                                           

  16  vendor\aimeos\upscheme\src\Up.php:364
      Aimeos\Upscheme\Task\AttributeMigrateKey::up()                                                                                                                                                                                

  17  vendor\aimeos\upscheme\src\Up.php:351
      Aimeos\Upscheme\Up::runTasks()                                                                                                                                                                                                

  18  vendor\aimeos\upscheme\src\Up.php:191
      Aimeos\Upscheme\Up::runTasks()                                                                                                                                                                                                

  19  vendor\aimeos\aimeos-core\Setup.php:84
      Aimeos\Upscheme\Up::up()                                                                                                                                                                                                      

  20  vendor\aimeos\aimeos-laravel\src\Command\SetupCommand.php:65
      Aimeos\Setup::up()                                                                                                                                                                                                            

  21  vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:36
      Aimeos\Shop\Command\SetupCommand::handle()                                                                                                                                                                                    

  22  vendor\laravel\framework\src\Illuminate\Container\Util.php:43
      Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()                                                                                                                                     

  23  vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:96
      Illuminate\Container\Util::unwrapIfClosure()                                                                                                                                                                                  

  24  vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php:35
      Illuminate\Container\BoundMethod::callBoundMethod()                                                                                                                                                                           

  25  vendor\laravel\framework\src\Illuminate\Container\Container.php:807
      Illuminate\Container\BoundMethod::call()                                                                                                                                                                                      

  26  vendor\laravel\framework\src\Illuminate\Console\Command.php:211
      Illuminate\Container\Container::call()                                                                                                                                                                                        

  27  vendor\symfony\console\Command\Command.php:341
      Illuminate\Console\Command::execute()                                                                                                                                                                                         

  28  vendor\laravel\framework\src\Illuminate\Console\Command.php:180
      Symfony\Component\Console\Command\Command::run()                                                                                                                                                                              

  29  vendor\symfony\console\Application.php:1102
      Illuminate\Console\Command::run()                                                                                                                                                                                             

  30  vendor\symfony\console\Application.php:356
      Symfony\Component\Console\Application::doRunCommand()                                                                                                                                                                         

  31  vendor\symfony\console\Application.php:195
      Symfony\Component\Console\Application::doRun()                                                                                                                                                                                

  32  vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php:197
      Symfony\Component\Console\Application::run()                                                                                                                                                                                  

  33  artisan:35
      Illuminate\Foundation\Console\Kernel::handle() 

[aimeos]

If it happens during reading the database schema and before anything else happens, this might be a Doctrine DBAL bug.
You can now check in the DBAL code why that happens or you can change the type of the column to VARCHAR(64) manually (but expect that there will be a lot of columns where this needs to be done).

[krzysiekp]

Maybe I should do installation according below order:

2021.10 => 2023.10 / laravel 11 => php artisan aimeos:setup
2023.10 => 2024.10 / laravel 12 => php artisan aimeos:setup
2024.10 => 2025.10 / laravel 12 =>php artisan aimeos:setup

?

[aimeos]

No, that won't make a difference.

[krzysiekp]

I analyzed the topic and it turns out that it works for

doctrine/dbal < 4.3

but not working for

doctrine/dbal > 4.2

Now, I have

doctrine/dbal 4.2.5

and it's working

[aimeos]

Thanks for finding out!

Can you create an issue here so it may get fixed in future releases?
https://github.com/doctrine/dbal/issues

[krzysiekp]

I have next error

Code: Select all

Migrating: \vendor\aimeos\aimeos-core\setup\OrderMergeBaseTable.php

   Doctrine\DBAL\Exception\InvalidFieldNameException 

  An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dest.baseid' in 'where clause'

  at vendor\doctrine\dbal\src\Driver\API\MySQL\ExceptionConverter.php:52                                                                                                                                                            
     48▕             1569,
     49▕             1586 => new UniqueConstraintViolationException($exception, $query),
     50▕             1054,
     51▕             1166,
  ➜  52▕             1611 => new InvalidFieldNameException($exception, $query),
     53▕             1052,
     54▕             1060,
     55▕             1110 => new NonUniqueFieldNameException($exception, $query),
     56▕             1064,

  1   vendor\doctrine\dbal\src\Connection.php:1418
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter::convert()                                                                                                                                                                  

  2   vendor\doctrine\dbal\src\Connection.php:1360
      Doctrine\DBAL\Connection::handleDriverException()                                                                                                                                                                             

Press any key to continue . . . 

There is no baseid column in mshop_order

[aimeos]

Always start from the initial database when performing the migration. The migration of the order domain doesn't work if it's half done and stopps in the middle (contrary to most other migration tasks).