upgrade to 2021 from 2019 missing column mlocsi.icon
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
upgrade to 2021 from 2019 missing column mlocsi.icon
Hi, trying an upgrade from typo3 9.5 to 10LTS and to 2021 aimeos version.
Upgrade is just having an issue when running the setup script with locale table icon column.
What should the schema for the icon column be in mysql? Haven't been able to find that in any of the aimeos repos.
./typo3 aimeos:setup
and everything else after that looks ok.
Upgrade is just having an issue when running the setup script with locale table icon column.
What should the schema for the icon column be in mysql? Haven't been able to find that in any of the aimeos repos.
./typo3 aimeos:setup
Code: Select all
Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mlocsi.icon' in 'field list':
SELECT
mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid",
mlocsi."code" AS "locale.site.code", mlocsi."label" AS "locale.site.label",
mlocsi."config" AS "locale.site.config", mlocsi."status" AS "locale.site.status",
mlocsi."icon" AS "locale.site.icon", mlocsi."logo" AS "locale.site.logo",
mlocsi."supplierid" AS "locale.site.supplierid", mlocsi."theme" AS "locale.site.theme",
mlocsi."editor" AS "locale.site.editor", mlocsi."mtime" AS "locale.site.mtime",
mlocsi."ctime" AS "locale.site.ctime"
FROM "mshop_locale_site" AS mlocsi
WHERE mlocsi."level" = 0
ORDER BY mlocsi."id" ASC
LIMIT 2147483647 OFFSET 0
while initializing or updating the Aimeos database
<debug>#0 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(1000): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
#1 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Locale/Manager/Site/Standard.php(697): Aimeos\MShop\Locale\Manager\Site\Standard->getSearchResults(Object(Aimeos\MW\DB\Connection\DBAL), '\n\t\t\t\t\tSELECT \n\t...')
#2 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Decorator/Depth.php(59): Aimeos\MShop\Locale\Manager\Site\Standard->search(Object(Aimeos\MW\Criteria\SQL), Array, NULL)
#3 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(165): Aimeos\MShop\Common\Manager\Decorator\Depth->search(Object(Aimeos\MW\Criteria\SQL))
#4 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(250): Aimeos\MW\Setup\Task\TablesMigrateSiteid->getSites()
#5 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->process(Array)
#6 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->migrate()
#7 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#8 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#9 /home/<---snipped out user--->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(82): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#10 /home/<---snipped out user--->/public_html/typo3conf/ext/aimeos/Classes/Command/SetupCommand.php(75): Aimeos\MW\Setup\Manager\Multiple->migrate(Object(Aimeos\MW\Setup\Task\CouponMigrateBasetValues))
#11 /home/<---snipped out user--->/vendor/symfony/console/Command/Command.php(299): Aimeos\Aimeos\Command\SetupCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/<---snipped out user--->/vendor/symfony/console/Application.php(978): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/<---snipped out user--->/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand(Object(Aimeos\Aimeos\Command\SetupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\C
onsole\Output\ConsoleOutput))
#14 /home/<---snipped out user--->/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /home/<---snipped out user--->/public_html/typo3/sysext/core/Classes/Console/CommandApplication.php(91): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOut
put))
#16 /home/<---snipped out user--->/vendor/typo3/cms-cli/typo3(23): TYPO3\CMS\Core\Console\CommandApplication->run()
#17 /home/<---snipped out user--->/vendor/typo3/cms-cli/typo3(24): {closure}()
#18 {main}</debug>
Add new type columns
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
......
and everything else after that looks ok.
-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
tried adding in some mysql columns (text/int etc) having a guess at types to try it out and then getting other errors on missing columns (log/supplierid/theme) etc.
Is there a sql schema somewhere in the sourcecode I can reference? Is this an artefact of skipping from 2019 to 2021? I had some composer 1.0->2.0 issues with typo3 10 that mean I'm probably stuck on 2021 that seems to install with composer 2.0.
Is there a sql schema somewhere in the sourcecode I can reference? Is this an artefact of skipping from 2019 to 2021? I had some composer 1.0->2.0 issues with typo3 10 that mean I'm probably stuck on 2021 that seems to install with composer 2.0.
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
That's a problem because we've used the manager to fetch the site tree but that won't work if there are additional columns in the SQL statements. Now, it's done directly using SQL statements. Can you please try the latest 2021.10-dev version?
We've also added a hint for migrating the ./ext/ folder:
https://aimeos.org/docs/latest/typo3/se ... ade-to-217
Please note that you must use composer 2.1 or newer to install Aimeos correctly. composer 2.0 won't work!
Code: Select all
composer req aimeos/aimeos-core:2021.10.x-dev
https://aimeos.org/docs/latest/typo3/se ... ade-to-217
Please note that you must use composer 2.1 or newer to install Aimeos correctly. composer 2.0 won't work!
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-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
Hi , I was using composer 2.1.9 but had not removed the ext folder.
Trying now with the x-dev version. If I run the setup cli task I don't receive the schema errors there, but I do get a "Error Maximum number of connections (3) for "db" exceeded while initializing or updating the Aimeos database"
stacktrace instead. Loading the aimeos module in the Typo3 backend also still gives the exception regarding the missing fields.
Is there somewhere the sql schema is listed, happy to try and add these manually if I've missed some DB migration script somewhere.
Trying now with the x-dev version. If I run the setup cli task I don't receive the schema errors there, but I do get a "Error Maximum number of connections (3) for "db" exceeded while initializing or updating the Aimeos database"
Code: Select all
$ ./vendor/typo3/cms-cli/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default
Error Maximum number of connections (3) for "db" exceeded while initializing or updating the Aimeos database
<debug>#0 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(163): Aimeos\MW\DB\Manager\DBAL->acquire('db')
#1 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(278): Aimeos\MW\Setup\Task\TablesMigrateSiteid->getSites()
#2 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->process(Array)
#3 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->migrate()
#4 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#5 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#6 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(82): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#7 /home/<--snipped username-->/public_html/typo3conf/ext/aimeos/Classes/Command/SetupCommand.php(75): Aimeos\MW\Setup\Manager\Multiple->migrate(Object(Aimeos\MW\Setup\Task\CouponMigrateBasetValues))
#8 /home/<--snipped username-->/vendor/symfony/console/Command/Command.php(299): Aimeos\Aimeos\Command\SetupCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /home/<--snipped username-->/vendor/symfony/console/Application.php(996): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /home/<--snipped username-->/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand(Object(Aimeos\Aimeos\Command\SetupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\C
onsole\Output\ConsoleOutput))
#11 /home/<--snipped username-->/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/<--snipped username-->/public_html/typo3/sysext/core/Classes/Console/CommandApplication.php(119): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOu
tput))
#13 /home/<--snipped username-->/vendor/typo3/cms-cli/typo3(23): TYPO3\CMS\Core\Console\CommandApplication->run()
#14 /home/<--snipped username-->/vendor/typo3/cms-cli/typo3(24): {closure}()
#15 {main}</debug>
Add new type columns
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text": OK
Checking table "mshop_text_list": OK
Drop old unique indexes
Drop old unique indexes
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text_list": OK
Migrate typeid to type
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text": OK
Checking table "mshop_text_list": OK
Update attribute "key" columns
Checking table mshop_attribute OK
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" OK
Drop the mshop_index_text table without ID column OK
Migrate mshop_index_text table engine to InnoDB OK
Prepare mshop_index_price table for simplification OK
Prepare mshop_index_text table for simplification OK
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Adding tax column to order tables
Checking table "mshop_order_base_product": OK
Checking table "mshop_order_base_service": OK
Checking table "mshop_order_base": OK
Migrate supplier code to ID and name in order product table done
Migrating product property domain to "product" OK
Rename warehouse table
Drop "mshop_product_stock.fk_msprost_whid" OK
Drop "mshop_product_stock.fk_msprost_stock_warehouseid" OK
Rename "mshop_product_stock.wareshouseid" OK
Rename "mshop_product_stock_wareshouse" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Ensure unique codes in mshop_service done
Migrate product code in stock table
Migrate "productcode" to "prodid" OK
Remove column "productcode" OK
Clear property "key" columns
Checking table mshop_attribute_property OK
Checking table mshop_customer_property OK
Checking table mshop_media_property OK
Checking table mshop_price_property OK
Checking table mshop_product_property OK
Creating admin tables
Using schema from cache.php
Checking table "madmin_cache": OK
Checking table "madmin_cache_tag": OK
Using schema from log.php
Checking table "madmin_log": OK
Using schema from job.php
Checking table "madmin_job": OK
Using schema from queue.php
Checking table "madmin_queue": OK
Update "siteid" columns
Checking table mshop_attribute_type OK
Checking table mshop_attribute_list_type OK
Checking table mshop_attribute_property_type OK
Checking table mshop_attribute_list OK
Checking table mshop_attribute_property OK
Checking table mshop_attribute OK
Checking table madmin_cache_tag OK
Checking table madmin_cache OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_catalog OK
Checking table mshop_coupon_code OK
Checking table mshop_coupon OK
Checking table mshop_customer_list_type
Is there somewhere the sql schema is listed, happy to try and add these manually if I've missed some DB migration script somewhere.
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
The connection limit is now higher in aimeos/aimeos-typo3:2021.10.x-dev. Can you try?
Yes, there's a scheme definition but schema upgrades must work automatically so you don't have to do it by hand
Yes, there's a scheme definition but schema upgrades must work automatically so you don't have to do it by hand
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-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
Hi, tried the upgrade (composer 2.1.9), php 7.4, apache 2.4 on a cpanel current release version.
However running the setup script still gives the same error.
I don't think there's anything wrong with my mysql setup:
My global variables for max user connections are standard:
All my mysql users also have 0 for max_user_connections in the mysql.users table. is the 3 being set from aimeos or typo3?
Code: Select all
composer.phar upgrade
Loading composer repositories with package information
Updating dependencies
Lock file operations: 0 installs, 7 updates, 0 removals
- Upgrading aimeos/ai-admin-jqadm (2021.10.2 => 2021.10.3)
- Upgrading aimeos/ai-admin-jsonadm (2021.10.1 => 2021.10.2)
- Upgrading aimeos/ai-client-html (2021.10.3 => 2021.10.4)
- Upgrading aimeos/ai-controller-jobs (2021.10.2 => 2021.10.3)
- Upgrading aimeos/ai-typo3 (2021.10.1 => 2021.10.2)
- Upgrading aimeos/aimeos-core (2021.10.x-dev 82b50c1 => 2021.10.x-dev aaa788e)
- Upgrading psr/cache (1.0.1 => 2.0.0)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 0 installs, 7 updates, 0 removals
- Downloading aimeos/aimeos-core (2021.10.x-dev aaa788e)
- Downloading aimeos/ai-controller-jobs (2021.10.3)
- Downloading psr/cache (2.0.0)
- Downloading aimeos/ai-typo3 (2021.10.2)
- Downloading aimeos/ai-client-html (2021.10.4)
- Downloading aimeos/ai-admin-jsonadm (2021.10.2)
- Downloading aimeos/ai-admin-jqadm (2021.10.3)
- Upgrading aimeos/aimeos-core (2021.10.x-dev 82b50c1 => 2021.10.x-dev aaa788e): Extracting archive
- Upgrading aimeos/ai-controller-jobs (2021.10.2 => 2021.10.3): Extracting archive
- Upgrading psr/cache (1.0.1 => 2.0.0): Extracting archive
- Upgrading aimeos/ai-typo3 (2021.10.1 => 2021.10.2): Extracting archive
- Upgrading aimeos/ai-client-html (2021.10.3 => 2021.10.4): Extracting archive
- Upgrading aimeos/ai-admin-jsonadm (2021.10.1 => 2021.10.2): Extracting archive
- Upgrading aimeos/ai-admin-jqadm (2021.10.2 => 2021.10.3): Extracting archive
Generating autoload files
64 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Code: Select all
$ ./vendor/typo3/cms-cli/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default
Error Maximum number of connections (3) for "db" exceeded while initializing or updating the Aimeos database
<debug>#0 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(163): Aimeos\MW\DB\Manager\DBAL->acquire('db')
#1 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(278): Aimeos\MW\Setup\Task\TablesMigrateSiteid->getSites()
#2 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->process(Array)
#3 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->migrate()
#4 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#5 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#6 /home/<--snipped username -->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(82): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#7 /home/<--snipped username -->/public_html/typo3conf/ext/aimeos/Classes/Command/SetupCommand.php(75): Aimeos\MW\Setup\Manager\Multiple->migrate(Object(Aimeos\MW\Setup\Task\CouponMigrateBasetValues))
#8 /home/<--snipped username -->/vendor/symfony/console/Command/Command.php(299): Aimeos\Aimeos\Command\SetupCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /home/<--snipped username -->/vendor/symfony/console/Application.php(996): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /home/<--snipped username -->/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand(Object(Aimeos\Aimeos\Command\SetupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\C
onsole\Output\ConsoleOutput))
#11 /home/<--snipped username -->/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/<--snipped username -->/public_html/typo3/sysext/core/Classes/Console/CommandApplication.php(119): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOu
tput))
#13 /home/<--snipped username -->/vendor/typo3/cms-cli/typo3(23): TYPO3\CMS\Core\Console\CommandApplication->run()
#14 /home/<--snipped username -->/vendor/typo3/cms-cli/typo3(24): {closure}()
#15 {main}</debug>
Add new type columns
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text": OK
Checking table "mshop_text_list": OK
Drop old unique indexes
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
etc.....
Code: Select all
mysql -e "show processlist"|grep -c Sleep
0
[root@ns3 home]# mysql -e "show variables like 'max_connections'"
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
[root@ns3 home]# mysql -e "show variables like 'wait_timeout'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
Code: Select all
MariaDB [(none)]> show global variables like '%connections%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| extra_max_connections | 1 |
| max_connections | 151 |
| max_user_connections | 0 |
+-----------------------+-------+
3 rows in set (0.002 sec)
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
You need to execute:
Code: Select all
composer req aimeos/aimeos-typo3:2021.10.x-devProfessional 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-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
Huh, I could have sworn I typed that in your first reply, maybe because I didn't "remove" before "require"?
Definitely in composer.json now: "aimeos/aimeos-typo3": "2021.10.x-dev"
But unfortunately still getting the same error:
Definitely in composer.json now: "aimeos/aimeos-typo3": "2021.10.x-dev"
Code: Select all
$ ea-php74 ~/composer.phar remove aimeos/aimeos-typo3 [372/3333]
./composer.json has been updated
Running composer update aimeos/aimeos-typo3
Loading composer repositories with package information
Updating dependencies
Lock file operations: 0 installs, 0 updates, 12 removals
- Removing aimeos/ai-admin-jqadm (2021.10.3)
- Removing aimeos/ai-admin-jsonadm (2021.10.2)
- Removing aimeos/ai-client-html (2021.10.4)
- Removing aimeos/ai-client-jsonapi (2021.10.2)
- Removing aimeos/ai-controller-frontend (2021.10.2)
- Removing aimeos/ai-controller-jobs (2021.10.3)
- Removing aimeos/ai-gettext (2021.10.1)
- Removing aimeos/ai-typo3 (2021.10.2)
- Removing aimeos/aimeos-typo3 (21.10.1)
- Removing nyholm/psr7-server (1.0.2)
- Removing tecnickcom/tcpdf (6.4.2)
- Removing typo3/cms-scheduler (v11.5.1)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 0 installs, 0 updates, 12 removals
- Removing typo3/cms-scheduler (v11.5.1)
- Removing tecnickcom/tcpdf (6.4.2)
- Removing nyholm/psr7-server (1.0.2)
- Removing aimeos/aimeos-typo3 (21.10.1)
- Removing aimeos/ai-typo3 (2021.10.2)
- Removing aimeos/ai-gettext (2021.10.1)
- Removing aimeos/ai-controller-jobs (2021.10.3)
- Removing aimeos/ai-controller-frontend (2021.10.2)
- Removing aimeos/ai-client-jsonapi (2021.10.2)
- Removing aimeos/ai-client-html (2021.10.4)
- Removing aimeos/ai-admin-jsonadm (2021.10.2)
- Removing aimeos/ai-admin-jqadm (2021.10.3)
Generating autoload files
[<--snipped username-->@ns3 ~]$ ea-php74 ~/composer.phar req aimeos/aimeos-typo3:2021.10.x-dev
./composer.json has been updated
Running composer update aimeos/aimeos-typo3
Loading composer repositories with package information
Updating dependencies
Lock file operations: 12 installs, 0 updates, 0 removals
- Locking aimeos/ai-admin-jqadm (2021.10.3)
- Locking aimeos/ai-admin-jsonadm (2021.10.2)
- Locking aimeos/ai-client-html (2021.10.4)
- Locking aimeos/ai-client-jsonapi (2021.10.2)
- Locking aimeos/ai-controller-frontend (2021.10.2)
- Locking aimeos/ai-controller-jobs (2021.10.3)
- Locking aimeos/ai-gettext (2021.10.1)
- Locking aimeos/ai-typo3 (2021.10.2)
- Locking aimeos/aimeos-typo3 (2021.10.x-dev 61dd4aa)
- Locking nyholm/psr7-server (1.0.2)
- Locking tecnickcom/tcpdf (6.4.2)
- Locking typo3/cms-scheduler (v11.5.1)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 12 installs, 0 updates, 0 removals
- Downloading aimeos/ai-controller-frontend (2021.10.2)
- Downloading aimeos/ai-controller-jobs (2021.10.3)
- Downloading typo3/cms-scheduler (v11.5.1)
- Downloading nyholm/psr7-server (1.0.2)
- Downloading aimeos/ai-typo3 (2021.10.2)
- Downloading aimeos/ai-gettext (2021.10.1)
- Downloading aimeos/ai-client-jsonapi (2021.10.2)
- Downloading tecnickcom/tcpdf (6.4.2)
- Downloading aimeos/ai-client-html (2021.10.4)
- Downloading aimeos/ai-admin-jsonadm (2021.10.2)
- Downloading aimeos/ai-admin-jqadm (2021.10.3)
- Downloading aimeos/aimeos-typo3 (2021.10.x-dev 61dd4aa)
- Installing aimeos/ai-controller-frontend (2021.10.2): Extracting archive
- Installing aimeos/ai-controller-jobs (2021.10.3): Extracting archive
- Installing typo3/cms-scheduler (v11.5.1): Extracting archive
- Installing nyholm/psr7-server (1.0.2): Extracting archive
- Installing aimeos/ai-typo3 (2021.10.2): Extracting archive
- Installing aimeos/ai-gettext (2021.10.1): Extracting archive
- Installing aimeos/ai-client-jsonapi (2021.10.2): Extracting archive
- Installing tecnickcom/tcpdf (6.4.2): Extracting archive
- Installing aimeos/ai-client-html (2021.10.4): Extracting archive
- Installing aimeos/ai-admin-jsonadm (2021.10.2): Extracting archive
- Installing aimeos/ai-admin-jqadm (2021.10.3): Extracting archive
- Installing aimeos/aimeos-typo3 (2021.10.x-dev 61dd4aa): Extracting archive
Generating autoload files
64 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
Code: Select all
[<--snipped username-->@ns3 ~]$ rm ~/var/cache/code -Rf
[<--snipped username-->@ns3 ~]$ ./vendor/typo3/cms-cli/typo3 cache:flush
[<--snipped username-->@ns3 ~]$ ./vendor/typo3/cms-cli/typo3 aimeos:setup
Initializing or updating the Aimeos database tables for site default
Error Maximum number of connections (3) for "db" exceeded while initializing or updating the Aimeos database
<debug>#0 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(163): Aimeos\MW\DB\Manager\DBAL->acquire('db')
#1 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(278): Aimeos\MW\Setup\Task\TablesMigrateSiteid->getSites()
#2 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesMigrateSiteid.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->process(Array)
#3 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(114): Aimeos\MW\Setup\Task\TablesMigrateSiteid->migrate()
#4 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#5 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(110): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#6 /home/<--snipped username-->/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(82): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#7 /home/<--snipped username-->/public_html/typo3conf/ext/aimeos/Classes/Command/SetupCommand.php(75): Aimeos\MW\Setup\Manager\Multiple->migrate(Object(Aimeos\MW\Setup\Task\CouponMigrateBasetValues))
#8 /home/<--snipped username-->/vendor/symfony/console/Command/Command.php(299): Aimeos\Aimeos\Command\SetupCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /home/<--snipped username-->/vendor/symfony/console/Application.php(996): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /home/<--snipped username-->/vendor/symfony/console/Application.php(295): Symfony\Component\Console\Application->doRunCommand(Object(Aimeos\Aimeos\Command\SetupCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /home/<--snipped username-->/vendor/symfony/console/Application.php(167): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /home/<--snipped username-->/public_html/typo3/sysext/core/Classes/Console/CommandApplication.php(119): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /home/<--snipped username-->/vendor/typo3/cms-cli/typo3(23): TYPO3\CMS\Core\Console\CommandApplication->run()
#14 /home/<--snipped username-->/vendor/typo3/cms-cli/typo3(24): {closure}()
#15 {main}</debug>
Add new type columns
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text": OK
Checking table "mshop_text_list": OK
Drop old unique indexes
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text_list": OK
Migrate typeid to type
Checking table "mshop_attribute": OK
Checking table "mshop_attribute_list": OK
Checking table "mshop_attribute_property": OK
Checking table "mshop_catalog_list": OK
Checking table "mshop_customer_list": OK
Checking table "mshop_customer_property": OK
Checking table "mshop_media": OK
Checking table "mshop_media_list": OK
Checking table "mshop_media_property": OK
Checking table "mshop_plugin": OK
Checking table "mshop_price": OK
Checking table "mshop_price_list": OK
Checking table "mshop_product": OK
Checking table "mshop_product_list": OK
Checking table "mshop_product_property": OK
Checking table "mshop_service": OK
Checking table "mshop_service_list": OK
Checking table "mshop_stock": OK
Checking table "mshop_supplier_list": OK
Checking table "mshop_tag": OK
Checking table "mshop_text": OK
Checking table "mshop_text_list": OK
Update attribute "key" columns
Checking table mshop_attribute OK
Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" OK
Drop the mshop_index_text table without ID column OK
Migrate mshop_index_text table engine to InnoDB OK
Prepare mshop_index_price table for simplification OK
Prepare mshop_index_text table for simplification OK
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Adding tax column to order tables
Checking table "mshop_order_base_product": OK
Checking table "mshop_order_base_service": OK
Checking table "mshop_order_base": OK
Migrate supplier code to ID and name in order product table done
Migrating product property domain to "product" OK
Rename warehouse table
Drop "mshop_product_stock.fk_msprost_whid" OK
Drop "mshop_product_stock.fk_msprost_stock_warehouseid" OK
Rename "mshop_product_stock.wareshouseid" OK
Rename "mshop_product_stock_wareshouse" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Ensure unique codes in mshop_service done
Migrate product code in stock table
Migrate "productcode" to "prodid" OK
Remove column "productcode" OK
Clear property "key" columns
Checking table mshop_attribute_property OK
Checking table mshop_customer_property OK
Checking table mshop_media_property OK
Checking table mshop_price_property OK
Checking table mshop_product_property OK
Creating admin tables
Using schema from cache.php
Checking table "madmin_cache": OK
Checking table "madmin_cache_tag": OK
Using schema from log.php
Checking table "madmin_log": OK
Using schema from job.php
Checking table "madmin_job": OK
Using schema from queue.php
Checking table "madmin_queue": OK
Update "siteid" columns
Checking table mshop_attribute_type OK
Checking table mshop_attribute_list_type OK
Checking table mshop_attribute_property_type OK
Checking table mshop_attribute_list OK
Checking table mshop_attribute_property OK
Checking table mshop_attribute OK
Checking table madmin_cache_tag OK
Checking table madmin_cache OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_catalog OK
Checking table mshop_coupon_code OK
Checking table mshop_coupon OK
Checking table mshop_customer_list_type OK
Checking table mshop_customer_property_type OK
Checking table mshop_customer_group OK
Checking table mshop_customer_property OK
Checking table mshop_customer_list
-
pixelplumber
- Posts: 22
- Joined: 26 Oct 2019, 12:38
Re: upgrade to 2021 from 2019 missing column mlocsi.icon
Hi, Just did a composer update:
- Upgrading aimeos/aimeos-core (2021.10.x-dev aaa788e => 2021.10.x-dev c4ae12c)
Looks like this revision is working!
Was able to load the setup script and now the database tables are there and the backend main module loads again under 11.
Cheers.
- Upgrading aimeos/aimeos-core (2021.10.x-dev aaa788e => 2021.10.x-dev c4ae12c)
Looks like this revision is working!
Was able to load the setup script and now the database tables are there and the backend main module loads again under 11.
Cheers.