Even after the above index it is slow but better than before as now it takes few seconds 20-30.
]]>do you have any error logs? I usually run tail -f on error.log in Debian and sometimes it tells me many things.
This is happening in all browsers, all themes?
]]>Note that the patch offered in the bug report is for Mahara v1.5.2 (I believe). v1.6.2 contains an additional explicit CAST and so requires manual editing.
Thanks again to Yaju for his original work on the bug and for his quick reply to our posting yesterday.
Hrynkiw
Kwantlen Polytechnic
(Edited to add: For what it's worth, the entire upgrade took only about 20 minutes to run. About 12-13 minutes for the core upgrade, about 7 minutes for blocktype.externalfeed (possibly because our test server is not accessible off-campus), and moments for each of the other entries on the upgrade list.)
]]>I've been fighting with this upgrade on and off for over a week now and have been extremely frustrated. My work day is almost over, but I'll certainly be trying your fix tomorrow and will report back my results.
Thank-you. You've earned much Good Karma today.
Hrynkiw
Kwantlen Polytechnic
Apply this patch to fix the issue.
]]>mysql> show full processlist;
| Id | User | Host | db | Command | Time | State | Info |
| 20 | tmahara | localhost | tmahara | Query | 643 | Sending data | UPDATE "block_instance", "artefact"
SET "block_instance".configdata = CONCAT('a:1:{s:10:"artefactid";i:', CAST("artefact".id AS CHAR), ';}')
WHERE
"artefact".artefacttype = 'html'
AND "artefact".note IS NOT NULL
AND "block_instance".blocktype = 'textbox'
AND CAST("block_instance".id AS CHAR) = "artefact".note |
What's it doing, and is it broken or just taking a really *really* long time?
Hrynkiw
Kwantlen Polytechnic University
(edited to remove a bunch of spaces from the mysql query.)
]]>