Textpattern CMS support forum

You are not logged in. Register | Login | Help

#11 2018-11-03 13:19:20

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,302
Website

Re: 4.5.7 > 4.7.1 login problem

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.


TXP Builders – finely-crafted code, design and txp

Offline

#12 2018-11-03 13:24:02

Gallex
Member
Registered: 2006-10-08
Posts: 1,103

Re: 4.5.7 > 4.7.1 login problem

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)

Offline

#13 2018-11-03 13:37:13

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,302
Website

Re: 4.5.7 > 4.7.1 login problem

Glad you got it working.

Just to clarify, did you run the update first under MySQL 5.1, then ran the textpattern update routine, then switched mySQL to 5.6 or 5.7. That could work as older versions of MySQL weren’t so strict about date formats.


TXP Builders – finely-crafted code, design and txp

Offline

#14 2018-11-03 16:38:23

Gallex
Member
Registered: 2006-10-08
Posts: 1,103

Re: 4.5.7 > 4.7.1 login problem

little rushed. all still not working :(
i can’t upload images, error says: No valid temporary directory was found. Please consult your website host. but it is and permissions set 0777 and path is correct under preferencies.
also can’t install plugins.

diagnostic says nothing but this:

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. Help

Offline

#15 2018-11-03 18:01:04

jakob
Moderator
From: Germany
Registered: 2005-01-20
Posts: 3,302
Website

Re: 4.5.7 > 4.7.1 login problem

Gallex wrote #314892:

i can’t upload images, error says: No valid temporary directory was found. Please consult your website host. but it is and permissions set 0777 and path is correct under preferencies.
also can’t install plugins.

That was your original problem, right?

Regarding the tmp directory, double check all your paths really are correct and are in your allowed public directories. Also try setting another path and see if that works any better.

Another thing you could check is the folder owner. Most FTP programs will show that. Maybe there’s a mismatch there, though 777 should still permit that? My host, for example, offers a means in its control panel to reset permissions for certain directories, and that can sometimes resolve stubborn cases. It doesn’t happen often, though.

Otherwise, put the site in debug mode and see if it gives you any more hints. There’s post about plugins here. It maybe worth checking your database collations …

The following PHP functions … are disabled on your server: pcntl_alarm, pcntl_fork, …

They are not an issue. There’s a thread on that and the warnings have been removed from the next version.


TXP Builders – finely-crafted code, design and txp

Offline

#16 2018-11-03 20:21:23

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

Re: 4.5.7 > 4.7.1 login problem

Gallex wrote #314892:

diagnostic says nothing but this:

What does it say about upload_tmp_dir and Temporary directory path?


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

Offline

#17 2018-11-03 22:22:22

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 638
Website

Re: 4.5.7 > 4.7.1 login problem

Gallex, is your site hosted with Hosteurope?


a hole turned upside down is a dome, though only when there’s gravity.

Offline

#18 2018-11-04 08:34:43

Gallex
Member
Registered: 2006-10-08
Posts: 1,103

Re: 4.5.7 > 4.7.1 login problem

etc wrote #314897:

What does it say about upload_tmp_dir and Temporary directory path?

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

Offline

#19 2018-11-04 08:35:18

Gallex
Member
Registered: 2006-10-08
Posts: 1,103

Re: 4.5.7 > 4.7.1 login problem

jayrope wrote #314917:

Gallex, is your site hosted with Hosteurope?

no

Offline

#20 2018-11-04 09:09:58

Gallex
Member
Registered: 2006-10-08
Posts: 1,103

Re: 4.5.7 > 4.7.1 login problem

jakob wrote #314893:

That was your original problem, right?

yes, it all started from this

Regarding the tmp directory, double check all your paths really are correct and are in your allowed public directories. Also try setting another path and see if that works any better.

everything looks correct.
temporary directory path and plugin cache directory path under preferences: /home/la01/sise_andrno/textpattern/tmp

Another thing you could check is the folder owner. Most FTP programs will show that. Maybe there’s a mismatch there, though 777 should still permit that? My host, for example, offers a means in its control panel to reset permissions for certain directories, and that can sometimes resolve stubborn cases. It doesn’t happen often, though.

changed 0444, diagnostic said: temporary directory is not writeable. changed back 0777

Otherwise, put the site in debug mode and see if it gives you any more hints. There’s post about plugins here. It maybe worth checking your database collations …

it is in debug mode, but doesn’t show any errors

Offline

Board footer

Powered by FluxBB