I have tried lot's of times and debugged but till now i can't find out where is the problem? Any kinds of help appreciated.
Error:
Connection.php第662行中的QueryException:SQLSTATE [42S22]:未找到列:1054'字段列表'中的未知列'adjusted_amount'(SQL:update tbl_bill_collection set dueamount = 0,adjusted_amount = 100,adjusted_by = 5302,adjusted_date = 2016 -12-20 21:19:31其中billno = 7777)
In My Controller Code:
DB :: table('bill_collection')
-
where('billno',555)
-
更新([
'dueamount'=> $ request-> input('dueamount'),
'adjusted_amount'=> $ request-> input('adjustment'),
'adjusted_by'=> Auth :: User() - > id,
'adjusted_date'=> date('Y-m-d H:i:s'),
]);
My database table column images given below:
1 回答
最有可能出现隐形字符的问题,如:"Unknown column in 'field list'", but column does exist
手动重新键入查询,看看是否有帮助 .