SQLSTATE[42S02]: Base table or view not found: 1146 Table

[Tboi]

PHP version: 8.2
Laravel version: 10
Aimeos version: 2023.10
Environment: Linux

Just finished installing the application but Flare is giving this error when I'm trying to preview the website:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'myshop.mshop_index_catalog' doesn't exist: SELECT mpro."id" , MIN(mindca."pos") AS "s0", MIN(mpro."id") AS "s1" FROM "mshop_product" mpro LEFT JOIN "mshop_index_catalog" AS mindca USE INDEX ("idx_msindca_s_ca_lt_po", "unq_msindca_p_s_cid_lt_po") ON mindca."prodid" = mpro."id" WHERE ( ( mpro."siteid" IN ('','1.') ) AND ( mindca."catid" IS NOT NULL AND mindca."catid" IN ('2','13','14') AND ( mindca."siteid" IN ('','1.') ) AND mindca."catid" IN ( '2','13','14' ) AND mindca."listtype" = 'promotion' AND mindca."pos" >= 0 AND ( ( mpro."status" = 1 ) AND ( mpro."type" = 'event' OR mpro."start" IS NULL OR mpro."start" <= '2024-01-21 00:32:00' ) AND ( mpro."end" IS NULL OR mpro."end" >= '2024-01-21 00:32:00' ) ) ) ) GROUP BY mpro."id" ORDER BY "s0" ASC, "s1" ASC LIMIT 100 OFFSET 0

[aimeos]

Was there any error during installation?
Run this command to update the database and add any missing tables or columns:

Code: Select all

php artisan aimeos:setup

[Tboi]

Error encountered during installation:

Script App\Composer::setup handling the post-create-project-cmd event terminated with an exception
The following exception is caused by a process timeout
Check https://getcomposer.org/doc/06-config.m ... ss-timeout for details

In Process.php line 1204:

The process ""/usr/bin/php8.2" artisan aimeos:setup --option=setup/default/demo:1" exceeded the timeout of 300 seconds.

[aimeos]

Do you have no internet connection?

[Tboi]

I do have Internet connection

[aimeos]

Maybe your PHP installation has configured a time limit on the CLI too. Can you try:

Code: Select all

/usr/bin/php8.2" -d max_execution_time=-1 artisan aimeos:setup --option=setup/default/demo:1

or for a full installation:

Code: Select all

/usr/bin/php8.2" -d max_execution_time=-1 composer create-project aimeos/aimeos