Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2018-10-22 10:13:35

claus
Member
From: Remseck / Neckar
Registered: 2007-05-23
Posts: 20
Website

[solved] Updating problem: Unknown column 'author' in 'txp_file'"

Hello!
I did an update from 4.5 to 4.7 this didn’t work out so i updated to 4.6
Now the site is up & running but in the backend i can only access the Language-panel and on top of the page is this warning:

User_Error “Unknown column ‘author’ in ‘txp_file’”
in /is/htdocs/wp1055590_YDHXQ6HXHH/www/cwde/textpattern/lib/txplib_db.php at line 405.

textpattern/lib/txplib_misc.php:1676 adminErrorHandler() updateErrorHandler() textpattern/lib/txplib_db.php:405 trigger_error() textpattern/lib/txplib_db.php:532 safe_query() textpattern/update/_to_4.6.0.php:82 safe_alter() textpattern/update/_update.php:84 include() textpattern/index.php:180 include()

What to do? Alter the MYSQL-DB? tried to upload older scripts but that didn’t work.
Any Idea?
Thanks a Lot

Claus

Last edited by claus (2018-10-22 14:27:23)

Offline

#2 2018-10-22 10:52:35

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

Re: [solved] Updating problem: Unknown column 'author' in 'txp_file'"

Hi Claus,

from what I can see, your site is still running 4.5.7 and trying to update to 4.6.0 when you visit the admin side. The weird thing is missing author column in txp_file table, it should be there since 4.2.0. If you can, please check `txp_file` (and also `txp_link` and `txp_image`) table structure and add author VARCHAR(64) NOT NULL field if missing. You’d also need to create indexes if this works, but first things first.


etc_[ query | search | pagination | date | tree | cache ]

Offline

#3 2018-10-22 14:26:56

claus
Member
From: Remseck / Neckar
Registered: 2007-05-23
Posts: 20
Website

Re: [solved] Updating problem: Unknown column 'author' in 'txp_file'"

Hi etc,

Yesh! This did the trick. Thanx a lot! Also you friendly forced me after 13 years of web-development to run my first direct SQL-Statement. Magnificent!

Now what about the Indexes you have mentioned? I made a short websearch and think I got the idea but have – as a MySQL-Newbie no Idea how to proceed. And the database is running – so what should i do for best practice?

Thanx a lot again!
Claus

Last edited by claus (2018-10-22 14:44:35)

Offline

Board footer

Powered by FluxBB