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
(
)
)
)