Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 7,398 total)
  • Author
    Posts
  • in reply to: #25847
    peterlaursen
    Participant

    I do not understand the latest point. I edited a NULL-column and added a NOT NULL column (both varchars).

    SQLyog sent this SQL (copied from HISTORY)

    Code:
    alter table `test`.`aa` add column `dd` varchar(30) NOT NULL after `cc`,change `bb` `bb` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL

    No defaults specified in this statement. Are you sure it is not the server that does this?

    Is what your refer to as 'latest version' 6.16?

    in reply to: SQLyog For Mac OS X #18568
    peterlaursen
    Participant

    I think it is possible to install the 'Microsoft Core Fonts' in darwine, excatly like in wine. This is undoubtedly an issue with fonts mapping between Wine and the underlying BSD-Unix kernel used by Mac OS-X.

    Refer to:

    http://webyog.com/faq/content/31/71/en/can…?highlight=wine

    (link to download of those fonts as exe-installers is there)

    in reply to: #25990
    peterlaursen
    Participant

    1) Please tell the SQLyog version! Help .. about tells this.

    2) Please specify that 'message of crash'. What exactly is it like. A screedump will be useful.

    3) I also do not understand “I reload the dump file”. Do you simply execute that small code snippet from an external file with SQLyog? For me it works fine (even if I repeat several times) – see

    [attachment=842:bonnie.jpg]

    One problem however could be the file encoding. That is why you should use a recent SQLyog version.

    in reply to: #26022
    peterlaursen
    Participant

    1) agreed. This dialogue should (as well as others) be resizable and non-modal (means it should be possible to work in main window even if this is open

    2) sorting. Not sure – one problem: You know that we plan to move 'code exectution' to 'manage indexes' dialogue (and not the 'subdialogue') to ensure that we execute a single ALTER TABLE only. Actually sorting indexes creates a new table definition!

    3) multiselect. I think it will less important once we execute all changes in one ALTER TABLE only. But anyway let us discuss this.

    4) All over the program we will check with the caption 'Cancel' that it only appears where 1) nothing has happened yet 2) performed actions can be reversed.

    in reply to: #26007
    peterlaursen
    Participant

    We cannot tell in every detail. The ISP must have that information somewhere.

    But please start reading:

    1) The “getting started” paragraph in the help file

    2) http://webyog.com/faq/content/16/66/en/wha…hlight=hostname

    Further: when specifying a domain for the connection don't use “http://”. The domain is “myserver.ext” not “http://myserver.ext” (“http://” is a PROTOCOL and connection to MySQL does no use that protocol).

    Probably you will need to start in CP to create a user for SQLyog/remote connection. Maybe also you will need to allow the ip/ip-range than you connect from. Besides that CP details are not relevant for SQLyog.

    Note that if connections fail when experimenting there may be two very differerent reasons:

    1) connection error like “can't connect …” . Then SQLyog finds no server where you specified. Details wrong, firewall etc.

    2) authentication errors like “access denied ..”. Then the server is there, but user details are not correct.

    in reply to: #26004
    peterlaursen
    Participant

    I do not think that MySQL support will care much about an issue reported with SQLyog only. Advice: post a reproducable test case with cmd line, next refer to other clients (QB, SQLyog, PhpMyAdmin .. whatsoever)

    in reply to: #26001
    peterlaursen
    Participant

    It is definitely the server that does!

    I tried from command line client

    Code:
    Enter password: ********
    Welcome to the MySQL monitor. Commands end with; or g.
    Your MySQL connection id is 6
    Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)

    Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

    mysql> use test;
    Database changed
    mysql> DELIMITER $$
    mysql>
    mysql> DROP PROCEDURE IF EXISTS `test`.`MyTest`$$
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    mysql>
    mysql> CREATE DEFINER=`root`@`localhost` PROCEDURE `MyTest`(IN _inVar MEDIUMINT(
    8) UNSIGNED)
    -> BEGIN
    ->
    -> SELECT 100 + _inVar;
    ->
    -> END$$
    Query OK, 0 rows affected (0.00 sec)

    mysql>
    mysql> DELIMITER;
    mysql> show create procedure mytest;
    +———–+———-+——————————————————–
    ———————————————————————–+
    | Procedure | sql_mode | Create Procedure
    |
    +———–+———-+——————————————————–
    ———————————————————————–+
    | mytest | | CREATE DEFINER=`root`@`localhost` PROCEDURE `mytest`(IN
    _inVar MEDIUMINT(8) UNSIGNED)
    BEGIN
    SELECT 100 + _inVar;

    END |
    +———–+———-+——————————————————–
    ———————————————————————–+
    1 row in set (0.00 sec)

    mysql>

    note

    Code:
    BEGIN
    SELECT 100 + _inVar;

    END

    |

    I am not sure I understand which of your servers (5.0.54 and 5.0.45) that does correct and which does wrong!

    If a recent version does 'worse' than an older one, I think you should report to bugs.mysql.com

    in reply to: #26000
    peterlaursen
    Participant

    btw:

    The short form “delimiter;” returns a syntax error for me on SQLyog 6.16/MySQL 5.0.51a.

    I need to insert a SPACE like “delimiter ;”.

    Does the short form work for you?

    in reply to: #25999
    peterlaursen
    Participant

    No records of such change in server changelogs, I think (I searched). Probably considered too small a change to put there …

    in reply to: #25998
    peterlaursen
    Participant

    We have no option to test with a server > 5.0.51a at the moment.

    With 5.0.51a on my localhost it behaves like your 5.0.45 server.

    I do not think it is a transmission issue. I think the server simply sometimes 'throws away' the empty lines.

    But it looks like it has been (more or less) fixed in 5.0.54.

    There have been lots of complaints in bugs.mysql.com and MySQL forums that the server did not preserve the original formatting for 'stored programs' and VIEWS (and I doubt it is fixed with VIEWs).

    in reply to: #25845
    peterlaursen
    Participant

    @shlomo

    1. Option to display sql before executing and give an option to copy&paste it. This is relevant for automated SQL generations, such as Manage Indexes, and Alter Table. Since this operation hangs an entire GUI window, and the whole sqlyog is unusable during this time, I'd prefer to copy it and run in from the command line client. Also, seeing the SQL before running it seems very important, especially for production systems.

    >> being a client SQLyog will have to wiat for the server's response. This is not a 'hang' – this is how a MySQL server and client communicate! You can have more connections or SQLyog instances running (as well as cmd line).

    >> 'preview SQL'

    2. Don't hang the front whole window while a long query is executing. Maybe use separate thread?

    >> again you can have more connections or SQLyog instances running. What we do plan to improve is that some dialogues 'block acces' to main window even if no activity is there

    3. Show running execution time during, when running a regular query. This is also relevant for aforementioned DDL operations from the GUI.

    >> never thought about that. I think we could update every 1 or 5 seconds … but did you ever read:

    http://webyog.com/faq/content/8/147/en/how…light=execution

    4. Remove DEFAULT '' from each table column that is created. It is not always needed, but it's there anyway. It shouldn't be added unless specifically chosen. This is actually a bug maybe, and not a feature.

    >> I do not understand! explain? program version? screenshot?

    in reply to: #25843
    peterlaursen
    Participant

    “On a VARCHAR NOT NULL column that has no DEFAULT value specified sqlyog should assume an empty string, not a NULL”

    [attachment=840:notnullchar.jpg]

    ok .. that makes sense! We will need some 'placeholder' for in the grid then because we actually read from the grid when inserting/updating.

    in reply to: #25994
    peterlaursen
    Participant

    1) we do have plans for the tabs (like rename, reorder), but not this …

    You can add here yourself: http://code.google.com/p/sqlyog/issues/detail?id=29

    2) That was considered allready when we released 5.0. I even think we considered to 'execute in virtual mode/simulate' for both SF's and SP's. (idea was that only stdout output and user variables should be affected, but not data stored on the server – whether user data or server variables).

    Any idea on how to handle OUT and IN/OUT -parameters?

    I think that was the main reason why we dropped the idea (+plus of course that codding such GUI functionality will take considerable time – and I think this was the first request of its kind).

    in reply to: #25974
    peterlaursen
    Participant

    Please let us analyse what the possibilities are!

    in reply to: #25884
    peterlaursen
    Participant

    I am sorry, but there is not change in 6.16 FINAL.

    To prevent overflow with BIGINT PKs we need to perform some conversions internally. We will analyse how this possibly could be optimized.

Viewing 15 posts - 3,181 through 3,195 (of 7,398 total)