Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Cannot change any field

AS-N's profile image AS-N posted 1 month ago in General Permalink

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

1 attachment(s):
  • Unbenannt
ansgar's profile image ansgar posted 1 month ago Permalink

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?

AS-N's profile image AS-N posted 1 month ago Permalink

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

USE db_1;

was already sent before.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 1 month ago Permalink

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)

AS-N's profile image AS-N posted 4 weeks ago Permalink

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!

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.