mahara-contributors team mailing list archive

[Son Nguyen <1131508@xxxxxxxxxxxxxxxxxx>]

A important note for testing is you have to install Mahara database
using MySQL.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/1131508

Title:
  artefact licences feature not configurable on mysql

Status in Mahara ePortfolio:
  In Progress

Bug description:
  http://<your url>/admin/site/licenses.php fails on a mysql
  installation because the EXCEPT clause is not in mysql.

  Instead of except, something like "LEFT JOIN, IS NULL" needs to be
  used.

  [WAR] c9 (lib/errors.php:749) Failed to get a recordset: mysql 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 'EXCEPT
      SELECT name FROM artefact_license' at line 2] in EXECUTE("
      SELECT license FROM artefact WHERE license IS NOT NULL and license <> ''
      EXCEPT
      SELECT name FROM artefact_license
  ")
  Command was:
      SELECT license FROM artefact WHERE license IS NOT NULL and license <> ''
      EXCEPT
      SELECT name FROM artefact_license
  Call stack (most recent first):

      log_message("Failed to get a recordset: mysql error: [1064: You...", 8, true, true) at /var/www/mahara-mysql/code/htdocs/lib/errors.php:109
      log_warn("Failed to get a recordset: mysql error: [1064: You...") at /var/www/mahara-mysql/code/htdocs/lib/errors.php:749
      SQLException->__construct("Failed to get a recordset: mysql error: [1064: You...") at /var/www/mahara-mysql/code/htdocs/lib/dml.php:846
      get_column_sql(" SELECT license FROM artefact WHERE license IS...") at /var/www/mahara-mysql/code/htdocs/admin/site/licenses.php:57

  [WAR] c9 (lib/dml.php:846) Failed to get a recordset: mysql 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 'EXCEPT
      SELECT name FROM artefact_license' at line 2] in EXECUTE("
      SELECT license FROM artefact WHERE license IS NOT NULL and license <> ''
      EXCEPT
      SELECT name FROM artefact_license
  ")
  Command was:
      SELECT license FROM artefact WHERE license IS NOT NULL and license <> ''
      EXCEPT
      SELECT name FROM artefact_license
  Call stack (most recent first):

      get_column_sql(" SELECT license FROM artefact WHERE license
  IS...") at /var/www/mahara-
  mysql/code/htdocs/admin/site/licenses.php:57

  Mahara: Site unavailable
  A nonrecoverable error occurred. This probably means you have encountered a bug in the system

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1131508/+subscriptions