Array
(
    [in_tipo] => Categoria
    [oneof0id_gruppo] => 1
    [in_sito] => sk
    [homePage] => Homepage
    [in_id_gruppo_articolo] => 940
)

Array
(
    [id_content] => integer
    [tipo] => varchar
    [xml] => clob
    [entity_version] => integer
    [entity_revision] => integer
    [user_create] => integer
    [data_create] => timestamp
    [user_update] => integer
    [data_update] => timestamp
    [user_live] => integer
    [data_live] => timestamp
    [data_visibilita] => timestamp
    [data_scadenza] => timestamp
    [id_parent] => integer
    [lang] => varchar
    [titolo] => varchar
    [path] => varchar
    [stato] => varchar
    [keywords] => varchar
    [description] => varchar
    [live_version] => varchar
    [ordinamento] => integer
    [f_data1] => timestamp
    [f_data2] => timestamp
    [f_varchar32] => varchar
    [f_varchar255] => varchar
    [f_number1] => integer
    [f_number2] => integer
    [sito] => varchar
    [in_home] => boolean
    [title] => varchar
    [categoria_kuba] => varchar
    [visibilita] => integer
    [label] => varchar
    [priorita] => integer
)
SELECT id_content, id_parent, titolo, tipo FROM content WHERE (tipo = :in_tipo) AND (data_visibilita IS NULL OR CURRENT_TIMESTAMP >= data_visibilita) AND (data_scadenza IS NULL OR CURRENT_TIMESTAMP <= data_scadenza) AND ((id_content) IN (SELECT id_content FROM visibilita WHERE (id_gruppo IN (:oneof0id_gruppo)))) AND (sito = :in_sito) AND (titolo <> :homePage) AND ((id_content) IN (SELECT id_content FROM gruppo_articoli_categoria_articolo WHERE (id_gruppo_articolo = :in_id_gruppo_articolo))) ORDER BY CASE WHEN id_parent IS NULL THEN 'zzzz'||titolo ELSE titolo END ASC Errore

Errore

 

SQLSTATE[42703]: Undefined column: 7 ERROR: column "id_gruppo_articolo" does not exist at character 417

#0 /home/httpd/volkswagen/lib/framework/dataaccess/DbAdapterPDO.php(272): PDOStatement->execute()
#1 /home/httpd/volkswagen/lib/framework/dataaccess/DbAdapterPDO.php(293): DbAdapterPDO->executeSQL(Array, Array)
#2 /home/httpd/volkswagen/lib/framework/dataaccess/DbAdapterPDO.php(751): DbAdapterPDO->execSQL('SELECT id_conte...', Array, Array)
#3 /home/httpd/volkswagen/lib/framework/Factory.php(261): DbAdapterPDO->select(Object(ContentSearch), Array)
#4 /home/httpd/volkswagen/lib/framework/Factory.php(317): Factory->searchRecord(Object(ContentSearch), Array)
#5 /home/httpd/volkswagen/var/mvc/website/controllers/CustomController.php(218): Factory->getRecordList(Object(ContentSearch), Array)
#6 /home/httpd/volkswagen/lib/Zend/Controller/Action.php(497): Website_CustomController->indexAction()
#7 /home/httpd/volkswagen/lib/Zend/Controller/Dispatcher/Standard.php(237): Zend_Controller_Action->dispatch('indexAction')
#8 /home/httpd/volkswagen/lib/Zend/Controller/Front.php(911): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#9 /home/httpd/skoda/www/index.php(73): Zend_Controller_Front->dispatch()
#10 {main}