distal-attribute
distal-attribute
distal-attribute
distal-attribute

Clicking on a view crashes Heidi

User, date Message
Written by tofudisan
4 years ago
Category: General
19 posts since Wed, 04 Nov 09
Is this where I post bugs now? Hope so.

I have a view defined in one of my schemas. Don't remember the last time I had to do anything with it. Anyway I'm now unable to get into the view to edit it or see the data. Every time I click on the view in the left pane Heidi crashes.

I'm up to revision 3579 and still have the problem. Here's the bug report:

date/time : 2010-11-04, 17:03:12, 343ms
computer name : PC10249
user name : chris.swearingen <admin>
registered owner : PC10249 / Golden Eagle Log Homes, Inc.
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 1 day 8 hours
program up time : 12 seconds
processors : 4x Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
physical memory : 1788/3325 MB (free/total)
free disk space : (C:) 433.79 GB
display mode : 1280x1024, 32 bit
process id : $15c8
allocated memory : 13.70 MB
executable : heidisql.exe
exec. date/time : 2010-11-04 17:02
version : 5.1.0.3579
compiled with : Delphi 2010
madExcept version : 3.0k
callstack crc : $95fcec6d, $90365474, $90365474
exception number : 1
exception class : Exception
exception message : Regular expression did not match the VIEW code in ParseViewStructure(): CREATE VIEW "users_view" AS select "user_list"."User_ID" AS "User_ID",concat("user_list"."User_FName",' ',"user_list"."User_LName") AS "User_Name","user_list"."User_Email" AS "User_Email" from "user_list".

main thread ($b98):
00760fe7 heidisql.exe mysql_connection 1867 +30 TMySQLConnection.ParseViewStructure
006d1b19 heidisql.exe Main 6804 +10 TMainForm.ParseSelectedTableStructure
006d14c5 heidisql.exe Main 6690 +47 TMainForm.DBtreeFocusChanged
0061cbfe heidisql.exe VirtualTrees TBaseVirtualTree.DoFocusChange
00621012 heidisql.exe VirtualTrees TBaseVirtualTree.HandleMouseDown
0053b1b8 heidisql.exe Controls TControl.DoMouseDown
00619360 heidisql.exe VirtualTrees TBaseVirtualTree.WMLButtonDown
00625227 heidisql.exe VirtualTrees TBaseVirtualTree.WndProc
0053eac8 heidisql.exe Controls TWinControl.MainWndProc
0049a524 heidisql.exe Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0056b229 heidisql.exe Forms TApplication.ProcessMessage
0056b26e heidisql.exe Forms TApplication.HandleMessage
0056b599 heidisql.exe Forms TApplication.Run
007a7742 heidisql.exe heidisql 66 +15 initialization

Written by ansgar
4 years ago
4940 posts since Fri, 07 Apr 06
The double quotes in your view code reveals you have enabled ANSI SQL style on your server:

CREATE VIEW "users_view" AS ...


Can you please switch to default SQL and see if that fixes the problem? Will most probably, as the regexp expects backticks where you have double quotes.
Written by cswearingen
4 years ago
2 posts since Fri, 05 Nov 10
Odd. Had to create a new account as I can't login with my other account (I'll post on that in another thread?).

Anyway the view wasn't originally created with any quotes/ticks other than the aliases. I was able to verify this behavior by remoting to the server and going into MySQL Admin to drop and recreate the view. I create it without any quotes/ticks (other than single quotes for aliases) and then went to Heidi and got the same bug report details showing double quotes.

After dropping the view and creating with ticks (`) I was able to get into it via Heidi. Seems the server itself was inserting the double-quotes in when the ticks are missing.
 

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