{"id":2111,"date":"2012-10-09T20:04:20","date_gmt":"2012-10-09T18:04:20","guid":{"rendered":"http:\/\/blog.fh-kaernten.at\/wehr\/?p=2111"},"modified":"2012-10-11T10:36:08","modified_gmt":"2012-10-11T08:36:08","slug":"moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix","status":"publish","type":"post","link":"https:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/","title":{"rendered":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix"},"content":{"rendered":"<p id=\"top\" \/>I just added the wonderful <a href=\"http:\/\/docs.moodle.org\/23\/en\/Ajax_marking_block\">ajax marking block<\/a> to our <a href=\"https:\/\/moodle.org\/\">Moodle<\/a> system. After little testing it seems that this block has some issues with our <a href=\"http:\/\/www.postgresql.org\/\">PostgreSQL<\/a> backend.<\/p>\n<p>In detail one of the major queries are aborting with the meaningful error message:<\/p>\n<h2 id=\"post-title\" style=\"padding-left: 30px;\">ERROR: failed to find conversion function from &#8220;unknown&#8221; to text<\/h2>\n<p>nice stuff \ud83d\ude42<\/p>\n<p>It turns out that the usage of a <em>&#8220;string<\/em> as <em>alias&#8221;<\/em> are not handled correctly in postgresql, or so,&#8230; this part needs an explicit cast &#8220;::text&#8221;<\/p>\n<p>If you also encountered this problem, you can download an updated <strong>query_base.class.php<\/strong> from -&gt; <a href=\"http:\/\/meditprojects.cti.ac.at\/download\/query_base.class.rar\">here<\/a><\/p>\n<p>have fun<\/p>\n<p>Mario<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I just added the wonderful ajax marking block to our Moodle system. After little testing it seems that this block has some issues with our PostgreSQL backend. In detail one of the major queries are aborting with the meaningful error message: ERROR: failed to find conversion function from &#8220;unknown&#8221; to text nice stuff \ud83d\ude42 It &hellip; <a href=\"https:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Moodle 2.3.x ajax marking block PostgreSQL compatibility fix<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"ngg_post_thumbnail":0,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-2111","post","type-post","status-publish","format-standard","hentry","category-moodle-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab\" \/>\n<meta property=\"og:description\" content=\"I just added the wonderful ajax marking block to our Moodle system. After little testing it seems that this block has some issues with our PostgreSQL backend. In detail one of the major queries are aborting with the meaningful error message: ERROR: failed to find conversion function from &#8220;unknown&#8221; to text nice stuff \ud83d\ude42 It &hellip; Continue reading Moodle 2.3.x ajax marking block PostgreSQL compatibility fix &rarr;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/\" \/>\n<meta property=\"og:site_name\" content=\"Mario&#039;s TinyLab\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-09T18:04:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-11T08:36:08+00:00\" \/>\n<meta name=\"author\" content=\"Mario Wehr\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mario Wehr\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/\"},\"author\":{\"name\":\"Mario Wehr\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\"},\"headline\":\"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix\",\"datePublished\":\"2012-10-09T18:04:20+00:00\",\"dateModified\":\"2012-10-11T08:36:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/\"},\"wordCount\":110,\"commentCount\":2,\"articleSection\":[\"Moodle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/\",\"url\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/\",\"name\":\"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#website\"},\"datePublished\":\"2012-10-09T18:04:20+00:00\",\"dateModified\":\"2012-10-11T08:36:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/2012\\\/10\\\/09\\\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#website\",\"url\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/\",\"name\":\"Mario&#039;s TinyLab\",\"description\":\"About cool\\\/interesting Projects and Technologies\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/#\\\/schema\\\/person\\\/8761b4d788b13b547de9ccd6504ce62d\",\"name\":\"Mario Wehr\",\"url\":\"https:\\\/\\\/blog.fh-kaernten.at\\\/wehr\\\/author\\\/wehr\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/","og_locale":"en_US","og_type":"article","og_title":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab","og_description":"I just added the wonderful ajax marking block to our Moodle system. After little testing it seems that this block has some issues with our PostgreSQL backend. In detail one of the major queries are aborting with the meaningful error message: ERROR: failed to find conversion function from &#8220;unknown&#8221; to text nice stuff \ud83d\ude42 It &hellip; Continue reading Moodle 2.3.x ajax marking block PostgreSQL compatibility fix &rarr;","og_url":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/","og_site_name":"Mario&#039;s TinyLab","article_published_time":"2012-10-09T18:04:20+00:00","article_modified_time":"2012-10-11T08:36:08+00:00","author":"Mario Wehr","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mario Wehr","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/#article","isPartOf":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/"},"author":{"name":"Mario Wehr","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d"},"headline":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix","datePublished":"2012-10-09T18:04:20+00:00","dateModified":"2012-10-11T08:36:08+00:00","mainEntityOfPage":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/"},"wordCount":110,"commentCount":2,"articleSection":["Moodle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/","url":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/","name":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix - Mario&#039;s TinyLab","isPartOf":{"@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#website"},"datePublished":"2012-10-09T18:04:20+00:00","dateModified":"2012-10-11T08:36:08+00:00","author":{"@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d"},"breadcrumb":{"@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/blog.fh-kaernten.at\/wehr\/2012\/10\/09\/moodle-2-3-x-ajax-marking-block-postgresql-compatiblity-fix\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.fh-kaernten.at\/wehr\/"},{"@type":"ListItem","position":2,"name":"Moodle 2.3.x ajax marking block PostgreSQL compatibility fix"}]},{"@type":"WebSite","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#website","url":"https:\/\/blog.fh-kaernten.at\/wehr\/","name":"Mario&#039;s TinyLab","description":"About cool\/interesting Projects and Technologies","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.fh-kaernten.at\/wehr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.fh-kaernten.at\/wehr\/#\/schema\/person\/8761b4d788b13b547de9ccd6504ce62d","name":"Mario Wehr","url":"https:\/\/blog.fh-kaernten.at\/wehr\/author\/wehr\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/2111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/comments?post=2111"}],"version-history":[{"count":0,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/posts\/2111\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/media?parent=2111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/categories?post=2111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fh-kaernten.at\/wehr\/wp-json\/wp\/v2\/tags?post=2111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}