4.8.7 Upgrade problems

kaline · 2021-06-26 16:33:21

Hi again, everyone.

Last night I upgraded another textpattern site I run and things went pretty smoothly. So, today I decided to tackle another one, and it’s not going so well.

I followed all of the instructions, made sure folders are writeable, etc. When I go to the admin page and try to log in, I get an error back saying “could_not_log_in”. Also weird on that login page is the checkbox with label “stay_logged_in” and a button labeled “log_in_button”. So it’s almost like there’s something else going on.

I tried to reset my password by clicking the “password_forgotton” link, and that said it was successful, but I never received an email.

I didn’t touch my textpattern/config.php file. It’s the same as it was before I upgraded when things were still working. I know it’s something stupid, but I can’t figure it out. Thanks in advance!

Last edited by kaline (2021-06-26 16:33:40)

colak · 2021-06-27 04:05:29

Did you try reuploading? Sometimes, gremlins appear when files are in transit.

kaline · 2021-06-27 13:39:00

Yes, @colak. In fact, I removed the old /textpattern folder (minus config.php) and re-uploaded it. Also did a re-upload of the files in / but it didn’t make a difference.

Bloke · 2021-06-27 14:10:19

If you can’t log into the back-end at all, it may be that the cookie is somehow mangled. So try and locate any Textpattern cookies and delete them. I’ve had it before where it just goes round in a loop and won’t let you log in.

However, if you’re seeing those untranslated strings, it seems as if the language pack isn’t being loaded properly, which points to a deeper problem. What language are you using? en-us?

If all the files are uploaded fine and clearing your Textpattern cookies doesn’t resolve it, try resetting your password at the database level, just to eliminate that. You should be safe to use the MySQL 8+ process on any version of MySQL, btw. It might be prudent for us to remove the docs that state the process for the other one, as most versions we support should now be able to use the latter process.

While you’re in your database admin interface, try checking a few things:

1) Check the collation of the database and all the tables / columns matches – they should all be the same.
2) Check the database charset in config.php matches the database.
3) In your txp_prefs table, check the ‘version’ string and let us know what it says. Seems as if the upgrade process isn’t working so knowing which version you’re upgrading from might be handy.
4) In the txp_prefs table, change the production_mode value to debug and then refresh your browser to see if there are any errors thrown which might help diagnose what’s going on.

Beyond that, I’m not sure what else could be the problem. It seems like it’s connected to a database okay but something between there and the browser is not working. Very odd.

kaline · 2021-06-29 16:12:42

Thanks, @bloke! It looks like resetting the password following the instructions in the link your provided fixed things. Thank you for your help!

bici · 2022-12-21 18:35:48

Is it still the case that when we move a TxP installation from one Domain to another that we need to hack the password for Admin via a mysql edit? I recall i had to that a year or so ago. But if we still need to change the password i am unable to locate the instructions

phiw13 · 2022-12-22 01:49:16

bici wrote #334362:

Is it still the case that when we move a TxP installation from one Domain to another that we need to hack the password for Admin via a mysql edit? I recall i had to that a year or so ago. But if we still need to change the password i am unable to locate the instructions

There is this in the docs. In my notes I found the following sql query (apply in a DB-editor) to change your password (obviously, replace username with your username) – source.

UPDATE txp_users SET pass=CONCAT('*', SHA1(UNHEX(SHA1('new-pass')))) WHERE name='username';

I honnestly don’t remember the situation with the main admin pass when moving a site.

Bloke · 2022-12-22 03:06:44

bici wrote #334362:

Is it still the case that when we move a TxP installation from one Domain to another that we need to hack the password for Admin via a mysql edit?

It’s not a requirement. If you upsticks an install from one domain to another, as long as the database comes across wholesale, the login and password will be the same.

But it is a good idea to change your password if you’re cloning a site, because then you won’t have two installs with identical login info. You can either do that from within Txp as normal (Admin->Users->Change your password) or at the db level using the password reset instructions.

Textpattern CMS

Textpattern CMS support forum

#1 2021-06-26 16:33:21