Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,064
Website GitHub Mastodon Twitter

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 | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#26 2020-09-01 11:03:22

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Hi there,
I’m back from holidays and back at work with my one Textpattern Install from Hell ,-)

To sum up: trying to update from 4.6.2 to 4.8.2, none of the tips above have helped, making a copy of the site now to be able to freely edit the database to hopefully find & eliminate any culprits.

Wish me luck!

Offline

#27 2020-09-01 22:10:30

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,702
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

If you can look at the database, take a look at the txp_prefs table and see what value is given for the version entry. In rare cases that needs resetting to make it run through the update steps.

If you need some help getting it working again, you’re welcome to send me an email.

Otherwise: good luck!! :-)


TXP Builders – finely-crafted code, design and txp

Offline

#28 2020-09-02 12:32:57

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Jakob, besten Dank! The version is exactly what I’ll be focussing on, as I had trouble with the entry in a previous update.

Offline

#29 2020-09-02 13:09:21

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Okay … this is what happened in the copy:

I deactivated plugins and logged off, then I copied the 4.8.2 files over.

When logging back in, the frontend was gone, with an unkonown section error.
I logged in and found the following errors:

The last ones were easily fixed by deleting the dir and changing permissions. The first ones disappeared after I looked into SQL and found that in txp_prefs the version was actually still at 4.6.2

I changed that to 4.8.2 and all errors disappeared. I then looked at the language tab and deleted de-de which has been replaced by de.

But … still, no frontend.

When I went to sections, it looked like this v v v below. There were no themes, and all pages were empty … no forms, too. No frontend code at all.

So, the good thing is, I can probably get back to a working site by copying all templates over manually, into a new theme. But why weren’t the old templates recognized?

Offline

#30 2020-09-03 11:58:54

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Okay, I can’t create a theme … “Themes creation failed”. Any ideas? Could I manually add the table for a theme to help me get going?

Offline

#31 2020-09-03 12:32:54

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

So I’ve copied the txp_skin from another installation. However, all my related database tables miss columns, e.g. txp_page is missing both skin and lastmod:

Could anybody help me out with an SQL command to create the columns in question?

Any other place that might need additional columns, except txp_page, txp_form oh and txp_section?
Are there any other new fields that my installation may be missing?

Offline

#32 2020-09-03 12:50:23

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

PS when in debug mode, I get the following errors in front end:

Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:3297 fetch_page()
textpattern/publish.php:740 parse_page()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:3297 fetch_page()
textpattern/publish.php:740 parse_page()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Unknown section

Offline

#33 2020-09-03 13:57:40

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #325731:

I looked into SQL and found that in txp_prefs the version was actually still at 4.6.2

I changed that to 4.8.2 and all errors disappeared.

I guess that’s why the update script did not run. Have you tried reverting it back to 4.6.2?

Offline

#34 2020-09-03 14:00:46

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

etc, do you mean I should revert it to 4.6.2 and then re-run the update script directly at _update.php?

Offline

#35 2020-09-03 14:09:49

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

txp should run update itself when you access the backend and version pref does not match txp version.

Offline

#36 2020-09-03 14:35:02

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Yay, that worked! Front end is back. Phew …

There are a few errors from deprecated tags, but, so far, nothing major.

Merci bien, etc!

Offline

Board footer

Powered by FluxBB