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

Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 7,398 total)
  • Author
    Posts
  • in reply to: #25795
    peterlaursen
    Participant

    It is no new request.

    But if it shall be done properly it should be based on 'knowledge' of SQL.

    Currently SQLyog is 'ignorant' about SQL … it has to ask the server every time!

    I think we should discuss the priority of this and similar requests after the 6.2 release.

    in reply to: #25798
    peterlaursen
    Participant

    I do not know what happened, but know I can see the image. Probably it was because it was a little big and took some time to transfer!

    With a reasonable image format , 'cut', and compression you could have saved our server 20MB of diskspace. It is rather easy to tell the same message with around 100KB! Please observe!

    in reply to: #25797
    peterlaursen
    Participant

    1)

    I think the image did not come? Could you try attaching again?

    2)

    Please read:

    http://dev.mysql.com/doc/refman/5.0/en/comp-err.html

    You are sure that the error message file used in that system is not chinese?

    It does not do with other clients? Please try an erroneous query from command line client (just “SELECT blahblah”!).

    Execute on a Linux shell (do not connect from a Windows machine). Alternatively try MySQL Query Browser ..

    3)

    What is wrong about Chinese? It is a very informative language! 🙂 Jokes apart .. we have no such reports before!

    I think this must be a configuration issue on your system or a silly mistake with the MySQL build distributed with that distro!

    in reply to: Xml Import? #24326
    peterlaursen
    Participant

    You did not overlook anything. We do not have this option yet.

    There is not a single 'XML format'. XML is a formal standard on how to use tags only – there are several ways to store data in XML. Anyway I agree that at least we should be able to import the .xml format that we export ourselves. I think this was a repetition of a previous reply …

    Are you aware of any approved or 'de facto' standard of XML data storage that we should support?

    I do not know 'Basecamp data' .. details .. link?

    in reply to: #25792
    peterlaursen
    Participant

    I have no problems with “SELECT now()” in SQLyog.

    [attachment=819:now.gif]

    The only issue I can see is that “SELECT 'this is a literal 20 times'” will violate the buffer containing the HEADER if the returns of 'this is a literal 20 times' is longer than 64 characters. Because with such query (with no alias) the header is identical to data themselves!

    We do not handle a HEADER size > 64 chars properly. Of course we will fix it. That I told already. Only such issue is that buffer/memory handling can (in C/C++) involve quite a lot of 'low level' programming. For that reason we may decide to fix in the 6.2 trunk and not the 6.16 trunk.

    in reply to: #25790
    peterlaursen
    Participant

    Please confirm that you SELECT 'a quoted string'.

    The reason for this crash is that we expect only column headers of up to 64 characters. That is the max. size of a column name in MySQL. However we probably overlooked that when we are not SELECTing from a database – but selecting a literal string instead – a longer header can occur, and that condition/expection is not handled properly.

    So this buffer issue occurs with the column header and not with data. Also not with an ALIAS >64 characters!

    If this is not what you are trying to tell then please detail!

    in reply to: #25789
    peterlaursen
    Participant

    I think you meant

    “select '0x00000000000000000000000000000000000000000000000000000000000000000000000000

    00000000000000000000000000000000000000000000000000000000000000000000000000000000

    00000000000000000000000000000000000000000000000000000000000000000000000000000000

    000000000000000000000000'”

    with singlequotes?

    We have reproduced this (except that on a single machine running Vista ServicePack1 (RC) it does not!). Maybe the OS buffer protection was improved .. maybe some other reason …

    Please try an alias like

    “select '0x00000000000000000000000000000000000000000000000000000000000000000000000000

    00000000000000000000000000000000000000000000000000000000000000000000000000000000

    00000000000000000000000000000000000000000000000000000000000000000000000000000000

    000000000000000000000000' as something”

    This works for us on all systems!

    But you are right of course that this is a bug. And we will fix this. I cannot guarantee in 6.16 but no later than 6.2.

    in reply to: #25787
    peterlaursen
    Participant

    Does not crash for me with 6.16 beta 1 on Vista.

    [attachment=818:select.gif]

    … but what is the idea of that select?

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

    You can try SQLyog with the Wine ports available for Mac OS-X ('darwine' and 'CrossOver for Mac').

    Search 'Wine' in this Forum for more details!

    in reply to: #25756
    peterlaursen
    Participant

    I wonder if you have some adaptor permanently attached to the VGA/DVI port?

    Please also reply the question to the extend that you can!

    in reply to: #25785
    peterlaursen
    Participant

    In 6.2 it will be possible to select individual SP's and other objects (not only tables) for copy and export operations.

    in reply to: #25782
    peterlaursen
    Participant

    Could you guys please tell how this is a SQLyog-related question?

    There is no Forums, mailing list or simailar available for this 'WoW Private Server'? We cannot know the thousands of applications that use MySQL!

    However we have a FAQ on this error 1045:

    http://webyog.com/faq/content/23/18/en/err…on-denied-.html

    One idea: you can try to skip the configuration wizard, The installation folder will contain .ini file templates named like my_medium.ini etc) rename one of them to my.ini and try start the server from command line with “net start mysql'.

    in reply to: #25765
    peterlaursen
    Participant

    It DOES reconnect.

    However with SSH tunnel the complete connection chain SQLyog<>PLINK<>SSHD<>MySQL is not 'reinstantiated' – only SQLyog<>PLINK is.

    Reconnecting/reinstantiating the complete connection chain will be implemented in version 6.2.

    Are you using SSH tunnel?

    in reply to: #25763
    peterlaursen
    Participant

    Without going too much into detail (because I am not a coder) I would say that you will need to start writing a parallel to the MySQL C-API (libmysql.dll). And that is not a simple task!

    in reply to: CSV Import #15571
    peterlaursen
    Participant
    JerryL wrote on Jan 23 2008, 09:22 PM:
    I have about the same problem as the previous user… but the nl solution doesn't work… neither does n or l or nr or AUTO or any of my other attempts to snag this by trial and error.

    PSPAD says the records in my file end with hex B6 which they call &para. My table is large, so I am using WINRAR, but the database doesn't seem to have a problems with that. It also has no trouble restoring an entire database created the same way, or a smaller single table non-compressed table also created by the same software. I'm running out of ideas… and shudder at the though of splitting the table into 6 or 7 noncompressed chunks… ugh! Any thoughts? Is there any documentation for the corect way to enter the line control parameters into the box (abbreviations, hex codes, actual characters?) Oh, I also tried putting a ; at the end of each line and entering that in the line termination box… result was too many fields in first record error message.

    First i will ask you to add to the topic. braching liek this is very confusing (and I would wish the Forums software eitehr supported it better or did not support it at all!) I posted a reply reading

    “did you try 'rn' ('cariage return' followed by 'newline')?

    This is DOS/Windows standard for linebreak (Unix/Linux is 'n' only).

    You could inspect/view the file in a HEX editor! If you do not know how to do this, just attache a small example (please zip before attaching).”

    Now I think you understand a HEX editor. anyway a small example/test case is much better than words!

Viewing 15 posts - 3,301 through 3,315 (of 7,398 total)