doutangguan2460 2016-06-19 00:37
浏览 141
已采纳

laravel QueryException / SQLSTATE [42S02]

I'm new to Laravel and have an error.
When I try to check my page, I get this error:

QueryException in Connection.php line 713: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_tcc.colaboradors' doesn't exist (SQL: select * from colaboradors order by id_colaborador asc)

My table name is 'colaboradores', I know the error is 'colaboradors', but I dont know where is that 'colaboradors' in my project files.
I need to find in the code to fix, but I dont have idea what file take care of sql in laravel.

My model for colaboradores:

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Colaborador extends Model {
    protected $fillable = array('id_colaborador','nome','rg','orgao_expedidor','cpf','estado_civil','sexo','nome_pai','nome_mae','natura‌​lidade','data_nascimento','login','senha','siape','pis','rua','numero','bairro',‌​'cidade','estado','cep','telefone_fixo','telefone_celular','telefone_comercial','email');
}

My controller : http://pastebin.com/QYgRBRrc

  • 写回答

1条回答 默认 最新

  • dqy0707 2016-06-19 01:23
    关注

    The "snake case", plural name of the class will be used as the table name unless another name is explicitly specified.

    So this is your issue.

    You have two options:

    • Either rename your model class or
    • Add in your model $table = 'colaboradores';
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂
  • ¥15 wordpress 产品图片 GIF 没法显示
  • ¥15 求三国群英传pl国战时间的修改方法
  • ¥15 matlab代码代写,需写出详细代码,代价私
  • ¥15 ROS系统搭建请教(跨境电商用途)
  • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。