SQLSTATE[42S02]: Base table or view not found: 1146 Table
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
SQLSTATE[42S02]: Base table or view not found: 1146 Table
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
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
Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table
Was there any error during installation?
Run this command to update the database and add any missing tables or columns:
Run this command to update the database and add any missing tables or columns:
Code: Select all
php artisan aimeos:setup
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
Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table
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.
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.
Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table
Do you have no internet connection?
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
Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table
I do have Internet connection
Re: SQLSTATE[42S02]: Base table or view not found: 1146 Table
Maybe your PHP installation has configured a time limit on the CLI too. Can you try:
or for a full installation:
Code: Select all
/usr/bin/php8.2" -d max_execution_time=-1 artisan aimeos:setup --option=setup/default/demo:1
Code: Select all
/usr/bin/php8.2" -d max_execution_time=-1 composer create-project aimeos/aimeos
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