Illuminate\Database\QueryException thrown with message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'logo' in 'field list' (SQL: update `basic_settings` set `footer_text` = We Invest your money property projects and we earn you 40% monthly. Welcome onboard let's join hands together., `copy_text` = Copyright ? Pro Invest SA 2017 - 2020 All Right Reserved., `updated_at` = 2020-08-03 23:55:19, `logo` = /tmp/phpfptGnR where `id` = 1)"Stacktrace:#64 Illuminate\Database\QueryException in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664#63 PDOException in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:479#62 PDO:prepare in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:479#61 Illuminate\Database\Connection:Illuminate\Database\{closure} in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657#60 Illuminate\Database\Connection:runQueryCallback in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624#59 Illuminate\Database\Connection:run in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:490#58 Illuminate\Database\Connection:affectingStatement in /home/proinve2/public_html/core/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423
1 回答
慕斯709654
TA貢獻(xiàn)1840條經(jīng)驗(yàn) 獲得超5個(gè)贊
basic_settings使用命令將新列添加到表中php artisan make:migration add_logo_field_to_basic_settings_table。
創(chuàng)建遷移后，進(jìn)行如下更改。
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class AddLogoFieldToBasicSettingsTable extends Migration
{
public function up()
{
Schema::table('basic_settings', function (Blueprint $table) {
$table->string('logo');
});
}
public function down()
{
Schema::table('basic_settings', function (Blueprint $table) {
$table->dropColumn(['logo']);
});
}
}
現(xiàn)在您可以遷移并創(chuàng)建或更新logo列。
遷移： php artisan migrate
- 1 回答
- 0 關(guān)注
- 138 瀏覽
添加回答
舉報(bào)
0/150
提交
取消