4.5.7 > 4.7.1 login problem

Gallex · 2018-11-02 12:28:33

mysql is upgraded 5.1 to 5.6, php is upgraded to 7.0, new (4.7) login form appears but after inserting a username and password this error is appearing:

This server runs PHP version 5.3.3-7+squeeze19. Textpattern needs PHP version 5.4.0 or better.

the login page and all is started from this problem

what you suggest, what to check?

Gallex · 2018-11-02 12:44:15

errors at the top:

internal_error.

User_Error "Unknown column 'owner' in 'where clause'"
in /home/la01/sise_andrno/textpattern/lib/txplib_db.php at line 410.

adminErrorHandler()
textpattern/lib/txplib_db.php:410 trigger_error()
textpattern/lib/txplib_db.php:1136 safe_query()
textpattern/lib/txplib_db.php:984 startRows()
textpattern/vendors/Textpattern/L10n/Lang.php:553 safe_rows_start()
textpattern/vendors/Textpattern/L10n/Lang.php:580 Textpattern\L10n\Lang->extract()
textpattern/lib/txplib_misc.php:507 Textpattern\L10n\Lang->load()
textpattern/index.php:198 load_lang()

Last edited by Gallex (2018-11-02 14:28:15)

jakob · 2018-11-02 12:55:40

I think there are various posts on the forum for the first message.

For the second message, check you don’t have something in your htaccess that might still be setting your server back to php 5.3. Otherwise try uploading a phpinfo info to your server and calling the file. That should tell you what’s running on your server even if your control panel says something different. Remember to delete that file once you’re done with it.

Gallex · 2018-11-02 13:12:55

jakob wrote #314868:

Otherwise try uploading a phpinfo info to your server and calling the file. That should tell you what’s running on your server even if your control panel says something different. Remember to delete that file once you’re done with it.

it says PHP Version 5.3.3-7+squeeze19
looks like i just have to wait till host finishes php upgrade…

Gallex · 2018-11-02 14:27:05

php is now 7.0, but:

errors at the top:

internal_error.

User_Error "Unknown column 'owner' in 'where clause'"
in /home/la01/sise_andrno/textpattern/lib/txplib_db.php at line 410.

adminErrorHandler()
textpattern/lib/txplib_db.php:410 trigger_error()
textpattern/lib/txplib_db.php:1136 safe_query()
textpattern/lib/txplib_db.php:984 startRows()
textpattern/vendors/Textpattern/L10n/Lang.php:553 safe_rows_start()
textpattern/vendors/Textpattern/L10n/Lang.php:580 Textpattern\L10n\Lang->extract()
textpattern/lib/txplib_misc.php:507 Textpattern\L10n\Lang->load()
textpattern/index.php:198 load_lang()

i paste diagnostic tool whole text:

Textpattern version: 4.7.1 (8556b02a5a91658745d1d493ff8ab322)
Last update: 2014-11-30 12:55:42/2018-11-02 08:35:19
Site URL: www.indiaca.ee
Admin URL: www.indiaca.ee/textpattern
Document root: /home/la01/sise_andrno/ (/home/la01/sise_andrno)
$path_to_site: /home/la01/sise_andrno
Textpattern path: /home/la01/sise_andrno/textpattern
Article URL pattern: section_id_title
Production status: debug
open_basedir: /home/la01/sise_andrno/:/home/web-04/c04/wp-login
upload_tmp_dir: /home/la01/sise_andrno/tmp
Temporary directory path: /home/la01/sise_andrno/textpattern/tmp
PHP version: 7.0.30-0+deb9u1
GD Graphics Library: 2.2.4; Supported formats: GIF, JPEG, PNG.
Server timezone: Europe/Helsinki
Server local time: 2018-11-02 16:18:01
Daylight Saving Time enabled?: 0
Automatically adjust Daylight Saving Time setting?: 1
Time zone (GMT offset in seconds): Europe/Tallinn (7200)
MySQL: 5.5.30 (mariadb.org binary distribution) 
Database server time: 2018-11-02 16:18:01
Database server time offset: 0 s
Database server timezone: SYSTEM
Database session timezone: SYSTEM
Locale: en_GB.UTF-8
Site / Admin language: en-gb / en-gb
Web server: Apache/2.4.25 (Debian)
PHP server API: fpm-fcgi
RFC 2616 headers: 0
Server OS: Linux 4.9.0-6-amd64
Admin-side theme: hive 4.7.1
Active plugins: 
	adi_notes-1.3 (modified)
	rah_metas-1.5
	rah_sitemap-1.2 (modified)
	smd_calendar-0.53 (modified)
	upm_img_popper-1.3.7 (modified)

Pre-flight check: 
------------------------

problem_connecting_update_server

The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wifcontinued, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority.
------------------------

.htaccess file contents: 
------------------------
# BEGIN Textpattern
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes
#ErrorDocument 403 default

<IfModule mod_rewrite.c>
    RewriteEngine On
    #RewriteBase /relative/web/path/

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^(.+) - [PT,L]

    RewriteCond %{REQUEST_URI} !=/favicon.ico
    RewriteRule ^(.*) index.php

    RewriteCond %{HTTP:Authorization}  !^$
    RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>

<IfModule mod_mime.c>
    AddType image/svg+xml  svg svgz
    AddEncoding gzip       svgz
</IfModule>
# END Textpattern

------------------------

Last update check: 2018-11-02 14:37:20, problem_connecting_update_server 

Charset (default/config): utf8/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: utf8
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
collation_connection: utf8_general_ci
collation_database: latin1_swedish_ci
collation_server: utf8_unicode_ci
17 database tables: textpattern is latin1, txp_category is latin1, txp_css is latin1, txp_discuss is latin1, txp_discuss_ipban is latin1, txp_discuss_nonce is latin1, txp_file is latin1, txp_form is latin1, txp_image is latin1, txp_lang is latin1, txp_link is latin1, txp_log is latin1, txp_page is latin1, txp_plugin is latin1, txp_prefs is latin1, txp_section is latin1, txp_users is latin1

10 custom fields: custom_1, custom_2, custom_3, custom_4, custom_5, custom_6, custom_7, custom_8, custom_9, custom_10 (10)

/admin-themes/classic/classic.php: 
	61532c16e97ac04f6a77c40092320d06
/admin-themes/hive/assets/js/main.js: 
	5fb2157b7be591b0f1a64a81c0e07307
/admin-themes/hive/hive.php: 
	fde208a1e25dfb21a1d1ee77c519425b
/admin-themes/hiveneutral/assets/js/main.js: 
	5fb2157b7be591b0f1a64a81c0e07307
/admin-themes/hiveneutral/hiveneutral.php: 
	e64d0330d00d23537b4a88b8b9fbcbc7
/include/txp_admin.php: 
	7519b76848be7755f86597d129155956
/include/txp_article.php: 
	9c66b94aebc82cc904474cabda1e9fd1
/include/txp_auth.php: 
	72d54d6c6054c00bc86783f8e8932615
/include/txp_category.php: 
	12f668975bf70313ad35386bd827752b
/include/txp_css.php: 
	8015b08c023a3f417dae965aedb528db
/include/txp_diag.php: 
	9e9c6577e381521035bd049d52fa5f22
/include/txp_discuss.php: 
	b0996486020d9cbab51cd20914296cd5
/include/txp_file.php: 
	7f33658528146b1ffd0df5ffb2d126b0
/include/txp_form.php: 
	0efc3a4e844bf8718568dea69732c97c
/include/txp_image.php: 
	7228e07fc0e2087e67c73d197fbc001e
/include/txp_lang.php: 
	1d7fa0b9769fa392e828a00cc25e119b
/include/txp_link.php: 
	3512cfc219a63d6f16ca3907e53c86eb
/include/txp_list.php: 
	081f5f993f883fbec744fe35dbcb6186
/include/txp_log.php: 
	2b15c0f98935bfc039e14f25663b34e4
/include/txp_page.php: 
	bd08cefe5cd6ca981369b5f6542ec22d
/include/txp_pane.php: 
	ec55f252887a68f3e3dc6510dd1385a0
/include/txp_plugin.php: 
	d3b7bff80b7ab92009dd90953c10c149
/include/txp_prefs.php: 
	f8ce3cb291904b544fb2a5edadf9a408
/include/txp_section.php: 
	d1b68fe799d91073ae5d38e97f6f3dbd
/include/txp_skin.php: 
	242bc7272a7260d8f868baca8ac40f34
/include/txp_tag.php: 
	4a939325b676d76a439f2843ea64e36d
/index.php: 
	5964dc9960bd95415d257364bbd381df
/lib/admin_config.php: 
	73adea849578cfc3e1473c2973f75b8f
/lib/class.thumb.php: 
	de16440b4815129444a93683735d8ed0
/lib/class.trace.php: 
	055e3bc1f8d3217aec152fa7e6216b1d
/lib/classTextile.php: 
	f970ce6ae622ffc333dc5190d2a17132
/lib/constants.php: 
	6b1cc698a4688276a88be8b945eda8bb
/lib/IXRClass.php: 
	a1b525b4a9ed12dcb5677d5232a3d92e
/lib/PasswordHash.php: 
	66a8aa4b2d6e0527877a797907efc035
/lib/taglib.php: 
	0cafc9b259d5a45475eb47d36a0d6567
/lib/txplib_admin.php: 
	af75aee8d639a179bb5d81cedb78a54e
/lib/txplib_db.php: 
	076e203592ff394e894df1a39691d577
/lib/txplib_forms.php: 
	debea9cd565421f98994b95356ccc735
/lib/txplib_head.php: 
	9824fa30efa00d17fcd1d9c577c3708a
/lib/txplib_html.php: 
	51366d184a65853f23b2bf20a4547fb9
/lib/txplib_misc.php: 
	780c955e5259d6a8d4a16720a628eea9
/lib/txplib_publish.php: 
	cbb1f3a43db8c239f448370e42718cce
/lib/txplib_theme.php: 
	f9806970169bed7a6ac34248322eccce
/lib/txplib_update.php: 
	ddef7c647997652b6b56b04c64d9e203
/lib/txplib_validator.php: 
	d5e11546c01a75753e96589d9e16045a
/lib/txplib_wrapper.php: 
	8778abc96eff3ccb07f3bccca5304896
/publish/atom.php: 
	e932843e6ddf39b6c6d3b7054cac6e01
/publish/comment.php: 
	a8220d9baf3880f589efdcbc752c2a41
/publish/log.php: 
	e3a4b1a93c3baf9ac768ad77159e076b
/publish/rss.php: 
	e623973ce45c62d16ede7645e66d225a
/publish/search.php: 
	93270cd66dff1aad9b489c206a6f1896
/publish/taghandlers.php: 
	7fc369210429643a397de6bb48758e3e
/publish.php: 
	69459fdde7b3115c54d630db5c5dac94
/textpattern.js: 
	013b698ec4c78b67b7976478f0b2612d
/update/_to_4.0.3.php: 
	fb35e8e3dce16aad32b3d3af1a2b60c7
/update/_to_4.0.4.php: 
	7982d5063df84b7a2b1bb07660b8886b
/update/_to_4.0.5.php: 
	376bafd8685724e7c9e91b1a3ffe172f
/update/_to_4.0.6.php: 
	99493842f5994cc7f6eb88abde8433fe
/update/_to_4.0.7.php: 
	61a7ffaf8635067565fc2e8c22492e9e
/update/_to_4.0.8.php: 
	d70f2023c97b7e34ed03f953eb2ea434
/update/_to_4.2.0.php: 
	19629cf52c940b7a4a62a9c1cad9b303
/update/_to_4.3.0.php: 
	f39bccf59a1d1dd42fb5a2a351e583ac
/update/_to_4.5.0.php: 
	d5fe48683eb7ce2244829cb6cf3a36b2
/update/_to_4.5.7.php: 
	d2a0a8eaf49fb8b21292938d6bc81238
/update/_to_4.6.0.php: 
	f410119d42530763f483f4ac593192d6
/update/_to_4.7.0.php: 
	2c05d4f7054a53fb2acd1c868a9978a3
/update/_update.php: 
	5b0cf6653c06307f625de74c83c705d8
/vendors/blueimp/fileupload/jquery.fileupload.js: 
	cbf3e62ed9e9051e13cc708ee056c0bc
/vendors/jquery/jquery/jquery.js: 
	a09e13ee94d51c524b7e2a728c7d4039
/vendors/jquery/jquery-ui/jquery-ui.js: 
	0a497d4661df7b82feee14332ce0bdaf
/vendors/Netcarver/Textile/DataBag.php: 
	6564919a34daee6623cbc353dac4087e
/vendors/Netcarver/Textile/Parser.php: 
	18019ac0b4a64b4762d01c7a2795c756
/vendors/Netcarver/Textile/Tag.php: 
	b8d2d5ac8ddd65c82c220d5ab2fad15f
/vendors/PrismJS/prism/prism.js: 
	20ad36b691229c5bf6b6cd590713f089
/vendors/Textpattern/Adaptable/AdapterInterface.php: 
	2ca155f9022bee03d9883c92f5e7d0c8
/vendors/Textpattern/Adaptable/Providable.php: 
	5e4dafa7ef6ce91d1413f5d035cc32ff
/vendors/Textpattern/Adaptable/ProvidableInterface.php: 
	4fad6fb0ae3b9943659b6a75f506b836
/vendors/Textpattern/Admin/Paginator.php: 
	4b55b5293578dc6eab040b09f75121bf
/vendors/Textpattern/Admin/Table.php: 
	d35a33cd48b5239eb8b05fbf71f96eff
/vendors/Textpattern/Admin/Theme.php: 
	a78a1d2c5955c67d8b65caf612e5ef2c
/vendors/Textpattern/Admin/Tools.php: 
	670f0eb7288145e1db50565a82aa8218
/vendors/Textpattern/Container/Container.php: 
	c6d55480dbc432b804735cc0aa49991c
/vendors/Textpattern/Container/ContainerInterface.php: 
	eb0dd1cbd9cde8f1ca76f17ef3eab76b
/vendors/Textpattern/Container/FactorableInterface.php: 
	7a98d544cc82356752421cb4924e14d0
/vendors/Textpattern/Container/FactoryInterface.php: 
	eee6a60f5d451535194c3b5c0583e64a
/vendors/Textpattern/Container/ReusableInterface.php: 
	bd8353eee806eec630307fe66fb54d84
/vendors/Textpattern/Date/Timezone.php: 
	e6cb18891da6b037bc84e96dba68e105
/vendors/Textpattern/DB/Core.php: 
	ec78eb77f7275df574c202db3f3a06ea
/vendors/Textpattern/Filter/Exception.php: 
	20fbdefe757e2ffa10510ba79be15189
/vendors/Textpattern/Filter/FilterCallable.php: 
	acb6078b24a05165c39382952730854b
/vendors/Textpattern/Filter/StringFilter.php: 
	3da0ebbec1107a1b02284eb5ac61f579
/vendors/Textpattern/Http/Request.php: 
	b9b97359cccd2781cc2ee0879817fe75
/vendors/Textpattern/Import/TxpXML.php: 
	4f0ba2e86d1f4fc0d51df804fed2557d
/vendors/Textpattern/Iterator/FileIterator.php: 
	b2895983f4b522ba8fb43ec3e500233d
/vendors/Textpattern/Iterator/RecDirIterator.php: 
	c3cf59afe374c285fc6a64ca7bf6770f
/vendors/Textpattern/Iterator/RecFilterIterator.php: 
	5cb9d60bbfac498254e926fb64b03d58
/vendors/Textpattern/Iterator/RecIteratorIterator.php: 
	340ae698929f267f057570a34df42c8f
/vendors/Textpattern/L10n/Lang.php: 
	ddd53e294721297136ee3f2592dc30fb
/vendors/Textpattern/L10n/Locale.php: 
	d2b933aff0ee023b5c9d8def3682dd23
/vendors/Textpattern/Loader.php: 
	fe4190fbfea4f13bf6a664d9db6bd551
/vendors/Textpattern/Mail/Adapter/Mail.php: 
	36b0821f9d9888bb37442baa3db91989
/vendors/Textpattern/Mail/AdapterInterface.php: 
	be075beed5cadde10f47440efe0ca03c
/vendors/Textpattern/Mail/Compose.php: 
	5ecf483447802c5a8c0d0494655c2000
/vendors/Textpattern/Mail/Encode.php: 
	1659d9da0e6c537b51c7cbbb2bafd2c3
/vendors/Textpattern/Mail/Exception.php: 
	e9c6f012af13f5bb8a4e0804349aacea
/vendors/Textpattern/Mail/Message.php: 
	be327d690d66a40438ac856911011fdd
/vendors/Textpattern/Module/Help/HelpAdmin.php: 
	4fd0022798e29fbe9523549517661267
/vendors/Textpattern/Password/Adapter/PasswordHash.php: 
	bfb97efec8fae5c351bc51d5341b9824
/vendors/Textpattern/Password/AdapterInterface.php: 
	8597c3f7072fd8b3a206743518e1d8ef
/vendors/Textpattern/Password/Generator.php: 
	20daccd1ad9cee8e00ef4f82142aa6a3
/vendors/Textpattern/Password/Hash.php: 
	128b26b0e60ad004c5daaabf8ff15e7f
/vendors/Textpattern/Password/Random.php: 
	7cbfbdb00fa7ae08f8208b5e9ccf8fb8
/vendors/Textpattern/Plugin/Plugin.php: 
	65ec5f4534ab90aac613b92c95e380c5
/vendors/Textpattern/Search/Filter.php: 
	b253d6fd147f0efa2eb5a3c7b86e8fca
/vendors/Textpattern/Search/Method.php: 
	cbe44bf2aeaf6b7b0a9a871b9deb10c3
/vendors/Textpattern/Security/Exception.php: 
	af306a7a85a6be2670129ffe252f691a
/vendors/Textpattern/Security/Filter.php: 
	fbf3003e02a71583fc5559426afe45da
/vendors/Textpattern/Server/Config.php: 
	e463474cd15b931918cc3c1d353948ea
/vendors/Textpattern/Server/Files.php: 
	b31726c28b4b3c8f634b292f414d167b
/vendors/Textpattern/Skin/AssetBase.php: 
	16ddb12dd47d745ad33870d84ebea819
/vendors/Textpattern/Skin/AssetInterface.php: 
	95e540133825dd2acf73abed73a88c4a
/vendors/Textpattern/Skin/CommonBase.php: 
	17e0cba2250301d03f15f3bddc3328d5
/vendors/Textpattern/Skin/CommonInterface.php: 
	1bafe4ac2c65b31e5b17a93cedaf36c6
/vendors/Textpattern/Skin/Css.php: 
	f5e16c5c422bdaba7f65e87216267c67
/vendors/Textpattern/Skin/CssInterface.php: 
	605dc4c98cf6e47e8cd0fae7e27012ea
/vendors/Textpattern/Skin/Form.php: 
	45e47c023fbbaa3947d06d51336c0d72
/vendors/Textpattern/Skin/FormInterface.php: 
	8e5a25e49668d42b29935d42ae720a10
/vendors/Textpattern/Skin/Page.php: 
	935eccac8dc3e9df75b720c1b2f9888e
/vendors/Textpattern/Skin/PageInterface.php: 
	f54a7c0e7beb3343d357a6ce5397f4fa
/vendors/Textpattern/Skin/Skin.php: 
	6ea549e1c5a2d21132b97cbadede6638
/vendors/Textpattern/Skin/SkinInterface.php: 
	f9c8f4340ab0bdd2658821d983a77ca2
/vendors/Textpattern/Tag/Registry.php: 
	d651ad90f6d87838fdfbf43cd8d457c4
/vendors/Textpattern/Tag/Syntax/Authors.php: 
	86a6154bd08e73319762b3387cdfb92a
/vendors/Textpattern/Tag/Syntax/File.php: 
	3f730fdaa76ca355b27ccb7478396258
/vendors/Textpattern/Tag/Syntax/Image.php: 
	c1319e2289fa56d0ab97cfc84b9f1496
/vendors/Textpattern/Tag/Syntax/Link.php: 
	3f8f78ef3580df9051df295122a6ff83
/vendors/Textpattern/Tag/Syntax/Partial.php: 
	798581ba13a2fa245a9a2a29bd8268a7
/vendors/Textpattern/Textfilter/Base.php: 
	148b6267831d35d6a8db15d1cd2ccdaf
/vendors/Textpattern/Textfilter/Constraint.php: 
	0f991e221704033b340b4627cd3bd8d7
/vendors/Textpattern/Textfilter/Nl2Br.php: 
	120fc5128e0feca793fef7554dc6e3c5
/vendors/Textpattern/Textfilter/Plain.php: 
	3db6d32fc7a0977de52c190fef26e444
/vendors/Textpattern/Textfilter/Registry.php: 
	2e72f55326955288956d3f073d80685b
/vendors/Textpattern/Textfilter/TextfilterInterface.php: 
	c4fed4b35a6192a99f4156096afa66dd
/vendors/Textpattern/Textfilter/Textile.php: 
	7cdebba481fca095d7217ae7d0d594bf
/vendors/Textpattern/Textile/Parser.php: 
	89adf00249564a589da43900def4aeec
/vendors/Textpattern/Textpack/Parser.php: 
	c1c16982cb729bbffacaf95ad962a4c6
/vendors/Textpattern/Textpack/String/Iterator.php: 
	8ec5882fd003c8944dfde641acccc0f7
/vendors/Textpattern/Textpack/StringInterface.php: 
	4b8188cd9e878f46e4f259525ae79d3c
/vendors/Textpattern/Type/StringType.php: 
	ac453a1d358a749aa5191bd68ce19a75
/vendors/Textpattern/Type/TypeCallable.php: 
	c52efaafaa97590c9c9c981d8f3ce998
/vendors/Textpattern/Type/TypeInterface.php: 
	0f44c97964b9c8918eb50df4dc4e8d2e
/vendors/Textpattern/Validator/BlankConstraint.php: 
	1382f7d7ec14085c9a845c05392a83c4
/vendors/Textpattern/Validator/CategoryConstraint.php: 
	1905d8a0caf31c928d278179948c4f2c
/vendors/Textpattern/Validator/ChoiceConstraint.php: 
	bb2acc51b1deffe94c5d35778d4d61fc
/vendors/Textpattern/Validator/Constraint.php: 
	19c8680ea34aab9205edb4953f8c3e48
/vendors/Textpattern/Validator/FalseConstraint.php: 
	bb26fc272d022d75db704425d2daef10
/vendors/Textpattern/Validator/FormConstraint.php: 
	3c102f4fd6901ab16cc168322af37e1d
/vendors/Textpattern/Validator/SectionConstraint.php: 
	d6c469fc4e538dc86a5173687965af93
/vendors/Textpattern/Validator/TrueConstraint.php: 
	b1d6b1cb9aac086af40aed4353762cfd
/vendors/Textpattern/Validator/Validator.php: 
	1c4ce4a0f834099e65cf20a3efc9b744
/vendors/Txp.php: 
	2b5fddedc158ac643a1e1bdab917932f
/../css.php: 
	2277486a44bb8c84a10546439a8d0c18
/../index.php: 
	3c7de42a5a7ab5e8a14348fe03b56c6c

------------------------

and all menu links have prefix tab_ :)

philwareham · 2018-11-02 15:50:22

Long shot, but have you tried to force re-install language file? e.g. go to languages panel, install/update ‘English’ and changed your UI/Site to use that. Remove and then re-install your preferred language and then switch the UI/Site back to your language?

jakob · 2018-11-02 16:37:55

"Unknown column 'owner' in 'where clause'"

This is one of those errors that have resulted from the upgrade function not completing properly. There’s been quite some discussion on this in another thread and I believe the dev version has some potential fixes, but in the past I have made a copy of the DB and then step-by-step executed the MySQL commands directly to the DB to add the missing columns. If you look at the code in the update folder you can see what has been changed…

Maybe someone else has a better tip for you…

Gallex · 2018-11-03 11:59:27

philwareham wrote #314872:

Long shot, but have you tried to force re-install language file? e.g. go to languages panel, install/update ‘English’ and changed your UI/Site to use that. Remove and then re-install your preferred language and then switch the UI/Site back to your language?

no languages has been installed and it doesn’t allow to install any :(

Gallex · 2018-11-03 12:42:19

changed mysql back to 5.1 in config file, reinstalled txp – database unavailable. brr, how so…? it’s in a phpmyadmin, i haven’t deleted it

Last edited by Gallex (2018-11-03 12:44:36)

Gallex · 2018-11-03 12:55:05

jakob wrote #314874:

"Unknown column 'owner' in 'where clause'"...
but in the past I have made a copy of the DB and then step-by-step executed the MySQL commands directly to the DB to add the missing columns.

i’m afraid that i can’t do this. :(

If you look at the code in the update folder you can see what has been changed…

folder code? you mean which files has been changed?
all but to_ 1.0.0, 4.0.2, 4.4.0, 4.4.1.

jakob · 2018-11-03 13:19:20

Gallex wrote #314887:

changed mysql back to 5.1 in config file, reinstalled txp – database unavailable. brr, how so…? it’s in a phpmyadmin, i haven’t deleted it

That just sounds like something wrong in the config.php or a change in your mysqluser password or db-name.

i’m afraid that i can’t do this. :(

Another idea instead of manually doctoring the database: I found where Oleg had made a possible fix for the update problem (not released yet) and you could try that. With luck it may allow the full update to run.

First, leave MySQL at 5.7 or whatever your most recent version was and re-upload your old pre-update database from Txp v4.5.7 (I hope you had a copy, right?) but don’t call up your site just yet.

Go here, click on the button marked “Raw” and then save that file as /textpattern/update/_to_4.6.0.php, overwriting the existing one from your clean 4.7.1 files. Now try logging in to your site and it should run the entire update routine this time (if it still doesn’t please report in as much detail as possible as Oleg has written “real-life tests needed”).

If you want to know what changed see here. As far as I’ve understood it, it disables the ‘no zero dates’ restriction that caused the update routine to sometimes fail mid-way before completion, then re-enables it after the update routine is done.

Gallex · 2018-11-03 13:24:02

problem solved.
exported again 5.1 database to 5.6 database and reinstalled txp and all started to work!
very sorry guys for this!

Last edited by Gallex (2018-11-03 13:27:44)

Textpattern CMS

Textpattern CMS support forum

#1 2018-11-02 12:28:33