Help for Aimeos

Same reply as the laravel error

They are:

users:
id` int(10) unsigned NOT NULL AUTO_INCREMENT,

users_address
`parentid` int(10) unsigned NOT NULL,

The only difference is auto increment

I have done that - redone the migration - changed the unsigned on users.

When I run

php artisan aimeos:setup --option=setup/default/demo:1

I get

Aimeos\MW\DB\Exception : SQLSTATE[HY000]: General error: 1005 Can't create table `tdbhosti_demoshop`.`users_address` (errno: 150 "Foreign key ...

sorry I should have mentioned I changed the structure of user so id was unsigned

Ok. I dropped all the tables and re-ran php artisan migrate.

I then ran

php artisan aimeos:setup --option=setup/default/demo:1

and got the error message

Aimeos\MW\DB\Exception : SQLSTATE[HY000]: General error: 1005 Can't create table `tdbhosti_demoshop`.`users_address` (errno: 150 "Foreign key ...

I manually changed the version in composer.json (but this was only installed yesterday via composer so you may wish to look at this) and ran an update. It updated to the later version.

I tried php artisan aimeos:setup --option=setup/default/demo:1 but got the same error.

My version of mySQL is ...

I removed the unsiqned from the users.id and the users_address.parentid was unsigned. The tables users_list.parentid and users_property.parentid are not there. I tried to rerun the setup command but got the same error.

I downloaded from composer yesterday. Composer is showing "aimeos/aimeos-laravel ...

from Navicat's table information:


CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE ...

I copied the changes from your instructions:

'mysql' => [
'driver' => 'mysql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB ...

I have the following error when installing and I get to installing the demo data. I have made the amendments to config/database.php. It is Larvel 5.8 on Linux.


SQLSTATE[HY000]: General error: 1005 Can't create table `tdbhosti_demoshop`.`users_address` (errno: 150 "Foreign key constraint is ...