I've altered the patch - have taken another approach. Now the patch checks the table collation for mysql and if is case insensitive then reduces the tag array to unique lowercase options.
A useful sql query for testing mysql tables (going from case insensitive to case sensitive) alter table <tablename> convert to character set utf8 collate utf8_bin; -- 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/1231920 Title: Duplicate tags in page creation gives error message Status in Mahara ePortfolio: Confirmed Status in Mahara 1.8 series: Confirmed Status in Mahara 1.9 series: Confirmed Bug description: Has anyone noticed, when creating a page, that if you put a tag in twice, the page will be created but you get an error message? I've tested this on two accounts and it's consistent - I've been able to test it on our own site and on a free host. The error message is: Site unavailable A nonrecoverable error occured. This probably means you have encountered a bug in the system For example, if you create a page, and put the tags university and University, the error is given. Our version of Mahara is 1.7.0 but I'm not sure what the free host has (it has all the same functions as our own). Firefox 23 and IE 9 Marion To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1231920/+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
