Public bug reported:

mahara 18.10 ubuntu Server 16.04 MySQL Firefox Quantum 64.0 / Linux

Trying to make a new blog entry fails with the following information:

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

>From the nginx-Error-Log:
2019/01/26 16:23:52 [error] 25515#25515: *325212 FastCGI sent in stderr: "dio')
PHP message: [WAR] ff (lib/dml.php:517)             AND a.institution IS NULL 
AND a.owner = '2'
PHP message: [WAR] ff (lib/dml.php:517)             AND a.parent IS NULL
PHP message: [WAR] ff (lib/dml.php:517)             GROUP BY
PHP message: [WAR] ff (lib/dml.php:517)                 a.id, a.artefacttype, 
a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, 
a.locked, a.allowcomments,
PHP message: [WAR] ff (lib/dml.php:517)                 u.profileicon, 
fi.orientation")Command was: 
PHP message: [WAR] ff (lib/dml.php:517)             SELECT
PHP message: [WAR] ff (lib/dml.php:517)                 a.id, a.artefacttype, 
a.mtime, f.size, fi.orientation, a.title, a.description, a.license, a.licensor, 
a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
PHP message: [WAR] ff (lib/dml.php:517)                 COUNT(DISTINCT c.id) AS 
childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT 
va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
PHP message: [WAR] ff (lib/dml.php:517)                 COUNT(DISTINCT api.id) 
AS profileiconcount
PHP message: [WAR] ff (lib/dml.php:517)             FROM "artefact" a
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_file_files" f ON f.artefact = a.id
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_file_image" fi ON fi.artefact = a.id
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact" c ON c.parent = a.id
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"view_artefact" va ON va.artefact = a.id
PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_attachment" aa ON aa.attachment = a.id
PHP message: [WAR] ff (lib/dml.php:517)                 LE

This only happens when trying to add a new blog post. All other
artefacts are not affected, as far as i can say. I tried with two
different user accounts and can reproduce this with both of them.

** Affects: mahara
     Importance: Undecided
         Status: New


** Tags: blog

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask 
on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1813405

Title:
  new blog entry fails

Status in Mahara:
  New

Bug description:
  mahara 18.10 ubuntu Server 16.04 MySQL Firefox Quantum 64.0 / Linux

  Trying to make a new blog entry fails with the following information:

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

  From the nginx-Error-Log:
  2019/01/26 16:23:52 [error] 25515#25515: *325212 FastCGI sent in stderr: 
"dio')
  PHP message: [WAR] ff (lib/dml.php:517)             AND a.institution IS NULL 
AND a.owner = '2'
  PHP message: [WAR] ff (lib/dml.php:517)             AND a.parent IS NULL
  PHP message: [WAR] ff (lib/dml.php:517)             GROUP BY
  PHP message: [WAR] ff (lib/dml.php:517)                 a.id, a.artefacttype, 
a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, 
a.locked, a.allowcomments,
  PHP message: [WAR] ff (lib/dml.php:517)                 u.profileicon, 
fi.orientation")Command was: 
  PHP message: [WAR] ff (lib/dml.php:517)             SELECT
  PHP message: [WAR] ff (lib/dml.php:517)                 a.id, a.artefacttype, 
a.mtime, f.size, fi.orientation, a.title, a.description, a.license, a.licensor, 
a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
  PHP message: [WAR] ff (lib/dml.php:517)                 COUNT(DISTINCT c.id) 
AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT 
va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
  PHP message: [WAR] ff (lib/dml.php:517)                 COUNT(DISTINCT 
api.id) AS profileiconcount
  PHP message: [WAR] ff (lib/dml.php:517)             FROM "artefact" a
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_file_files" f ON f.artefact = a.id
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_file_image" fi ON fi.artefact = a.id
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact" c ON c.parent = a.id
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"view_artefact" va ON va.artefact = a.id
  PHP message: [WAR] ff (lib/dml.php:517)                 LEFT OUTER JOIN 
"artefact_attachment" aa ON aa.attachment = a.id
  PHP message: [WAR] ff (lib/dml.php:517)                 LE

  This only happens when trying to add a new blog post. All other
  artefacts are not affected, as far as i can say. I tried with two
  different user accounts and can reproduce this with both of them.

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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to