Tables are not created
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Tables are not created
Env: MacOS 10.14.6
PHP: 7.2
DB: PostgreSQL 11.4
Aimeos: 2019.10
Laravel: 5.8
Hello Aimeos.
The steps before command are completed. Database configurations changed. But at the installation stage I get an error:
When I check the database, it turns out that the tables, except those that were previously migrated, were not created.
Why is this occured?
Thank you.
PHP: 7.2
DB: PostgreSQL 11.4
Aimeos: 2019.10
Laravel: 5.8
Hello Aimeos.
The steps before command
Code: Select all
php artisan aimeos:setup
Code: Select all
Pros-MacBook-Pro:aimeostest01 a2881dante$ php artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "default"
Changing warehouseid column in mshop_product_stock 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
Rename "prodid" to "parentid" in table "mshop_product_stock"
Checking column "prodid" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Migrate product code in stock table
Adding warehouse code to order base product table OK
Moving product tag tables to own domain
Moving table "mshop_product_tag_type" OK
Moving table "mshop_product_tag" OK
Ensure unique codes in mshop_service OK
Update 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
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Update charset and collation
Checking table mshop_coupon OK
Checking table mshop_coupon_code OK
Checking table cache OK
Checking table mshop_cache_tag OK
Checking table mshop_catalog OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_customer OK
Checking table mshop_customer_address OK
Checking table mshop_customer_group OK
Checking table mshop_customer_list_type OK
Checking table mshop_customer_list OK
Checking table mshop_customer_property_type OK
Checking table mshop_customer_property OK
Checking table madmin_job OK
Checking table mshop_locale_site OK
Checking table mshop_locale OK
Checking table mshop_locale_language OK
Checking table mshop_locale_currency OK
Checking table madmin_log OK
Checking table mshop_media_type OK
Checking table mshop_media OK
Checking table mshop_media_list_type OK
Checking table mshop_media_list OK
Checking table mshop_media_property_type OK
Checking table mshop_media_property OK
Checking table mshop_order_base OK
Checking table mshop_order_base_address OK
Checking table mshop_order_base_coupon OK
Checking table mshop_order_base_product OK
Checking table mshop_order_base_product_attr OK
Checking table mshop_order_base_service OK
Checking table mshop_order_base_service_attr OK
Checking table mshop_order OK
Checking table mshop_order_status OK
Checking table mshop_plugin_type OK
Checking table mshop_plugin OK
Checking table mshop_price_type OK
Checking table mshop_price OK
Checking table mshop_price_list_type OK
Checking table mshop_price_list OK
Checking table mshop_index_attribute OK
Checking table mshop_index_catalog OK
Checking table mshop_index_price OK
Checking table mshop_index_supplier OK
Checking table mshop_index_text OK
Checking table mshop_product_type OK
Checking table mshop_product OK
Checking table mshop_product_list_type OK
Checking table mshop_product_list OK
Checking table mshop_product_property_type OK
Checking table mshop_product_property OK
Checking table madmin_queue OK
Checking table mshop_service_type OK
Checking table mshop_service OK
Checking table mshop_service_list_type OK
Checking table mshop_service_list OK
Checking table mshop_stock_type OK
Checking table mshop_stock OK
Checking table mshop_subscription OK
Checking table mshop_supplier OK
Checking table mshop_supplier_address OK
Checking table mshop_supplier_list_type OK
Checking table mshop_supplier_list OK
Checking table mshop_tag_type OK
Checking table mshop_tag OK
Checking table mshop_text OK
Checking table mshop_text_type OK
Checking table mshop_text_list_type OK
Checking table mshop_text_list OK
Add new type columns
Checking table "mshop_attribute":
Doctrine\DBAL\Exception\TableNotFoundException : An exception occurred while executing 'SELECT obj_description('mshop_attribute'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_attribute" does not exist
LINE 1: SELECT obj_description('mshop_attribute'::regclass) AS table...
^
at /Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:63
59| case '42703':
60| return new Exception\InvalidFieldNameException($message, $exception);
61|
62| case '42P01':
> 63| return new Exception\TableNotFoundException($message, $exception);
64|
65| case '42P07':
66| return new Exception\TableExistsException($message, $exception);
67|
Exception trace:
1 Doctrine\DBAL\Driver\AbstractPostgreSQLDriver::convertException("An exception occurred while executing 'SELECT obj_description('mshop_attribute'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_attribute" does not exist
LINE 1: SELECT obj_description('mshop_attribute'::regclass) AS table...
^", Object(Doctrine\DBAL\Driver\PDOException))
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166
2 Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), "An exception occurred while executing 'SELECT obj_description('mshop_attribute'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_attribute" does not exist
LINE 1: SELECT obj_description('mshop_attribute'::regclass) AS table...
^")
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146
Why is this occured?
Thank you.
Re: Tables are not created
Can you please execute:
It seems like PostgreSQL throws an error if DBAL tries to get the table details of a table that doesn't exist (yet).
Code: Select all
composer req aimeos/aimeos-core:2019.10.x-dev
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
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Re: Tables are not created
DB still empty, errors still occur.
Code: Select all
Pros-MacBook-Pro:aimeostest01 a2881dante$ composer req aimeos/aimeos-core:2019.10.x-dev
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 0 installs, 1 update, 0 removals
- Removing aimeos/aimeos-core (2019.10.3)
- Installing aimeos/aimeos-core (2019.10.x-dev 0488036): Cloning 048803600a from cache
Writing lock file
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
Discovered Package: aimeos/aimeos-laravel
Discovered Package: facade/ignition
Discovered Package: fideloper/proxy
Discovered Package: laravel/tinker
Discovered Package: nesbot/carbon
Discovered Package: nunomaduro/collision
Package manifest generated successfully.
> @php artisan vendor:publish --tag=public --force
Copied Directory [/vendor/aimeos/aimeos-laravel/public] To [/public/packages/aimeos/shop]
Publishing complete.
> @php artisan migrate
Nothing to migrate.
You have new mail in /var/mail/a2881dante
Pros-MacBook-Pro:aimeostest01 a2881dante$ php artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "default"
Changing warehouseid column in mshop_product_stock 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
Rename "prodid" to "parentid" in table "mshop_product_stock"
Checking column "prodid" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Migrate product code in stock table
Adding warehouse code to order base product table OK
Moving product tag tables to own domain
Moving table "mshop_product_tag_type" OK
Moving table "mshop_product_tag" OK
Ensure unique codes in mshop_service OK
Update 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
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Update charset and collation
Checking table mshop_coupon OK
Checking table mshop_coupon_code OK
Checking table cache OK
Checking table mshop_cache_tag OK
Checking table mshop_catalog OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_customer OK
Checking table mshop_customer_address OK
Checking table mshop_customer_group OK
Checking table mshop_customer_list_type OK
Checking table mshop_customer_list OK
Checking table mshop_customer_property_type OK
Checking table mshop_customer_property OK
Checking table madmin_job OK
Checking table mshop_locale_site OK
Checking table mshop_locale OK
Checking table mshop_locale_language OK
Checking table mshop_locale_currency OK
Checking table madmin_log OK
Checking table mshop_media_type OK
Checking table mshop_media OK
Checking table mshop_media_list_type OK
Checking table mshop_media_list OK
Checking table mshop_media_property_type OK
Checking table mshop_media_property OK
Checking table mshop_order_base OK
Checking table mshop_order_base_address OK
Checking table mshop_order_base_coupon OK
Checking table mshop_order_base_product OK
Checking table mshop_order_base_product_attr OK
Checking table mshop_order_base_service OK
Checking table mshop_order_base_service_attr OK
Checking table mshop_order OK
Checking table mshop_order_status OK
Checking table mshop_plugin_type OK
Checking table mshop_plugin OK
Checking table mshop_price_type OK
Checking table mshop_price OK
Checking table mshop_price_list_type OK
Checking table mshop_price_list OK
Checking table mshop_index_attribute OK
Checking table mshop_index_catalog OK
Checking table mshop_index_price OK
Checking table mshop_index_supplier OK
Checking table mshop_index_text OK
Checking table mshop_product_type OK
Checking table mshop_product OK
Checking table mshop_product_list_type OK
Checking table mshop_product_list OK
Checking table mshop_product_property_type OK
Checking table mshop_product_property OK
Checking table madmin_queue OK
Checking table mshop_service_type OK
Checking table mshop_service OK
Checking table mshop_service_list_type OK
Checking table mshop_service_list OK
Checking table mshop_stock_type OK
Checking table mshop_stock OK
Checking table mshop_subscription OK
Checking table mshop_supplier OK
Checking table mshop_supplier_address OK
Checking table mshop_supplier_list_type OK
Checking table mshop_supplier_list OK
Checking table mshop_tag_type OK
Checking table mshop_tag OK
Checking table mshop_text OK
Checking table mshop_text_type OK
Checking table mshop_text_list_type OK
Checking table mshop_text_list OK
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": 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
Migrating configuration keys in coupon tables OK
Migrating product property domain to "product" OK
Update attribute "key" columns
Checking table mshop_attribute OK
Update lists "key" columns
Checking table mshop_attribute_list OK
Checking table mshop_catalog_list OK
Checking table mshop_customer_list OK
Checking table mshop_media_list OK
Checking table mshop_price_list OK
Checking table mshop_product_list OK
Checking table mshop_service_list OK
Checking table mshop_supplier_list OK
Checking table mshop_text_list 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
Renaming catalog index tables to index
Checking table "mshop_catalog_index_attribute" OK
Checking table "mshop_catalog_index_catalog" OK
Checking table "mshop_catalog_index_price" OK
Checking table "mshop_catalog_index_text" OK
Add new type columns for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Drop old unique indexes for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Migrate typeid to type for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Rename "refid" to "parentid" in table "users_address"
Checking column "refid" OK
Update charset and collation for Laravel tables
Checking table users OK
Checking table users_address OK
Checking table users_list_type OK
Checking table users_list OK
Checking table users_property_type OK
Checking table users_property OK
Remove left over Laravel user references
Remove unused users_address records OK
Remove unused users_list records OK
Remove unused users_property records OK
Creating base tables
Using schema from locale.php
Checking table "mshop_locale_site":
Doctrine\DBAL\Exception\TableNotFoundException : An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^
at /Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:63
59| case '42703':
60| return new Exception\InvalidFieldNameException($message, $exception);
61|
62| case '42P01':
> 63| return new Exception\TableNotFoundException($message, $exception);
64|
65| case '42P07':
66| return new Exception\TableExistsException($message, $exception);
67|
Exception trace:
1 Doctrine\DBAL\Driver\AbstractPostgreSQLDriver::convertException("An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^", Object(Doctrine\DBAL\Driver\PDOException))
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166
2 Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), "An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^")
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146
Re: Tables are not created
Same error type but different location. Can you run that again?
Code: Select all
composer update
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
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Re: Tables are not created
Same error, nothing changed.
Re: Tables are not created
Can you post the output please?
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
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Re: Tables are not created
Code: Select all
Pros-MacBook-Pro:aimeostest01 a2881dante$ php artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "default"
Changing warehouseid column in mshop_product_stock 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
Rename "prodid" to "parentid" in table "mshop_product_stock"
Checking column "prodid" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Migrate product code in stock table
Adding warehouse code to order base product table OK
Moving product tag tables to own domain
Moving table "mshop_product_tag_type" OK
Moving table "mshop_product_tag" OK
Ensure unique codes in mshop_service OK
Update 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
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Update charset and collation
Checking table mshop_coupon OK
Checking table mshop_coupon_code OK
Checking table cache OK
Checking table mshop_cache_tag OK
Checking table mshop_catalog OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_customer OK
Checking table mshop_customer_address OK
Checking table mshop_customer_group OK
Checking table mshop_customer_list_type OK
Checking table mshop_customer_list OK
Checking table mshop_customer_property_type OK
Checking table mshop_customer_property OK
Checking table madmin_job OK
Checking table mshop_locale_site OK
Checking table mshop_locale OK
Checking table mshop_locale_language OK
Checking table mshop_locale_currency OK
Checking table madmin_log OK
Checking table mshop_media_type OK
Checking table mshop_media OK
Checking table mshop_media_list_type OK
Checking table mshop_media_list OK
Checking table mshop_media_property_type OK
Checking table mshop_media_property OK
Checking table mshop_order_base OK
Checking table mshop_order_base_address OK
Checking table mshop_order_base_coupon OK
Checking table mshop_order_base_product OK
Checking table mshop_order_base_product_attr OK
Checking table mshop_order_base_service OK
Checking table mshop_order_base_service_attr OK
Checking table mshop_order OK
Checking table mshop_order_status OK
Checking table mshop_plugin_type OK
Checking table mshop_plugin OK
Checking table mshop_price_type OK
Checking table mshop_price OK
Checking table mshop_price_list_type OK
Checking table mshop_price_list OK
Checking table mshop_index_attribute OK
Checking table mshop_index_catalog OK
Checking table mshop_index_price OK
Checking table mshop_index_supplier OK
Checking table mshop_index_text OK
Checking table mshop_product_type OK
Checking table mshop_product OK
Checking table mshop_product_list_type OK
Checking table mshop_product_list OK
Checking table mshop_product_property_type OK
Checking table mshop_product_property OK
Checking table madmin_queue OK
Checking table mshop_service_type OK
Checking table mshop_service OK
Checking table mshop_service_list_type OK
Checking table mshop_service_list OK
Checking table mshop_stock_type OK
Checking table mshop_stock OK
Checking table mshop_subscription OK
Checking table mshop_supplier OK
Checking table mshop_supplier_address OK
Checking table mshop_supplier_list_type OK
Checking table mshop_supplier_list OK
Checking table mshop_tag_type OK
Checking table mshop_tag OK
Checking table mshop_text OK
Checking table mshop_text_type OK
Checking table mshop_text_list_type OK
Checking table mshop_text_list OK
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": 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
Migrating configuration keys in coupon tables OK
Migrating product property domain to "product" OK
Update attribute "key" columns
Checking table mshop_attribute OK
Update lists "key" columns
Checking table mshop_attribute_list OK
Checking table mshop_catalog_list OK
Checking table mshop_customer_list OK
Checking table mshop_media_list OK
Checking table mshop_price_list OK
Checking table mshop_product_list OK
Checking table mshop_service_list OK
Checking table mshop_supplier_list OK
Checking table mshop_text_list 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
Renaming catalog index tables to index
Checking table "mshop_catalog_index_attribute" OK
Checking table "mshop_catalog_index_catalog" OK
Checking table "mshop_catalog_index_price" OK
Checking table "mshop_catalog_index_text" OK
Add new type columns for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Drop old unique indexes for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Migrate typeid to type for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Rename "refid" to "parentid" in table "users_address"
Checking column "refid" OK
Update charset and collation for Laravel tables
Checking table users OK
Checking table users_address OK
Checking table users_list_type OK
Checking table users_list OK
Checking table users_property_type OK
Checking table users_property OK
Remove left over Laravel user references
Remove unused users_address records OK
Remove unused users_list records OK
Remove unused users_property records OK
Creating base tables
Using schema from locale.php
Checking table "mshop_locale_site":
Doctrine\DBAL\Exception\TableNotFoundException : An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^
at /Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:63
59| case '42703':
60| return new Exception\InvalidFieldNameException($message, $exception);
61|
62| case '42P01':
> 63| return new Exception\TableNotFoundException($message, $exception);
64|
65| case '42P07':
66| return new Exception\TableExistsException($message, $exception);
67|
Exception trace:
1 Doctrine\DBAL\Driver\AbstractPostgreSQLDriver::convertException("An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^", Object(Doctrine\DBAL\Driver\PDOException))
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:166
2 Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOPgSql\Driver), Object(Doctrine\DBAL\Driver\PDOException), "An exception occurred while executing 'SELECT obj_description('mshop_locale_site'::regclass) AS table_comment;':
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "mshop_locale_site" does not exist
LINE 1: SELECT obj_description('mshop_locale_site'::regclass) AS tab...
^")
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:146
Re: Tables are not created
Which commit of aimeos/aimeos-core is installed on your system now?
It must be aa1fbcbe4ffb1878ec22dd59ccb218a3660c7dbe
Code: Select all
composer show
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
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Re: Tables are not created
I'm sorry. Now I tried again - tables created, but another error occurred.
Code: Select all
Pros-MacBook-Pro:aimeostest01 a2881dante$ php artisan aimeos:setup
Initializing or updating the Aimeos database tables for site "default"
Changing warehouseid column in mshop_product_stock 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
Rename "prodid" to "parentid" in table "mshop_product_stock"
Checking column "prodid" OK
Move stock tables to own domain
Checking "mshop_product_stock" OK
Checking "mshop_product_stock_type" OK
Migrate product code in stock table
Adding warehouse code to order base product table OK
Moving product tag tables to own domain
Moving table "mshop_product_tag_type" OK
Moving table "mshop_product_tag" OK
Ensure unique codes in mshop_service OK
Update 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
Remove mshop_locale char constraints
Checking constraint for "langid" OK
Checking constraint for "currencyid" OK
Update charset and collation
Checking table mshop_coupon OK
Checking table mshop_coupon_code OK
Checking table cache OK
Checking table mshop_cache_tag OK
Checking table mshop_catalog OK
Checking table mshop_catalog_list_type OK
Checking table mshop_catalog_list OK
Checking table mshop_customer OK
Checking table mshop_customer_address OK
Checking table mshop_customer_group OK
Checking table mshop_customer_list_type OK
Checking table mshop_customer_list OK
Checking table mshop_customer_property_type OK
Checking table mshop_customer_property OK
Checking table madmin_job OK
Checking table mshop_locale_site OK
Checking table mshop_locale OK
Checking table mshop_locale_language OK
Checking table mshop_locale_currency OK
Checking table madmin_log OK
Checking table mshop_media_type OK
Checking table mshop_media OK
Checking table mshop_media_list_type OK
Checking table mshop_media_list OK
Checking table mshop_media_property_type OK
Checking table mshop_media_property OK
Checking table mshop_order_base OK
Checking table mshop_order_base_address OK
Checking table mshop_order_base_coupon OK
Checking table mshop_order_base_product OK
Checking table mshop_order_base_product_attr OK
Checking table mshop_order_base_service OK
Checking table mshop_order_base_service_attr OK
Checking table mshop_order OK
Checking table mshop_order_status OK
Checking table mshop_plugin_type OK
Checking table mshop_plugin OK
Checking table mshop_price_type OK
Checking table mshop_price OK
Checking table mshop_price_list_type OK
Checking table mshop_price_list OK
Checking table mshop_index_attribute OK
Checking table mshop_index_catalog OK
Checking table mshop_index_price OK
Checking table mshop_index_supplier OK
Checking table mshop_index_text OK
Checking table mshop_product_type OK
Checking table mshop_product OK
Checking table mshop_product_list_type OK
Checking table mshop_product_list OK
Checking table mshop_product_property_type OK
Checking table mshop_product_property OK
Checking table madmin_queue OK
Checking table mshop_service_type OK
Checking table mshop_service OK
Checking table mshop_service_list_type OK
Checking table mshop_service_list OK
Checking table mshop_stock_type OK
Checking table mshop_stock OK
Checking table mshop_subscription OK
Checking table mshop_supplier OK
Checking table mshop_supplier_address OK
Checking table mshop_supplier_list_type OK
Checking table mshop_supplier_list OK
Checking table mshop_tag_type OK
Checking table mshop_tag OK
Checking table mshop_text OK
Checking table mshop_text_type OK
Checking table mshop_text_list_type OK
Checking table mshop_text_list OK
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": 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
Migrating configuration keys in coupon tables OK
Migrating product property domain to "product" OK
Update attribute "key" columns
Checking table mshop_attribute OK
Update lists "key" columns
Checking table mshop_attribute_list OK
Checking table mshop_catalog_list OK
Checking table mshop_customer_list OK
Checking table mshop_media_list OK
Checking table mshop_price_list OK
Checking table mshop_product_list OK
Checking table mshop_service_list OK
Checking table mshop_supplier_list OK
Checking table mshop_text_list 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
Renaming catalog index tables to index
Checking table "mshop_catalog_index_attribute" OK
Checking table "mshop_catalog_index_catalog" OK
Checking table "mshop_catalog_index_price" OK
Checking table "mshop_catalog_index_text" OK
Add new type columns for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Drop old unique indexes for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Migrate typeid to type for Laravel
Checking table "users_list": OK
Checking table "users_property": OK
Rename "refid" to "parentid" in table "users_address"
Checking column "refid" OK
Update charset and collation for Laravel tables
Checking table users OK
Checking table users_address OK
Checking table users_list_type OK
Checking table users_list OK
Checking table users_property_type OK
Checking table users_property OK
Remove left over Laravel user references
Remove unused users_address records OK
Remove unused users_list records OK
Remove unused users_property records OK
Creating base tables
Using schema from locale.php
Checking table "mshop_locale_site": done
Checking table "mshop_locale_language": done
Checking table "mshop_locale_currency": done
Checking table "mshop_locale": done
Using schema from attribute.php
Checking table "mshop_attribute_type": done
Checking table "mshop_attribute": done
Checking table "mshop_attribute_list_type": done
Checking table "mshop_attribute_list": done
Checking table "mshop_attribute_property_type": done
Checking table "mshop_attribute_property": done
Using schema from customer.php
Checking table "mshop_customer": done
Checking table "mshop_customer_address": done
Checking table "mshop_customer_list_type": done
Checking table "mshop_customer_list": done
Checking table "mshop_customer_group": done
Checking table "mshop_customer_property_type": done
Checking table "mshop_customer_property": done
Checking table "users": done
Checking table "users_address": done
Checking table "users_list_type": done
Checking table "users_list": done
Checking table "users_property_type": done
Checking table "users_property": done
Using schema from media.php
Checking table "mshop_media_type": done
Checking table "mshop_media": done
Checking table "mshop_media_list_type": done
Checking table "mshop_media_list": done
Checking table "mshop_media_property_type": done
Checking table "mshop_media_property": done
Using schema from order.php
Checking table "mshop_order_base": done
Checking table "mshop_order_base_address": done
Checking table "mshop_order_base_product": done
Checking table "mshop_order_base_product_attr": done
Checking table "mshop_order_base_service": done
Checking table "mshop_order_base_service_attr": done
Checking table "mshop_order_base_coupon": done
Checking table "mshop_order": done
Checking table "mshop_order_status": done
Using schema from plugin.php
Checking table "mshop_plugin_type": done
Checking table "mshop_plugin": done
Using schema from price.php
Checking table "mshop_price_type": done
Checking table "mshop_price": done
Checking table "mshop_price_list_type": done
Checking table "mshop_price_list": done
Checking table "mshop_price_property_type": done
Checking table "mshop_price_property": done
Using schema from product.php
Checking table "mshop_product_type": done
Checking table "mshop_product": done
Checking table "mshop_product_list_type": done
Checking table "mshop_product_list": done
Checking table "mshop_product_property_type": done
Checking table "mshop_product_property": done
Using schema from stock.php
Checking table "mshop_stock_type": done
Checking table "mshop_stock": done
Using schema from service.php
Checking table "mshop_service_type": done
Checking table "mshop_service": done
Checking table "mshop_service_list_type": done
Checking table "mshop_service_list": done
Using schema from supplier.php
Checking table "mshop_supplier": done
Checking table "mshop_supplier_address": done
Checking table "mshop_supplier_list_type": done
Checking table "mshop_supplier_list": done
Using schema from text.php
Checking table "mshop_text_type": done
Checking table "mshop_text": done
Checking table "mshop_text_list_type": done
Checking table "mshop_text_list": done
Using schema from coupon.php
Checking table "mshop_coupon": done
Checking table "mshop_coupon_code": done
Using schema from catalog.php
Checking table "mshop_catalog": done
Checking table "mshop_catalog_list_type": done
Checking table "mshop_catalog_list": done
Using schema from tag.php
Checking table "mshop_tag_type": done
Checking table "mshop_tag": done
Using schema from index.php
Checking table "mshop_index_attribute": done
Checking table "mshop_index_catalog": done
Checking table "mshop_index_price": done
Checking table "mshop_index_supplier": done
Checking table "mshop_index_text": done
Using schema from subscription.php
Checking table "mshop_subscription": done
Add locale data for languages and currencies
Adding data for MShop locale languages 188/188
Adding data for MShop locale currencies 156/156
Add stock type domain values done
Creating admin tables
Using schema from cache.php
Checking table "madmin_cache": done
Checking table "madmin_cache_tag": done
Using schema from log.php
Checking table "madmin_log": done
Using schema from job.php
Checking table "madmin_job": done
Using schema from queue.php
Checking table "madmin_queue": done
Adding data for MShop locale domain
Adding data for MShop locale sites done
Adding data for MShop locales done
Adding locale data if not yet present OK
Remove ctime/editor from index tables
Checking table "mshop_index_attribute": OK
Checking table "mshop_index_catalog": OK
Checking table "mshop_index_price": OK
Checking table "mshop_index_supplier": OK
Checking table "mshop_index_text": OK
Setting locale to "default" OK
Adding currency ID to order base product table done
Migrating taxrate column in order tables
Migrating taxrate column in order base product table done
Migrating taxrate column in order base service table done
Migrating preview column in media table done
Creating platform specific schema
Using tables from index-pgsql.sql
Checking index "mshop_index_text.idx_msindte_content": created
Using tables from order-pgsql.sql
Checking index "mshop_order_base_product_attr.idx_msordbaprat_si_cd_va":
Aimeos\MW\DB\Exception : SQLSTATE[42601]: Syntax error: 7 ERROR: cannot insert multiple commands into a prepared statement: CREATE INDEX "idx_msordbaprat_si_cd_va" ON "mshop_order_base_product_attr" ("siteid", "code", left("value", 16));
CREATE INDEX "idx_msordbaseat_si_cd_va" ON "mshop_order_base_service_attr" ("siteid", "code", left("value", 16));
at /Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/DBAL/Simple.php:94
90|
91| try {
92| $result = $this->exec();
93| } catch( \PDOException $e ) {
> 94| throw new \Aimeos\MW\DB\Exception( $e->getMessage() . ': ' . $this->sql, $e->getCode() );
95| }
96|
97| return new \Aimeos\MW\DB\Result\PDO( $result );
98| }
Exception trace:
1 Aimeos\MW\DB\Statement\DBAL\Simple::execute()
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Task/Base.php:161
2 Aimeos\MW\Setup\Task\Base::execute("CREATE INDEX "idx_msordbaprat_si_cd_va" ON "mshop_order_base_product_attr" ("siteid", "code", left("value", 16));
", "db-order")idx_msordbaseat_si_cd_va" ON "mshop_order_base_service_attr" ("siteid", "code", left("value", 16));
/Applications/AMPPS/www/aimeos-test2/aimeostest01/vendor/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php:257
-
- Posts: 7
- Joined: 04 Nov 2019, 10:23
Re: Tables are not created
Code: Select all
aimeos/aimeos-core 2019.10.x-dev aa1fbcb Full-featured e-commerce components for high performance online shops