Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participantdid 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).
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.
peterlaursen
Participantas 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!
peterlaursen
ParticipantI posted this to our issue tracker:
peterlaursen
ParticipantYES!
We will fix in 6.16 only!
The error occurs with MySQL servers 3.x and 4.0, not MySQL 4.1 and up!
peterlaursen
ParticipantIt is reproduced with MySQL 3.x and 4.0 (but not higher versions)!
It will be fixed in version 6.16 beta1!
peterlaursen
ParticipantStill 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!
peterlaursen
ParticipantCan you confirm that your MySQL version is 3.x or 4.0 ??
peterlaursen
ParticipantFrom 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!
peterlaursen
ParticipantActually 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!
peterlaursen
ParticipantWith 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
peterlaursen
Participant1) 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!
peterlaursen
ParticipantAs regards the 'grantor' issue.
http://dev.mysql.com/doc/refman/5.0/en/privileges.html
“The Timestamp and Grantor columns currently are unused …”
January 22, 2008 at 10:06 am in reply to: Tunnelling On Shared Host: Extension Xml Was Not Found #23679peterlaursen
ParticipantActually 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.
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!
-
AuthorPosts