Update from 4.0.4 to 4.0.8 /latin1 to utf8

alexandra · 2009-03-16 09:49:09

Hi there,

a client of mine changed the hoster and along with the shift he wants updating his old TXP installation (4.0.4) to 4.0.8.

Now the issue is: the old database is latin1 the new utf8.
I dumped the old DB and inserted it into the new one which is based on TXP 4.0.4.

Now i wonder if it is best to first update to 4.0.8 and then change the charakterset to utf? Or shall i first change to utf8 and then update?

BTW: If someone is out there who can change latin1 to utf8 for me (for pay) let me know. I am not really familiar with this characterset problems.

wet · 2009-03-16 10:49:05

alexandra wrote:

Now i wonder if it is best to first update to 4.0.8 and then change the charakterset to utf? Or shall i first change to utf8 and then update?

This doesn’t matter.

BTW: If someone is out there who can change latin1 to utf8 for me

rvm_latin1_to_utf8

(for pay)

Hint.

xbl4814 · 2013-06-15 10:21:16

Apologies for the apparent stupid question but how do we run the rvm_latin1_to_utf8 plugin?

We are getting the latin1 >> utf8 problems with incorrect characters displaying and trying to resolve without much success

http://www.gardens-of-argyll.co.uk/events/

Our diagnostic report is detailed below:

Textpattern version: 4.5.4 (r4919)
Last Update: 2013-06-15 10:04:39/2013-06-15 08:15:45
Document root: /home/gardenso/public_html
$path_to_site: /home/gardenso/public_html
Textpattern path: /home/gardenso/public_html/textpattern
Permanent link mode: section_title
Temporary directory path: /home/gardenso/public_html/tmp
Site URL: www.gardens-of-argyll.co.uk
PHP version: 5.3.26
GD Image Library: bundled (2.1.0 compatible); supported formats: GIF, JPG, PNG.
Server TZ: Europe/London
Server Local Time: 2013-06-15 11:20:17
DST enabled?: 0
auto_dst: 0
Time Zone: (+3600)
MySQL: 5.1.69-cll
Locale: en_GB.UTF-8
Server: Apache/2.2.24 (Unix) mod_ssl/2.2.24 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Server API: cgi-fcgi
RFC 2616 headers: 0
Server OS: Linux 2.6.32-279.5.2.el6.x86_64
Active plugins: zem_paginate-0.1, zem_contact-0.6m, zem_event-0.30m, rvm_latin1_to_utf8-0.3m
theme_name: classic 4.5.4

.htaccess file contents:
————————————
ErrorDocument 404 /notfound.html

#DirectoryIndex index.html index.php
#Options +FollowSymLinks
#RewriteBase /relative/web/path/

<IfModule mod_rewrite.c> RewriteEngine On

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L] RewriteRule ^(.*) index.php

</IfModule>

#php_value register_globals 0

Redirect /html/gardens/achamore.htm http://www.gardens-of-argyll.co.uk/gardens/achamore-gardens.html
Redirect /html/gardens/an_cala.htm http://www.gardens-of-argyll.co.uk/gardens/an-cala.html
Redirect /html/gardens/ardchattan_priory.htm http://www.gardens-of-argyll.co.uk/gardens/ardchattan-priory-garden.html
Redirect /html/gardens/ardencraig.htm http://www.gardens-of-argyll.co.uk/gardens/ardencraig-gardens.html
Redirect /html/gardens/ardkinglas.htm http://www.gardens-of-argyll.co.uk/gardens/ardkinglas-woodland-garden.html
Redirect /html/gardens/ardmaddy.htm http://www.gardens-of-argyll.co.uk/gardens/ardmaddy-castle-garden.html
Redirect /html/gardens/ardtornish.htm http://www.gardens-of-argyll.co.uk/gardens/ardtornish.html
Redirect /html/gardens/arduaine.htm http://www.gardens-of-argyll.co.uk/gardens/arduaine-garden.html
Redirect /html/gardens/ascog.htm http://www.gardens-of-argyll.co.uk/gardens/ascog-hall-fernery-and-garden.html
Redirect /html/gardens/barguillans.htm http://www.gardens-of-argyll.co.uk/
Redirect /html/gardens/benmore.htm http://www.gardens-of-argyll.co.uk/gardens/benmore-botanic-garden.html
Redirect /html/gardens/colonsay.htm http://www.gardens-of-argyll.co.uk/gardens/colonsay-house-garden.html
Redirect /html/gardens/crarae.htm http://www.gardens-of-argyll.co.uk/gardens/crarae-garden.html
Redirect /html/gardens/glenarn.htm http://www.gardens-of-argyll.co.uk/gardens/glenarn.html
Redirect /html/gardens/jura.htm http://www.gardens-of-argyll.co.uk/gardens/jura-house-garden.html
Redirect /html/gardens/kilmory.htm http://www.gardens-of-argyll.co.uk/gardens/kilmory-woodland-park.html
Redirect /html/gardens/kinlochlaich.htm http://www.gardens-of-argyll.co.uk/gardens/kinlochlaich-house-gardens.html
Redirect /html/gardens/stonefield.htm http://www.gardens-of-argyll.co.uk/
Redirect /html/gardens/torosay.htm http://www.gardens-of-argyll.co.uk/gardens/torosay-castle-and-gardens.html

Redirect /html/contacts.htm http://www.gardens-of-argyll.co.uk/contact/
Redirect /html/events.htm http://www.gardens-of-argyll.co.uk/events/
Redirect /html/guest_book.htm http://www.gardens-of-argyll.co.uk/
Redirect /html/links.htm http://www.gardens-of-argyll.co.uk/links.html
Redirect /html/map.htm http://www.gardens-of-argyll.co.uk/map.html

————————————

Charset (default/config): latin1/latin1
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_filesystem: binary
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: OK

colak · 2013-06-15 13:11:55

Apologies for the apparent stupid question but how do we run the rvm_latin1_to_utf8 plugin?

You install it and follow the instructions. It’s been years since I last used it but i remember that it was dead simple.

xbl4814 · 2013-06-15 18:39:36

Must be missing something so simple :-)

We have installed and activated but doesn’t seem to make any changes and presumed after installing there was a way to “run” the plugin.

colak · 2013-06-16 05:48:32

I guess you read the onlie instructions. From what I remember you might have to go under extensions (I might be wrong), and select the tables you want converted.

Also you might need to change the encoding in the config file once finished.

I would also post in the plugin’s thread as ruud might respond from there.

Textpattern CMS

Textpattern CMS support forum

#1 2009-03-16 09:49:09

Update from 4.0.4 to 4.0.8 /latin1 to utf8

#2 2009-03-16 10:49:05

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

#3 2013-06-15 10:21:16

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

#4 2013-06-15 13:11:55

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

#5 2013-06-15 18:39:36

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

#6 2013-06-16 05:48:32

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

Board footer