Aimeos installation from composer works but stop executing before database setup

octorber123 · Post by **octorber123** » 21 Jul 2020, 10:55

here is the out for: composer show

: Picture12.jpg (186.12 KiB) Viewed 2683 times

: Picture13.jpg (175.08 KiB) Viewed 2683 times

Post by **aimeos** » 21 Jul 2020, 11:48

Can you have a look if your installed version contains this code now ("id" instead of "bigIncrements")?
https://github.com/aimeos/aimeos/commit ... 6d640f8d94

octorber123 · Post by **octorber123** » 21 Jul 2020, 11:59

yes this is the code in the user migration file.

public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->id('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->rememberToken();
$table->timestamps();
});
}

octorber123 · Post by **octorber123** » 21 Jul 2020, 12:03

I don't know if this helps, but this is the error I get when opening the dev server of laravel,

: Picture133.jpg (128.9 KiB) Viewed 2683 times

Post by **aimeos** » 21 Jul 2020, 12:12

If the setup doesn't run flawlessly, the application won't run at all.
Can you please post the output of

Code: Select all

show create table users;

from the mysql console?

octorber123 · Post by **octorber123** » 21 Jul 2020, 12:58

this is the output on the sql command line

Post by **aimeos** » 21 Jul 2020, 13:28

We need the full output of

Code: Select all

show create table users

but I guess your MySQL server uses the MyISAM table engine by default for some reasons. Can you please try again:

Code: Select all

composer create-project aimeos/aimeos:2019.10.x-dev myshop

We've updated the migration file to enfore InnoDB engine for the users table now.

octorber123 · Post by **octorber123** » 22 Jul 2020, 11:22

where should i put this?
show create table users , should i put it in the sql command line?

Also i have changed my default engine to InnoDB by editing the my.ini file in mysql and in maria db so all tables by default will be created as innodb.

I ran the composer create-project aimeos/aimeos:2019.10.x-dev myshop a few times before and after changing my default engine but now it seems that the migrations are not running due to an exception. a pic can be seen below

: wqerqwer.jpg (65.88 KiB) Viewed 2671 times

thanks for the help

octorber123 · Post by **octorber123** » 22 Jul 2020, 11:39

I HAVE GOOD NEWS!!! (sorry for caps)

I finally fixed the problem, so basically I had to change the default engine of the DB to Innodb by editing the my.ini files of MariaDB and MySQL. Then I ran the standard composer create-project aimeos/aimeos myshop, and it worked

thanks so much for your help and patience

Post by **aimeos** » 22 Jul 2020, 11:41

Great! We've changed that in the Laravel migration file too, so the tables will be created using the InnoDB engine regardless of the MySQL server settings.

Can you try again using:

Code: Select all

composer create-project aimeos/aimeos:2019.10.x-dev myshop

We've fixed the id() problem so we want to release a new version with all the changes.

Thank you for your time and patience!

Help for Aimeos

Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Re: Aimeos installation from composer works but stop executing before database setup

Connect with your social network account