The request of my function has a problem: function rdvDelete($rdv) { $pdo = connexion(); $sql = $pdo->prepare("DELETE FROM visitors,rdvs WHERE rdvs.idRdv = :rdv AND visitors.idVisitor = rdvs.idVisitor"); <-- line 34 $sql->execute(['rdv' => $rdv]); } $rdv = 3 !!! And this…
I am trying to speed up a simple SELECT query on a table that has around 2 million entries, in a MariaDB MySQL database. It took over 1.5s until I created an index for the columns that I need, and…
I'm having problems with a slow SQL query running on the following system: Operating system: Debian 11 (bullseye) Database: MariaDB 10.5.15 (the version packaged for bullseye) The table schemas and some sample data (no DB Fiddle as it doesn't support…
I have a polymorphic relationship between an Article model and 3 models (Company, Group & User) that sometimes returns null. 90% of the time, the articleable relation is perfectly OK and looks like this: #relations: array:1 [▼ "articleable" => AppModelsUser…
I am trying to install mariadb usin pip3 on a python 3.8 environment on a Ubuntu 2004 server. I did download the mariadb-connector-c (version 3.31) and copied the files to their destinations. I also installed python2-dev and its dependencies on…
I have had a few crashes on my TS3 server since switching from SQLite to MariaDB, unfortunately they are now almost daily. Does anyone know this error and what I'm doing wrong? The logs are for the crash on 2022-07-22…
Running MySQL/MariaDB in a Docker container: docker run -p 3306:3306 --name $(DATABASE_NAME) -v /tmp/mysql:/var/lib/mysql -e MYSQL_DATABASE=$(DATABASE_NAME) -e MYSQL_USER=$(DATABASE_USER) -e MYSQL_ROOT_PASSWORD=$(DATABASE_PASSWORD) -d mariadb:latest > /dev/null And then running Django version 4 locally with: manage.py runserver 127.0.0.1:8000 Error django.db.utils.OperationalError: (2013, "Lost connection…
I try to install mariadb package on my ubuntu 20.04 and I get this message : Collecting mariadb Using cached mariadb-1.1.3.tar.gz (80 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error × python setup.py egg_info did not run successfully. │ exit…
I run a MariaDB PaaS on azure with SSL and run phpMyAdmin on AKS. By trying to connect I get a very unclear message: Cannot log in to the MySQL server and mysqli::real_connect(): (HY000/2002): No such file or directory At…
I want to customize some MariaDB server configs (wait_timeout, etc.). I followed the instructions on the official Docker image and created two .cnf files inside my host dir config/mariadb which is mounted in the container via these volumes: volumes: -…