thankyou for the reply, i didn’t know that.
With the configuration issue it is when i try and save, even when clicking retry in firefox it just does the same i have attached a picture.
there doesn’t seem to be any error in IE the error is "This page cannot be displayed"
-
MODX Staff
- 12,272 Posts
What collation does phpMyAdmin say the tables actually using. It’s easy to get a mismatch, particularly on legacy installations that have been upgraded.
I seem to recall some issues in the past with the way Debian servers interact with MODx, but that could be complete hogwash and a figment of my imagination. How is PHP running, and can it be upgraded to a more recent release?
Ryan Thrash, MODX Co-Founder
Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
it had them as latin1_swedish_ci so i changed them to utf8_bin using:
alter table yourtable default collate utf8_bin; for each table
(the default collation is already set to utf8_bin)
but it’s still not working, i do have a duplicate table set, modx_2 with a default installation when i change the config to this it is working, anything else i need to do to those tables?
-
MODX Staff
- 12,272 Posts
You can’t actually just convert the table types without first performing some data migration steps. You’ll have to Google around for some info on that or hopefully someone will chime in here with more details. I believe it involves a set of export/import steps and can’t always be guaranteed to be lossless, but I’m not certain.
Ryan Thrash, MODX Co-Founder
Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me