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

Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 7,398 total)
  • Author
    Posts
  • in reply to: CSV Import #15570
    peterlaursen
    Participant

    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).

    in reply to: #25762
    peterlaursen
    Participant

    “i really need to be able to set filters to each field, is that not possible”

    Not yet implemented if you mean 'filter on more than one field at a time'. There is a 'filter on one field' in the context menu of a cell in the DATA tab (not yet implemented either in RESULT tab. There is a problem with BLOBs that halted this).

    Both features are planned. Also an option for 'user-inputting' values to filter by is. But this last one and 'filter on more than one field at a time' may be released with ENTERPRISE only.

    Parts of code is there. But we gave 1st priority to (ENTERPRISE) Query Builder and Schema Designer.

    in reply to: #25755
    peterlaursen
    Participant

    as a workaround you can delete 4 lines in sqlyog.ini reading like

    Left=56

    Top=-5

    Right=1249

    Bottom=853

    Then SQLyog will start in standard position (upper left corner of PRIMARY screen) next time it starts.

    We will try to fix it in 6.16 or 6.2 , but still please tell details about what software is used for configuring this multimonitor setup!

    in reply to: #25761
    peterlaursen
    Participant

    I posted this to our issue tracker:

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

    in reply to: #25743
    peterlaursen
    Participant

    YES!

    We will fix in 6.16 only!

    The error occurs with MySQL servers 3.x and 4.0, not MySQL 4.1 and up!

    in reply to: #25741
    peterlaursen
    Participant

    It is reproduced with MySQL 3.x and 4.0 (but not higher versions)!

    It will be fixed in version 6.16 beta1!

    in reply to: #25750
    peterlaursen
    Participant

    Still an 'embedded' OLE object does not contain binary data similar to what a BLOB (in access: a memo field) would!

    We are preparing our own test case. But please post yours as well”

    If it is possble with ODBC to retrieve the data and store only the binary data (with no OLE headers) we will find out!

    in reply to: #25739
    peterlaursen
    Participant

    Can you confirm that your MySQL version is 3.x or 4.0 ??

    in reply to: #25760
    peterlaursen
    Participant

    From the same MySQL docs link:

    “However, a TIMESTAMP column can be allowed to contain NULL by declaring it with the NULL attribute. In this case, the default value also becomes NULL unless overridden with a DEFAULT clause that specifies a different default value. DEFAULT NULL can be used to explicitly specify NULL as the default value. (For a TIMESTAMP column not declared with the NULL attribute, DEFAULT NULL is illegal.)”

    Now we (on the client side) implicitly add “default NULL” to a TIMESTAMP declared NULL with no explicit default. Actually we would not need to, because if we did not, the server would! But this may be like that for MySQL 4.0 compability! If you had asked me 2 years ago I would have remembered all those details!

    in reply to: #25759
    peterlaursen
    Participant

    Actually I have been editing the post a little for clarity!

    I think that we should discuss this.

    Basically we can simply ignore if user enters “NULL” in the default column of CREATE/ALTER TABLE gui for a TIMESTAMP type I think! Then it will work too!

    in reply to: #25757
    peterlaursen
    Participant

    With recent MySQL versions (>=4.1) just leave the 'Not NULL' checkbox unchecked, leave the default empty, and it will be defined “NULL default NULL”.

    What is your MySQL version? Earlier version differ!

    In HISTORY you can see what happens if you enter *NULL* literally. It generates invalid SQL like

    alter table `test`.`test` add column `ts` timestamp DEFAULT 'NULL' NULL after `something`

    A timestamp default is assumed to be a string in 'yyyy-mm-dd hh:mm:ss' format. NULL will add “default NULL” implicitly.

    For completenes I will add that if you CHECK the checkbox the timestamp will be

    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

    .. if not a CURRENT_TIMESTAMP is allready defined. If such one is defined it will be

    NOT NULL DEFAULT '0000-00-00 00:00:00' (however note that zero-time is not allowed in certain sql_modes – you can enter another default as 'yyyy-mm-dd hh:mm:ss'!)

    This is implemented in the server! compare what SQLyog sends (see in HISTORY) and compare what SHOW CREATE TABLE returns after creation!

    More details in MySQL docs:

    http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

    For other TIMESTAMP constructions than

    *NULL DEFAULT NULL

    *NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

    *(NOT) NULL DEFAULT 'yyyy-mm-dd hh:mm:ss')

    .. you will have to write the CREATE/ALTER statement yourself

    in reply to: #25736
    peterlaursen
    Participant

    1) Would it make any difference to use 'localhost' instead of '127.0.0.1' ?

    2) If you have a Internet connection that makes it possible or a LAN could you try your global ip or LAN ip? Also try the 'Computer Name'.

    3) Any more details in the MONyog log?

    4) If you have another ('ordinary') webserver installed can you connect to this one (on port 80 or 8080). There are very small and simple webservers available you can test with, if you do not want to experiment with IIS or Apache!

    5) If you have a LAN available can you connect from another computer (using ip or 'Computer Name')?

    I still can only think of Firewall (and Host File) issues!

    in reply to: #25717
    peterlaursen
    Participant

    As regards the 'grantor' issue.

    http://dev.mysql.com/doc/refman/5.0/en/privileges.html

    “The Timestamp and Grantor columns currently are unused …”

    in reply to: Tunnelling On Shared Host: Extension Xml Was Not Found #23679
    peterlaursen
    Participant

    Actually we had a discussion about this With Godaddy about 6 monts ago.

    They explain

    “The basic problem is that our PHP4 on Windows includes an older MySQL client library that only work or MySQL <= 4.0. Currently, all new MySQL databases in our system are 4.1 or 5.0, although we still have many 4.0 that exist. (Our Windows Shared hosting customers who want to use MySQL [vs MSSQL] use other languages than PHP4 [e.g. ASP, ASP.NET, Cold Fusion.]) We did try to comment all references to extension_loaded() in the tunnel, and when trying to connect to a MySQL 4.1 database, we experienced the “Client does not supprt authentication protocol” PHP error mentioned in http://forge.mysql.com/wiki/PHP_FAQ.

    While the tunnel on our Windows PHP4 should work fine with any MySQL 4.0 databases in our system, the fact that our Windows PHP4 simply can't connect to MySQL 4.1/5.0 databases is the key problem.”

    So currently GoDaddy will not support PHP on Windows hosting. It works in your case with SQLyog 4.x, but that must be because you have an older setup (“… although we still have many 4.0 that exist”) than what they do today.

    To support MySQL 4.1 and 5.x features we need full XML support. SQLyog 4.x was designed for 3.23 and 4.0 basically! We cannot release that.

    There have been discussion that Godaddy should update their PHP configuration (but it probably is not easy as it has a lot of dependencies!) or we should provide an ASP based tunneller. No conclusion yet.

    in reply to: #25748
    peterlaursen
    Participant

    “Images are stored in an “OLE Object” column”

    No they are not stored, I guess! OLE means 'Object Linking and Embedding'. I think the Access database only has stored a link to the image file? OLE is not supported by ODBC I think (but not sure).

    However, please attach a small example of such file with a few (small) images. Also attach the images themselves (please zip into a single file before attaching) and we can debug what info the driver is able to get!

Viewing 15 posts - 3,316 through 3,330 (of 7,398 total)