SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "D"
LINE 6: AND n.categoria = 10%5D AND cn.macro = 2
^
Array
(
[0] => Array
(
[file] => /usr/share/php/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /usr/share/php/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT distinct cn.*
FROM sito.categoria_news as cn
JOIN sito.news as n ON (n.categoria = cn.id)
WHERE n.data_pubblicazione <= current_date
AND cn.macro = 2
AND n.categoria = 10%5D AND cn.macro = 2
ORDER BY nome_categoria
[1] => Array
(
)
)
)
[3] => Array
(
[file] => /usr/share/php/Zend/Db/Adapter/Abstract.php
[line] => 736
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT distinct cn.*
FROM sito.categoria_news as cn
JOIN sito.news as n ON (n.categoria = cn.id)
WHERE n.data_pubblicazione <= current_date
AND cn.macro = 2
AND n.categoria = 10%5D AND cn.macro = 2
ORDER BY nome_categoria
[1] => Array
(
)
)
)
[4] => Array
(
[file] => /var/www/cdaf.it/wre/library/PagePart/News.php
[line] => 70
[function] => fetchAll
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT distinct cn.*
FROM sito.categoria_news as cn
JOIN sito.news as n ON (n.categoria = cn.id)
WHERE n.data_pubblicazione <= current_date
AND cn.macro = 2
AND n.categoria = 10%5D AND cn.macro = 2
ORDER BY nome_categoria
)
)
[5] => Array
(
[file] => /var/www/cdaf.it/wre/library/PageComposer/PageComposer.php
[line] => 139
[function] => requestProcessing
[class] => News
[type] => ->
[args] => Array
(
[0] => Array
(
[cat] => 10%5D
[mac] => 2
[page] => 1
)
)
)
[6] => Array
(
[file] => /var/www/cdaf.it/wre/library/PageComposer/PageComposer.php
[line] => 83
[function] => runPageParts
[class] => PageComposer
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => News Object
(
[itemForPage] => 24
[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] => 127.0.0.1
[dbname] => cdafdb2019
[username] => nr_admin
[password] => ciFIll2etK2g5e8b6WFe
[port] => 5432
[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] =>
)
[name] => mainContent
[pageReg:protected] => PageRegistry Object
(
[inPageScope] => Array
(
[currentPageName] => soci-sostenitori
)
[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
(
[header] => Zend_Config Object
(
[_allowModifications:protected] =>
[_index:protected] => 0
[_count:protected] => 3
[_data:protected] => Array
(
[loc] => it
[path] => it/pagepart/news.tpl.htm
[default] => true
)
[_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
(
[old] => Array
(
[cat] => 10%5D
[mac] => 2
[page] => 1
)
[macro] => Array
(
[id] => 2
[titolo] => Soci Sostenitori
[testo] =>
[url] => soci-sostenitori
)
[url] => /news/soci-sostenitori.htm
)
[args:protected] => Array
(
)
)
[1] => Header 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] => 127.0.0.1
[dbname] => cdafdb2019
[username] => nr_admin
[password] => ciFIll2etK2g5e8b6WFe
[port] => 5432
[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] =>
)
[name] => header
[pageReg:protected] => PageRegistry Object
(
[inPageScope] => Array
(
[currentPageName] => soci-sostenitori
)
[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
(
[p404] => Zend_Config Object
(
[_allowModifications:protected] =>
[_index:protected] => 0
[_count:protected] => 3
[_data:protected] => Array
(
[loc] => it
[path] => it/pagepart/header.tpl.htm
[default] => true
)
[_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] => Footer 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] => 127.0.0.1
[dbname] => cdafdb2019
[username] => nr_admin
[password] => ciFIll2etK2g5e8b6WFe
[port] => 5432
[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] =>
)
[name] => footer
[pageReg:protected] => PageRegistry Object
(
[inPageScope] => Array
(
[currentPageName] => soci-sostenitori
)
[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
(
[p404] => Zend_Config Object
(
[_allowModifications:protected] =>
[_index:protected] => 0
[_count:protected] => 3
[_data:protected] => Array
(
[loc] => it
[path] => it/pagepart/footer.tpl.htm
[default] => true
)
[_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] => 127.0.0.1
[dbname] => cdafdb2019
[username] => nr_admin
[password] => ciFIll2etK2g5e8b6WFe
[port] => 5432
[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] =>
)
[name] => meta
[pageReg:protected] => PageRegistry Object
(
[inPageScope] => Array
(
[currentPageName] => soci-sostenitori
)
[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
(
[header] => 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
(
[cat] => 10%5D
[mac] => 2
[page] => 1
)
)
)
[7] => Array
(
[file] => /var/www/cdaf.it/wre/WebRenderEngine.php
[line] => 204
[function] => renderPage
[class] => PageComposer
[type] => ->
[args] => Array
(
[0] =>
[1] => Array
(
[cat] => 10%5D
[mac] => 2
[page] => 1
)
)
)
[8] => Array
(
[file] => /var/www/cdaf.it/wre/WebRenderEngine.php
[line] => 62
[function] => processRequest
[class] => WebRenderEngine
[type] => ->
[args] => Array
(
)
)
[9] => Array
(
[file] => /var/www/cdaf.it/wre/WebRenderEngine.php
[line] => 133
[function] => __construct
[class] => WebRenderEngine
[type] => ->
[args] => Array
(
[0] => main.xml
)
)
[10] => Array
(
[file] => /var/www/cdaf.it/portale/index.php
[line] => 140
[function] => bootstrap
[class] => WebRenderEngine
[type] => ::
[args] => Array
(
)
)
)