Forum Replies Created
-
AuthorPosts
-
RiteshMember
OK.
Got it.
We will be releasing SQLyog v4.02 FINAL on Monday that will have this bug fixed.
RiteshMemberPlease download the latest binary and let me know the results.
RiteshMemberWe have released a new build of SQLyog 4.02 BETA that fixes this bug.
You can download the latest binary from the following links:
FREE Edition: http://www.webyog.com/sqlyog/SQLyog402.exe
Enterprise Edition: http://www.webyog.com/sqlyog/SQLyog402Ent.exe
With that I would like to say that this bug will only effects v4.1.8 and v4.1.9. There already exists a bug report which explains the issue you are getting:
RiteshMemberCan you post a screenshot of the connection window with the database list?
SQLyog should never crash and if it is crashing then we need to fix the bug.
RiteshMemberSQLyog logs all the queries that it executes in the history pane. Can you cut-n-paste the query that SQLyog uses to set the privileges?
Can you provide us with create table statement of your mysql.user table?
RiteshMemberDoes switching off multi-monitor mode help?
Which multi-monitor management (e.g. Ultramon) software do you use?
RiteshMemberDid you try v4.02?
RiteshMemberCan you post a screenshot of your query pane with both the queries?
RiteshMemberbfalling wrote on Jan 31 2005, 06:21 PM:1) When you double-click a column header, the column width expands to at least fully display the column name, if not to the width of the largest content appearing in that column (kind of like Excel functionality). Your choice on how to handle loooooong data…2) When the SQL Results pane shows a result set, as there is *already* a horizontal scrollbar (I've got a lot of fields), couldn't you go the full distance and just display all the column headers fully by default?
Uncheck the option Truncate column header to max. data size in Tools -> Preferences.
RiteshMemberCurrently you can only sync 2 MySQL databases using SQLyog and SQLyog Job Agent.
Scheduled ODBC Import is planned for SQLyog v4.1.
As of now, you will need to import data from MS Access db manually using SQLyog's ODBC Import Tool.
RiteshMember@leegold: Can you cut-n-paste CREATE TABLE… stmt. for mysql.user table? Case of 'Y' and 'N' will matter if the collation for the columns are *case-sensitive*.
Also, did you run *mysql_fix_privilege_tables* script on your MySQL server?
RiteshMemberCurrently to edit/insert/delete any record in the Insert/Update window, you require to have a PK defined on the table.
RiteshMemberComplete MySQL 4.1 permissions are planned for SQLyog v4.1.
RiteshMemberCurrently, you can not specify length of PK using the Create/Alter Table…. This feature is in the TO-DO list of SQLyog.
You can always create a UNIQUE key using Table -> Manage Indexes… on the TEXT column. It will have the same property like PK.
HTH
RiteshMemberThis new release fixes the following bugs as reported at our forums:
http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1156
http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1164
http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1157
We have added a new feature in v4.02 wherein after every successful connection, SQLyog will try to fetch information about the character_set of the MySQL server and will set the correct values accordingly for client and result.
You can now view/add/edit data in your language.
-
AuthorPosts