Steps to reproduce the issue

• install joomla (3.3.6 on postgresql 9.3) with all test data
• open the site

Expected result

• no errors

Actual result

in home

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 "ixobg_contentitem_tag_map" AS "m" INNER JOIN "ixobg_tags" AS "t" ON m.tag_id = t.id INNER JOIN "ixobg_ucm_content" AS "cc" ON m.core_content_id = cc.core_content_id INNER JOIN "ixobg_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

in sample sites -> content modules
Database query failed (error # %s): %s SQL=SELECT EXTRACT (MONTH FROM "created") AS created_month,created, id, title,EXTRACT (YEAR FROM "created") AS created_year FROM ixobg_content WHERE state = 2 AND checked_out = 0 GROUP BY created_year DESC, created_month DESC LIMIT 10

in sample sites -> archive
Database query failed (error # %s): %s SQL=SELECT EXTRACT (MONTH FROM "created") AS created_month,created, id, title,EXTRACT (YEAR FROM "created") AS created_year FROM ixobg_content WHERE state = 2 AND checked_out = 0 GROUP BY created_year DESC, created_month DESC LIMIT 10

in sample sites -> related items
Database query failed (error # %s): %s SQL=SELECT a.id,a.title,DATE_FORMAT(a.created, "%Y-%m-%d") as created,a.catid,cc.access AS cat_access,cc.published AS cat_state, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN a.id::text || ':' || a.alias ELSE a.id::text END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN cc.id::text || ':' || cc.alias ELSE cc.id::text END as catslug FROM ixobg_content AS a LEFT JOIN ixobg_content_frontpage AS f ON f.content_id = a.id LEFT JOIN ixobg_categories AS cc ON cc.id = a.catid WHERE a.id != 37 AND a.state = 1 AND a.access IN (1,1) AND ("," || REPLACE(a.metakey, ", ", ",") || "," LIKE "%modules%" OR "," || REPLACE(a.metakey, ", ", ",") || "," LIKE "%content%") AND (a.publish_up = '1970-01-01 00:00:00' OR a.publish_up <= '2014-10-16 10:43:18') AND (a.publish_down = '1970-01-01 00:00:00' OR a.publish_down >= '2014-10-16 10:43:18') LIMIT 5

System information (as much as possible)

Additional comments