
Good content takes time and effort to come up with.
Please consider supporting us by just disabling your AD BLOCKER and reloading this page again.
Many times when you are working on SQLite database with Laravel you might have come across a wired error that SQLite doesn't support dropping foreign keys.
The reason is SQLite database has no concept called foreign keys. Let's fix this issue in Laravel.
To fix the DBAL issues make sure to install the following package.
composer require doctrine/dbal
Example 1
public function down()
{
Schema::table('comments', function (Blueprint $table) {
$table->dropForeign(['parent_id']);
$table->dropColumn(['parent_id']);
});
}
Example 1
public function down()
{
Schema::table('comments', function (Blueprint $table) {
/** Make sure to put this condition to check if driver is SQLite */
if (DB::getDriverName() !== 'sqlite') {
$table->dropForeign(['parent_id']);
}
$table->dropColumn(['parent_id']);
});
}
You can put this condition for multiple columns too.
Example 2
public function down()
{
Schema::table('payments', function (Blueprint $table) {
if (DB::getDriverName() !== 'sqlite') {
$table->dropForeign(['coupon_id']);
$table->dropForeign(['currency_id']);
}
$table->dropColumn(['status', 'currency_id', 'coupon_id', 'notes', 'invoice_number']);
});
}
I hope this might have solved your issues. Happy coding.
Google reCAPTCHA Integration In PHP Laravel Forms
Route Model Binding In Laravel & Change Default Column id To Another Column
Free Live Chat Integration Using TAWK.IO
Make Laravel Controllers Slim By Skimming Form Validation Request
Unable to prepare route [{fallbackPlaceholder}] for serialization. Uses Closure In Laravel
Cache Static Files With NGINX Server
Add Analytics To AMP (Accelerated Mobile Pages) HTML Pages
GitHub Login With PHP Laravel Socialite
Run Raw Queries Securely In Laravel
Test Your Local Developing Laravel Web Application From Phone Browser Without Any Software
What Is HTTP? Different HTTP Methods And Status Codes Explained With Examples
Send Email In PHP With PHPMailer
Custom Validation Rules In PHP Laravel (Using Artisan Command)