[SOLVED] error on upgrade 4.4.1 > 4.7.1

Gallex · 2018-08-29 06:56:33

User_Error "Unknown column 'ip' in 'txp_log'"
in /home/clients/www.sisekujundus.ee/www/textpattern/lib/txplib_db.php at line 410.
textpattern/lib/txplib_misc.php:1715 adminErrorHandler()
updateErrorHandler()
textpattern/lib/txplib_db.php:410 trigger_error()
textpattern/lib/txplib_db.php:545 safe_query()
textpattern/update/_to_4.5.7.php:32 safe_alter()
textpattern/update/_update.php:91 include()
textpattern/index.php:214 include()

diagnostic tool:

Textpattern version: 4.7.1 (8556b02a5a91658745d1d493ff8ab322)
Last update: 2018-08-29 06:45:34/2018-08-28 10:14:36
Site URL: www.sisekujundus.ee
Admin URL: www.sisekujundus.ee/textpattern
Document root: /home/clients/www.sisekujundus.ee/www
$path_to_site: /home/clients/www.sisekujundus.ee/www
Textpattern path: /home/clients/www.sisekujundus.ee/www/textpattern
Article URL pattern: messy
Production status: live
open_basedir: /home/clients/www.sisekujundus.ee:/usr/share/php
upload_tmp_dir: /home/clients/www.sisekujundus.ee/tmp
Temporary directory path: /home/clients/www.sisekujundus.ee/www/textpattern/tmp
PHP version: 7.0.31-1~dotdeb+8.1
GD Graphics Library: bundled (2.1.0 compatible); Supported formats: GIF, JPEG, PNG.
Server timezone: UTC
Server local time: 2018-08-29 06:54:48
Daylight Saving Time enabled?: 1
Automatically adjust Daylight Saving Time setting?: 1
Time zone (GMT offset in seconds): Europe/Tallinn (7200)
MySQL: 5.6.38-log (MySQL Community Server (GPL)) 
Database server time: 2018-08-29 09:53:24
Database server time offset: -83 s
Database server timezone: SYSTEM
Database session timezone: SYSTEM
Locale: C
Site / Admin language: en-gb / en
Web server: nginx
PHP server API: fpm-fcgi
RFC 2616 headers: 0
Server OS: Linux 3.16.0-4-amd64
...

colak · 2018-08-29 10:39:51

User_Error "Unknown column 'ip' in 'txp_log'"

This is strange! I do not think that there is an ip column anymore in the latest txp. Did you upgrade your languages? Did you force refresh the admin site?

Gallex · 2018-08-29 11:28:54

colak wrote #313684:

This is strange! I do not think that there is an ip column anymore in the latest txp. Did you upgrade your languages?

i have only british english installed and yes, it’s up to date.

Did you force refresh the admin site?

yes, a lot.

uploaded textpattern folder once more. same.
diagnostic tool also not recognizing the version, still recommends to install 4.7.1

colak · 2018-08-29 16:15:46

Maybe the installer did not delete the IP column. Do you have a backup of your pre upgrade db? Maybe you should try to upgrade it more gradually. ie. 4.4.1>4.6>4.7.1

colak · 2018-08-30 05:53:49

Or maybe before you do the above you can try deleting the ip column.

etc · 2018-08-30 07:14:48

It looks like ip column of txp_log table has already been deleted prior to 4.7 upgrade.

Gallex · 2018-08-30 08:10:51

colak wrote #313694:

Maybe the installer did not delete the IP column. Do you have a backup of your pre upgrade db? Maybe you should try to upgrade it more gradually. ie. 4.4.1>4.6>4.7.1

no, i don’t have backup of database.
i try this: downgrade to 4.4.1 and then upgrade 4.4.1 > 4.6 > 4.7.1. could this help, what you think?

PS. site itself works fine – no errors on public side. and i can change and save everything in admin side, but this error message stays at the top all the time and also pop ups all the time then i’m saving something.

Last edited by Gallex (2018-08-30 08:45:54)

jakob · 2018-08-30 08:59:40

Have a look in your database at what you have in the row version in the table txp_prefs (or look with smd_prefalizer). I remember having problems with updates from very old versions and had to manually edit it to get the update script to trigger, which then silences the error.

Gallex · 2018-08-30 09:29:48

jakob wrote #313716:

Have a look in your database at what you have in the row version in the table txp_prefs (or look with smd_prefalizer). I remember having problems with updates from very old versions and had to manually edit it to get the update script to trigger, which then silences the error.

the only thing that textpattern won’t let me do, is activate/deactivate the plugins. :(
looks like i have to contact with host…

uli · 2018-08-30 09:53:06

Gallex wrote #313719:

the only thing that textpattern won’t let me do, is activate/deactivate the plugins. :(
looks like i have to contact with host…

Such behaviour might be due to a textpattern/textpattern.js file from cache. And for jakob’s proposal you don’t need a plugin. Changing/erasing the TXP version number can be done with phpMyAdmin or similar.

gaekwad · 2018-08-30 10:03:57

My helpful tip for Textpattern upgrades to be absolutely sure there are no cached files: use Tor browser. Start a new session for each site. By default, Tor does not store any cached files – take advantage of that and it becomes a useful tool for the Textpattern administrator.

Gallex · 2018-08-30 10:13:03

uli wrote #313720:

Such behaviour might be due to a textpattern/textpattern.js file from cache. And for jakob’s proposal you don’t need a plugin. Changing/erasing the TXP version number can be done with phpMyAdmin or similar.

i have host who don’t let me to access phpMyAdmin.
and what txp version should be there, 4.7.1? i need to give instructions to them.
and after this, i just need to reinstall and don’t worry anymore with this below, it should disappear?
User_Error "Unknown column 'ip' in 'txp_log'"

Textpattern CMS

Textpattern CMS support forum

#1 2018-08-29 06:56:33