Questions tagged as 'mysql'

Tagged questions
0
answers

Database connection failure: SQLSTATE [HY000] [2002] No such file or directory

I'm having this error in MySQL when I try to connect. Everything works perfectly when run by localhost, but when run by hosting, this happens: SQLSTATE[HY000] [2002] No such file or directory I changed the address, password, bank name ... A...
asked by 20.12.2018 / 02:47
0
answers

How to change the connection to the database using Sequelize + MySql + Express depending on the parameter sent in the request?

For example, when you receive a parameter in the request equal to db1, in the precise controller that uses the db1 connection string When you start the NodeJS server, the config.json configuration with the connection data is already loaded....
asked by 19.12.2018 / 18:17
1
answer

How to change product categories in Magento via MySQL?

I've imported the csv from the products in my store but they came with the categories all changed. Is there any way to change the categories via or some other faster way?     
asked by 12.03.2014 / 18:31
0
answers

Problem generating multiple ticketsPHP

I have some problems generating bulk tickets using the BoletoPHP open source system, as I need to have hundreds of tickets generated in a script through information coming from the Database. These tickets are stored on the server inside a fol...
asked by 03.01.2019 / 20:22
2
answers

Jquery Autocomplete with Ajax via PHP and Mysql

I have an input that is populated via Jquery autocomplete. Simple and efficient. But I wanted to make that when selecting a number of this input (it's an IMEI cell number) he would already look for (I imagine it is in Ajax) the device to which i...
asked by 13.12.2018 / 17:43
0
answers

MySqlException .NET Core 2.1: Unknown column 'xxxx' in 'field list'

I have a bizarre error that I would like to share with you. I'm using Visual Studio 2017 and creating an MVC application with NET Core 2.1, based on a MySQL database and tables that already existed previously. I created a model called Resu...
asked by 26.12.2018 / 22:17
0
answers

Mysql switch from master / slave to master / master multi slave

I have the following master / slave configuration: 1 master and 3 slaves (slaves used in time-consuming queries for reports). I need to know if it is possible to convert a slave to master in a master / master configuration by keeping the 2 re...
asked by 13.12.2018 / 13:21
0
answers

Error executing query in MySQL: Illegal mix of collations

In my environment: Linux Debian 9. mysql See 14.14 Distrib 5.6.41, for Linux (x86_64) using EditLine wrapper. I'm getting the following error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for...
asked by 14.12.2018 / 15:36
0
answers

PDO Duplicate Data Update Problem

I'm having a problem updating if I remove ! from if (!empty($data['slug'])) the code just does not work, and if I leave ! it simply says that there is its own value without changing any detail, could someone please help me....
asked by 11.12.2018 / 19:12
0
answers

Listing does not complete all rows

I have a problem when it comes to making a listing. It has hours that normal list and has hours that does not show all lines Inthisimageaboveshows7morelineswouldhavetoshow15.theproblemisthatifIrefreshthepageithashoursthatloadsnormalandhashou...
asked by 07.12.2018 / 15:59