updated version of aimeos and theme

[KhushalWebroot]

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?

[aimeos]

Did you execute this command to update the database structure?

Code: Select all

php artisan aimeos:setup

[KhushalWebroot]

yes

[aimeos]

Did it execute without any errors?

[KhushalWebroot]

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.

[aimeos]

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