mysql - Laravel 5 Connection.php 中的 QueryException 第 673 行 :

Question

我收到此错误:

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 似乎在将“类别”发送到查询之前删除了“类别”周围的引号。请问有什么想法吗？

Answer 1

试试这个:

private function updateSettingsTable($request, $requestType,$settingType)
{
  $redundants = Preference::where('tenant_id', session('tenant')) ->where('setting_type', "'".$settingType."'")->delete();
 }