Upgrade error

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
kuoyehs
Posts: 22
Joined: 09 Sep 2019, 03:01

Upgrade error

Post by kuoyehs » 24 Sep 2019, 08:02

I upgrade "aimeos/aimeos-laravel" package 2018.10.4 to 2019.07.4, and "aimeos/aimeos-core", "aimeos/ai-client-html", "aimeos/aimeos-core" related package 2018.10.x-dev to 2019.07.x-dev.

I follow the document https://aimeos.org/docs/Laravel/Upgrade to upgrade, but when I use "php artisan aimeos:setup", and have the error message.

Code: Select all

 SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ""unq_msindpr_p_s_prid_lt""
  LINE 1: ALTER TABLE "mshop_index_price" DROP INDEX "unq_msindpr_p_s_...
                                                     ^
I use "php artisan aimeos:account sandy@visual-next.com --admin" to add admin account have the error message.

Code: Select all

SQLSTATE[42703]: Undefined column: 7 ERROR:  column lvuli.type does not exist
  LINE 3: ...   lvuli."parentid" AS "customer.lists.parentid", lvuli."typ...
                                                               ^
  HINT:  Perhaps you meant to reference the column "lvuli.typeid".
I use laravel 5.4, and postgreSQL.

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

Re: Upgrade error

Post by aimeos » 24 Sep 2019, 20:42

PostgreSQL doesn't support the "ALTER TABLE ... DROP INDEX ..." syntax.

Can you please use

Code: Select all

"aimeos/aimeos-core": "2019.07.x-dev"
in your composer.json and run "composer update afterwards? When the latest version is installed, you can try again running "aimeos:setup".
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

kuoyehs
Posts: 22
Joined: 09 Sep 2019, 03:01

Re: Upgrade error

Post by kuoyehs » 25 Sep 2019, 03:59

My composer.json
Image

After I run "composer update", I run "php artisan aimeos:setup", but have the error message.

Code: Select all

SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ""idx_msindte_value""
  LINE 1: ALTER TABLE "mshop_index_text" DROP INDEX "idx_msindte_value...
                                                    ^

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

Re: Upgrade error

Post by aimeos » 26 Sep 2019, 07:44

Can you make sure that you have commit b85bb89b9d73e035db9ac8b03e86b26f73311cd3 (run "composer show" to display the installed versions).
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

kuoyehs
Posts: 22
Joined: 09 Sep 2019, 03:01

Re: Upgrade error

Post by kuoyehs » 26 Sep 2019, 09:19

I run "composer show", these is version.
Image

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

Re: Upgrade error

Post by aimeos » 26 Sep 2019, 19:31

We removed another setup task as well that contained non-PostgreSQL compatible statements. Can you please update and try again?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply