Sorry about the frustration. We try to fix issues as soon as we can, but we've got limited resources. :(
Really the main limitation on MySQL support is that the Mahara lead developers, my employer Catalyst IT (http://www.catalyst.net.nz), is an organization that primarily uses Postgres. So, pretty much the entirety of our paid Mahara development work is done on Postgres, because that's what all our clients are using, and consequently MySQL-specific work has to come out of our non-funded general bug fixing time, or from community code contributions. We do have one Mahara client running MySQL now, though, so you may see more active MySQL bug fixing in the future. We would welcome a patch for this issue. On a quick search through the code base I see only about 12 instances of CAST() still present, so in theory it shouldn't be too much work to solve. I haven't migrated a large site from MySQL to Postgres before, so I can't offer any specific insights into the process. There is a page about it on the Postgres site: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL . There was also a comment thread about it on mahara.org recently, in which Dajan suggested checking the Moodle forums for advice, since it does come up there occasionally. https://mahara.org/interaction/forum/topic.php?id=5573 Sorry I can't be of more help! -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contrib members https://bugs.launchpad.net/bugs/1081947 Title: Adding Journal or Text box to a page takes approx 2 minutes to load Status in Mahara ePortfolio: Confirmed Bug description: Mahara version 1.5.2 Linux CentOS release 5.8 PHP Version 5.3.15 MySQL 5.0.77 When editing a page and trying to add a normal text box by dragging it into the page, this loads for approx 2 minutes or more and then eventually appears. It happens with a journal too but all others are fine and are instant as they should be. I'm not getting any apache log errors for this nor general server errors. The only thing I am able to see is the query that it hangs on for this length of time.... it is the below... I hope someone can help as obviously this is causing quite a lot of issues for the users!! Anyone able to diagnose what is the issue here? The thing is, there is another exact version of the Mahara site alongside this one but just a blank version which runs perfectly fine so this must be an issue within the database somewhere or the maharadata. Query below: this hangs for about 1 minute 45.. SELECT a.*, CAST(a.owner IS NOT NULL AND a.owner = '1739' AS UNSIGNED) AS editable FROM "artefact" a LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE ( a.owner = '1739' OR a.id IN ( SELECT aar.artefact FROM "group_member" m JOIN "artefact" aa ON m.group = aa.group JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id WHERE m.member = '1739' AND aar.can_republish = 1 ) OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1) OR a.institution IN ('test','mahara') ) AND artefacttype IN('blog')ORDER BY title ASC LIMIT 10 | Then this one for the rest of the time until eventually the text box or journal appears on the page: SELECT COUNT(*) FROM "artefact" a LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE ( a.owner = '1739' OR a.id IN ( SELECT aar.artefact FROM "group_member" m JOIN "artefact" aa ON m.group = aa.group JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id WHERE m.member = '1739' AND aar.can_republish = 1 ) OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1) OR a.institution IN ('test','mahara') ) AND artefacttype IN('blogpost') | Thank you for your help To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1081947/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
