Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2018-11-03 21:12:36

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

etc wrote #314908:

Great! Have you used _to_4.6.0.php from 4.7.1 or 4.7.2, please?

Yes! oops: from 4.7.2.

Last edited by jayrope (2018-11-03 21:13:14)


A hole turned upside down is a dome, when there’s also gravity.

Offline

#14 2018-11-03 21:16:19

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Thanks, you are the first “live” tester! :-) Hopefully, MySQL 5.3 switch headache is gone in 4.7.2.

Offline

#15 2018-11-03 21:19:30

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

On a minor note diagnostics tell me, that
- the files directory isn’t writable although permissions are 770 (solved, path was wrong in prefs), and
- “The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: syslog.”

Is that problematic?

Last edited by jayrope (2018-11-03 21:22:38)


A hole turned upside down is a dome, when there’s also gravity.

Offline

#16 2018-11-03 21:20:24

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

jayrope wrote #314909:

Regarding updating to 4.2.0 first: No i didn’t do this. I am aware that this procedure existed, but the update notes for 4.7.1 have put the note into a subpage so that i has escaped my attention.
:(
What kind of possible errors could i get now?

Frankly, I don’t remember, Stef (Bloke) is the right person here.

Offline

#17 2018-11-03 21:21:33

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

jayrope wrote #314912:

On a minor note diagnostics tell me, that
- the files directory isn’t writable although permissions are 770, and
- “The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: syslog.”

Is that problematic?

Yes for files upload, no for syslog.

Offline

#18 2018-11-03 21:24:15

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 687
Website Mastodon

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

etc wrote #314914:

Yes for files upload, no for syslog.

Thanx a bunch, solved the files, path was wrong in preferences.
Hmm, well, then i guess i#ll do a DB backup again quick and work on as if nothing has happened ,) Thank you very much, etc and Uli!


A hole turned upside down is a dome, when there’s also gravity.

Offline

#19 2018-11-16 10:58:45

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 153
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Worked for me as well!

#314908:

FIX:
— Uploaded Textpattern 4.7.1 to server
— Made two empty files, _to_1.0.0.php and _to_4.0.2.php in update folder
and used _to_4.6.0.php from dev version 4.7.2 @ github
— Then ran /textpattern/update/update.php directly

Frontend and backend are back, languages are updated, yay!

Offline

#20 2018-11-16 11:26:45

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #315301:

Made two empty files, _to_1.0.0.php and _to_4.0.2.php in update folder

Hmmm, maybe we shouldn’t have removed them. Perhaps the upgrade script from very old versions expects them to exist for reasons I can’t quite fathom right now. It’s no hardship to add those empty files back into Txp 4.7.2 if it helps upgradeability.

Anyone have any insight why this might be necessary? Or if we can work around it?


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

Offline

#21 2018-11-16 11:31:54

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Bloke wrote #315305:

Hmmm, maybe we shouldn’t have removed them. Perhaps the upgrade script from very old versions expects them to exist for reasons I can’t quite fathom right now. It’s no hardship to add those empty files back into Txp 4.7.2 if it helps upgradeability.

Since the files are gone (dunno why and when), I have removed their includes in 4.7.2 _update.php. That’s all I know…

Offline

#22 2018-11-16 11:38:15

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

etc wrote #315306:

Since the files are gone (dunno why and when), I have removed their includes in 4.7.2 _update.php.

Ahhh, that explains it. I see now that they’re referenced in 4.7.1’s _update.php but the files themselves were removed. Oopsie. In which case, having those DB entries removed from the _update.php array in 4.7.2 should fix things. Nice one. We should probably mention that in HISTORY.txt when we talk about improving the upgrade experience.

Last edited by Bloke (2018-11-16 11:39:33)


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

Offline

#23 2020-07-16 11:38:45

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 153
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #315301:

Worked for me as well!

FIX:
— Uploaded Textpattern 4.7.1 to server
— Made two empty files, _to_1.0.0.php and _to_4.0.2.php in update folder
and used _to_4.6.0.php from dev version 4.7.2 @ github
— Then ran /textpattern/update/update.php directly

Frontend and backend are back, languages are updated, yay!

Ups. I have the exact same problem after trying to update from 4.6.2 to 4.8.1 in preparation for a PHP update from 5.5 to 7.4 … Textpattern backend is available, frontend is gone with error “Unknown section”. In backend there’s a couple error notes, see below.

Oh and the above solution fails …

Any ideas??

User_Error "Unknown column 'prefs_id' in 'field list'"
in /data/www/medienforum/textpattern/lib/txplib_db.php at line 409.
textpattern/lib/txplib_misc.php:1676 adminErrorHandler()
updateErrorHandler()
textpattern/lib/txplib_db.php:409 trigger_error()
textpattern/lib/txplib_db.php:483 safe_query()
textpattern/update/_to_1.0.0.php:203 safe_insert()
textpattern/update/_update.php:90 include()
textpattern/index.php:180 include()

Offline

#24 2020-07-16 12:40:51

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,271
GitHub

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #324577:

Any ideas??

User_Error "Unknown column 'prefs_id' in 'field list'"...

textpattern/lib/txplib_misc.php:1676 adminErrorHandler()...

forum.textpattern.com/viewtopic.php?pid=314124#p314124 might be helpful.

Offline

Board footer

Powered by FluxBB