Structure Sync Leaves Out Comment

[cpriest]

Hey there, It seem that the structure synchronization tool does not take into account comment changes, is there any way this can be added?

Also, when there's an error altering a table it would be really nice to see the whole query so we can tell where the problem might be… sometimes the error isn't specific enough because it cuts off the beginning part of the alter query…

Thanks!

[peterlaursen]

1) Comments.

Well actually it is the plan that with version 5.1 the STRUCTURE SYNC tool shall be completely finished. So I second this request. It should not be allowed to delay the release of 5.1 I think, but then it could be added with a 'service release' (5.1.x)

2) Error in ALTER TABLE.

I am not sure that I understand this. When you copy to file or clipboard you get the complete query – all CREATE, ALTER and DROP statements. And the errors that you might get are errors sent by the server. But you should not get errors! What kind of error do you get? Is this issue/question/request also related to the STRUCTURE SYNC tool or just the common ALTER TABLE -functionality?

[cpriest]

Hello, clarification on #2

Its not related to a structure sync… I was altering a table at one point and had made numerous changes, one of which was causing an error. I believe I had put in the default value in the len column… clearly my mistake.

The problem was that when I went to save the changes I got back a non-descript error which referred to the alter table query that I couldn't see. It'd be nice if when you go to alter a table if the sql statement produces an error that we can see the sql statement that produced the error…

Thanks much!

[peterlaursen]

You should be able to see the alter table statement in HISTORY tab (unless it exceeds 4 KB in size >> http://www.webyog.com/faq/28_89_en.html) – also if it is unsuccessfull

[Ritesh]

Support for COMMENTS in Structure Sync Tool has already been implemented in v5.1 development tree.

[peterlaursen]

FAQ write-up accordingly!

http://www.webyog.com/faq/5_20_en.html

[cpriest]

Hey, good to hear about the comment structure syncronization, its still tripping me up. Is there a way I can download the 5.1 development version? I can handle a few crashes if need be…

Also, with the error on alter table, how can I see the history if there's a modal 'alter table' window up?

Thanks!

[Ritesh]

v5.1 BETA 1 would be available next week. We are fine-tuning the last remaining 10% issues as of now 🙂

[peterlaursen]

Quote:

Also, with the error on alter table, how can I see the history if there's a modal 'alter table' window up?

Right! The 'Alter Table' pane is 'stealing focus' and must be closed.

[Author]

Posts