Skip to content

Error running migration to setup demo: #60

@londoh

Description

@londoh

$ php artisan aimeos:setup --option=setup/default/demo:1
everything proceeds normally to here:

...
Creating admin tables                                                 
  Using schema from cache.php                                         
    Checking table "madmin_cache":                                    OK
    Checking table "madmin_cache_tag":                                

then this:

[Aimeos\MW\DB\Exception]                                                                                                                                                       
  Executing statement "ALTER TABLE madmin_cache_tag ADD CONSTRAINT fk_macac_tid FOREIGN KEY (tid, tsiteid) REFERENCES madmin_cache (id, siteid) ON UPDATE CASCADE ON DELETE CAS  
  CADE" failed: An exception occurred while executing 'ALTER TABLE madmin_cache_tag ADD CONSTRAINT fk_macac_tid FOREIGN KEY (tid, tsiteid) REFERENCES madmin_cache (id, siteid)  
   ON UPDATE CASCADE ON DELETE CASCADE':                                                                                                                                         
  SQLSTATE[HY000]: General error: 1005 Can't create table `aimeos`.`#sql-1d87_520` (errno: 150 "Foreign key constraint is incorrectly formed") 

laravel 5.2
php 7.0.8
apache 2.4.6
and mariadb

$ mysql -V
mysql  Ver 15.1 Distrib 10.1.16-MariaDB, for Linux (x86_64) using readline 5.1

Please let me know if you have solution, otherwise I'll have a look into it later or tomorrow and report back if I can figure out why.

regards

l.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions