+- Hazeron Forums (https://hazeron.com/mybb)
+-- Forum: Shores of Hazeron (https://hazeron.com/mybb/forumdisplay.php?fid=1)
+--- Forum: Updates (https://hazeron.com/mybb/forumdisplay.php?fid=11)
+--- Thread: 2024-02-22 Major Fail when Upgrading the Wiki (/showthread.php?tid=3052)
RE: 2024-02-22 Major Fuck Up - Deantwo - 02-23-2024
Could you maybe rename this thread to something less vague?
I fear what people's reaction would be to an update thread titled "2024-02-22 Major Fuck Up". Maybe just rename it to "2024-02-22 Wiki Data Loss" or something.
RE: 2024-02-22 Major Fuck Up - Haxus - 02-23-2024
If you want files of data just ask.
Renamed. Still feel like punishing myself.
RE: 2024-02-22 Major Fuck Up - Celarious - 02-23-2024
(02-23-2024, 01:12 AM)Haxus Wrote: I got the same error. Push the skip button and you will login with your old password.Unfortunately it seemed my old password no longer worked, so I reset it and and got a temporary one
That temp password works, but because it's a temporary, it forces me to change it in order to login, and I can't change it due to the error
Googled the db error and apparently you need to run a script called Update.php, apparently not doing that can cause the error
RE: 2024-02-22 Major Fuck Up when Upgrading the Wiki - Haxus - 02-23-2024
Thank you. I was going to research the problem in the morning. I will check out that update script.
RE: 2024-02-22 Major Fuck Up when Upgrading the Wiki - Celarious - 02-23-2024
For reference, the mediawiki manual (here and here) mentions it's a mandatory step of upgrades:
Quote:You should run update.php after each upgrade of MediaWiki or after the update or install of an extension that requires a schema update.
Also mentions that there's also a GUI-based web updater you can use directly from the wiki, if you find it easier: https://hazeron.com/mediawiki-1.41.0/mw-config/index.php
RE: 2024-02-22 Major Fuck Up when Upgrading the Wiki - Haxus - 02-23-2024
The gui based updater is the one I ran at each step/version along the way. Sometimes it worked and sometimes it destroyed the database, requiring an intermediate version to progress through the updates. It was a slow process.
So having already run the upgrade I will have to find another solution.
RE: 2024-02-22 Major Fail when Upgrading the Wiki - Haxus - 02-23-2024
I ran the update.php script. It ran without errors. It did not solve the problem. I'll keep looking for an answer.
RE: 2024-02-22 Major Fail when Upgrading the Wiki - Haxus - 02-23-2024
Wiki is working properly now. User passwords can be changed without a database error.
A table 'bot_passwords' was missing from the database. Through all their updating they never managed to create it in my old data. I think that table did not exist in the old version we were using.
RE: 2024-02-22 Major Fail when Upgrading the Wiki - Haxus - 02-23-2024
Nightly backups of the wiki and forum databases did their work last night.
I forgot to set those up after the server change two years ago. This contributed to my failure yesterday. I thought they were working but alas.
The coup de grace was that the backup I did just before the upgrade was no good for a stupid reason I will not elaborate.
RE: 2024-02-22 Major Fail when Upgrading the Wiki - Haxus - 02-23-2024
On to the forum upgrade. There are plenty of backups of that database to avoid a repeat of yesterday.