I have a Problem getting UTF-8 encoded Strings out of a MariaDB-Database. Today I updated my XAMPP-Distro to 10.4.11-MariaDB (MySql) and PHP 7.2.29 and now a strange Problem arised wich had not occoured with the older version. Preliminary informations: I…
I installed uWamp 3.1.0 but the php versions are quite old. I coulg update PHP to 7.4.4 using instructions found here. I tried the same with mariadb 10.4 butting the 32bit versione in bindatabasemariadb-10.4.12 and copuing my_uwamp.ini from old mysql…
Created a new database but can't create new user account due to this error. Does anyone know how to fix this? I can't find any solution to fix this. 1030 - Got error 176 "Read page with wrong checksum" from…
Besides having mariadb 10.1.36-MariaDB I get following error. EXPLAIN ANALYZE select 1 MySQL said: Documentation 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to…
I am using a MySql DataBase and I want to know if there are any methods to modify a value of a column every x minutes/hours/days. For example, I want to execute the following query every 5 minutes, UPDATE table…
Nextcloud and mariadb were installed through docker-compose using the nextcloud official image posted on the docker hub. At first it ran fine, but at some point I get the following error: version: '2' volumes: nextcloud: db: services: db: image: mariadb…
I have MariaDB + Nginx on Linux Debian 9(stretch). After installing MariaDB it and trying to start it, I got the error saying: [Warning] Could not increase number of max_open_files to more than 4096 (request: 4214). So I googled it…
We have the following table id # primary key device_id_fk auth # there's an index on it old_auth # there's an index on it And the following query. $select_user = $this->db->prepare(" SELECT device_id_fk FROM wtb_device_auths AS dv WHERE (dv.auth= :auth…
Environment: centos7 + mariadb5.5.64. Let me show the installation info on screen when to run mysql_secure_installation. # mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In…
I'm running MariaDB SQL server on Debian Linux, I have phpMyAdmin installed. SSMTP is installed and configured so I can send emails from the command line. I have a simple table, called team_members, and every time a new team member…