Best practices for database error handling
This problem came up when I started to do unit testing for a website that I wrote. Whether I mock the database or spin up a Docker instance to use is a question for later, but what really got me curious is how to handle errors in PHP for trying to instantiate an object, but failed.
Why am I seeing SET NAMES UTF8 collation repeatedly in the MySQL (MariaDB) general log and slow query log
I’m attempting to troubleshoot why a PHP script is running slower on MariaDB 10.5.22 (~10 mins) than on MySQL 5.6 (~1 min). It’s a simple script that takes data from a CSV file and uploads to a table. For some reason, I’m seeing the following repeatedly in the MySQL general log:
Error While Setting Up Traq v.3.7.3: Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064
I am new to MariaD and PHP and I am trying to setup Traq (the project management/issue ticket tracking system) from traq.io on my Windows computer as I am trying to do some testing. I am currently running the following versions: