Post Views: 16 1. Execute database migration in Laravel 9, modify the field name, and then modify its properties, and report an error: There is no column with name inbounded_quantity on table return_order_items. As...
Post Views: 15 1. In Laravel 6, update field properties 2. Error when executing the migration, Doctrine\dbal\exception : unknown column type “tinyInteger” requested. as shown in Figure 1 3. Since the data of this...
Laravel 6 / Laravel Database Migrations / Web Application Development / Database / Web Framework / MySQL / Laravel / MySQL 5.7
Post Views: 18 1. When performing database migration, an error is reported: sqlstate[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long. as shown in Figure 1 The index length limit of MySQL...
Post Views: 16 1. In Laravel 6’s database migration, when adding a foreign key constraint, Illuminate\Database\QueryException : SQLState[HY000]: General error: 1215 Cannot add foreign key constraint. as shown in Figure 1 2. The code...
Post Views: 18 1. Now the field Theme_Asset of the table Theme_Asset is of type VARCHAR(255). The previous migration code is as follows. as shown in Figure 1 2. Now plan to add a...
Post Views: 18 1. In Laravle 6’s database migration, the data table option does not support adding comments. as shown in Figure 1 2. Reference:https://stackoverflow.com/questions/37493431/how-to-add-comment-to-table-not-column-in-laravel-5-migration. How to add comment to table (not column) in...
Laravel 6 / Laravel Modules / Web Application Development / Web Framework / Laravel / Artisan Command
Post Views: 17 1. In the Git library, it is found that the database migration file has some changes, such as: the field MINE_TYPE is changed to MIME_TYPE. as shown in Figure 1 2....
PHP / SQL / Yii / Yii 2 / Yii2 Database Migration / Web Application Development / Programming Language / Web Framework
Post Views: 13 1. In Yii 2.0, create a primary key column based on database migration. $this->primaryKey() is used by default. The created primary key column is int(11) by default. as shown in Figure...
Rancher / Yii 2 / Rancher 2.3 / Yii2 Database Migration / Web Application Development / Server / Programming Language / Web Framework / Cloud Server / SQL / Yii
Post Views: 14 1. When the container is upgraded for the first time in Rancher, the database migration will be repeated, and then the error will be reported to the upgrade failure. as shown...
Web Application Development / Yii2 Database Migration / Database / Programming Language / Web Framework / MySQL / PHP / SQL / Yii / MySQL 5.7 / PHP 7.4 / Yii 2
Post Views: 10 1. Table name: CPA_CHANNEL_APP_SOURCE design, table prefix: CPA_, as shown in Figure 1 2. View command: yii migrate/create help documentation 3. Add field. If the migrated name follows the format of...
关注:
更多
![在执行数据库迁移时，报错：SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'theme_installation_version_preset_theme_store_theme_version_id_index' is too long](https://www.shuijingwanwq.com/wp-content/uploads/2022/06/1-3-720x340.png)
![在 Laravel 6 的数据库迁移中，添加外键约束时，Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint](https://www.shuijingwanwq.com/wp-content/uploads/2022/06/1-2-720x340.png)
Recent Comments