Since today morning I have a problem with the mariadb.service running on Ubuntu 18.04 with Plesk. It stopped and I can't restart it again. service mysqld start Job for mariadb.service failed because a fatal signal was delivered to the control…
I'm learning PDO now and I found it better to learn it in a LEMP docker stack (Nginx, php-fpm, MariaDB, phpMyadmin) on my Ubuntu 18.04LTS. This is my php file: <?php try { $mydb = new PDO('mysql:host=database;dbname=mysql;charset=utf8', 'root', 'admin'); }…
I want to get multiple user records from MariaDB: const mariadb = require('mariadb'); const pool = mariadb.createPool(...); const conn = await pool.getConnection(); const query = `SELECT * FROM user WHERE id IN (?)`; const rows = await conn.query(query, [requestTargets]); where…
I need to modify MySQL code to pass this error and get the same result. I use localhost with Xampp .. Apache/2.4.29 (Win32) OpenSSL/1.1.0g PHP/7.2.1 Server type: MariaDB Server version: 10.1.30-MariaDB - mariadb.org binary distribution Database client version: libmysql -…
There is Centos 7 server with Asterisk PBX 11.25.3 and mysql Ver 15.1 Distrib 10.3.18-MariaDB, for Linux (x86_64). extensions.conf: [from-main-asterisk] exten => _9XXXXXXXXXXXX,1,MYSQL(Connect connid localhost root rootpasswd mydatabase) exten => _9XXXXXXXXXXXX,n,GotoIf($["${connid}" = ""]?error,1) exten => _9XXXXXXXXXXXX,n(select_sim),MYSQL(Query RESULTID ${connid} set autocommit=0)…
I am trying to search a table where I have daily ranked keywords (SEO keywords). Therefore I have index on a key_id per keyword, and new position value per each keyword. I would like to find out how I can…
I am trying to create a login in SQL and using stored procedures to capture the login information. Even when executing the stored procedure on phpmyadmin, my out param is always returning Null, and I can't figure out why. userid…
I am the sole dev working with a very large warehouse management system for a small business. Our software is housed on a local server that is only accessible within the building, but I also have a local copy of…
When i run this sql in phpmyadmin SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; it shows @@SQL_MODE STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION @@GLOBAL.SQL_MODE STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION How to Disable strict mode on MariaDB using phpmydmin?
I developed an application connected to mariaDB (Ver 15.1 Distrib 10.1.31-MariaDB, for Win32) in DelphiXE8. I want to improve query performance. Describe the simplified scenario: de_User Table (innoDB) (rows 81762) ID_U INT PRIMARY KEY Name VARCHAR(30) INDEX ID_U, Name de_doc…