Comments (7)
I have fixed this issue by using increment('id') instead of id() in 2014_10_12_000000_create_users_table.php file
& I use $table->unsignedInteger('user_id'); instead of $table->integer('user_id')->unsigned();
in 2016_07_29_171118_create_chatter_discussion_table.php file
from chatter.
same here
from chatter.
That did work however, now this error responds after changing the unsignedBigIntegers.
General error: 1005 Can't create table dashhound
.chatter_discussion
(errno: 121 "Duplicate key on write or update") (SQL: alter table chatter_discussion
add constraint chatter_discussion_chatter_category_id_foreign
foreign key (chatter_category_id
) references chatter_categories
(id
) on delete cascade)
from chatter.
That did work however, now this error responds after changing the unsignedBigIntegers.
General error: 1005 Can't create table
dashhound
.chatter_discussion
(errno: 121 "Duplicate key on write or update") (SQL: alter tablechatter_discussion
add constraintchatter_discussion_chatter_category_id_foreign
foreign key (chatter_category_id
) referenceschatter_categories
(id
) on delete cascade)
first you need to fresh database next use migrate
from chatter.
That did work however, now this error responds after changing the unsignedBigIntegers.
General error: 1005 Can't create tabledashhound
.chatter_discussion
(errno: 121 "Duplicate key on write or update") (SQL: alter tablechatter_discussion
add constraintchatter_discussion_chatter_category_id_foreign
foreign key (chatter_category_id
) referenceschatter_categories
(id
) on delete cascade)first you need to fresh database next use migrate
I did manage to get it working eveentually, apologies for not updating the issue. I've since created my own due to it being a university project and looks good having my own.
from chatter.
Migrating: 2016_07_29_171118_create_chatter_post_table
Migrated: 2016_07_29_171118_create_chatter_post_table (0.02 seconds)
Migrating: 2016_07_29_171128_create_foreign_keys
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1005 Can't create table forum
.chatter_discussion
(errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table chatter_discussion
add constraint chatter_discussion_user_id_foreign
foreign key (user_id
) references users
(id
) on delete cascade on update cascade)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667| // If an exception occurs when attempting to run a query, we'll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database's errors.
670| catch (Exception $e) {
671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|
+12 vendor frames
13 database/migrations/2016_07_29_171128_create_foreign_keys.php:17
Illuminate\Support\Facades\Facade::__callStatic()
+21 vendor frames
35 artisan:37
Illuminate\Foundation\Console\Kernel::handle()
from chatter.
help please ;(
from chatter.
Related Issues (20)
- Chatter Forums Error
- Avatar image
- Chatter not getting maintenance? HOT 5
- The {!! $categoriesMenu !!} doesn't follow the order
- A very weird bug I found !!
- Not working on Laravel 5.8, buttons, reply, edit HOT 4
- General error: 1005 Can't create table `frmfire`.`chatter_discussion`
- How to Solve - General error: 1005 Can't create table `frmfire`.`chatter_discussion` HOT 2
- $slug = str_slug($request->title, '-'); HOT 1
- Can't create table - Foreign key constraint is incorrectly formed HOT 1
- Bad method call exception HOT 1
- Can't upload image in TINYMCE HOT 1
- Unable to locate publishable resources HOT 1
- Need to modify 'chatter.discussion.store' route to check for permission
- Url Error
- Is this project dead? HOT 8
- Laravel 8 and Chatter HOT 5
- please help me to solve this problem when updating laravel
- Not working with laravel 8 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from chatter.