11 April 2016, 9:13

mmm. Attempted and abandoned. 

Had to restore old db and folders.  Went back to a place where pages were not rendering (problem on first install), errors about plugins not being installed etc..

Also there seemed to be no way to define the 'database collation' at the point while installing with Softaculous.

Will attempt when am next feeling brave and attempt to be more methodical!

Rob 

11 April 2016, 17:13

I didn't use Softaculous ,

I followed the steps in the next link

https://wiki.mahara.org/wiki/System_Administrator's_Guide/Installing_Mahara/Installing_Mahara_in_Wampserver

however, when creating database  I selected other collation

I recommand to test new installation and change the db collation and see if this would help or not.

did this error occoured with new installation, or you didn't have this problem then it occoured?

13 April 2016, 16:22

Hi Rob,

I don't use Softaculous either.

If you still have the old database and access to mysql, this link may be useful:

http://stackoverflow.com/questions/1294117/how-to-change-collation-of-database-table-column

I would run this SQL command to get a list of all the mahara tables that don't have the right collation:

SELECT concat (
    'ALTER TABLE ',
    t1.TABLE_SCHEMA,
    '.',
    t1.TABLE_NAME,
    ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;'
    ) As col1
from
    information_schema.tables t1
where
    t1.TABLE_SCHEMA = 'DB NAME GOES HERE' AND
    t1.TABLE_COLLATION IS NOT NULL AND
    t1.TABLE_COLLATION NOT IN ('utf8_unicode_ci');

Then, copy the results of that query and run those queries.

That should fix the collation issues.

Please let me know how it works out for you.

Thanks,

Ghada

17 April 2016, 0:39

Hi Ghada, 

Thanks for your reply and help. 

In the end I had to go back to the hosts who did 'multiple configuration changes'. I have no clue what really and they managed to get our site up and running. 

I am not sure if it had anything to do with the db collation and suspect I was clutching at straws. 

I am now testing mahara properly and it's amazing.

Will continue..

Rob

p.s. That error description is rather annoying tho ;) 

17 April 2016, 10:21

14 June 2016, 22:39

Thanks Ghada

Have been so far. 
Good package. 

Thank goodness for these support forums too. 

Rob