Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2024-01-18 19:39:19

MrLongbaugh
Member
From: Hamburg - Germany
Registered: 2004-10-11
Posts: 116

Problem updating from previous version to 4.8.8

It seems that FTP did not update all files in the folder textpattern.
Now I get these messages:
Uncaught mysqli_sql_exception: Unknown column ‘skin’ in ‘field list’
I guess that the db was not properly updated.
Can I start the update process again? Any other suggestions?

Offline

#2 2024-01-19 08:53:51

etc
Developer
Registered: 2010-11-11
Posts: 5,053
Website GitHub

Re: Problem updating from previous version to 4.8.8

The result depends on how far the update process has run, but it should be safe to retry. What is version value in txp_prefs db table?

Offline

#3 2024-01-19 09:06:07

MrLongbaugh
Member
From: Hamburg - Germany
Registered: 2004-10-11
Posts: 116

Re: Problem updating from previous version to 4.8.8

value is 4.8.8
thanks for helping!

Last edited by MrLongbaugh (2024-01-19 09:06:34)

Offline

#4 2024-01-19 09:21:04

etc
Developer
Registered: 2010-11-11
Posts: 5,053
Website GitHub

Re: Problem updating from previous version to 4.8.8

MrLongbaugh wrote #336413:

value is 4.8.8

Ah, that’s problematic. You can try changing it to the previously installed version and run update again, but backup first please.

Offline

#5 2024-01-19 12:11:10

MrLongbaugh
Member
From: Hamburg - Germany
Registered: 2004-10-11
Posts: 116

Re: Problem updating from previous version to 4.8.8

Thanks a lot. Perfect Tipp.
The page is running again.

Only one thing: under “Presentation”: “Pages, “Forms” and “Styles” have no content.
As the page is working, it seems that Textpatttern is using pages, forms und styles but not showing them in backend.

Offline

#6 2024-01-19 12:15:19

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,269
Website GitHub

Re: Problem updating from previous version to 4.8.8

Glad it’s at least running again.

Missing admin content is likely to be a database collation issue. If you can, temporarily switch on debugging mode in prefs and visit your Pages/Forms/Styles panel to see if it spits any warnings. Then flick the pref back to Live.

If it complains about a mix of collations, we can go from there to find the culprit and tweak your connection settings or DB table collation so everything runs smoothly.

Btw, are you running rah/etc_flat for template management?


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

#7 2024-01-19 12:29:23

MrLongbaugh
Member
From: Hamburg - Germany
Registered: 2004-10-11
Posts: 116

Re: Problem updating from previous version to 4.8.8

Switching on debugging mode gave no extra output at Pages/Forms/Styles but on Admin/Preferences:

8192 "Function strftime() is deprecated"
in /home/web77/public_html/textpattern/lib/txplib_misc.php at line 2787.
textpattern/lib/txplib_misc.php:2787 adminErrorHandler()
textpattern/include/txp_prefs.php:631 safe_strftime()
textpattern/include/txp_prefs.php:376 dateformats()
textpattern/include/txp_prefs.php:282 pref_func()
textpattern/include/txp_prefs.php:45 prefs_list()
textpattern/index.php:230 include()

Thanks for your answer

Offline

#8 2024-01-19 12:40:41

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,269
Website GitHub

Re: Problem updating from previous version to 4.8.8

Hmm maybe it’s not collation then. That’s the usual culprit. Pretty sure it complains in debugging mode. But maybe it doesn’t any more.

Just to be sure, what does you High Diagnostics report about collation info?


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

#9 2024-01-19 13:25:13

MrLongbaugh
Member
From: Hamburg - Germany
Registered: 2004-10-11
Posts: 116

Re: Problem updating from previous version to 4.8.8

Is this the data you asked for?

collation_connection: utf8mb3_general_ci
collation_database: latin1_swedish_ci
collation_server: utf8mb4_0900_ai_ci

Offline

#10 2024-01-19 13:48:15

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,269
Website GitHub

Re: Problem updating from previous version to 4.8.8

Yes. With three different collations in use, my money is still on that.

It would probably help a bit if your connection collation was the same as your server. Pretty sure you can configure that in config.php.

But I think the disparity between Latin and utf8 is more likely the key. After backing up your database I would be tempted to try changing your txp_pages table and columns to one of the utf8mb_* collations. Then visit your Pages panel and see if stuff shows up. If it does, do the same with txp_css and txp_forms. And, in fact, any table that shows a Latin collation.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Online

Board footer

Powered by FluxBB