Transfer to new server - French accent problem

Need help installing Joomla! 1.5? For all Joomla! 1.5 installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 779
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Transfer to new server - French accent problem

Postby Chacapamac » Fri Oct 02, 2015 3:00 pm

You can reach the site (temporarly) at —> http://www.pulsionvoyages.grafcomm.ca/index.php

When I transfer that site to this new hosting environment, all the french accent are replaced by �

Their settings (in Joomla administration Systeme infos) are:
- PHP : 5.3.29
- Database Version: 10.0.21-MariaDB
- Database Collation (where I think the problem reside is : N/A (mySQL < 4.1.2)

Their server collation is —> utf8mb4_unicode_ci

The Joomla database collation (I always use) is —> utf8_general_ci

This site work perfectly on the original server and on my Mamp 5.3 local server

When I mount my site (with Akeeba backup) on that new server, I think the accents are obviously not well interpreted by the new environment.

Anybody with more knowledge on that type of situation can help me fix this?
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/

User avatar
ribo
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3168
Joined: Sun Jan 03, 2010 8:47 pm
Contact:

Re: Transfer to new server - French accent problem

Postby ribo » Fri Oct 02, 2015 3:14 pm

Try this. Create a new database. Before import db alter this from phpmyadmin

Code: Select all

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

After restore your back up with akeeba( i use to restore/tranfer with no akeeba but you use akeeba)
Also you can try utf8_general_ci if you want
chat room spontes : http://www.spontes.com

User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 779
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Re: Transfer to new server - French accent problem

Postby Chacapamac » Sat Oct 03, 2015 1:27 am

I want to thank you ribo for your answer. Really appreciated.

I’m not really a pro to work with database

What you want me to do; Tell me if correct

I have the working site on my local mamp without the accent mess.

1— I go to my Mamp PHPMyAdmin on this database

2— I pass that exact query in the input box of SQL query on database ?

Code: Select all

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;


Do I have to change “databasename” by the real full name of the database — e.g. pulsionz_12345
and “tablename” with the actual prefix of the database —e.g. cfgv_

The exact query will be something like

Code: Select all

ALTER DATABASE pulsionz_12345 CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE cfgv_ CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;


You also suggest utf8_general_ci - What you think will be better?

Also do I have to adjust my database collation on the import side to match what I choose in the query?

Not Sure????
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/

User avatar
Chacapamac
Joomla! Guru
Joomla! Guru
Posts: 779
Joined: Wed Feb 20, 2008 6:50 am
Location: Canada, Montreal
Contact:

Re: Transfer to new server - French accent problem

Postby Chacapamac » Sat Oct 03, 2015 2:54 am

Thanks Everybody - Find the simple Fix here —> viewtopic.php?f=431&t=891676&p=3333100#p3333100

mariadb mysql isn’t compatible with Joomla 1.5 without the fix
Can God help us?
Marketing, SEO, Web development - Powered by Joomla!
http://www.grafcomm.ca/


Return to “Installation 1.5”

Who is online

Users browsing this forum: No registered users and 9 guests