Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

alexandra
Member
From: Cologne, Germany
Registered: 2004-04-02
Posts: 1,370

Update from 4.0.4 to 4.0.8 /latin1 to utf8

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.

Offline

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

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,340
Website GitHub Mastodon

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

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.

Offline

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

xbl4814
Member
Registered: 2013-06-14
Posts: 10

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

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

Offline

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,172
Website GitHub Mastodon Twitter

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

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.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

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

xbl4814
Member
Registered: 2013-06-14
Posts: 10

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

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.

Offline

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,172
Website GitHub Mastodon Twitter

Re: Update from 4.0.4 to 4.0.8 /latin1 to utf8

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.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

Board footer

Powered by FluxBB