updated version of aimeos and theme

KhushalWebroot · Post by **KhushalWebroot** » 30 May 2023, 05:21

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mpro.boost' in 'field list': SELECT mpro."id" AS "product.id", mpro."siteid" AS "product.siteid", mpro."type" AS "product.type", mpro."code" AS "product.code", mpro."label" AS "product.label", mpro."url" AS "product.url", mpro."start" AS "product.datestart", mpro."end" AS "product.dateend", mpro."status" AS "product.status", mpro."ctime" AS "product.ctime", mpro."mtime" AS "product.mtime", mpro."editor" AS "product.editor", mpro."target" AS "product.target", mpro."dataset" AS "product.dataset", mpro."scale" AS "product.scale", mpro."config" AS "product.config", mpro."rating" AS "product.rating", mpro."ratings" AS "product.ratings", mpro."instock" AS "product.instock", mpro."boost" AS "product.boost" FROM "mshop_product" mpro WHERE ( ( mpro."siteid" IN ('','1.') ) AND mpro."id" IN (20,21,22,23) ) GROUP BY mpro."id", mpro."id" ORDER BY mpro."id" ASC LIMIT 4 OFFSET 0

I upgraded my aimeos package version from 2022 to 2023 and also my theme from 2022 to 2023 now I'm getting errors because all the database tables have changed structure. Do I have a way to update the theme without having any errors? Would you be able to help me export the old website's data and import it into the new website?

Post by **aimeos** » 30 May 2023, 07:30

Did you execute this command to update the database structure?

Code: Select all

php artisan aimeos:setup

KhushalWebroot · Post by **KhushalWebroot** » 30 May 2023, 07:48

Post by **aimeos** » 30 May 2023, 08:06

Did it execute without any errors?

KhushalWebroot · Post by **KhushalWebroot** » 01 Jun 2023, 10:30

yes and would you be able to tell me how to clear the cache for all full applications by cmd or in any other manner.

php artisan cache:clear
php artisan aimeos:clear
php artisan config:cache

these dosn't help.

Post by **aimeos** » 03 Jun 2023, 11:29

Your database is definitely missing the new columns.

Try to run the command again and see if it terminates early due to PHP memory or time limits:

Code: Select all

php artisan aimeos:setup

You should also try to set PHP limits manually on the command line:

Code: Select all

php -d memory_limit=-1 -d max_execution_time=300 artisan aimeos:setup

Help for Aimeos