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 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
  • ¥15 ETLCloud 处理json多层级问题
  • ¥15 matlab中使用gurobi时报错
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么