Page 9 of 53
Re: Regulars' Table
Posted: Fri Nov 25, 2022 12:09 am
by Altbert
Selene310187 wrote: ↑Thu Nov 24, 2022 10:25 pm
I don't know how I managed to corrupt the test forum installation on my local machine (I believe it has something to do that I didn't shutdown the Apache and Mysql services in the XAMPP Control Panel before I shutdown the computer yesterday). When I tried to load the forum on localhost the next day, I only got a critical Mysql error message. Then I saw that the Mysql service isn't running and restarting it gave me the error "mysql shutdown unexpectedly". After I restored the backup from the mysql data folder, I could finally run the Mysql service but I still got the critical error message when I try to load the test forum. The final solution was importing a database backup of the forum's database, repairing the table "db" under the mysql main database and adding a missing database user with the right user permissions to the imported database.
That's something I never encountered during the time using XAMPP (some 10 years), but then I never used Apache and MySQL as a service! Just loaded the modules and received PIDs and Ports. As far as I can remember, just once I clicked the service checkboxes, but that didn't turn out well, but I have no recollection of the issues or results. Never used services again.
Re: Regulars' Table
Posted: Fri Nov 25, 2022 12:59 am
by Selene310187
Altbert wrote: ↑Fri Nov 25, 2022 12:09 am
Selene310187 wrote: ↑Thu Nov 24, 2022 10:25 pm
I don't know how I managed to corrupt the test forum installation on my local machine (I believe it has something to do that I didn't shutdown the Apache and Mysql services in the XAMPP Control Panel before I shutdown the computer yesterday). When I tried to load the forum on localhost the next day, I only got a critical Mysql error message. Then I saw that the Mysql service isn't running and restarting it gave me the error "mysql shutdown unexpectedly". After I restored the backup from the mysql data folder, I could finally run the Mysql service but I still got the critical error message when I try to load the test forum. The final solution was importing a database backup of the forum's database, repairing the table "db" under the mysql main database and adding a missing database user with the right user permissions to the imported database.
That's something I never encountered during the time using XAMPP (some 10 years), but then I never used Apache and MySQL as a service! Just loaded the modules and received PIDs and Ports. As far as I can remember, just once I clicked the service checkboxes, but that didn't turn out well, but I have no recollection of the issues or results. Never used services again.
Sorry, I mixed something up. When I said "services" I actually meant "modules".
Re: Regulars' Table
Posted: Fri Nov 25, 2022 5:02 pm
by Altbert
Selene310187 wrote: ↑Fri Nov 25, 2022 12:59 am
Sorry, I mixed something up. When I said "services" I actually meant "modules".
I never shutdown the modules. First I close the browser tab/window in which I test run and then choose Quit to shutdown XAMPP, before shutting down the PC. Quitting XAMPP should automatically close the modules.
Re: Regulars' Table
Posted: Fri Nov 25, 2022 5:17 pm
by Selene310187
I didn't quit XAMPP either before I shutdown the notebook. The only other things I did this day were a major Windows update and getting Windows Spotlight to show new images (it was stuck) with code snippets I found in the internet. Maybe I have broken something using these code snippets.
Re: Regulars' Table
Posted: Fri Nov 25, 2022 5:31 pm
by Altbert
Following are some possible solutions I found on the internet:
1. Run XAMPP using administrator priveleges
2. Restore your database backup
3. Change your MySQL port
Hope this might help.
Re: Regulars' Table
Posted: Fri Nov 25, 2022 6:11 pm
by Selene310187
Altbert wrote: ↑Fri Nov 25, 2022 5:31 pm
Following are some possible solutions I found on the internet:
1. Run XAMPP using administrator priveleges
2. Restore your database backup
3. Change your MySQL port
Hope this might help.
I already could solve the problem (found these steps as well but they were not enough to solve the problem, see quote at the bottom). I posted this subject to find out why this happened (I admit, I wasn't clear enough). But your suggestion can help others who have a similar problem
.
Selene310187 wrote: ↑Thu Nov 24, 2022 10:25 pmThe final solution was importing a database backup of the forum's database, repairing the table "db" under the mysql main database and adding a missing database user with the right user permissions to the imported database.
Re: Regulars' Table
Posted: Fri Nov 25, 2022 8:28 pm
by Altbert
Great you found the issue!
Re: Regulars' Table
Posted: Sat Nov 26, 2022 12:54 pm
by smr1957
Good day, all! Just slimmed across the issue you were having, Selene, and the responses by Albert, but since I no longer do websites my eyes and brain began to shut down - LOL!
Glad you got the issue sorted out!
On the agenda for me today is some more playtime - everyone in my SSE game is at the Coffee House having a party - Etienne, Jenassa, Chacone, Hador, and Rayya, plus over 30 additional followers from mods; quite the crowd there! And, after this, I think it will be time to do my long talkws about readjustment to my existing build, and consequent start of a new game. Not looking forward to buying or rebuilding all the existing houses and redoing all the related quests needed for them - again! Bit, once the build ha be modified, that should be it for any further rebuilding of my mod list as a whole.
Re: Regulars' Table
Posted: Sat Nov 26, 2022 5:07 pm
by Ivanhoe1955SI
I feel really wicked sick right now. My doctor expressed the suspicion a long time ago that it could also be long covid. That seems to be confirmed now.
I am constantly tired, can not concentrate any longer work, even hobby work is not possible at the moment.
I will therefore reduce my activities a bit, slowly rebuild my Morrowind (Fallout 4 and Skyrim have to wait) and otherwise take it easy.
Therefore, it can be that I am not active here for days.
Translated with
www.DeepL.com/Translator (free version)
Ich fühle mich momentan richtig böse krank. Mein Arzt äußerte schon vor längerer Zeit den Verdacht, dass es auch long covid sein könnte. Das scheint sich jetzt zu bestätigen.
Ich bin ständig müde, kann mich nicht konzentrieren und längeres Arbeiten, auch Hobbyarbeiten sind momentan nicht möglich.
Werde daher meine Aktivitäten etwas herunterfahren, mein Morrowind langsam wieder neu aufbauen (Fallout 4 und Skyrim müssen warten) und mich sonst schonen.
Daher kann es sein das ich hier tagelang nicht aktiv bin.
Re: Regulars' Table
Posted: Sat Nov 26, 2022 8:17 pm
by Altbert
Ivanhoe1955SI wrote: ↑Sat Nov 26, 2022 5:07 pm
I feel really wicked sick right now. My doctor expressed the suspicion a long time ago that it could also be long covid. That seems to be confirmed now.
I am constantly tired, can not concentrate any longer work, even hobby work is not possible at the moment.
I will therefore reduce my activities a bit, slowly rebuild my Morrowind (Fallout 4 and Skyrim have to wait) and otherwise take it easy.
Therefore, it can be that I am not active here for days.
That sucks, Ivanhoe. Get better soon! We will all be waiting here.