So, the other day I was fighting with my development environment for building web apps. My database was causing me all kinds of grief and I finally threw in the towel, turned in, and went to sleep.
The next morning I got up, dived back in, and made some progress. I managed to get XAMPP uninstalled successfully, then re-installed. Everything seemed to work. The Apache web server served web pages, the PHP code ran as expected, and the MySQL database let me enter and retrieve data. I had to go through some hoops to get the databases set up again, but once they were in place things ran well.
Until they didn’t. < heavy sigh >
I went to one of the web apps, loaded the page, and instead of seeing the expected output, I got another database error message. WTF?
I went through the logs, did some searching on Google, looked at the problem every which way to Sunday. Then it occurred me to that MySQL under XAMPP is running on top of MariaDB, which I also have installed on my development box. I’m guessing whatever got screwed up the other day was the MariaDB code, which cascaded down to the MySQL database.
Once again I uninstalled XAMPP, then MariaDB. Another few minutes ended with XAMPP being reinstalled. Once again, I stepped through all the configuration process, rebuilt the databases, and crossed my fingers.
Back to my web app, load the page … success!
Everything is working as expected and all is right with the world.
I love it when an app comes together.
I hope all is right in your world, my Hordeling.
If you’d like to support my efforts, why not buy me a chocolate chip cookie through my Ko-Fi page? https://ko-fi.com/jhusum