Forums | Mahara Community
Support
/
A nonrecoverable error occurred. This probably means you have encountered a bug in the system
07 April 2016, 23:39
thank you again
here is phpinfo
in php_error.log
==================
07-Apr-2016 13:21:21 Europe/Paris] [WAR] 70 (lib\dml.php:513) Failed to get a recordset: mysqli error: [1038: Out of sort memory, consider increasing server sort buffer size] in EXECUTE("
[07-Apr-2016 13:21:21 Europe/Paris] [WAR] 70 (lib\dml.php:513) SELECT
[07-Apr-2016 13:21:21 Europe/Paris] [WAR] 70 (lib\dml.php:513) a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
[07-Apr-2016 13:21:21 Europe/Paris] [WAR] 70 (lib\dml.php:513) COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
[07-Apr-2016 13:21:21 Europe/Paris] [WAR] 70 (lib\dml.php:513) COUNT(DISTINCT api.id) AS profileiconcount
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) FROM "artefact" a
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact" c ON c.parent = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "skin" s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "usr" u ON a.id = u.profileicon AND a.owner = u.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) AND a.institution IS NULL AND a.owner = '1'
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) AND a.parent IS NULL
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) GROUP BY
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) u.profileicon")
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) Command was:
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) SELECT
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) COUNT(DISTINCT api.id) AS profileiconcount
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) FROM "artefact" a
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact" c ON c.parent = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "skin" s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) LEFT OUTER JOIN "usr" u ON a.id = u.profileicon AND a.owner = u.id
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) AND a.institution IS NULL AND a.owner = ?
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) AND a.parent IS NULL
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) GROUP BY
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
[07-Apr-2016 13:21:22 Europe/Paris] [WAR] 70 (lib\dml.php:513) u.profileicon and values was (1)
[07-Apr-2016 13:21:22 Europe/Paris] Call stack (most recent first):
[07-Apr-2016 13:21:22 Europe/Paris] * get_recordset_sql("
[07-Apr-2016 13:21:22 Europe/Paris] SELECT
[07-Apr-2016 13:21:22 Europe/Paris] a.id, a.artefa...", array(size 1), "", "") at D:\wamp\www\mahara\lib\dml.php:679
[07-Apr-2016 13:21:22 Europe/Paris] * get_records_sql_assoc("
[07-Apr-2016 13:21:22 Europe/Paris] SELECT
[07-Apr-2016 13:21:22 Europe/Paris] a.id, a.artefa...", array(size 1)) at D:\wamp\www\mahara\artefact\file\lib.php:654
[07-Apr-2016 13:21:22 Europe/Paris] * ArtefactTypeFileBase::get_my_files_data(0"1", null, null, null) at D:\wamp\www\mahara\lib\form\elements\filebrowser.php:159
[07-Apr-2016 13:21:22 Europe/Paris] * pieform_element_filebrowser(object(Pieform), array(size 19)) at D:\wamp\www\mahara\lib\pieforms\pieform.php:1480
[07-Apr-2016 13:21:22 Europe/Paris] * Pieform->build_element_html(array(size 19)) at D:\wamp\www\mahara\lib\pieforms\pieform.php:714
[07-Apr-2016 13:21:22 Europe/Paris] * Pieform->build() at D:\wamp\www\mahara\lib\pieforms\pieform.php:169
[07-Apr-2016 13:21:22 Europe/Paris] * Pieform::process(array(size 11)) at D:\wamp\www\mahara\lib\pieforms\pieform.php:71
[07-Apr-2016 13:21:22 Europe/Paris] * pieform(array(size 11)) at D:\wamp\www\mahara\artefact\blog\post.php:193
[07-Apr-2016 13:21:22 Europe/Paris]
08 April 2016, 0:19
I got syntax error
SELECT
a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
COUNT(DISTINCT c.id) AS childcount, COUNT (DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
COUNT(DISTINCT api.id) AS profileiconcount
FROM artefact a
LEFT OUTER JOIN "artefact_file_files" f ON f.artefact = a.id
LEFT OUTER JOIN "artefact" c ON c.parent = a.id
LEFT OUTER JOIN "artefact" api ON api.parent = a.id AND api.artefacttype = 'profileicon'
LEFT OUTER JOIN "view_artefact" va ON va.artefact = a.id
LEFT OUTER JOIN "artefact_attachment" aa ON aa.attachment = a.id
LEFT OUTER JOIN "skin" s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
LEFT OUTER JOIN "usr" u ON a.id = u.profileicon AND a.owner = u.id
WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
AND a.institution IS NULL AND a.owner = '1'
AND a.parent IS NULL
GROUP BY
a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
u.profileicon
============
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 'DISTINCT aa.artefact) AS attachcount, COUNT(DISTINCT va.view) AS viewcount, COUN' at line 3
I will try to fix error and post result
10 April 2016, 19:27
when I run following SQL
SELECT
a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments, u.profileicon AS defaultprofileicon,
COUNT(DISTINCT c.id) AS childcount, COUNT(DISTINCT va.view) AS viewcount, COUNT(DISTINCT s.id) AS skincount,
COUNT(DISTINCT api.id) AS profileiconcount
FROM artefact a
LEFT OUTER JOIN artefact_file_files f ON f.artefact = a.id
LEFT OUTER JOIN artefact c ON c.parent = a.id
LEFT OUTER JOIN artefact api ON api.parent = a.id AND api.artefacttype = 'profileicon'
LEFT OUTER JOIN view_artefact va ON va.artefact = a.id
LEFT OUTER JOIN artefact_attachment aa ON aa.attachment = a.id
LEFT OUTER JOIN skin s ON (s.bodybgimg = a.id OR s.viewbgimg = a.id)
LEFT OUTER JOIN usr u ON a.id = u.profileicon AND a.owner = u.id
WHERE a.artefacttype IN ('file','folder','image','profileicon','archive','video','audio')
AND a.institution IS NULL AND a.owner = '?'
AND a.parent IS NULL
GROUP BY
a.id, a.artefacttype, a.mtime, f.size, a.title, a.description, a.license, a.licensor, a.licensorurl, a.locked, a.allowcomments,
u.profileicon
I got error
#1038 - Out of sort memory, consider increasing server sort buffer size
10 April 2016, 21:29
Hi,I've installed a new Mahara 15.10 with mysql in my environment. I don't get this error. It's something to do with your environment.
I've suggested that you try to increase the sort buffer for your mysql setting - just to see if this will stop this error. Because you could get past this error and come up with another error that could lead to the root of the cause.
Maybe try to *drop* the database and start again with a new database.
Ghada
10 April 2016, 22:12
thank you for your help
I did increased it to 1M, 2M,10M
and I still got same error.
I did install it in other pc (also windows and WAMP) and I didn't get this error when I click on add journal, however I got it when I clicked add plan
I will try to do your suggestion and post what I will got
thank you again
10 April 2016, 23:29
thank you,
I deleted privouse installation and its db and created new one
and now I don't have that problem in same environment
I changed collation of db from utf8_unicode_ci to utf8_general_ci (I tried same collation and I still got the error so I changed it to this one as Moodle)
I'm not sure if that was the problem , however I don't have the problem any more either when I add new entry in journal or when I add new plan
Thanks Ghada
11 April 2016, 0:09
Hi,
This is really great news! You solved it!
The UTF encoding didn't come to my mind at all - but it now makes sense.
I hope this helps others in the future.
Good job!
Cheers,
Ghada
11 April 2016, 6:19
Thanks for sharing this problem. I have the same. Where do you change this setting please.
My problem arises on Journal/New Entry; Files and Editing Notes. The error looks the same 'Out of Sort Memory' etc.
Thanks in advance
Rob
11 April 2016, 7:43
OK found this (below) about changing collation,, but it has not helped:
It seems each table needs to be updated separately anyway as the change does not seem to cascade down.
- Log into phpMyAdmin.
- Select your database from the list on the left.
- Click on "Operations" from the top set of tabs.
- In the Collation box, choose your new collation from the dropdown menu. utf8_general_ci is the most common utf8 collation.
- Select your database from the list on the left.
Default MySQL character set and collation - Media Temple
SQL query: Edit Edit
CREATE TRIGGER `mhwl_update_unread_delete2_trigger` AFTER DELETE ON `mhwl_module_multirecipient_userrelation` FOR EACH ROW BEGIN IF OLD.read = '0' AND OLD.role = 'recipient' THEN UPDATE "mhwl_usr" SET unread = unread -1 WHERE id = OLD.usr;
END IF ;
END
MySQL said: Documentation
#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 '"mhwl_usr" SET unread = unread - 1 WHERE id = OLD.usr;
END IF;
' at line 5