error in joomla page site

Avatar
  • Answered
i make joomla site with postgresql database but when load site page display this error:
An error has occurred while processing your request.

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page


If difficulties persist, please contact the System Administrator of this site and report the error below.

0 Database query failed (error # %s): %s SQL=SELECT "m"."tag_id","m"."core_content_id","m"."content_item_id","m"."type_alias",COUNT( "tag_id") AS "count","t"."access","t"."id","ct"."router","cc"."core_title","cc"."core_alias","cc"."core_catid","cc"."core_language" FROM "qgwj2_contentitem_tag_map" AS "m" INNER JOIN "qgwj2_tags" AS "t" ON m.tag_id = t.id INNER JOIN "qgwj2_ucm_content" AS "cc" ON m.core_content_id = cc.core_content_id INNER JOIN "qgwj2_content_types" AS "ct" ON m.type_alias = ct.type_alias WHERE "m"."tag_id" IN (2,3,4,5) AND t.access IN (1,1) AND (cc.core_access IN (1,1) OR cc.core_access = 0) AND ("m"."content_item_id" <> 24 OR "m"."type_alias" <> 'com_content.article') AND "cc"."core_state" = 1 GROUP BY "m"."core_content_id" ORDER BY "count" DESC LIMIT 5

i dont khow where in problem.please help me:(
Avatar
Arn
Hello, Sorry for the problems with PostgreSQL with your Joomla installation. Unfortunately, there are reported issues with PostgreSQL, so based on the information you have provided it could many things. If you were having problems after installing a language, then you may want to check out this post and see if they don't have a solution for you. Or, you may want seek assistance from the Joomla community on this issue as there multiple possibilities that cause the failed database query issue that you're seeing. Please try reviewing the Joomla Forum posts on PostgreSQL issues for more information. We would also recommend using Joomla with MySQL by using the default installations (in Softaculous if you are in InMotion customer). Apologies again for the problems with PostgreSQL in Joomla. We do support the database use on our servers, but for use with Joomla, it's more stable to use Joomla with MySQL. Regards, Arnel C.