Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantSeptember 12, 2007 at 6:00 pm in reply to: Cannot Alter Stored Proc Anymore – Green Arrow Disabled And F5 Does No #24963ParticipantI know that such changes can be annoying.
But it has also been confusing to some users that single-arrow in some contexts would 'execute all' – and a little dangerous actually. That is why we disabled it for the 'special tab' in 6.0 to tell users that ALL would be executed!
Basically I think what we do now is correct, and what we did originally was not.
September 12, 2007 at 4:11 pm in reply to: Cannot Alter Stored Proc Anymore – Green Arrow Disabled And F5 Does No #24961ParticipantI will reply that that again!
Short answer:
–> Use the duble-arrow icon!
Long answer:
–> When you alter an SP from SQLyog a template script will be generated using the current SP code like
Code:DELIMITER $$DROP PROCEDURE IF EXISTS `test`.`rrrrrrrr`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `rrrrrrrr`()
BEGIN
select * from t4.blabla;
END$$DELIMITER;
In here there are TWO SQL statements: DROP and CREATE (DELIMITER is NOT a SQL statement – it is a client-side control statement only!). To ALTER you have to 'execute all' – both DROP and CREATE. That is what the 'double green icon' is for.
In your old version the single and double green arrows did the same for the 'special' or 'advanced' tab type used for SP, VIEW etc. templates.
The only reason that this 'special tab' was introduced was that in the beginning the 'common' tab type did not handle DELIMITER.
Actually version 6.1 beta 1 will be released in a few days and there will then only be ONE tab type. There is no need for the 'special' one anymore as 'common' tab type works with DELIMITER. And both single-arrow and double-arrow icons will be available on all tabs. But you should note that also with this one you will have to 'execute all'. 'execute' (single-arrow) only executes the statement where cursor is positioned!
Was that understandable?
Participantthere seems to be a special issue with Czech locale.
We verified now that nothins is hardcoded, we only issue WIN 32 API calls like
(SHGetFolderPath(NULL, CSIDL_APPDATA, NULL, 0, fullpath) to get the APPDATA path.
However when we
if(SUCCEEDED(SHGetFolderPath(NULL, CSIDL_APPDATA, NULL, 0, fullpath))) fullpathstr.SetAs(fullpath);
.. there is no 'else' … so we do not 'catch' such exceptions at the moment!
We will soon provide either
* a binary that does some logging
* or a simple commandline program printing the output of the API calls, so that we can wee what goes wrong!
If possible we will also install a Czech WinXP ourselves. We have a Microsoft subscription for ISV's and have more than 100 DVD's with software .. Czech XP is probably there.
5.32 COMMUNITY can be downloaded from:
http://www.webyog.com/downloads/SQLyog532.exe
If you use ENTERPRISE, please create a ticket and I will give the 5.32 link and registration details for you.
ParticipantWhat would you print?
From the SQL-editor?
Form RESULT in text-mode?
Something else?
ParticipantBut of course you can schedule SJA data sync to execute on short intervals like 2 mins, 5 mins.
The job only need to include that single table.
ParticipantNot with SQLyog.
Maybe a TRIGGER can be used (but I cannot figure out exactly how to write it – also depends on what exactly should happen) and maybe MySQL-PROXY can handle it.
Also the
table could be a FEDERATED table. TRIGGERS and FEDERATED tables are only possible with MysQL 5.x and 6.x.
But basically I think that having tables with dublicate data is a bad design!
September 11, 2007 at 11:19 am in reply to: Stored Procedure Formatting Lost On Backup/restore #24884ParticipantThe formatting issue:
You were right and I was wrong. It is basically a SQLyog issue. It has been solved in the development tree.
However, with some (mostly early 5.0.x) server versions there may be server issues too.
ParticipantProgram version please?!
1)
Are you talking about CREATE/ALTER TABLE GUI?
Can you explain 'hardly visible' ?
2)
Display in Objects tab is like MySQL returns it when queried SHOW CREATE …
If we change that you will not be able to copy/paste and use it!
3)
Tooltip ('hovering') on Objects in Object Brower is a nice idea.
But I am not sure that I think COMMENTS is the most important information for such tooltip.
September 11, 2007 at 8:11 am in reply to: Stored Procedure Formatting Lost On Backup/restore #24883Participantthe 'box' character is probably a
. Upon request we will go deeper into the formatting thing!
About Forums:
Forums are HTML and multiple
are stripped to one! Clik the icon 'wrap in code tags' for text that should be formatted. Almost all such software does the same! Except for .txt and common and compressed image formats (.jpg, .gif, .png) I recommend that you zip attachements. For two reasons:
* to save disk space on the server
* because any format that can directly infect a computer with virus etc. and be used for 'code injection' we cannot accept! This is not to protect ourselves actually (because Linux does not care about file extensions) but in order to protect our users against malicious attacks!
ParticipantIssue confirmed with our Ubuntu 7.04 (64 bit with 32 bit libraries).
However not yet sure if it is the same issue as you report.
We will need a little time to analyze this! I hope we can get in 'pushed in' tomorrow or Wednesday.
ParticipantWe have 2 different Ubuntu's installed. A 7.04 64 bit (with 32 bit libraries installed too) and an older (6.x I think) 32 bit.
No problem the latter. We will try the other one as well , but it mostly looks like some issue specific to your system.
Ideas are welcome!
ParticipantI do not mind!
We have some reports (I guess 6-8) that ini copy has failed.
Except for one (in our ticket system – and a very special one) manual copying has solved this every time as far as we know. Did I miss something?
We also know it has worked on > 20 systems of our own (2K, XP, 2003, Vista, Wine), and several * 1000 users have upgraded since 6.06. And that they would report (even if they do not understand they would report symptoms!).
We have no clue till now why it failed when it did!
Now this copy is a one time thing only needed when upgrading from <= 6.05 to >=6.06.
BTW: I do not understand why it is interesting to discuss if I 'admit' …
And further I think it is bad 'netiquete' to discuss this in another user's thread. In this thread we (you and I) should concentrate on helping this user!
ParticipantGot your details ..
we will see what we can find out tomorrow!
Participant -
AuthorPosts
