SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error in tsquery: "WA+0821+7001+0763+(FORTRESS)+Pintu+Baja+Fortress+Olympus++Plaju+Palembang", query was: SELECT count(*) as c
FROM (SELECT DISTINCT n.id,
testo_ricerca as testo_ricerca,
n.titolo as titolo,
ftq ,
n.ricerca
FROM portale.news n
JOIN portale.news_siti as ns ON (ns.news = n.id and ns.sito = 1)
LEFT JOIN portale.news_materie as m ON (m.news = n.id),
TO_TSQUERY('italian', 'WA+0821+7001+0763+(FORTRESS)+Pintu+Baja+Fortress+Olympus++Plaju+Palembang') AS ftq
WHERE n.ricerca @@ ftq AND pubblicazione <= current_date
AND (m.materia is NULL OR m.materia IN ('16','39','35','1','22','17','14','44','20','2','13','28','36','6','45','19','32','34','8','9','5','12','27','18','47','38','24','41','15','4','11','25','7','37','31','10','29','50','30','3','40','26','43','49','46','42','33','23','21','48') )
AND pubblica = true AND (data_fine IS NULL or data_fine >= current_date)) as k
Array
(
[0] => Array
(
[file] => /usr/share/php/Zend/Db/Statement.php
[line] => 303
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /usr/share/php/Zend/Db/Adapter/Abstract.php
[line] => 480
[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 count(*) as c
FROM (SELECT DISTINCT n.id,
testo_ricerca as testo_ricerca,
n.titolo as titolo,
ftq ,
n.ricerca
FROM portale.news n
JOIN portale.news_siti as ns ON (ns.news = n.id and ns.sito = 1)
LEFT JOIN portale.news_materie as m ON (m.news = n.id),
TO_TSQUERY('italian', 'WA+0821+7001+0763+(FORTRESS)+Pintu+Baja+Fortress+Olympus++Plaju+Palembang') AS ftq
WHERE n.ricerca @@ ftq AND pubblicazione <= current_date
AND (m.materia is NULL OR m.materia IN ('16','39','35','1','22','17','14','44','20','2','13','28','36','6','45','19','32','34','8','9','5','12','27','18','47','38','24','41','15','4','11','25','7','37','31','10','29','50','30','3','40','26','43','49','46','42','33','23','21','48') )
AND pubblica = true AND (data_fine IS NULL or data_fine >= current_date)) as k
[1] => Array
(
)
)
)
[3] => Array
(
[file] => /usr/share/php/Zend/Db/Adapter/Abstract.php
[line] => 756
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT count(*) as c
FROM (SELECT DISTINCT n.id,
testo_ricerca as testo_ricerca,
n.titolo as titolo,
ftq ,
n.ricerca
FROM portale.news n
JOIN portale.news_siti as ns ON (ns.news = n.id and ns.sito = 1)
LEFT JOIN portale.news_materie as m ON (m.news = n.id),
TO_TSQUERY('italian', 'WA+0821+7001+0763+(FORTRESS)+Pintu+Baja+Fortress+Olympus++Plaju+Palembang') AS ftq
WHERE n.ricerca @@ ftq AND pubblicazione <= current_date
AND (m.materia is NULL OR m.materia IN ('16','39','35','1','22','17','14','44','20','2','13','28','36','6','45','19','32','34','8','9','5','12','27','18','47','38','24','41','15','4','11','25','7','37','31','10','29','50','30','3','40','26','43','49','46','42','33','23','21','48') )
AND pubblica = true AND (data_fine IS NULL or data_fine >= current_date)) as k
[1] => Array
(
)
)
)
[4] => Array
(
[file] => /var/www/loescher.it/wre/library/PagePart/Ricerca.php
[line] => 839
[function] => fetchRow
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => SELECT count(*) as c
FROM (SELECT DISTINCT n.id,
testo_ricerca as testo_ricerca,
n.titolo as titolo,
ftq ,
n.ricerca
FROM portale.news n
JOIN portale.news_siti as ns ON (ns.news = n.id and ns.sito = 1)
LEFT JOIN portale.news_materie as m ON (m.news = n.id),
TO_TSQUERY('italian', 'WA+0821+7001+0763+(FORTRESS)+Pintu+Baja+Fortress+Olympus++Plaju+Palembang') AS ftq
WHERE n.ricerca @@ ftq AND pubblicazione <= current_date
AND (m.materia is NULL OR m.materia IN ('16','39','35','1','22','17','14','44','20','2','13','28','36','6','45','19','32','34','8','9','5','12','27','18','47','38','24','41','15','4','11','25','7','37','31','10','29','50','30','3','40','26','43','49','46','42','33','23','21','48') )
AND pubblica = true AND (data_fine IS NULL or data_fine >= current_date)) as k
)
)
[5] => Array
(
[file] => /var/www/loescher.it/wre/library/PageComposer/PageComposer.php
[line] => 139
[function] => requestProcessing
[class] => Ricerca
[type] => ->
[args] => Array
(
[0] => Array
(
[parola] => WA 0821 7001 0763 (FORTRESS) Pintu Baja Fortress Olympus Plaju Palembang
)
)
)
[6] => Array
(
[file] => /var/www/loescher.it/wre/library/PageComposer/PageComposer.php
[line] => 83
[function] => runPageParts
[class] => PageComposer
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => Ricerca 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] => loescherdb2019
[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] =>
)
[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/ricerca.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
(
[dominio] => loescher.it
[sito] => Array
(
[id] => 1
[nome_sito] => LŒSCHER EDITORE
[sottodominio] => www
[immagine] => 54
[menu_opzionale] => 1
[fot1] =>
Sede operativa:
Torino, Via Vittorio Amedeo II, 18
Divisione di Zanichelli editore S.p.A. Società a socio unico
Sede legale:
Bologna, via Irnerio 34
[fot2] =>
Capitale sociale 25.000.000 € I.V. P. IVA IT04284651207
Cod. Fiscale e N° Iscrizione Reg.Imp.Bo 04284651207
REA N. 582138 – BOLOGNA - Licenza SIAE n. 4872/I/4535
[fot3] =>
La Loescher Editore Divisione di Zanichelli editore S.p.A. opera con sistema qualità certificato KIWA-CERMET n. 11469-A secondo la norma UNI EN ISO 9001:2015. Politica Aziendale