Cannot change any field

Hi,

suddenly I cannot change any field I get after making a select. I want to manually change the field products_price, but it doesn't let me. None of the field are changeable. No error message or anything, just no reaction.

My current version is 11.0.0.6099

I suppose HeidiSQL cannot determine the underlying table name. In such cases the contents are read-only, as it's impossible to fire UPDATE queries without a table name.

Is that MS SQL?

It's MySQL and it worked before for years now.

USE db_1;

was already sent before.

I wondered about that slash in your WHERE clause - never saw that on MySQL.

However - you could watch out for errors or warnings in the SQL log panel at the bottom. Perhaps also enable debug log messages if there isn't anything. (Tools > Preferences > Logging)

You're right, it was the "products_price/products_last_purchasing_price" in the select. It says it has no idea where it's coming from: products_price/products_last_purchasing_price.

/ Spalte #4 hat eine unbekannte Herkunft: products_price/products_last_purchasing_price /

Sorry, German version

In the where clause it works fine. Thank you!