{"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"],"_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}]}}