Post by jfsimon » Tue Feb 07, 2023 1:05 pm

Good day,
I imported a database back from an opencart 3 instance and character set isn't properly displayed.
Though i can't remember what template/lang. on original, the admin panel was French, and newer 3.0.3.7 has admin Engligh.
Maybe this is not related to the issue ...

The site displays like this:
Currency: "€ Euro" for €
"£ Pound Sterling" for £
$ properly shows.

There are other glitches in the charset on the pages.

What could cause this ?

Thanks & regards
Jean-François

Newbie

Posts

Joined
Wed Mar 17, 2021 12:41 am

Post by xxvirusxx » Tue Feb 07, 2023 4:21 pm

Wrong config files....

Edit both config files and change all instances from http:// to https://

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by jfsimon » Tue Feb 07, 2023 6:11 pm

Good morning,

I updated config files, the issue remains.
Database import show characters like 'é' inside, i did a manual import qith mysql (the built in restort fails).
Could that be the reason, is there special character conversion during import/export ?

Regards,
Jean-François

Newbie

Posts

Joined
Wed Mar 17, 2021 12:41 am

Post by ADD Creative » Tue Feb 07, 2023 6:14 pm

Having the wrong charset could cause that. Use your web browser's developer to check the content-type header and the meta charset element are utf-8.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by xxvirusxx » Tue Feb 07, 2023 7:53 pm

Then, possible corupted database when ws imported.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by jfsimon » Wed Feb 08, 2023 6:25 am

Ok thanks,
Probably the DB import was not all right.

I'll work on it.
Jean-François

Newbie

Posts

Joined
Wed Mar 17, 2021 12:41 am

Post by jfsimon » Wed Feb 08, 2023 6:43 pm

Good morning,
I rooted the issue to MariaDB using latin1 charset,
Do you have recommendations: reinstall MariaDB fresh, convert tables, try use latin1 in Opencart ?
Thanks
Jean-François

Newbie

Posts

Joined
Wed Mar 17, 2021 12:41 am

Post by JNeuhoff » Wed Feb 08, 2023 9:39 pm

You should use UTF8, and for the database I recommend using the collation utf8mb3_general_ci.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jfsimon » Wed Feb 08, 2023 10:23 pm

Ok thank you

Newbie

Posts

Joined
Wed Mar 17, 2021 12:41 am
Who is online

Users browsing this forum: Semrush [Bot] and 260 guests