Textpattern CMS support forum

You are not logged in. Register | Login | Help

#11 2019-10-22 10:27:22

etc
Developer
Registered: 2010-11-11
Posts: 3,427
Website

Re: Multiple problems upgrading from 4.0.3

jakob wrote #319806:

@boyandin: there are few people more qualified to help than etc!

Hey, I meant to help with translation, most technical aspects of the web are mystery for me!

Offline

#12 2019-11-21 13:20:21

boyandin
Member
Registered: 2005-09-16
Posts: 21

Re: Multiple problems upgrading from 4.0.3

Thanks to everyone for offers of help. I’m again out of my wits trying to upgrade the site in situ.

The DB collation of 4.0.3 is already utf8_general_ci, and charset is already utf8 (specified in both config.hp and in META tag).

However, the site is hosted under MariaDB 10.0.15 and perhaps this is the problem. Even if I try to upgrade to 4.0.4, I get all Cyrillic characters replaced with ‘?’, no matter the charset/collation.

I will try now copying the site to a VM with MySQL 5.7 and PHP 5.3 (not the MariaDB) and try upgrading there.

@etc , actually, I speak English quite well, I only have problem with Russian text being garbled during upgrade.


Om gate gate paragate parasamgate bodhi svaha

Offline

#13 2019-11-21 13:22:22

boyandin
Member
Registered: 2005-09-16
Posts: 21

Re: Multiple problems upgrading from 4.0.3

Bloke wrote #319799:

Is there any possibility of temporarily rolling back PHP to 5.4? That should at least allow you to get past the ‘yield’ thing.

Yes. Actually, I am using 5.3 currently – the main problem so far is Russian characters being destroyed during upgrade to the next version (4.0.4).


Om gate gate paragate parasamgate bodhi svaha

Offline

#14 2019-11-21 13:42:46

etc
Developer
Registered: 2010-11-11
Posts: 3,427
Website

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320180:

However, the site is hosted under MariaDB 10.0.15 and perhaps this is the problem.

Ah, that’s quite possible. Please share if you find a solution.

Offline

#15 2019-11-21 14:20:24

boyandin
Member
Registered: 2005-09-16
Posts: 21

Re: Multiple problems upgrading from 4.0.3

etc wrote #320182:

Ah, that’s quite possible. Please share if you find a solution.

Sure, I’ll update the thread in any case.


Om gate gate paragate parasamgate bodhi svaha

Offline

#16 Yesterday 16:04:55

boyandin
Member
Registered: 2005-09-16
Posts: 21

Re: Multiple problems upgrading from 4.0.3

So far, no luck.

Main problem is to create a VM with OS old enough to support PHP 5.3 components (I will have to build them). Wasted several hours on Ubuntu 18.04, after I understood I will have to manually build all the PHP 5.3 dependency libraries (such as old OpenSSL etc).

Is it possible to import posts/content from old TextPattern installation to a new one?

I have wasted much time on this migration already, and still stuck at exactly the same place.


Om gate gate paragate parasamgate bodhi svaha

Offline

#17 Yesterday 16:29:19

etc
Developer
Registered: 2010-11-11
Posts: 3,427
Website

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320527:

So far, no luck.

Main problem is to create a VM with OS old enough to support PHP 5.3 components

It looks more like a MariaDB problem. Have you tried this?

Offline

#18 Yesterday 16:31:37

boyandin
Member
Registered: 2005-09-16
Posts: 21

Re: Multiple problems upgrading from 4.0.3

etc wrote #320528:

It looks more like a MariaDB problem. Have you tried this?

In fact, it’s currently PHP 5.3 building problem – I copied the installation to MySQL 5.7-powered environment. It has imported from MariaDB without glitches.


Om gate gate paragate parasamgate bodhi svaha

Offline

#19 Yesterday 17:07:17

etc
Developer
Registered: 2010-11-11
Posts: 3,427
Website

Re: Multiple problems upgrading from 4.0.3

And what errors you get under your current PHP version? It could be just a matter of commenting out few badly-named txp functions like yield().

Offline

#20 Yesterday 18:00:46

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 3,591
Website

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320527:

So far, no luck.

Main problem is to create a VM with OS old enough to support PHP 5.3 components (I will have to build them). Wasted several hours on Ubuntu 18.04, after I understood I will have to manually build all the PHP 5.3 dependency libraries (such as old OpenSSL etc).

Is it even necessary to do that … Could you not first try the upgrade path to an up-to-date PHP5.6+ or 7 server with a regular non-MariaDB Mysql installation? That’s a pretty common constellation.

Is it possible to import posts/content from old TextPattern installation to a new one?

You can bring in the respective tables from an earlier database. They will still need updating in part at least, though, as there have been some minor changes. The posts are stored in the `textpattern` table, the images in `txp_image`, the pages and forms in `txp_page` and `txp_form` etc., the sections in `txp_section` and the users in `txp_users`.

If you did set up a clean installation as a test case in your new environment first, you could import the textpattern table entries as sql first (just the entries, not the table creation) and then see if they display correctly first of all. I can’t remember off hand exactly what has changed to the Textpattern table over the years, but that is in the code of the update folder. You may find, for example, that you need to correct your `expires` entries.


TXP Builders – finely-crafted code, design and txp

Offline

Board footer

Powered by FluxBB