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.
Setup MAMP Virtual Hosts For Local PHP Development
Create Gmail App Password For SMTP Mails
Lazy Load YouTube And Other Videos In Website
Why And How To Use PHP PDO With CRUD Examples
What Is Laravel Resourceful Controllers?
PHP extension ext-intl * is missing
Use Different PHP Versions In Ubuntu / Linux
Route Model Binding In Laravel & Change Default Column id To Another Column
Securely SSH Your Server & Push Files With FileZilla
Getting Started With AMP (Accelerated Mobile Pages)
Push Files To CPanel / Remote Server using FTP Software FileZilla
SummerNote WYSIWYG Text Editor
Client-Side DataTable, Adding Super Powers To HTML Table