CMS Made Simple Forums

We are transferring our CMSMS site to a new host.  I know very little about how this is done and have paid to have it done for me.  The only technical info I can give you that I think may be related is that my original SQL version is older than the new one.

Everything looks great and functions correctly except that within the content areas and in a few other places (like in the footer and next to the "print button" in the top right) there are strange characters like this, Â, showing up.  They seem to be most common at the end or beginning of sentences and next to links, but do occur in other places as well.

Any ideas?  I can successfully go in to each page's content area and manually delete the characters and can probably figure out how to manually delete the rest in the non-content areas.  I'd rather know what caused this though.

**Solution/Updated:  I manually went in and deleted all of these characters.  Thanks!**

good question. I think the database collation could be related.

I highly recommend you to upgrade your system.

try going into the pages with the errors and re-typing in the letter (they are usually special characters), i had the same problem when transferring a MySQL database

I looked at your source and they good thing is they are all the same. So, what I would do is cut and past the entire pages contents into notepad or textpad and use the "search and replace" feature. Only what you should do is cut and paste the rogue character in the "search for box" and leave the "replace with" box empty. This has nothing to do with your DB or the CMS system - I don't believe anyway.

Again, cut and paste your pages content and replace the character.

Also, when you are done - you should consider upgrading to the newest version of CMSMS as you current version has a few known vulnerabilities.

Good luck,
-J

I am sure it happened while transfer of MySQL database from one server to another.
Similar problem I had when I once was moving website from the local machine into my webhosting.
As viebig said - it is something about collation of the websites.
Also something about the configuration of mysql connection encoding on old machine and new machine.
For example if on old machine mysql connection is established with "utf-8", and in the new machine with "latin1".

What I did, before importing mysql data into new server, I simply opened MySQL dump file on the text editor and replaced all strange characters into appropriate once and then imported the whole data into new machine.

Greetings.

That is weird then. I have moved close to 30-40 of these sites to various hosts and have never seen that before. Not to say it can't happen, I just haven't seen it but I have seen others issues that were similiar. Good luck though..

Well Jack @ PharSide you were lucky enuf to transfer them between DB running the same ver. of mySQL and the same shema set...

I've had this happen to me from transfering between diff. mySQL, had to export and import on the same site/mySQL as it was originally set up on older ver. and was transfering to newer ver. on new server and it wouldn't take it...

I went to old site and imported it using phpmyadmin into the new ver. there then exporting and importing it to new site worked but I had the strange symbol problem and just went into each page and changed it...

viebig wrote: I highly recommend you to upgrade your system.

So do I. Unless you want your site cracked.
See http://wiki.cmsmadesimple.org/index.php ... mall_Guide
Always use the latest official stable version (soon 1.4).

I agree too on the character set mismatch of the two SQL servers.

Pierre M.