error when aimeos setup

[ahmed31916]

Hello,

I clone my aimeos shop project to another computer. The composer update done perfectly, BUT when I tried to setup aimeos by this command: "php artisan aimeos:setup", I get this error:

Code: Select all

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'women_store.madmin_log' doesn't exist: 
INSERT INTO "madmin_log" (
"facility", "timestamp", "priority", "message", "request", "siteid"
) VALUES (
?, ?, ?, ?, ?, ?
)
["core\/sql","2022-04-22 13:01:46",7,"Time: 9.1660022735596ms\nClass: Aimeos\\MShop\\Locale\\Manager\\Language\\Standard\nSELECT \nmlocla.\"id\" AS \"locale.language.id\", mlocla.\"label\" AS \"locale.language.label\",\nmlocla.\"status\" AS \"locale.language.status\", mlocla.\"mtime\" AS \"locale.language.mmlocla.\"id\" ASC\nLIMIT 2147483647 OFFSET 0","91eeaf0f398b5ccb69776ed16383d1b9",""]

aimeos version: 2022.04

[aimeos]

Can you post your complete output?

[ahmed31916]

Code: Select all

Initializing or updating the Aimeos database tables for site "default"
Migrate type columns
  Add new type columns
    Checking table "mshop_attribute": 
    Checking table "mshop_attribute_list":     
    Checking table "mshop_attribute_property": 
    Checking table "mshop_catalog_list":       
    Checking table "mshop_customer_list":      
    Checking table "mshop_customer_property":  
    Checking table "mshop_media":
    Checking table "mshop_media_list":
    Checking table "mshop_media_property":
    Checking table "mshop_plugin":
    Checking table "mshop_price":
    Checking table "mshop_price_list":
    Checking table "mshop_product":
    Checking table "mshop_product_list":
    Checking table "mshop_product_property":
    Checking table "mshop_service":
    Checking table "mshop_service_list":
    Checking table "mshop_stock":
    Checking table "mshop_supplier_list":
    Checking table "mshop_tag":
    Checking table "mshop_text":
    Checking table "mshop_text_list":
  Drop old unique indexes
    Checking index "unq_msattr_sid_dom_cod_tid":
    Checking index "unq_msattli_sid_dm_rid_tid_pid": 
    Checking index "unq_msattpr_sid_tid_lid_value": 
    Checking index "unq_mscatli_sid_dm_rid_tid_pid":
    Checking index "unq_mscusli_sid_dm_rid_tid_pid":
    Checking index "unq_mcuspr_sid_tid_lid_value":
    Checking index "unq_msmedli_sid_dm_rid_tid_pid":
    Checking index "unq_msmedpr_sid_tid_lid_value":
    Checking index "unq_msplu_sid_tid_prov":
    Checking index "unq_msprili_sid_dm_rid_tid_pid":
    Checking index "unq_msproli_sid_dm_rid_tid_pid":
    Checking index "unq_mspropr_sid_tid_lid_value":
    Checking index "unq_msserli_sid_dm_rid_tid_pid":
    Checking index "unq_mssto_sid_pcode_tid":
    Checking index "unq_mssupli_sid_dm_rid_tid_pid":
    Checking index "unq_mstag_sid_dom_tid_lid_lab":
    Checking index "unq_mstexli_sid_dm_rid_tid_pid":
  Migrate typeid to type
    Checking table "mshop_attribute":
    Checking table "mshop_attribute_list":
    Checking table "mshop_attribute_property":
    Checking table "mshop_catalog_list":
    Checking table "mshop_customer_list":
    Checking table "mshop_customer_property":
    Checking table "mshop_media":
    Checking table "mshop_media_list":
    Checking table "mshop_media_property":
    Checking table "mshop_plugin":
    Checking table "mshop_price":
    Checking table "mshop_price_list":
    Checking table "mshop_product":
    Checking table "mshop_product_list":
    Checking table "mshop_product_property":
    Checking table "mshop_service":
    Checking table "mshop_service_list":
    Checking table "mshop_stock":
    Checking table "mshop_supplier_list":
    Checking table "mshop_tag":
    Checking table "mshop_text":
    Checking table "mshop_text_list":
  Drop typeid columns
    Checking table "mshop_attribute":
    Checking table "mshop_attribute_list":
    Checking table "mshop_attribute_property":
    Checking table "mshop_catalog_list":
    Checking table "mshop_customer_list":
    Checking table "mshop_customer_property":
    Checking table "mshop_media":
    Checking table "mshop_media_list":
    Checking table "mshop_media_property":
    Checking table "mshop_plugin":
    Checking table "mshop_price":
    Checking table "mshop_price_list":
    Checking table "mshop_product":
    Checking table "mshop_product_list":
    Checking table "mshop_product_property":
    Checking table "mshop_service":
    Checking table "mshop_service_list":
    Checking table "mshop_stock":
    Checking table "mshop_supplier_list":
    Checking table "mshop_tag":
    Checking table "mshop_text":
    Checking table "mshop_text_list":
Clear property "key" columns
Creating attribute schema
Creating cache schema
Creating catalog schema
Creating CMS tables
Creating coupon schema
Creating customer schema
Creating media schema
Creating price schema
Creating product schema
Update property "key" columns
  Checking table users_property
Creating service schema
Creating supplier schema
Creating text schema
Update lists "key" columns
  Checking table mshop_attribute_list
  Checking table mshop_catalog_list
  Checking table mshop_customer_list
  Checking table mshop_media_list
  Checking table mshop_price_list
  Checking table mshop_product_list
  Checking table mshop_service_list
  Checking table mshop_supplier_list
  Checking table mshop_text_list
Update Laravel lists "key" columns
  Checking table users_list
Update property "key" columns
  Checking table users_property
Creating locale schema
Add locale data for languages and currencies
  Adding data for MShop locale languages

   Aimeos\Base\DB\Exception 

  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'women_store.madmin_log' doesn't exist: 
                                INSERT INTO "madmin_log" (
                                        "facility", "timestamp", "priority", "message", "request", "siteid"
                                ) VALUES (
                                        ?, ?, ?, ?, ?, ?
                                )
                        ["core\/sql","2022-04-23 02:14:26",7,"Time: 1.0368824005127ms\nClass: Aimeos\\MShop\\Locale\\Manager\\Language\\Standard\nSELECT \nmlocla.\"id\" AS \"locale.language.id\", mlocla.\"label\" AS \"locale.language.label\",\nmlocla.\"status\" AS \"locale.language.status\", mlocla.\"mtime\" AS \"locale.language.mtime\",\nmlocla.\"editor\" AS \"locale.language.editor\", mlocla.\"ctime\" AS \"locale.language.ctime\"\nFROM \"mshop_locale_language\" mlocla\nWHERE 1 = 1\nORDER BY mlocla.\"id\" ASC\nLIMIT 2147483647 OFFSET 0","ecdb725d38fcf31c6303a761a42b4ca8",""]

  at C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-base\src\DB\Statement\DBAL\Prepared.php:77
     73▕        {
     74▕                try {
     75▕                        $result = $this->exec();
     76▕                } catch( \Doctrine\DBAL\Driver\Exception $e ) {
  ➜  77▕                        throw new \Aimeos\Base\DB\Exception( $e->getMessage() . ': ' . $this->sql . json_encode( array_column( $this->binds, 0 ) ), $e->getCode() );
     78▕                }
     79▕
     80▕                return new \Aimeos\Base\DB\Result\DBAL( $result );
     81▕        }

  1   C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-core\src\MAdmin\Log\Manager\Standard.php:294
      Aimeos\Base\DB\Statement\DBAL\Prepared::execute()

  2   C:\xampp\htdocs\WomenStore\vendor\aimeos\aimeos-core\src\MShop\Common\Manager\Base.php:108
      Aimeos\MAdmin\Log\Manager\Standard::saveItem(Object(Aimeos\MAdmin\Log\Item\Standard))

[aimeos]

Is there a complete stack trace available too (after the last two lines of output)?

[ahmed31916]

No

[aimeos]

Can you execute "php artisan -vvv aimeos:setup"? Maybe this reveals the remaining stack trace.