我收到此错误:
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens (SQL: delete from `preferences` where `tenant_id` = 154 and `setting_type` = Category and 1 = 1)
当我使用此功能时:
private function updateSettingsTable($request, $requestType, $settingType)
{
$redundants = Preference::where('tenant_id', session('tenant'))->where('setting_type', $settingType)->delete();
}
并像这样称呼它:
$this->updateSettingsTable($request, 'categories', 'Category');
似乎Laravel在将其发送到查询之前删除了"类别"周围的引号。有什么想法吗?
试试这个:
private function updateSettingsTable($request, $requestType,$settingType)
{
$redundants = Preference::where('tenant_id', session('tenant')) ->where('setting_type', "'".$settingType."'")->delete();
}