Шаблон:DSpace2: различия между версиями

Версия 13:57, 12 сентября 2021

Не удаётся подключиться к базе данных (Cannot access the database: Postgres functions missing, have you compiled PHP with the --with-pgsql option? (Note: if you recently installed PHP, you may need to restart your webserver and database)).

‎

Дополнительные данные из repository.geologyscience.ru

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{{2}}} ORDER BY `a`.`_pageID`,`a`.`_pageName`,CONCAT("[",`b`.`Cite`," ",`a`.`Na' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `a`.`_pageID` AS `cargo_backlink_page_id_a`,`a`.`_pageName` AS `_pageName`,CONCAT("[",`b`.`Cite`," ",`a`.`Name`,"]") AS `Смотрите также` FROM `gscargo__DS_name2` `a` LEFT OUTER JOIN `gscargo__DS_cite2` `b` ON ((`a`.`Link`=`b`.`Link`)) WHERE `a`.`_pageName` = {{{2}}} ORDER BY `a`.`_pageID`,`a`.`_pageName`,CONCAT("[",`b`.`Cite`," ",`a`.`Name`,"]") LIMIT 100

@@ Строка 7: / Строка 7: @@
 {{#cargo_query:tables=DS_name2=a, DS_cite2=b
 |join on=a.Link=b.Link
-|where=a._pageName like "%{{{2}}}%"
+|where=a._pageName = {{{2}}}
 |fields=a._pageName,CONCAT("[",b.Cite," ",a.Name,"]")=Смотрите также
 |format=table