what a crappy application

3 reasons why its crappy
1 - you are german ...all german software is crappy and they dear ask money for it ...suck it up ...and drink dutch bier sucker...
2 - you just stepped from apple API into microsoft ...and you are lost... coz now you can alot more ...but you just not use to it that it is allowed...explore ... dude ...
3 - you are some student and this is your first application .. than we all understand ...and hope you'll make it better...

but that isnt the reason i posted it ...
first message is to get attention...

your proggy does executes my query ...but crashes when i swicth to "data" tab..

here is the query:

DROP TABLE IF EXISTS server_params;
CREATE TABLE server_params
(
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
server_id INT(10) UNSIGNED ,
map VARCHAR(255),

net_strAdminPassword VARCHAR(64),
net_strConnectPassword VARCHAR(64),
gam_bUseExtraEnemies ENUM('0','1') DEFAULT 0,
ded_bRestartWhenEmpty ENUM('0','1') DEFAULT 0,
gam_bRespawnInPlace ENUM('0','1') DEFAULT 1,
gam_iFragLimit INT(10) UNSIGNED DEFAULT 0,
gam_iTimeLimit INT(10) UNSIGNED DEFAULT 0,
gam_bAmmoStays ENUM('0','1') DEFAULT 1,
gam_bHealthArmorStays ENUM('0','1') DEFAULT 1,
gam_bAllowHealth ENUM('0','1') DEFAULT 1,
gam_bAllowArmor ENUM('0','1') DEFAULT 1,
gam_bInfiniteAmmo ENUM('0','1') DEFAULT 1,
gam_bFriendlyFire ENUM('0','1') DEFAULT 1,
gam_bWeaponsStay ENUM('0','1') DEFAULT 1,
gam_bGibs ENUM('0','1') DEFAULT 1,
ser_bKickOnSyncLate ENUM('0','1') DEFAULT 1,
plr_bOnlySam ENUM('0','1') DEFAULT 1,
gam_iObserverOffset ENUM('0','1') DEFAULT 1,
ser_iMaxAllowedBPS INT(10) UNSIGNED DEFAULT 1638400,
ser_bEnumeration ENUM('0','1') DEFAULT 0,
net_iCompression ENUM('0','1') DEFAULT 0,
gam_iStartMode ENUM('Control Zone','Objective Thief','Serious Rugby','Team Control Zone','Capture The Flag','Steal The Objective'),
gam_ctMaxPlayers INT(10) UNSIGNED DEFAULT 42,
gam_tmSpawnInvulnerability INT(10) UNSIGNED DEFAULT 3,
ser_strMOTD VARCHAR(255),
net_tmConnectionTimeout INT(10) UNSIGNED DEFAULT 60,
net_tmProblemsTimeout INT(10) UNSIGNED DEFAULT 60,
gam_iStartDifficulty ENUM('Tourist','Easy','Normal','Hard','Serious','Mental') DEFAULT 'Serious',
gam_fExtraEnemyStrength ENUM('0','25%','50%','75%','100%','125%','150%','175%','200%') DEFAULT '0',
gam_fExtraEnemyStrengthPerPlayer ENUM('0','25%','50%','75%','100%','125%','150%','175%','200%') DEFAULT '0',
gam_iBlood ENUM('None','Green','Red','Hippy') DEFAULT 'Red',
gam_bPlayEntireGame ENUM('0','1') DEFAULT 1,
net_strObserverPassword VARCHAR(64),
net_iMaxObservers INT(10) UNSIGNED DEFAULT 8,
net_iVIPReserve INT(10) UNSIGNED DEFAULT 0,
net_strVIPPassword VARCHAR(64),
net_tmDisconnectTimeout INT(10) UNSIGNED DEFAULT 60,
gam_strGameSpyExtras LONGTEXT,
net_strLocationCode VARCHAR(128),
net_strLocalHost VARCHAR(128),
ser_bHeartbeatGameSpy ENUM('0','1') DEFAULT 0,
ded_tmTimeout ENUM('0','1') DEFAULT 1,

last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY status (server_id)
)ENGINE=MyISAM;

your proggy crashes directly after execution is complete and i switch to data tab...

after restart of the proggy ...it crashes everytime i try to access that table...

i see you do some smily replacements ...i hope you do it before render ...and not before saving to DB...
coz otherwise i've no way to post you the real SQL..

You do not really expect some serious reply to such ungracious statements, do you?

@ostap: as you analyzed anses skills that good, why don't you do some better "proggy"? no, let me ask you another question: why do you use it anyway? no one's asking for anything here, all that anse wants is good reports on errors so it stays a good "proggy" like we all want it to be and maybe you should start doing something good to the people instead flaming on them...but often that just how pips compensate their frustrated life, so no offense to you, dude

Thanks, tribal.

I already thought of deleting this post but ostap's arguments start to amuse me :)

Tribal is right ..i'm letting my steam out here...
Why i'm pissed off ? .. because i work on apple every fucking day of the week.
I'm not gonna include my wors experiences with that OS ..
but this one feels like "that one made for apple"
if you are an programmer - you'll know what i mean

and to ou anus ..or was it anse ?
what ever...
If you are ever come acrose free exresssion ...
you should think twice before thinking of removing it...

what ever .. screw you all ..
program still crashes on my table ...

none others do .. but others are more crappy than this proggy..

i'm not interested in pesting anyone...
i'm just reporting a fucking huge bug...

fix it ..
and remove that sort button .. each time i press an column ..
i have to reset the sorting ...

its not handy... if YOU deside ... its more handy if you give an option to the user as it is...(dont be an apple ars ... be an programmer)

fix it ..
and remove that sort button .. each time i press an column ..
i have to reset the sorting ...

its not handy... if YOU deside ... its more handy if you give an option to the user as it is...(dont be an apple ars ... be an programmer)

I'll refrase ..
multiple sortng option - is great ... implement it fucking diferently than as freaking default when user cklicks the column
stay away from apple ..

trust me.. i'm the sun screen

http://www.youtube.com/watch?v=xfq_A8nXMsQhttp://www.youtube.com/watch?v=xfq_A8nXMsQ

Hehe.. Is this probably a bot spamming my forum ? Probably not :)

ostap, if you want to report some access violation then go and paste the callstack here, describe the issue a bit and stay friendly. You can't expect any help after raging against me, or is it apple? I don't know...

It is not a bot ... sorry if i affended you in anyway ...
i'm just getting more and more pissed off by software now days...

if you wanted the stack dump - i would advice you to just execute my sql i've posted before ... you'll get all the info you need

and about the sorting - Yep ... could you please make it optional ...and not that sorting is added each time i click on column ?

query that includes multiple sorting options is not often used ... but is handy ... - the way you made it - it accumulates each time i press the column ...
it is annoying coz - each time i need to resort table - i have to clear the selection.

ow one more thing

single filter for just one column - would be nice too
directy setable from the options balk ...

select * from id = x ? .. or "timestamp=x" ?
it is freaking handy... trust me ...
just one column ...

if you want an algo tip - here is one

- if 1 column selected - sort by 1 column
- if >1 coluns selected - create sorting record (a+b+...)
- if 1 column clicked - remove all sorting records... sort by 1 column

this would be more convinient ..than acumulating clicks...

multiple sorting - should be left to the user choice ...not your program ... thats my point !!!

To make it all square ..
I'll donate you 100 euro ... if you'll make those changes...
No jocking ... coz from all soft i could find - yours is mucho grande ... better than else...

its not a price - its just apreciation for work your already did...i'm still using your client ...even that it crashes...


you know my email ...and i'm standing by the words i just said.

Ok, man. I cannto reproduce any crash after running your CREATE TABLE and going to the data tab. Nothing. Just an empty table. So I guess you have some old version in use. Callstack here, man.

Sorting: There already is an alternative when clicking on the "Sorting" button on the upper right. Please check it out. There should not be some customization option to make this stuff even more complicated.

The filter proposal sounds exactl like what is already possible in the upper right "multi column filter" edit box, is it? Probably missed that because the "Filter" panel is hidden.

main thread ($3ec):
004047ce +016 heidisql.exe System 548 +0 @TRUNC
006e7957 +027 heidisql.exe helpers 1453 +2 MakeInt
0067cf6c +1d0 heidisql.exe Main 3443 +35 TMainForm.DataGridBeforePaint
005e6107 +017 heidisql.exe VirtualTrees TBaseVirtualTree.DoBeforePaint
005f49c7 +077 heidisql.exe VirtualTrees TBaseVirtualTree.PaintTree
005ecc9b +0b3 heidisql.exe VirtualTrees TBaseVirtualTree.Paint
0054e843 +057 heidisql.exe Controls TCustomControl.PaintWindow
00548fc1 +055 heidisql.exe Controls TWinControl.PaintHandler
005497a0 +048 heidisql.exe Controls TWinControl.WMPaint
0054e7dd +011 heidisql.exe Controls TCustomControl.WMPaint
005e3bf9 +055 heidisql.exe VirtualTrees TBaseVirtualTree.WMPaint
00544540 +2d4 heidisql.exe Controls TControl.WndProc
00548e08 +568 heidisql.exe Controls TWinControl.WndProc
005ef534 +0e8 heidisql.exe VirtualTrees TBaseVirtualTree.WndProc
005484a8 +02c heidisql.exe Controls TWinControl.MainWndProc
00499e18 +014 heidisql.exe Classes StdWndProc
7c90e470 +010 ntdll.dll KiUserCallbackDispatcher

thread $7a0 (TWorkerThread):
7c90df58 +0a ntdll.dll NtWaitForSingleObject
7c8025d5 +85 kernel32.dll WaitForSingleObjectEx
7c80253d +0d kernel32.dll WaitForSingleObject
005d0991 +19 heidisql.exe VirtualTrees TWorkerThread.Execute
00460713 +2b heidisql.exe madExcept HookedTThreadExecute
00497946 +42 heidisql.exe Classes ThreadProc
00406818 +28 heidisql.exe System 548 +0 ThreadWrapper
004605f5 +0d heidisql.exe madExcept CallThreadProcSafe
0046065f +37 heidisql.exe madExcept ThreadExceptFrame
>> created by main thread ($3ec) at:
005d0886 +16 heidisql.exe VirtualTrees TWorkerThread.Create

ha ..it crashesh on render ...nice..

check the allocated string lengths ... it could be the cause ..
coz 1 out of 2 times when i press continue (multiple times) - proggy works...

still wonder why thoughif you corrupted your stuck - windows would terminate your prog on first return

But many Borland classes use heap allocate ... so your stack might not be affected...

and i see you use "WaitForSingleObject" ...
I had similar problems when child threads were using globaly allocated strings..(beside the designated data for that thread) ..(dumb of coz ...but nobody is perfect)

and about the sorting again :

yep i've already found that - its cumbersome...
selected collumns disappear from the view ...and any new sorting require to reset it back to default...

what i ment is - just a drop down menu with columns right on the top of the data list ...
and filter by:
something =X,
something != X
somethign > X
something in (not IN) (list)...etc...
... thats most used operation for quick view through large tables....

and clicking on each name - should not autmaticaly add it to the multicolumn sorting ...

Thanks for the callstack. It tells me - like I already guessed - you have an old build in use. You are seeing bugs I already fixed. Please update via Help > Check for updates.

About sorting again: Did you then see the right click menu items?
- Reset sorting
- Quick filter > ...
Sounds like you are searching for those.

well yea ... new version is mucho better :)
no crash windows and all tables are accesable and editable (previous version did not show the edit tab at all)
but clicking on the column - still adds sorting to the list ...and keeps accumulating...

I've also evaluated the right click menu options ...
they are handy..(just few of them) ...except just one :)

here i go again ...
right click=>Quick Filter=>field_name='..."

is exactly what i ment ...but not that deep into the options ..
its not even on the top ...but thats not the point ...

I will mention Apple again ...i hate the guts of it ...but one and only MySQL client available there - was kinda simple and offered exactly what i got use to in the past 5 years working with it ...
a direct select (drop down list) of the columns and the value for filter...

it is convinient and visible directly to any type of user.
instead of digging into the options menu.

you are creating a mini dialog when i click on the menu option
why not put the same one (or move) just near the messsage "xxx table: xx,xxx rows total, limited to 1,000"...

searching by one value - is the first what user wants to do ..
so it is unlogical to hide that deep into the options...

multiple search is great ... - keep it ...but plz make it optional ...not accumulative as it is now

as i would implement it -
is to use a dialog window to select column as you did ...
or use key stroke + mouse click ...to select columns for sorting...and than if needed adjust direction from the existing dialog...


just think ... if you want to see a record of users...
you click first on date - to see latest ...than you click on update ...to see updated... than you click on few other fields to see differences...
All this still just 1 field sorting ...
Right now - its impossible - coz you collect each click into filter option.

btw - this was ..and still the most confusing option...
coz in default windows - you got just 1 column sorting ...
so all the users use to ...

click click ..wtf ? .. hmmm ok no sorting thus...
just later i've discovered the reset option...and sorting was by id, by date , by name , by field x, by field y... etc...
no wonder i had no change ...

To round it all up for today -
Proggy is good now ... but all the issues ive given to you - are the same issues i'm facing every day at my work ...

UI - is not just add an option to the list and done with it...
Sometime we sit for hours arguing why it should be on the left and not on the righ... or should be green instead of red...
drop down instead of radio/ckeck button list...

As well - new stuff ... its hard to invent now days ...coz users are dumb fucking wanahaves ..nobody likes new stuff unless its as easy as candy sucking ...

What i'm asking you - is not simplifying your program ...
but making your UI more accessable to professionals than to beginers...

ow ...and its true...
programmers are the most laziest ppl in the world ...

Calm down man. I'm not lazy.

I'm a bit lost in the myriad of comments here. What I understood is your proposal to make sorting action always per one column when you click a column header, they should not be cumulated. Did I understand right?

i ment us programmers in global ...not just you...:)

yep...
and multisort - via dialog ... or keystroke+ click ...or both actually...

damit ... sorry
i've just discovered something i shouldnt ...
you are from Germany ... i just looked at the bottom of your page ...

this explains alot ...
sorry ...i'm withdrowing all my issues...due to the fact that all german software i've ever encountered - was always super crap ... sorry ...no personal feelings..

although as promised - i will transfer your the 100 .. before new year...thanx ...

nothing against the fox ..
its just german programmers are ...
never mind...

move to holland - it helps alot ...

No need for donations - although they are welcome. I would be happier if we could just get a bit more practical and exact, and a less spammy and shouty.

ya

This thread is funny, albeit rather sad.

Does adding a new comment to this 6 year old diatribe explain why it appears at/near the top of forum postings, or is there some setting I can change to avoid such "crap?" Whoever ostap was he/she posted 47 messages in one thread -- I hope English was his/her 2nd language because it's deplorable...

Sorry, there is only the setting "Notify me on replies", which you can disable, but that's a global option, not per date selection.

Sorry, there is only the setting "Notify me on replies", which you can disable, but that's a global option, not per date selection.

No need to apologize but thanks! I just wondered why this post seems "current" when it's not.

Honestly, I've never used a MySQL client I like as much as HeidiSQL. It's simple, intuitive design makes it easy for scatterbrains like me who forget SQL query terms, syntax and other more technical details. I donated only €10.00 so it was a real bargain... I should donate more!

Thanks again, ansgar!