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.
Automate Repeating Tasks In Linux Server With Cronjobs
Integrate Google Translate Into Your Website
Push Files To CPanel / Remote Server using FTP Software FileZilla
Test Your Local Developing Laravel Web Application From Phone Browser Without Any Software
Custom Validation Rules In PHP Laravel (Using Artisan Command)
Sass or SCSS @function vs @mixin
SummerNote WYSIWYG Text Editor Save Images To Public Path In PHP Laravel
Free Live Chat Integration Using TAWK.IO
What Is Composer? How Does It Work? Useful Composer Commands And Usage
Stripe Payment Integration With Laravel
Increase Session Timeout In Laravel
Upload File From Frontend Server {GuzzleHttp} To REST API Server In PHP {Laravel}