SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 6: AND cod_filiale = '' ^
Array
(
    [0] => Array
        (
            [file] => /opt/versions/ZendFramework-1.11.11-minimal/library/Zend/Db/Statement.php
            [line] => 300
            [function] => _execute
            [class] => Zend_Db_Statement_Pdo
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                        )

                )

        )

    [1] => Array
        (
            [file] => /opt/versions/ZendFramework-1.11.11-minimal/library/Zend/Db/Adapter/Abstract.php
            [line] => 479
            [function] => execute
            [class] => Zend_Db_Statement
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                        )

                )

        )

    [2] => Array
        (
            [file] => /opt/versions/ZendFramework-1.11.11-minimal/library/Zend/Db/Adapter/Pdo/Abstract.php
            [line] => 238
            [function] => query
            [class] => Zend_Db_Adapter_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => SELECT (EXTRACT(YEAR FROM data)) as anno,
                       id,
                       nome
                  FROM unimpiego.archivio_vetrine
                 WHERE stato_id IN (1,3)
                   AND cod_filiale = ''
              ORDER BY data DESC,nome ASC;
                    [1] => Array
                        (
                        )

                )

        )

    [3] => Array
        (
            [file] => /opt/versions/ZendFramework-1.11.11-minimal/library/Zend/Db/Adapter/Abstract.php
            [line] => 736
            [function] => query
            [class] => Zend_Db_Adapter_Pdo_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => SELECT (EXTRACT(YEAR FROM data)) as anno,
                       id,
                       nome
                  FROM unimpiego.archivio_vetrine
                 WHERE stato_id IN (1,3)
                   AND cod_filiale = ''
              ORDER BY data DESC,nome ASC;
                    [1] => Array
                        (
                        )

                )

        )

    [4] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/library/PagePart/Vetrina.php
            [line] => 45
            [function] => fetchAll
            [class] => Zend_Db_Adapter_Abstract
            [type] => ->
            [args] => Array
                (
                    [0] => SELECT (EXTRACT(YEAR FROM data)) as anno,
                       id,
                       nome
                  FROM unimpiego.archivio_vetrine
                 WHERE stato_id IN (1,3)
                   AND cod_filiale = ''
              ORDER BY data DESC,nome ASC;
                )

        )

    [5] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/library/PageComposer/PageComposer.php
            [line] => 137
            [function] => requestProcessing
            [class] => Vetrina
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [f] => ReggioEmilia
                        )

                )

        )

    [6] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/library/PageComposer/PageComposer.php
            [line] => 80
            [function] => runPageParts
            [class] => PageComposer
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [0] => Vetrina Object
                                (
                                    [db] => Zend_Db_Adapter_Pdo_Pgsql Object
                                        (
                                            [_pdoType:protected] => pgsql
                                            [_numericDataTypes:protected] => Array
                                                (
                                                    [0] => 0
                                                    [1] => 1
                                                    [2] => 2
                                                    [INTEGER] => 0
                                                    [SERIAL] => 0
                                                    [SMALLINT] => 0
                                                    [BIGINT] => 1
                                                    [BIGSERIAL] => 1
                                                    [DECIMAL] => 2
                                                    [DOUBLE PRECISION] => 2
                                                    [NUMERIC] => 2
                                                    [REAL] => 2
                                                )

                                            [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                            [_config:protected] => Array
                                                (
                                                    [host] => db.unimpiego.it
                                                    [port] => 5433
                                                    [dbname] => unimpiegodb2
                                                    [username] => nr_admin
                                                    [password] => 
                                                    [charset] => 
                                                    [persistent] => 
                                                    [options] => Array
                                                        (
                                                            [caseFolding] => 0
                                                            [autoQuoteIdentifiers] => 1
                                                            [fetchMode] => 2
                                                        )

                                                    [driver_options] => Array
                                                        (
                                                        )

                                                )

                                            [_fetchMode:protected] => 2
                                            [_profiler:protected] => Zend_Db_Profiler Object
                                                (
                                                    [_queryProfiles:protected] => Array
                                                        (
                                                        )

                                                    [_enabled:protected] => 
                                                    [_filterElapsedSecs:protected] => 
                                                    [_filterTypes:protected] => 
                                                )

                                            [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                            [_connection:protected] => PDO Object
                                                (
                                                )

                                            [_caseFolding:protected] => 0
                                            [_autoQuoteIdentifiers:protected] => 1
                                            [_allowSerialization:protected] => 1
                                            [_autoReconnectOnUnserialize:protected] => 
                                        )

                                    [pricing] => 
                                    [name] => home
                                    [pageReg:protected] => PageRegistry Object
                                        (
                                            [inPageScope] => Array
                                                (
                                                    [currentPageName] => vetrina
                                                )

                                            [ZSession] => Zend_Session_Namespace Object
                                                (
                                                    [_namespace:protected] => ZScope
                                                )

                                        )

                                    [redirectioURL:protected] => 
                                    [config:protected] => Zend_Config_Xml Object
                                        (
                                            [_skipExtends:protected] => 
                                            [_allowModifications:protected] => 
                                            [_index:protected] => 0
                                            [_count:protected] => 2
                                            [_data:protected] => Array
                                                (
                                                    [arguments] =>           
        
                                                    [templates] => Zend_Config Object
                                                        (
                                                            [_allowModifications:protected] => 
                                                            [_index:protected] => 0
                                                            [_count:protected] => 1
                                                            [_data:protected] => Array
                                                                (
                                                                    [data] => Zend_Config Object
                                                                        (
                                                                            [_allowModifications:protected] => 
                                                                            [_index:protected] => 0
                                                                            [_count:protected] => 2
                                                                            [_data:protected] => Array
                                                                                (
                                                                                    [loc] => it
                                                                                    [path] => it/pagepart/vetrina.tpl.htm
                                                                                )

                                                                            [_skipNextIteration:protected] => 
                                                                            [_loadedSection:protected] => 
                                                                            [_extends:protected] => Array
                                                                                (
                                                                                )

                                                                            [_loadFileErrorStr:protected] => 
                                                                        )

                                                                )

                                                            [_skipNextIteration:protected] => 
                                                            [_loadedSection:protected] => 
                                                            [_extends:protected] => Array
                                                                (
                                                                )

                                                            [_loadFileErrorStr:protected] => 
                                                        )

                                                )

                                            [_skipNextIteration:protected] => 
                                            [_loadedSection:protected] => private
                                            [_extends:protected] => Array
                                                (
                                                )

                                            [_loadFileErrorStr:protected] => 
                                        )

                                    [templateName:protected] => 
                                    [renderValues:protected] => Array
                                        (
                                            [filiale] => ReggioEmilia
                                            [reg_old] => 
                                        )

                                    [args:protected] => Array
                                        (
                                        )

                                )

                            [1] => Banner Object
                                (
                                    [db] => Zend_Db_Adapter_Pdo_Pgsql Object
                                        (
                                            [_pdoType:protected] => pgsql
                                            [_numericDataTypes:protected] => Array
                                                (
                                                    [0] => 0
                                                    [1] => 1
                                                    [2] => 2
                                                    [INTEGER] => 0
                                                    [SERIAL] => 0
                                                    [SMALLINT] => 0
                                                    [BIGINT] => 1
                                                    [BIGSERIAL] => 1
                                                    [DECIMAL] => 2
                                                    [DOUBLE PRECISION] => 2
                                                    [NUMERIC] => 2
                                                    [REAL] => 2
                                                )

                                            [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                            [_config:protected] => Array
                                                (
                                                    [host] => db.unimpiego.it
                                                    [port] => 5433
                                                    [dbname] => unimpiegodb2
                                                    [username] => nr_admin
                                                    [password] => 
                                                    [charset] => 
                                                    [persistent] => 
                                                    [options] => Array
                                                        (
                                                            [caseFolding] => 0
                                                            [autoQuoteIdentifiers] => 1
                                                            [fetchMode] => 2
                                                        )

                                                    [driver_options] => Array
                                                        (
                                                        )

                                                )

                                            [_fetchMode:protected] => 2
                                            [_profiler:protected] => Zend_Db_Profiler Object
                                                (
                                                    [_queryProfiles:protected] => Array
                                                        (
                                                        )

                                                    [_enabled:protected] => 
                                                    [_filterElapsedSecs:protected] => 
                                                    [_filterTypes:protected] => 
                                                )

                                            [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                            [_connection:protected] => PDO Object
                                                (
                                                )

                                            [_caseFolding:protected] => 0
                                            [_autoQuoteIdentifiers:protected] => 1
                                            [_allowSerialization:protected] => 1
                                            [_autoReconnectOnUnserialize:protected] => 
                                        )

                                    [pricing] => 
                                    [name] => banner
                                    [pageReg:protected] => PageRegistry Object
                                        (
                                            [inPageScope] => Array
                                                (
                                                    [currentPageName] => vetrina
                                                )

                                            [ZSession] => Zend_Session_Namespace Object
                                                (
                                                    [_namespace:protected] => ZScope
                                                )

                                        )

                                    [redirectioURL:protected] => 
                                    [config:protected] => Zend_Config_Xml Object
                                        (
                                            [_skipExtends:protected] => 
                                            [_allowModifications:protected] => 
                                            [_index:protected] => 0
                                            [_count:protected] => 2
                                            [_data:protected] => Array
                                                (
                                                    [arguments] =>           
        
                                                    [templates] => Zend_Config Object
                                                        (
                                                            [_allowModifications:protected] => 
                                                            [_index:protected] => 0
                                                            [_count:protected] => 1
                                                            [_data:protected] => Array
                                                                (
                                                                    [data] => Zend_Config Object
                                                                        (
                                                                            [_allowModifications:protected] => 
                                                                            [_index:protected] => 0
                                                                            [_count:protected] => 2
                                                                            [_data:protected] => Array
                                                                                (
                                                                                    [loc] => it
                                                                                    [path] => it/pagepart/banner.tpl.htm
                                                                                )

                                                                            [_skipNextIteration:protected] => 
                                                                            [_loadedSection:protected] => 
                                                                            [_extends:protected] => Array
                                                                                (
                                                                                )

                                                                            [_loadFileErrorStr:protected] => 
                                                                        )

                                                                )

                                                            [_skipNextIteration:protected] => 
                                                            [_loadedSection:protected] => 
                                                            [_extends:protected] => Array
                                                                (
                                                                )

                                                            [_loadFileErrorStr:protected] => 
                                                        )

                                                )

                                            [_skipNextIteration:protected] => 
                                            [_loadedSection:protected] => private
                                            [_extends:protected] => Array
                                                (
                                                )

                                            [_loadFileErrorStr:protected] => 
                                        )

                                    [templateName:protected] => 
                                    [renderValues:protected] => Array
                                        (
                                        )

                                    [args:protected] => Array
                                        (
                                        )

                                )

                            [2] => Login Object
                                (
                                    [db] => Zend_Db_Adapter_Pdo_Pgsql Object
                                        (
                                            [_pdoType:protected] => pgsql
                                            [_numericDataTypes:protected] => Array
                                                (
                                                    [0] => 0
                                                    [1] => 1
                                                    [2] => 2
                                                    [INTEGER] => 0
                                                    [SERIAL] => 0
                                                    [SMALLINT] => 0
                                                    [BIGINT] => 1
                                                    [BIGSERIAL] => 1
                                                    [DECIMAL] => 2
                                                    [DOUBLE PRECISION] => 2
                                                    [NUMERIC] => 2
                                                    [REAL] => 2
                                                )

                                            [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                            [_config:protected] => Array
                                                (
                                                    [host] => db.unimpiego.it
                                                    [port] => 5433
                                                    [dbname] => unimpiegodb2
                                                    [username] => nr_admin
                                                    [password] => 
                                                    [charset] => 
                                                    [persistent] => 
                                                    [options] => Array
                                                        (
                                                            [caseFolding] => 0
                                                            [autoQuoteIdentifiers] => 1
                                                            [fetchMode] => 2
                                                        )

                                                    [driver_options] => Array
                                                        (
                                                        )

                                                )

                                            [_fetchMode:protected] => 2
                                            [_profiler:protected] => Zend_Db_Profiler Object
                                                (
                                                    [_queryProfiles:protected] => Array
                                                        (
                                                        )

                                                    [_enabled:protected] => 
                                                    [_filterElapsedSecs:protected] => 
                                                    [_filterTypes:protected] => 
                                                )

                                            [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                            [_connection:protected] => PDO Object
                                                (
                                                )

                                            [_caseFolding:protected] => 0
                                            [_autoQuoteIdentifiers:protected] => 1
                                            [_allowSerialization:protected] => 1
                                            [_autoReconnectOnUnserialize:protected] => 
                                        )

                                    [pricing] => 
                                    [name] => login
                                    [pageReg:protected] => PageRegistry Object
                                        (
                                            [inPageScope] => Array
                                                (
                                                    [currentPageName] => vetrina
                                                )

                                            [ZSession] => Zend_Session_Namespace Object
                                                (
                                                    [_namespace:protected] => ZScope
                                                )

                                        )

                                    [redirectioURL:protected] => 
                                    [config:protected] => Zend_Config_Xml Object
                                        (
                                            [_skipExtends:protected] => 
                                            [_allowModifications:protected] => 
                                            [_index:protected] => 0
                                            [_count:protected] => 2
                                            [_data:protected] => Array
                                                (
                                                    [arguments] =>           
        
                                                    [templates] => Zend_Config Object
                                                        (
                                                            [_allowModifications:protected] => 
                                                            [_index:protected] => 0
                                                            [_count:protected] => 1
                                                            [_data:protected] => Array
                                                                (
                                                                    [data] => Zend_Config Object
                                                                        (
                                                                            [_allowModifications:protected] => 
                                                                            [_index:protected] => 0
                                                                            [_count:protected] => 2
                                                                            [_data:protected] => Array
                                                                                (
                                                                                    [loc] => it
                                                                                    [path] => it/pagepart/login.tpl.htm
                                                                                )

                                                                            [_skipNextIteration:protected] => 
                                                                            [_loadedSection:protected] => 
                                                                            [_extends:protected] => Array
                                                                                (
                                                                                )

                                                                            [_loadFileErrorStr:protected] => 
                                                                        )

                                                                )

                                                            [_skipNextIteration:protected] => 
                                                            [_loadedSection:protected] => 
                                                            [_extends:protected] => Array
                                                                (
                                                                )

                                                            [_loadFileErrorStr:protected] => 
                                                        )

                                                )

                                            [_skipNextIteration:protected] => 
                                            [_loadedSection:protected] => private
                                            [_extends:protected] => Array
                                                (
                                                )

                                            [_loadFileErrorStr:protected] => 
                                        )

                                    [templateName:protected] => 
                                    [renderValues:protected] => Array
                                        (
                                        )

                                    [args:protected] => Array
                                        (
                                        )

                                )

                            [3] => Meta Object
                                (
                                    [db] => Zend_Db_Adapter_Pdo_Pgsql Object
                                        (
                                            [_pdoType:protected] => pgsql
                                            [_numericDataTypes:protected] => Array
                                                (
                                                    [0] => 0
                                                    [1] => 1
                                                    [2] => 2
                                                    [INTEGER] => 0
                                                    [SERIAL] => 0
                                                    [SMALLINT] => 0
                                                    [BIGINT] => 1
                                                    [BIGSERIAL] => 1
                                                    [DECIMAL] => 2
                                                    [DOUBLE PRECISION] => 2
                                                    [NUMERIC] => 2
                                                    [REAL] => 2
                                                )

                                            [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                                            [_config:protected] => Array
                                                (
                                                    [host] => db.unimpiego.it
                                                    [port] => 5433
                                                    [dbname] => unimpiegodb2
                                                    [username] => nr_admin
                                                    [password] => 
                                                    [charset] => 
                                                    [persistent] => 
                                                    [options] => Array
                                                        (
                                                            [caseFolding] => 0
                                                            [autoQuoteIdentifiers] => 1
                                                            [fetchMode] => 2
                                                        )

                                                    [driver_options] => Array
                                                        (
                                                        )

                                                )

                                            [_fetchMode:protected] => 2
                                            [_profiler:protected] => Zend_Db_Profiler Object
                                                (
                                                    [_queryProfiles:protected] => Array
                                                        (
                                                        )

                                                    [_enabled:protected] => 
                                                    [_filterElapsedSecs:protected] => 
                                                    [_filterTypes:protected] => 
                                                )

                                            [_defaultProfilerClass:protected] => Zend_Db_Profiler
                                            [_connection:protected] => PDO Object
                                                (
                                                )

                                            [_caseFolding:protected] => 0
                                            [_autoQuoteIdentifiers:protected] => 1
                                            [_allowSerialization:protected] => 1
                                            [_autoReconnectOnUnserialize:protected] => 
                                        )

                                    [pricing] => 
                                    [name] => meta
                                    [pageReg:protected] => PageRegistry Object
                                        (
                                            [inPageScope] => Array
                                                (
                                                    [currentPageName] => vetrina
                                                )

                                            [ZSession] => Zend_Session_Namespace Object
                                                (
                                                    [_namespace:protected] => ZScope
                                                )

                                        )

                                    [redirectioURL:protected] => 
                                    [config:protected] => Zend_Config_Xml Object
                                        (
                                            [_skipExtends:protected] => 
                                            [_allowModifications:protected] => 
                                            [_index:protected] => 0
                                            [_count:protected] => 2
                                            [_data:protected] => Array
                                                (
                                                    [arguments] =>           
        
                                                    [templates] => Zend_Config Object
                                                        (
                                                            [_allowModifications:protected] => 
                                                            [_index:protected] => 0
                                                            [_count:protected] => 1
                                                            [_data:protected] => Array
                                                                (
                                                                    [data] => Zend_Config Object
                                                                        (
                                                                            [_allowModifications:protected] => 
                                                                            [_index:protected] => 0
                                                                            [_count:protected] => 2
                                                                            [_data:protected] => Array
                                                                                (
                                                                                    [loc] => it
                                                                                    [path] => it/pagepart/meta.tpl.htm
                                                                                )

                                                                            [_skipNextIteration:protected] => 
                                                                            [_loadedSection:protected] => 
                                                                            [_extends:protected] => Array
                                                                                (
                                                                                )

                                                                            [_loadFileErrorStr:protected] => 
                                                                        )

                                                                )

                                                            [_skipNextIteration:protected] => 
                                                            [_loadedSection:protected] => 
                                                            [_extends:protected] => Array
                                                                (
                                                                )

                                                            [_loadFileErrorStr:protected] => 
                                                        )

                                                )

                                            [_skipNextIteration:protected] => 
                                            [_loadedSection:protected] => private
                                            [_extends:protected] => Array
                                                (
                                                )

                                            [_loadFileErrorStr:protected] => 
                                        )

                                    [templateName:protected] => 
                                    [renderValues:protected] => Array
                                        (
                                        )

                                    [args:protected] => Array
                                        (
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [f] => ReggioEmilia
                        )

                )

        )

    [7] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/WebRenderEngine.php
            [line] => 174
            [function] => renderPage
            [class] => PageComposer
            [type] => ->
            [args] => Array
                (
                    [0] => 
                    [1] => Array
                        (
                            [f] => ReggioEmilia
                        )

                )

        )

    [8] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/WebRenderEngine.php
            [line] => 52
            [function] => processRequest
            [class] => WebRenderEngine
            [type] => ->
            [args] => Array
                (
                )

        )

    [9] => Array
        (
            [file] => /var/www/unimpiego/pubblico/wre/WebRenderEngine.php
            [line] => 107
            [function] => __construct
            [class] => WebRenderEngine
            [type] => ->
            [args] => Array
                (
                    [0] => main.xml
                )

        )

    [10] => Array
        (
            [file] => /var/www/unimpiego/pubblico/portale/index.php
            [line] => 142
            [function] => bootstrap
            [class] => WebRenderEngine
            [type] => ::
            [args] => Array
                (
                )

        )

)