欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

【Laravel-Eloquent ORM】SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at‘ in ‘field

程序员文章站 2022-07-10 18:21:03
错误信息:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list' (SQL: update `table_name` set `STATE` = 1, `updated_at` = 2020-12-10 18:05:37 where `column_1` = xxx and `STATE` = 0 and `column_2` = xxx )解决方法:对应Model封装类中public...

错误信息:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list' (SQL: update `table_name` set `STATE` = 1, `updated_at` = 2020-12-10 18:05:37 where `column_1` = xxx and `STATE` = 0 and `column_2` = xxx )

解决方法:
对应Model封装类中

	public $timestamps = false;

原因:
By default, Eloquent expects created_at and updated_at columns to exist in your tables. If you do not wish to have these columns to be automatically managed by Eloquent, then you need to set the $timestamps property in your model to false. Your file Building.php should look like:
【Laravel-Eloquent ORM】SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at‘ in ‘field
意思是 默认的情况下Eloquent 预计表中有created_at和updated_at 这两列,会自动对这两列进行管理。问题在于表结构中没有这两个字段,timestamps属性默认为true,就出问题了。

参考:
https://*.com/questions/46700757

本文地址:https://blog.csdn.net/weixin_43967505/article/details/110958595

相关标签: php laravel