Multiple problems upgrading from 4.0.3

boyandin · 2019-11-21 13:22:22

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).

etc · 2019-11-21 13:42:46

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.

boyandin · 2019-11-21 14:20:24

etc wrote #320182:

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

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

boyandin · 2019-12-14 16:04:55

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.

etc · 2019-12-14 16:29:19

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?

boyandin · 2019-12-14 16:31:37

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.

etc · 2019-12-14 17:07:17

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().

jakob · 2019-12-14 18:00:46

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.

colak · 2019-12-14 19:00:39

Hi boyandin

I have a modified txp v4.4.1 (r3575) which works just fine on PHP v5.4.45 and MySQL v5.6.45-86.1. The modifications mostly regard the yield instances but also some others. Do let me know if you want a copy to help you with the upgrade and I’ll zip it and upload it for you.

boyandin · 2019-12-14 23:22:50

Environment: Ubuntu 18.04.3, PHP 5.6.40/MySQL 5.7/Nginx:

@colak: thanks I would appreciate sending me that patched version.

@jakob: “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.”

This is what I attempted to do first. The initial (4.0.3) site state worked fine on the above environment, after proposed upgrade path (first to 4.2.0, the to the latest) I experienced the same set of errors I already saw on MariaDB 10.* environment.

@etc: what I see after an upgrade attempt 4.0.3 to 4.2.0:

Site fails with error:
Parse error: syntax error, unexpected ‘yield’ (T_YIELD), expecting ‘(’ in ./textpattern/publish/taghandlers.php on line 274

On admin pages I see:
Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from tp_txp_prefs as txp_prefs where prefs_id=1 AND user_name=’‘ in ./textpattern/lib/txplib_db.php on line 85

Notice: Undefined variable: language in ./textpattern/index.php on line 70

Strict Standards: Non-static method theme::init() should not be called statically in ./textpattern/index.php on line 95

Strict Standards: Non-static method theme::factory() should not be called statically in ./textpattern/lib/txplib_theme.php on line 95

Strict Standards: Non-static method theme::path() should not be called statically in ./textpattern/lib/txplib_theme.php on line 50

Strict Standards: Declaration of classic_theme::announce() should be compatible with theme::announce($thing = Array) in ./textpattern/theme/classic/classic.php on line 274

Last edited by boyandin (2019-12-14 23:30:53)

colak · 2019-12-15 06:39:53

boyandin wrote #320542:

Environment: Ubuntu 18.04.3, PHP 5.6.40/MySQL 5.7/Nginx:

@colak: thanks I would appreciate sending me that patched version.

Here it is. Note that the images and files directories are not included and neither is the config.php file.

boyandin · 2019-12-15 07:24:28

colak wrote #320545:

Here it is. Note that the images and files directories are not included and neither is the config.php file.

Downloaded, thank you!

Textpattern CMS

Textpattern CMS support forum

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

Re: Multiple problems upgrading from 4.0.3

Bloke wrote #319799:

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

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320180:

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

Re: Multiple problems upgrading from 4.0.3

etc wrote #320182:

#16 2019-12-14 16:04:55

Re: Multiple problems upgrading from 4.0.3

#17 2019-12-14 16:29:19

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320527:

#18 2019-12-14 16:31:37

Re: Multiple problems upgrading from 4.0.3

etc wrote #320528:

#19 2019-12-14 17:07:17

Re: Multiple problems upgrading from 4.0.3

#20 2019-12-14 18:00:46

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320527:

#21 2019-12-14 19:00:39

Re: Multiple problems upgrading from 4.0.3

#22 2019-12-14 23:22:50

Re: Multiple problems upgrading from 4.0.3

#23 2019-12-15 06:39:53

Re: Multiple problems upgrading from 4.0.3

boyandin wrote #320542:

#24 2019-12-15 07:24:28

Re: Multiple problems upgrading from 4.0.3

colak wrote #320545:

Board footer