A PHP Error was encountered

Severity: Warning

Message: pg_query(): Query failed: ERROR: error de sintaxis en o cerca de «;» LINE 9: AND c.idcategoria = ; ^

Filename: postgre/postgre_driver.php

Line Number: 234

Backtrace:

File: /var/www/distron.com.py/application/models/Categoria_model.php
Line: 21
Function: query

File: /var/www/distron.com.py/application/controllers/Categoria.php
Line: 43
Function: total_rows

File: /var/www/distron.com.py/application/controllers/Categoria.php
Line: 30
Function: paginacion

File: /var/www/distron.com.py/index.php
Line: 315
Function: require_once

Database Error

A Database Error Occurred

Error Number:

ERROR: error de sintaxis en o cerca de «;» LINE 9: AND c.idcategoria = ; ^

SELECT count(*) as cant FROM stock_producto p left JOIN stock_marca m ON m.idmarca = p.idmarca left JOIN stock_categoria c ON c.idcategoria = p.idcategoria left join stock_categoria c2 on c2.idcategoria = c.idcategoria_padre WHERE p.activo = TRUE AND c.activo = TRUE AND m.activo = TRUE AND c.idcategoria = ;

Filename: models/Categoria_model.php

Line Number: 21