Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
I broke site admin -- only shows Admin > Prefs > Languages
I seem to have done something evil to my database (near as I can figure) in attempting to update from 4.0.6 —> 4.0.8, failing, and reverting to 4.0.6.
The site still works fine for visitors.
While I was trying to get 4.0.8 working, it complained at each admin screen of an error at line 555 of textpattern/lib/txplib_misc.php, which upon examination has something to do with plugins. I decided to revert to 4.0.6 and attack the update another day. I restored all of httpdocs/ (i.e., doc root, including textpattern) from a saved .tgz and now:
When I log in as admin, it comes up on the Admin > Preferences > Language screen, and nothing will move it off of that screen. Click any other tab of Prefs or any other section of Admin or any other section at all — the URL changes in the bar, the display does not.
Any ideas?
Offline
Re: I broke site admin -- only shows Admin > Prefs > Languages
P.S. — I have access to phpMyAdmin on that database, though I’m not familiar with the tool or its use; if this helps.
Offline
Re: I broke site admin -- only shows Admin > Prefs > Languages
Hi keith
Did you update the language?
With php myadmin all you need to do is select all/damaged tables and then chose repair if there is a db problem.
Maybe you did not upload all the txp4.0.6 files. Try uploading them again
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: I broke site admin -- only shows Admin > Prefs > Languages
I don’t remember whether I updated the language while trying to move to 4.0.8. That screen was & is confusing. If I do nothing do I stay with US-English as it was? I do not want 25 other languages on my site, if I do nothing do they get installed, or did they already?
In phpMyAdmin I selected all tables and said Repair. It seemed to succeed but nothing has changed when I try to log in as an admin.
I did restore all txp 4.0.6.files. I had made a backup (tar czf httpdocs-4-0-6.tgz httpdocs) before trying to update to 4.0.8. That is what I restored. So all files below the doc root are as they were. That’s why I assume it must be the database that has somehow gotten wedged.
Offline
Re: I broke site admin -- only shows Admin > Prefs > Languages
Fixed now, with the help of a friend deeply knowledgeable in things MySQL, to whom I gave ssh access and sudo privileges. I stopped the Web server; he stopped mysqld, edited a config file, and restarted it without a password — all this so he could do an orderly shutdown of the database. (I did not and do not have a master password to the MySQL server, which is running in a hosting environment managed by Plesk.) We then copied into place in /var/lib/mysql a backup directory, from two days before, of the entire database of the affected domain. Restarted mysqld with its (unknown) password, restarted the Web server, and whew all worked as before. It might not have, if the database for that domain had happened to be in use when the backup went off. Note that this wasn’t a phpMyAdmin backup we were restoring, it was simply a directory full of files.
This is an amazing amount of trouble to have gone to as a result of trying to update from 4.0.6 to 4.0.8, and it came about because I followed the (extremely minimal) instructions at
- Download ( http://textpattern.com/download/ )
instead of the far more explicit ones at
- Upgrading ( http://textbook.textpattern.net/wiki/index.php?title=Upgrading_to_a_New_Version )
or
- Updating ( http://textbook.textpattern.net/wiki/index.php?title=Updating_to_a_New_Revision )
Perhaps a link to one of the latter, judiciously placed at the former, would be in order?
Offline
#6 2009-08-13 09:03:00
- antioche
- New Member
- Registered: 2009-08-10
- Posts: 1
Re: I broke site admin -- only shows Admin > Prefs > Languages
Hi,
I had the same problem described above when trying to upgrade to 4.08, failing and trying to revert to 4.06 using backed up files. This resulted in being stuck on the language setting page everytime I tried to access the admin side.
After much headache and frustration, I finally noticed that the culprit was the _upgrade.php script, which, by default, redirects the user to the language setting page after an upgrade is detected. Checking the database, I spotted that the Textpattern version was still set to 4.08 in the txp_prefs table, although my files were now back to their 4.06 version (after my downgrade). Since the _upgrade.php script is only able to upgrade and not to downgrade, I was going through a infinite loop of failed upgrades…
So to sort this problem, just edit the version entry in the txp_pref table back to the version matching your files (in my case 4.06).
Note that this problem may happen everytime you force a downgrade without also reverting the database to its previous state.
Cheers,
Antioche
Offline