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.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.
Regulars' Table
- Altbert
- Moderator
- Joined: Tue Nov 01, 2022 10:58 pm
- Location: Netherlands
- Contact:
Re: Regulars' Table
Bis vincit, qui se vincit in victoria - He conquers twice who conquers himself in victory (Publius Syrus)
- Selene310187
- Site Admin
- Joined: Fri Oct 07, 2022 8:34 pm
- Contact:
Re: Regulars' Table
Sorry, I mixed something up. When I said "services" I actually meant "modules".Altbert wrote: ↑Fri Nov 25, 2022 12:09 amThat'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.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.
- Altbert
- Moderator
- Joined: Tue Nov 01, 2022 10:58 pm
- Location: Netherlands
- Contact:
Re: Regulars' Table
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.Selene310187 wrote: ↑Fri Nov 25, 2022 12:59 am Sorry, I mixed something up. When I said "services" I actually meant "modules".
Bis vincit, qui se vincit in victoria - He conquers twice who conquers himself in victory (Publius Syrus)
- Selene310187
- Site Admin
- Joined: Fri Oct 07, 2022 8:34 pm
- Contact:
Re: Regulars' Table
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.
- Altbert
- Moderator
- Joined: Tue Nov 01, 2022 10:58 pm
- Location: Netherlands
- Contact:
Re: Regulars' Table
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.
1. Run XAMPP using administrator priveleges
2. Restore your database backup
3. Change your MySQL port
Hope this might help.
Bis vincit, qui se vincit in victoria - He conquers twice who conquers himself in victory (Publius Syrus)
- Selene310187
- Site Admin
- Joined: Fri Oct 07, 2022 8:34 pm
- Contact:
Re: Regulars' Table
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.
- Altbert
- Moderator
- Joined: Tue Nov 01, 2022 10:58 pm
- Location: Netherlands
- Contact:
Re: Regulars' Table
Great you found the issue!
Bis vincit, qui se vincit in victoria - He conquers twice who conquers himself in victory (Publius Syrus)
- smr1957
- Joined: Tue Nov 01, 2022 10:25 pm
- Location: Florida, United States
- Contact:
Re: Regulars' Table
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.
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.
- Ivanhoe1955SI
- Joined: Wed Nov 16, 2022 2:52 pm
Re: Regulars' Table
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)
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)
Spoiler
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.
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.
Don't blame me, I'm only human after all
- Altbert
- Moderator
- Joined: Tue Nov 01, 2022 10:58 pm
- Location: Netherlands
- Contact:
Re: Regulars' Table
That sucks, Ivanhoe. Get better soon! We will all be waiting here.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.
Bis vincit, qui se vincit in victoria - He conquers twice who conquers himself in victory (Publius Syrus)