UPGRADE from 2020.10 to 2021.04 in PostgreSQL
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!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
UPGRADE from 2020.10 to 2021.04 in PostgreSQL
Hello,
windows 10: 64
PostgreSQL 9.6.15
Laravel Framework 8.37.0
PHP 7.4.16
"php": "^7.3|^8.0",
"aimeos/aimeos-laravel": "~2021.04",
my first database (created by 2020.10) contains my data, I want to update to the latest version I followed the following steps:
and
----
it displays the following errors:
and in the log file:
we notice that the table "mshop_rule" is not created and other columns ...
NB: i solved other error by : directly in the database .
Thank you so much!
windows 10: 64
PostgreSQL 9.6.15
Laravel Framework 8.37.0
PHP 7.4.16
"php": "^7.3|^8.0",
"aimeos/aimeos-laravel": "~2021.04",
my first database (created by 2020.10) contains my data, I want to update to the latest version I followed the following steps:
- I created a new empty database and installed in last version, it works.
- but when I change the connection to the first database and run the following commands:
Code: Select all
php artisan config:cache ;php artisan cache:clear ; php artisan aimeos:clear
Code: Select all
php ./artisan aimeos:setup
php ./artisan route:clear
php ./artisan view:clear
php ./artisan aimeos:clear
it displays the following errors:
and in the log file:
we notice that the table "mshop_rule" is not created and other columns ...
NB: i solved other error by :
Code: Select all
alter table mshop_locale_site DROP CONSTRAINT mshop_locale_site_siteid_key CASCADE
DROP TABLE users CASCADE;
Thank you so much!
- Attachments
-
- Sans titre.png (47.82 KiB) Viewed 1042 times
-
- log.png (85.35 KiB) Viewed 1042 times
Re: UPGRADE from 2020.10 to 2021.04 in PostgreSQL
Hello,
in this file : vendor\aimeos\aimeos-core\lib\mshoplib\setup\OrderMigrateProductSupplier.php
why it is two lines
since these two lines are already in the file
vendor\aimeos\aimeos-core\lib\mshoplib\setup\default\schema\order.php
when I delete these files the setup works through and hangs in the
thank you
in this file : vendor\aimeos\aimeos-core\lib\mshoplib\setup\OrderMigrateProductSupplier.php
why it is two lines
Code: Select all
$table->addColumn( 'supplierid', 'string', ['length' => 36, 'customSchemaOptions' => ['charset' => 'binary', 'default' => '']] );
$table->addColumn( 'suppliername', 'string', ['length' => 255, 'default' => ''] );
vendor\aimeos\aimeos-core\lib\mshoplib\setup\default\schema\order.php
Code: Select all
$table->addColumn( 'supplierid', 'string', array( 'length' => 36, 'customSchemaOptions' => ['charset' => 'binary', 'default' => ''] ) );
$table->addColumn( 'suppliername', 'string', array( 'length' => 255, 'default' => '' ) );
Code: Select all
Aimeos\MW\DB\Exception
SQLSTATE[42601]: Syntax error: 7 ERREUR: erreur de syntaxe sur ou près de « ON »
LINE 1: DROP INDEX "unq_mssto_sid_pcode_ty" ON "mshop_stock"
^: DROP INDEX "unq_mssto_sid_pcode_ty" ON "mshop_stock"
- Attachments
-
- error.png (21.03 KiB) Viewed 1012 times
Re: UPGRADE from 2020.10 to 2021.04 in PostgreSQL
What's the error message when you update?mahmoud wrote: ↑20 Apr 2021, 11:13 Hello,
in this file : vendor\aimeos\aimeos-core\lib\mshoplib\setup\OrderMigrateProductSupplier.php
why it is two lines
since these two lines are already in the fileCode: Select all
$table->addColumn( 'supplierid', 'string', ['length' => 36, 'customSchemaOptions' => ['charset' => 'binary', 'default' => '']] ); $table->addColumn( 'suppliername', 'string', ['length' => 255, 'default' => ''] );
vendor\aimeos\aimeos-core\lib\mshoplib\setup\default\schema\order.phpCode: Select all
$table->addColumn( 'supplierid', 'string', array( 'length' => 36, 'customSchemaOptions' => ['charset' => 'binary', 'default' => ''] ) ); $table->addColumn( 'suppliername', 'string', array( 'length' => 255, 'default' => '' ) );
Can you please create an issue in the https://github.com/aimeos/aimeos-core Github repository?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star