Environment This is my environment: System: CentOS 7 virtual machine, created by virtualbox, only mysql installed MySQL: 5.7.35 Setup MySQL by this chinese toturial: link my.cnf: [mysqld] # slow query log slow_query_log=on slow_query_log_file=/var/log/mysql/slow_query.log long_query_time=1 # UTF-8 collation-server=utf8_general_ci init-connect='SET NAMES utf8'…
I have a query that is not returning all the results it should. I'm using Laravel, but the result is the same if I write the query directly in PHPMyAdmin: clientpages::selectRaw('page as value, COUNT(ID) as `count`') ->where('page', 'like', '%blog%') ->orWhere('page',…
I am trying to create a script, which will update column lang_id in table static if static.method_id = methods.method_id and if methods.mm_id = languages.mm_id and if languages.is_default = 1. But this one is not working, tell me please, why? UPDATE…
EDIT : the pbm is not that I used space in the password after all, so I changed the description While trying to configure xampp, I ran into an error : fatal: unknown configuration directive 'function' on line 44 of…
I've been using the code below to populate tables in a MySQL database for a few years and it's been working fine. Imports MySql.Data.MySqlClient Public sub Thing(dt as datatable) Try 'dt is datatable object populated from MSsqlServer Dim MySQLcmdSelect As…
I'm using xampp as a dev server and it has worked great for weeks. I had to reboot the machine xampp is installed on today and now, this evening, I am getting errors (warnings) when trying to do the exact…
I have table look like this in phpmyadmin: +-----------+-----------------+-------------------+ |nom_ele_id | nom_ele_title | nom_ele_parent_id | +===========+=================+===================+ | 7060 | STANDARD | NULL | | 6953 | SOL | 7060 | | 6957 | type de sol | 6953 | +-----------+-----------------+-------------------+…
I am scraping a website which return html containing single and double quotation and an example text is <div class="article__content"> <font face="Arial Helvetica sans-serif" size="3">Successful hires will expand the group's ongoing efforts applying machine learning to drug discovery biomolecular simulation…
In this code, I cannot find the problem, can someone help me? int getids; using (var SqlCommand = new MySqlCommand($"SELECT a.id+1 AS start FROM table AS a, table AS b WHERE a.id < b.id GROUP BY a.id HAVING start <…
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]…