[ashwin]

Hi,

Quote:

There was an error while executing a query.The query and the error message has been logged at: C:UsersMiguelAppDataRoamingSQLyogsqlyog.err. Please click on “Open Error File…” to open the error file.

Open the error file and at the bottom of the file you can see the error message and details. There might be many reason for the MySQL error while executing SQL script. Please check the error message for the exact reason.

Regards,

Ashwin A

[ashwin]

Hi Achintya,

Quote:

I am using SQLyog version 9.51

SQLyog version you are using is 9.51. But from the screen-shot we can see that in Connection manager “Clone” button is not present. Version history 9.2 beta1- “Added an option to clone a connection in the connection manager.”

Refer: http://www.webyog.com/blog/2011/06/30/sqlyog-mysql-gui-9-2-beta-1-released/

Please check Help->About for the proper SQLyog version.

About the error, Can you connect to the tunneler URL from a browser? Are you behind a proxy server? Then you should provide the required authentication details by clicking on the Advanced button. Also, go to Help->Check for updates and tell us if you are getting this message “Unable to find update information”.

Regards,

Ashwin A

[ashwin]

Can you please tell:

1) SQLyog version, MySQL version(SELECT VERSION()), connection type?

2) Screen-shot of Duplicate table structure/data.

3) SHOW CREATE TABLE of both the tables(duplicated table and source table).

[ashwin]

Moving you to the right place…

[ashwin]

Hello,

Quote:

when creating a table in the designer it now defaults to creating the table that updates the timestamp on row update. How can I change the default behavior to not add the command so it is an on insert only timestamp?

Please read this FAQ:

http://www.webyog.com/faq/content/8/159/en/how-do-i-define-timestamp-properties-with-sqlyog.html

If you want to do this- (NOT) NULL DEFAULT CURRENT_TIMESTAMP, then “Just define the column type and name/identifier and enter “CURRENT_TIMESTAMP” (without quotes) in the default column. You may check the NOT NULL checkbox or not and the column will be created accordingly. “

I guess you are just adding NOT NULL to TIMESTAMP without adding the CURRENT_TIMESTAMP as default. That's why you are getting “on update current_timestamp” but not DEFAULT CURRENT_TIMESTAMP.

Quote:

Plus how to I view the table creation sql on an existing table without having to do a sqldump?

Click the tablename in the Object browser and open the INFO tab and you can see the Create table statement for the table. The DDL information of the table will be shown in the INFO tab.

Regards,

Ashwin A

[ashwin]

Hello,

This is a server error and not an error with SQLyog.

Please try the following:

1) Stop MySQL server.

2) Empty the /tmp folder (The file 'C:xampptmp#sql7c0_a_6.MYI' is a temporary file created by MySQL with a random file name. If such file exists already creation of new file will fail. So try emptying the TEMP folder.)

3) Restart MySQL server.

Refer MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

Regards,

Ashwin A

[ashwin]

Here is the FAQ detailing how SQLyog calculates those times. But anyway we will analyze this and update here.

[ashwin]

Hello,

Is it always reproducible to you? We tried in Windows 2003 Server and it is not reproducible. Any other dialog window having this painting issue? Please open Tools->User Manager and check whether there is any painting issue or not.

Regards,

Ashwin A

[ashwin]

Hi Mitch,

Quote:

In the tree view on the left, when database name is selected and mouse is not over the selected database, the name is truncated. See attached screen shot. The full name of the highlighted database is mcmurrayinternal. When I mouse over the selected database name, I can see the full name.

The issue is added here: http://code.google.com/p/sqlyog/issues/detail?id=1748 We will analyze this and update you.

Regards,

Ashwin A

[ashwin]

Issue confirmed. This bug fix will be available in the next public release.

[ashwin]

Hello,

Thanks for the information. As changing the resolution fixes this issue you don't have to change the DPI. Thank you for reporting this bug. We will look into it.

Regards,

Ashwin A

[ashwin]

Also, please change the DPI setting to smaller(100%) and check.

[ashwin]

Issue confirmed. We are checking this.

[ashwin]

Hello,

Issue confirmed. We will fix this with priority. With Windows classic theme and screen resolution of 1280*768 this is reproducible. Can you please try increasing your screen resolution to 1280*1024(Recommended) and check if the issue still persists.

Regards,

Ashwin A

[ashwin]

Hi Larsen,

Quote:

The problem I see is that the user normally assumes that pressing “save” is all he has to do.

We have released 9.51GA. In this build after you press 'Save Changes' in User manager 'FLUSH PRIVILEGES' will be executed. You can download it from [url=”http://http://webyog.com/en/downloads.php”%5Dhere%5B/url%5D

Regards,

Ashwin A

[Author]

Posts