phpmyadmin, MariaDB 10 and Point columns
Trying to edit a column of a table in MariaDB using PHPmyAdmin v5.1.1 gives me trouble. It saves the column as binary and I need to edit the whole row in order to be able to edit it as text.…
can't start mariaDB on manjaro – Phpmyadmin
I'm trying to start phpmyadmin, but i can't seem to start mariadb first. here is the command i'm trying to do : systemctl start mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status…
Plesk Server DB query failed: SQLSTATE[HY000] [2002] No such file or directory
So I have just encountered a problem with my Plesk server and have been trying to figure it out. This is on a Plesk Obsidian 18.0.36 server with Ubuntu 20.04 running on MariaDB 10.3.29. The error: DB query failed: SQLSTATE[HY000]…
MariaDB 10.5.11 slow performance compared to MySQL 8.0.13 – CentOS
Having trouble with particular query performance after migrating large database from MySQL 8.0.13 data to MariaDB 10.5.11. I install MariaDB via repo: [mariadb] name = MariaDB 10.5 para CentOS 7 baseurl = http://yum.mariadb.org/10.5/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 To export database I use:…
Viewing the SQL query that created the database? – Phpmyadmin
How can I view the text input query that was used to create a database table? I'm using MariaDB with PHPMyAdmin! Edit: I remember I found it long ago, when clicking on edit or change or something similar! Damn it's…
German Umlaute not considered in JSON_CONTAINS() with MariaDB – Phpmyadmin
first time posting here. I am facing a problem with unpredicted behavior on my PROD server and my local environment. Here is some background on the situation: In my application (backend Laravel 7, frontend regular html/javascript) I need to search…
SQL Sort by multiple columns of a different table – Mysql
I have two tables: The first one having the columns: |Name | Company | Job| with values such as (jack apple developer), (Julian google developer), (Jim eBay developer), (jack apple janitor), (Julian google janitor), (Jim eBay janitor), (jack apple manager),…
Moved site , all links got corrupted, need correct SQL query to fix – Phpmyadmin
Wordpress. from litespeed to ngix server. All of my links to plugins, images CSS and scripts added "%20" on the end. Example: https://example.com%20/wp-content/plugins/wp-maintenance-mode/assets/css/style.min.css? I assume the solution would be to change all "example.com%20" to "example.com" in the database. What would…
Weird caching happening in Maria DB with query selecting minimal available id – Phpmyadmin
I have a query, that selects the lowest available id free in a table. It works perfect in my tests, but however I realized, that it always returns 9 in production. So I deleted id number 6 (which is lower)…
Laravel/MariaDB: errno 150 "Foreign key constraint is incorrectly formed" – PHP Versions
I'm on Laravel 5.4, PHP 5.6, Ubuntu 18.04, MariaDB 10.4.8. When I run php artisan migrate, I get: In Connection.php line 647: SQLSTATE[HY000]: General error: 1005 Can't create table `test-kursach-backend`.`comments` (errno: 150 "Foreign ke y constraint is incorrectly formed") (SQL:…