I have the following error: Object of class AppEntityFournisseurs could not be converted to string I wish that in my order page we can choose a supplier to register in the db page and supplier page in order to associate…
I've compiled and installed Python 3.10.9 (from .tar) and mariadb-c-connector (from official Github repo) on my Debian 11 (bullseye) machine. I also installed: ufw, fail2ban, mariadb-server, mariadb-client. Now if i install mariadb in my Python pipenv and run i got…
I'm trying to get the right data from the database, I'm retriving a model with a media relation via eloquent, but I want to return a photo that contains the 'main' tag stored in JSON, if this tag is missing,…
My target: I have a list of stock_ids and want to get the last bids (its sorted by date) only one per stock_id. For the picture, it means i want: stock_id bid 3 663.91953 1 46.44281 2 9.02798 One problem…
having an ansible playbook that will run on all hosts including Debian based & RedHat based servers this will install mariadb on RHEL based servers only doing some configuration changes, start the service once the service started handlers are used…
I use VestaCP with apache, nginx and Mariadb 10.3 on Debian 10 with 2core CPU and 3GB RAM. main purpose: store on opencart with ~10k products (about 150 tables in SQL). Right now I got very long pauses on searches…
How can I improve the following query's performance while the server is loaded? I've created a combo index and removed the index from the table because it's not picking it up, but is there another way to do it? ,…
We see large gaps in primary key column with auto_increment in mysql 8.0.31 release version in multiple tables (with default - innodb_autoinc_lock_mode = 2 (“interleaved” lock mode)). Also I understand some smaller gaps can happen in this mode. We have…
I have 2 servers installed in 2 differents localisation, with a synchronisation files managed by heartbeat + drbd. They are running since few months and the date of the last main server reboot is : 2022-12-07 15:44 This night on…
MariaDB is installed on server with IP 1.2.3.4, new MySQL user has been created on 1.2.3.4 for remote IP a.b.c.d, but while trying to connect MySQL on 1.2.3.4 from a.b.c.d giving error: ERROR 2003 (HY000): Can't connect to MySQL server…