Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

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

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: 9,637
Website

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: 139
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
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,076

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

#25 2020-07-16 14:47:52

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,159
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

or

forum.textpattern.com/viewtopic.php?id=50844
forum.textpattern.com/viewtopic.php?pid=310901#p310901
forum.textpattern.com/viewtopic.php?id=47268
etc

Do check the forum for textpattern/lib/txplib_misc.php:1676 adminErrorHandler and you’ll get more results.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github | Covid-19; a resource
I do my best editing after I click on the submit button.

Offline

Board footer

Powered by FluxBB