I'm testing this in MyPhpAdmin on "10.5.24-MariaDB-cll-lve", I can not define SET statements such as "SET @x = 1;" (from the manual),they don't fail but the following statementis flagged as failing. I have also tried DECLARE. If I put a…
I rarely come here to ask questions, since I usually find answers by digging hard, but this time I didn't see solutions and I'm really very frustrated. I am setting up a docker container with MariaDB, with this Dockerfile: FROM…
As part of our introduction to computer security course, we have a short unit on SQL injections. One of the homework assignments is a basic unsanitized login page. The expected solution is something along the lines of the classic '…
I am having an issue filtering a Mariadb query through HAVING on a computed column based on a Mariadb variable. I am having an issue in Laravel Elquent where a query I am running is producing no results. I have…
I use WAMP on my dev machine running MariaDB. On the server I use MySQL. The main page is a list of events sorted by a metavalue: event_date. Here's the query as generated by Wordpress SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_posts…
I am building a data table with pagination on the frontend and the table contains advanced filtering and sorting with optional column visibility. There's also the possibility to do actions on the selected rows in the table. The data in…
I have a table filled with pre-calculated prices for rental objects. This is a simple version of it: CREATE TABLE `pricecache` ( `oid` int(11) NOT NULL DEFAULT '0', `start` date NOT NULL, `end` date NOT NULL, `duration` tinyint(3) UNSIGNED NOT…
I'm encountering performance issues with a Laravel application deployed in a production environment. The application is designed to register views for videos, and it utilizes the firstOrNew method to retrieve or create device records for each view. However, regardless of…
I cannot resolve the following issue: root@MyCluster:/opt/WorkLoadManager/slurm/23.11.5# systemctl status slurmctld × slurmctld.service - Slurm controller daemon Loaded: loaded (/etc/systemd/system/slurmctld.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Tue 2024-04-09 16:18:33 CEST; 4s ago Process: 2592430 ExecStart=/opt/WorkLoadManager/slurm/23.11.5/sbin/slurmctld --systemd $SLURMCTLD_OPTIONS (code=exited,…
I am wondering why a mariadb installation allows me to create a database and create the user but fails on granting privileges. Here is what I perceive: MariaDB [mydb]> show grants; +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT…