# \[SOLVED\] Error: SQLSTATE\[42S22\]: Column not found: 1054

**URL:** <https://discourse.cakephp.org/t/solved-error-sqlstate-42s22-column-not-found-1054/5827>\
**Category:** Need Help\
**Created:** [March 21, 2019, 12:26pm UTC](https://discourse.cakephp.org/t/solved-error-sqlstate-42s22-column-not-found-1054/5827 "2019-03-21T12:26:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jonatas](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/jonatas/32/1351_2.png) [@Jonatas](https://discourse.cakephp.org/u/Jonatas)\
**Post date:** [March 21, 2019, 12:26pm UTC](https://discourse.cakephp.org/t/solved-error-sqlstate-42s22-column-not-found-1054/5827/1 "2019-03-21T12:26:32Z")

</div>

Hi guys!

I create my system in PHP 5.6, but deploy it in PHP 7.0.

I’m getting **Error:** SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘Aluno.id\_auto\_escola’ in ‘where clause’ when I try to get data in my hasOne query.

I’m very mess bacause this error appears in just one use case, in all other times the function works fine.

my call:  
$aluno = TableRegistry::get(‘aluno’)  
-\>getAlunos(  
$idAutoEscola,  
$idAluno,  
‘S’  
)[0];

my **getAlunos** method:  
public function getAlunos($idAutoEscola, $idAluno = null, $isAtivo = null, $nomeCpf = null) {

```
    $aluno = $this->find('all', ['contain' => ['Parcelamento', 'Parcelamento.Parcelas', 'AutoEscola', 'Categori', 'TpProcesso', 'FmPagamento']])
                    ->where(['Aluno.id_auto_escola' => $idAutoEscola]);

    if(!empty($idAluno)) $aluno->where(['Aluno.id_aluno' => $idAluno]);
    if(!empty($isAtivo)) $aluno->where(['Aluno.is_ativo' => $isAtivo]);
    if(!empty($nomeCpf))
        $aluno->where(['OR' => [
                        'nome LIKE' => '%' . $nomeCpf . '%',
                        'cpf' => $nomeCpf
                    ]]);

    $aluno->order(['nome']);

    $aluno = $aluno->toList();

    foreach($aluno as $a) {
        $this->setStatusPagamento($a);
    }

    return $aluno;
}

```

What can I do solve this problem?

Thanks!

---

<div class="post-metadata">

**Author:** ![Jonatas](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/jonatas/32/1351_2.png) [@Jonatas](https://discourse.cakephp.org/u/Jonatas)\
**Post date:** [March 21, 2019, 1:17pm UTC](https://discourse.cakephp.org/t/solved-error-sqlstate-42s22-column-not-found-1054/5827/2 "2019-03-21T13:17:21Z")

</div>

I’ve just find the problem!

Cake was generating the query  
SELECT… FROM FROM aluno aluno  
…  
…  
WHERE (Aluno.id\_auto\_escola = :c0  
AND Aluno.id\_aluno = :c1  
AND Aluno.is\_ativo = :c2)

The problem is that my production database wat setted to work with case sensitive table names. I just setup it to unsensite with ```  
lower\_case\_table\_names = 1

```auto

Reguards
```

---

<div class="post-metadata">

**Author:** ![user\_looser](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/user_looser/32/2161_2.png) [@user\_looser](https://discourse.cakephp.org/u/user_looser)\
**Post date:** [January 25, 2022, 10:57am UTC](https://discourse.cakephp.org/t/solved-error-sqlstate-42s22-column-not-found-1054/5827/3 "2022-01-25T10:57:03Z")

</div>

Hi, I have the same problem. How can I change it on production server when I do not have access to ini file?