Search found 10 matches
- 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
- 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
users:
id` int(10) unsigned NOT NULL AUTO_INCREMENT,
users_address
`parentid` int(10) unsigned NOT NULL,
The only difference is auto increment
- 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...
- 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
- 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 ...
- 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...
- 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...
- 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...
- 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',...
- 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...