Error when upgrade to 2020.10 latest

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Error when upgrade to 2020.10 latest

Post by MikaelNazarenko » 28 Aug 2020, 14:26

this command:

Code: Select all

composer require aimeos/aimeos-laravel:~2019.10 -v
gives error:

Code: Select all

Migrating: 2017_08_11_073824_create_menus_wp_table

   Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' (SQL: create table `` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(191) not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at /var/www/schmuck/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668|

  Exception trace:

  1   Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''")
      /var/www/schmuck/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63

  2   PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''")
      /var/www/schmuck/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Error when upgrade to 2020.10 latest

Post by aimeos » 28 Aug 2020, 14:31

This isn't related to Aimeos at all. Seems like it's one of your own migration files that causes the problem or maybe ask in the Laravel forum why that happens.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: Error when upgrade to 2020.10 latest

Post by MikaelNazarenko » 28 Aug 2020, 14:41

hm..

This command doesn't update aimeos to version 2019.10.31:

Code: Select all

composer require aimeos/aimeos-laravel:~2019.10.31
I still have:

Code: Select all

aimeos/ai-admin-jqadm                 2019.10.6             Aimeos ai-admin-jqadm extension
aimeos/ai-admin-jsonadm               2019.10.2             Aimeos ai-admin-jsonadm extension
aimeos/ai-client-html                 2019.10.10            Aimeos ai-client-html extension
aimeos/ai-client-jsonapi              2019.10.2             Aimeos JSON API extension
aimeos/ai-controller-frontend         2019.10.3             Aimeos ai-controller-frontend extension
aimeos/ai-controller-jobs             2019.10.4             Aimeos ai-controller-jobs extension
aimeos/ai-gettext                     2019.10.1             Aimeos Gettext extension
aimeos/ai-laravel                     2019.10.2             Laravel adapter for Aimeos web shops and e-commerce solutions
aimeos/ai-payments                    2019.10.1             Payment extension for Aimeos web shops and e-commerce solutions
aimeos/ai-swiftmailer                 2019.10.1             SwiftMailer adapter for Aimeos web shops and e-commerce solutions
aimeos/aimeos-core                    2019.10.7             Full-featured e-commerce components for high performance online shops
aimeos/aimeos-laravel                 2019.10.x-dev 1557846 Professional, full-featured and high performance Laravel e-commerce package for online shops and complex B2B projects

MikaelNazarenko
Expert
Posts: 274
Joined: 27 Jun 2019, 16:19

Re: Error when upgrade to 2020.10 latest

Post by MikaelNazarenko » 28 Aug 2020, 18:37

I have created new project to check the problem:

Code: Select all

{
    "name": "name/aimeos",
    "authors": [
        {
            "name": "mike",
            "email": "email@gmail.com"
        }
    ],
    "prefer-stable": true,
    "minimum-stability": "dev",
    "require": {
        "aimeos/aimeos-laravel": "~2019.10"
    },
    "scripts": {
        "post-update-cmd": [
            "@php artisan vendor:publish --tag=public --force",
            "@php artisan migrate",
            "\\Aimeos\\Shop\\Composer::join"
        ]
    }
}
Then I ran

Code: Select all

composer update
The components versions are:

Code: Select all

aimeos/ai-admin-jqadm                2019.10.19 Aimeos ai-admin-jqadm extension
aimeos/ai-admin-jsonadm              2019.10.7  Aimeos ai-admin-jsonadm extension
aimeos/ai-client-html                2019.10.20 Aimeos ai-client-html extension
aimeos/ai-client-jsonapi             2019.10.8  Aimeos JSON API extension
aimeos/ai-controller-frontend        2019.10.11 Aimeos ai-controller-frontend extension
aimeos/ai-controller-jobs            2019.10.19 Aimeos ai-controller-jobs extension
aimeos/ai-gettext                    2019.10.1  Aimeos Gettext extension
aimeos/ai-laravel                    2019.10.7  Laravel adapter for Aimeos web shops and e-commerce solutions
aimeos/ai-swiftmailer                2019.10.1  SwiftMailer adapter for Aimeos web shops and e-commerce solutions
aimeos/aimeos-core                   2019.10.31 Full-featured e-commerce components for high performance online shops
aimeos/aimeos-laravel                2019.10.6  Professional, full-featured and high performance Laravel e-commerce package for online shops and complex B2B projects
And searching getBaseItem method in all project doesn't give result. There is not such method..((

What the problem ? Are you sure this method implemented in 2019.10.31 ?

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: Error when upgrade to 2020.10 latest

Post by aimeos » 29 Aug 2020, 08:24

Unfortunately, the getBaseItem() method is only available in 2020.x
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply