php - Sql 连接查询错误。有人请帮助我

Question

这是我在 Laravel Blade 中的模型函数。在此我有两个表“admins”和“candidates”使用连接查询连接这两个表。但是在运行我的代码时我可能会得到下面提到的这个错误。

if ( Input::has('recordcreator') and $request->input('recordcreator') != NULL){
            $querys->join('admins','admins.adminid','=','candidates.createdby');
            $querys->where('admins.firstname', 'LIKE', '%'. $request->input('recordcreator') .'%')->orWhere('admins.lastname', 'LIKE', '%'. $request->input('recordcreator') .'%')->where('admins.status','1'); 
        } 

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'firstname' in order clause is ambiguous (SQL: select * from rsi_candidates inner join rsi_admins on rsi_admins.adminid = rsi_candidates.createdby where rsi_admins.lastname LIKE %ic% and rsi_admins.status = 1 or rsi_admins.firstname LIKE %ic% group by rsi_candidates.candidateid order by firstname asc limit 20 offset 0)

Answer 1

As i see your laravel error you may add the table name in front of your firstname column in orderby clause

或者您也可以尝试这个解决方案

open your database.php file located in config directory
Config->database.php  in your mysql database array add this.

'严格' => 假，