Bug - Commented Query Error

b_ernesto@hotmail.com's profile image b_ernesto@hotmail.com posted 11 months ago in General Permalink

Hello, in the query box I have a commented query and an active query

#SELECT * FROM facturas WHERE id_tercero=1714;

SELECT * FROM caja WHERE nuc=156498 OR NUC=51;

I recibe the (caja) data. Edit it in the Grid. The modified data is on the commented table (facturas).

(This is the log) #SELECT * FROM facturas WHERE id_tercero=1714;

SELECT FROM caja WHERE nuc=156498 OR NUC=51; / Filas afectadas: 0 Filas encontradas: 5 Advertencias: 0 DuraciĆ³n para 1 consulta: 0,016 seg. / UPDATE havaianas.facturas SET id_moneda_dp='PSO' WHERE nuc=156498; / Error de SQL (1054): Unknown column 'id_moneda_dp' in 'field list' */

HeidiSQL is a great software. Thank you for your work.

1 attachment(s):
  • error
ansgar's profile image ansgar posted 11 months ago Permalink

Could be some issue with such old MySQL versions. MySQL 5.1.73 is from 2013. I highly recommend to update to MySQL 8.x or a current MariaDB version. Your screenshot tells your using Windows 7, which is as well outdated and unsupported.

b_ernesto@hotmail.com's profile image b_ernesto@hotmail.com posted 11 months ago Permalink

It's True, the problem is related to Windows 7.

Doing the same procedure form windows server, it works ok.

Doing it from windows 7 against MySql 5.6, don't let me edit, it's like read only.

Thank You

Please login to leave a reply, or register at first.