Crash with message : Column "Name" not available.

[expired user #8816]'s profile image [expired user #8816] posted 9 years ago in General Permalink
I'm trying to connect to my database but heidi launch an exception into EDatabaseError
with following message Column "Name" not available.

From wihch table it is talking about ? I have no table with a column "Name". "name yes but Name no.

Somebody know this exception ?
ansgar's profile image ansgar posted 9 years ago Permalink
It's an exception which HeidiSQL is intentionally raising when something is trying to access a nonexistent column name in a result. Can you post the stack trace from that crash here?
[expired user #8816]'s profile image [expired user #8816] posted 9 years ago Permalink
I can't because i resolved my problem. I think it came from my sql server and not from heidi. I retrieve a correct version of my SQL version and all thing is ok.
Thanks for your reply.
[expired user #9099]'s profile image [expired user #9099] posted 9 years ago Permalink

It's an exception which HeidiSQL is intentionally raising when something is trying to access a nonexistent column name in a result. Can you post the stack trace from that crash here?



I have the same problem. And I cannot change my MySQL server setting.
HeidiSQL version is 9.2.0.4981 and 9.2 portable version have the same problem.

The attachment is bugreport.txt, thanks~
1 attachment(s):
ansgar's profile image ansgar posted 9 years ago Permalink
Your stack trace ends with an integer overflow, not with the above mentioned error message?
[expired user #9099]'s profile image [expired user #9099] posted 9 years ago Permalink

Your stack trace ends with an integer overflow, not with the above mentioned error message?



I find that HeidiSQL has two problems.
1. HeidiSQL shows that 'Column "Name" not available.'. Now I cannot get the stack trace, but I can get it ago.
2. If I change Language setting in the login windows, HeidiSQL will get an integer overflow.
1 attachment(s):
  • -
[expired user #9099]'s profile image [expired user #9099] posted 9 years ago Permalink

Your stack trace ends with an integer overflow, not with the above mentioned error message?



I download and install this version: http://www.heidisql.com/installers/HeidiSQL_9.2.0.4981_Setup.exe

I get the 'Column "Name" not available.' error. The attachment is bugreport.txt, thanks~
1 attachment(s):
ansgar's profile image ansgar posted 9 years ago Permalink
The stack says that HeidiSQL executes such a query:
SHOW PROCEDURE STATUS WHERE `Db`='SelectedDatabase';

... which returns one or more rows, but does not get the column "Name" in that result.

Probably you can post
* the server version you are accessing
* the results of "SHOW PROCEDURE STATUS" with one row
[expired user #9099]'s profile image [expired user #9099] posted 9 years ago Permalink

The stack says that HeidiSQL executes such a query:

SHOW PROCEDURE STATUS WHERE `Db`='SelectedDatabase';

... which returns one or more rows, but does not get the column "Name" in that result.

Probably you can post
* the server version you are accessing
* the results of "SHOW PROCEDURE STATUS" with one row



the results of "SHOW PROCEDURE STATUS":
DB,NAME,TYPE,DEFINER,MODIFIED,CREATED,SECURITY_TYPE,COMMENT,CHARACTER_SET_CLIENT,COLLATION_CONNECTION,"DATABASE COLLATION"
XX_DB_NAME,correct_kongur_process,PROCEDURE,username@hostname,"2012-04-10 15:19:01","2012-04-10 15:19:01",DEFINER,,gbk,gbk_chinese_ci,gbk_chinese_ci
XX_DB_NAME,correct_kongur_process_1,PROCEDURE,username@hostname,"2012-04-10 15:13:11","2012-04-10 15:13:11",DEFINER,,gbk,gbk_chinese_ci,gbk_chinese_ci
XX_DB_NAME,truncate_table_by_doy,PROCEDURE,username@hostname,"2011-12-31 21:53:14","2011-12-31 21:53:14",DEFINER,,gbk,gbk_chinese_ci,gbk_chinese_ci


Thanks~
vr_andrey's profile image vr_andrey posted 3 years ago Permalink

Hi! I've got the same an error. I have deployed two DBs from one dump to check synchronization. Then I ran migration which removed a column from first DB. In UI was selected a table. I got an error when I switched to second DB and selected the same table. Log attached.

1 attachment(s):

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