Questions tagged as 'mariadb'

Tagged questions
0
answers

Error while using concat_ws mariaDB

I'm having a problem concatenating a table's first and last name, CONCAT_WS ("", first, last name) LIKE: name I have this code, if I get a name it finds, if I put name and surname does not find, being q is concatenated the columns, it is not tak...
asked by 17.05.2018 / 16:52
1
answer

Join two SQL queries MariaDB

Two tables tab_Ord_Ser and tab_Pos_Alb . In two different queries I can know the values but I can not unite them in just one. These are: SELECT Prazo_Producao as Data, COUNT( 'Numero OS' ) AS Produzir, Tipo_Album FRO...
asked by 24.04.2018 / 21:18
0
answers

Add / View Friend Database

I have a users table and a friends table, every friend is also a user, I would like to know how to insert items (add a friend) and how to check (list friends)? CREATE TABLE IF NOT EXISTS usuarios( id INT NOT NULL AUTO_INCR...
asked by 08.04.2018 / 15:02
0
answers

Shuffled information Magento 1.9.3.8 and bug in pagseguro

Hello. I recently updated the magento to version 1.9.3.8, everything went well, until I came across an issue, new registrations are going to the shuffled database (language in place of name, password hash in place of last name, last name in plac...
asked by 01.04.2018 / 02:32
0
answers

Replace MariaDB with Mysql in Xampp

I have already researched and found almost nothing related to this, so I came to ask for help, MariaDB is giving a laravel error, so I want to switch to Mysql. MariaDB returns this error to me. Looking for solutions, I found some, but they...
asked by 05.03.2018 / 03:28
0
answers

Trigger to update several lines MariaDB

I'm trying to create a trigger to update the stock value of the products table, according to the status of the note. ex. on the note have 2 products 1 | Qty: 3 2 | Qty: 5 When the status is updated to "0" which means that the note ha...
asked by 08.02.2018 / 15:27
0
answers

Delay in executing a file

I have a cents auction script, and there is a PHP file that is responsible for entering the customer's bid when the button is clicked. That is, when the customer clicks the button to bid, it triggers this file and inserts the bid into the pro...
asked by 26.01.2018 / 02:13
0
answers

MySQL Upgrade / MariaDB

Well, I currently use version 10.1 of MariaDB on my server with cPanel. I thought about upgrading to version 10.2 to see if I get a little performance. However, the following warning is displayed for me:    MariaDB enables "strict mode" by...
asked by 26.01.2018 / 01:30
1
answer

Connection error in mariadb

Today I installed lamp on my manjaro and everything was working normally, until I went to test php with mysql and typed the code: $conexao = mysqli_connect('localhost','root','','data'); I realize that after that all the rest...
asked by 27.01.2018 / 09:21
0
answers

Error starting MariaDB in CentOS7

Good morning. I have a dedicated server running CentOS7 and MariaDB has stopped and I can not restart the service. [root@new ~]# mysqld start 2018-01-17 13:31:10 140236707752192 [Note] mysqld (mysqld 10.1.22-MariaDB) starting as process 19665...
asked by 17.01.2018 / 14:52