Tagged: database migration

在 Laravel 9 中执行数据库迁移,修改字段名称,再修改其属性,报错:There is no column with name inbounded_quantity on table return_order_items 0

Perform 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.

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...

在执行数据库迁移时,报错:SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'theme_installation_version_preset_theme_store_theme_version_id_index' is too long 0

In database migration in Laravel 6, SQLState[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long

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...

在 Laravel 6 的数据库迁移中,添加外键约束时,Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint 0

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

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...