Search found 10 matches

by jim1506
04 Sep 2019, 08:57
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

Same reply as the laravel error
by jim1506
03 Sep 2019, 13:48
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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
by jim1506
03 Sep 2019, 12:00
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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 constrai...
by jim1506
03 Sep 2019, 10:03
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

sorry I should have mentioned I changed the structure of user so id was unsigned
by jim1506
03 Sep 2019, 10:02
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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 ...
by jim1506
03 Sep 2019, 09:39
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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 Maria...
by jim1506
03 Sep 2019, 09:02
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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-lar...
by jim1506
03 Sep 2019, 07:44
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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 utf8_u...
by jim1506
03 Sep 2019, 05:12
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Re: Foreign Key on Setup

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_PASSWORD',...
by jim1506
02 Sep 2019, 16:40
Forum: Laravel package
Topic: Foreign Key on Setup
Replies: 17
Views: 8795

Foreign Key on Setup

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 inco...