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

Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 7,398 total)
  • Author
    Posts
  • in reply to: #26971
    peterlaursen
    Participant

    Please read:

    http://webyog.com/faq/content/16/66/en/wha…-at-an-isp.html

    My best idea is that you remove “https://”. As you use the COMMUNITY version you must connect directly. For direct connection to MySQL, protocol descriptors (like “https://” and “http://”) does not apply!

    Some routing systems on some networks will simply ignore the protocol descriptor if the MySQL port is specified, but not all! And it is theoretically incorrect to specify like “https://” .. SQLyog is not a browser and MySQL is not a Webserver!

    in reply to: #26955
    peterlaursen
    Participant

    Could you please attache two structure-only dump to reproduce with?

    That would thins a lot easier (and please zip!).

    Create a ticket if you want privacy.

    in reply to: #26952
    peterlaursen
    Participant

    I replied in your ticket.

    in reply to: Sqlyog On Windows Vista #23622
    peterlaursen
    Participant

    @tim

    I do not think you told as clear before (in your ticket) as now that this happens when improting CSV files! it was not clear to me before that this was where to problem occurred. We will try to reproduce this on a 64 bit Windows tomorrow.

    Except for that, are there other issues?

    Now as you went to the Forums, I will close your ticket as it is preferable to communicate in one place only!

    in reply to: #26954
    peterlaursen
    Participant

    You can start the program from command line of course. But SQLyog does not take parameters like connection names or connection strings. Also from inside the program there is no option to define a connection to connect automatically to predefined connections.

    They have both been requested before. Refer to:

    http://code.google.com/p/sqlyog/issues/detail?id=275

    We are trying our best to 'catch up' with all those (small and medium) requests posted by users. We have done a lot with 7.0 release but not this!

    in reply to: #26953
    peterlaursen
    Participant

    connections details are stored in the “sqlyog.ini” file. So if this file is recoverable, you can! Simply replace …

    in reply to: #26944
    peterlaursen
    Participant

    There are 3 issues

    1)

    comments

    // this is not a valid MySQL comment

    — but this is

    #and this is

    /*and also this is*/

    2)

    you are missing a ';' to conclude IF .. ENDIF construction.

    this

    Code:
    BEGIN
    IF ….
    ENDIF
    END

    should be

    Code:
    BEGIN
    IF ….
    ENDIF;
    END

    3)

    Since you (need to) use a ';' as delimiter inside the SP code you need to set a user defined DELIMITER around the SP code and conclude the SP with that. So the above becomes (using | as user DELIMITER)

    Code:
    DELIMITER |
    CREATE ….
    BEGIN
    IF ….
    ENDIF;
    END|

    In summary (without comments):

    Code:
    delimiter |

    CREATE PROCEDURE `spLoadAddrType`
    (IN param1 TINYINT(1), IN param2 VARCHAR(11), IN param3 TINYINT(1))
    MODIFIES SQL DATA
    SQL SECURITY Definer
    COMMENT 'Loads addrtype via insert or update'
    BEGIN
    IF ((SELECT COUNT(*) FROM addrtype WHERE addrtypeid = param1)=0) THEN
    INSERT INTO
    addrtype(addrtypeid,
    addrtypename,
    dispord)
    VALUES
    (param1,
    param2,
    param3);
    ELSE
    UPDATE
    addrtype
    SET
    addrtypename = param2,
    dispord = param3
    WHERE
    addrtypeid = param1;
    END IF;
    END|

    Delimiter;

    in reply to: #26949
    peterlaursen
    Participant

    You can try with version 7.0 TRIAL edition. Just install it to another folder then where your current version is.

    If this is an issue with SQLyog that has been fixed between 6.16 and 7.0 there is really nothing more we can do.

    in reply to: #26946
    peterlaursen
    Participant

    1) please tell the program version! If not 7.0 then try it and see if problem is the same (there was some fix in reconnect recently)

    2) is this happening with a specific server or more/all servers? What about a local server installed wiht default parameters?

    3) how do you connect? direct, HTTP or SSH?

    4) please tell the 'wait_timeout' and 'interactive_timeout' server settings (from SQLyog: tools .. show ..variables)

    5) if this slowness also occuring for operations that does not involve server communication – like switching between TABS and operating menus in the interface?

    in reply to: #26829
    peterlaursen
    Participant

    1)

    If data with special characters are stored with SQLyog does the problem persist? One reason for this could be that data are stored with UTF8 encoding into a (non-unicode) MySQL 3.23 table by some application. SQLyog does not encode/decode it displays data as they are stored. What application is writing and using those data?

    2)

    Please provide a small dump that illustrates this. A single table with a few rows of data is eonoug. Please dump with SQLyog – not any backup routine from a special application and not phpMyAdmin. Also attach a screenshot of how if displays for you in SQLyog, and in something else wehre it displays as you would expect. We will not be able to do progress without such *exact test case*.

    in reply to: #26887
    peterlaursen
    Participant

    Also a small test case (a SQL dump of a database) could be usable for this discussion.

    Just 4-5 tables with a few Foreign Keys/relationsships and a few rows of data in each table for instance.

    in reply to: #26897
    peterlaursen
    Participant

    I am moving this to 'customisation' where it belongs!

    in reply to: #26937
    peterlaursen
    Participant

    1)

    “I'm blocked from doing anything in the application until the current query returns. Or am I simply missing something.”

    Both yes and no! To run multiple queries simultaneously you nned to create two connections (this cannot possible be changed as this is how a MySQL server and client communicate). No matter how many query tabs you open in SQLyog, they will all use the same connection. To open another connection (using same connection details) use the menu .. file .. new connection using current settings (keyboard shotcut: Ctrl + N). To display all connection use menu .. windows .. cascade. QB must be opening a connection for every tab.

    2)

    “if I simultaneously run multiple queries (SHIFT-F9), the results are not returned for any of the queries until the last query has completed!

    This is a very good point! I don't know if we ever thought about it like this! But it is correct! We will discuss this. Actually first result should ideally return at once and it should be possible to work in the RESULT TAB opened while the remaining queries are completing. This will require more 'multithreadedness' in SQLyog, but this is also planned!

    We have considerations about about a 'revamp' of the GUI (such as a tabbed interface for connections). We have not decided on 'release strategy' in detail after 7.0 release. We have some details that were not completed in some features that I estimate would take around 2 months. After that discussion is open!

    in reply to: #26936
    peterlaursen
    Participant

    Additional: the search function here uses MySQL full-text indexes. Most software like this does. Only strings >= 4 characters are indexed by MySQL full-text indexes.

    in reply to: #26827
    peterlaursen
    Participant

    OK .. thanks for your feedback. Anyway it should work with every MySQL version. As explained here:

    http://webyog.com/faq/content/34/148/en/do…y-language.html

    Quote:
    … The above applies to MySQL from version 4.1. Before that MySQL does not support SET NAMES. With MySQL 3.23 and 4.0 SQLyog will simply receive a 'binary copy' of what is stored on the server. The computer must be using a LOCALE setting matching the stream of data.

    Please try 6.56 or 7.0 RC2. If problems persist please reply back. We will check internally if there is some known bug in 6.51.

Viewing 15 posts - 2,851 through 2,865 (of 7,398 total)