Toad for MySQL - Beta

Toad for MySQL Beta Program Community

Beta Community Discussion

Scott M. Sanders
Follow / 16 Dec 2014 at 9:00pm / Toad for MySQL Beta Program
Latest post by on 16 Dec 2014 at 9:19pm

Editor Execute Button Breaks

Expand content
My editors’ execute script buttons randomly stop working. I click the icon or arrow, but nothing happens. I have to restart Toad every time. I have 7.5.0.422, and it did this in at least the...

My editors’ execute script buttons randomly stop working. I click the icon or arrow, but nothing happens.

I have to restart Toad every time.

I have 7.5.0.422, and it did this in at least the last beta, too.

49 1 / Create an account to join the discussion.
Steven Soto
Follow / 15 Dec 2014 at 8:16pm / Toad for MySQL Beta Program

Toad for MySQL v7.5.0.422 Beta is now available

Expand content
Toad for MySQL v7.5.0.422 Beta is now available A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now...

Toad for MySQL v7.5.0.422 Beta is now available

A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now!

http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

20 0 / Create an account to join the discussion.
snolan_484
Follow / 1 Apr 2013 at 5:32pm / Toad for MySQL Beta Program
Latest post by on 8 Dec 2014 at 6:07pm

Snippet shortcuts not working?

Expand content
If I type the snippet shortcut in the editor and press Ctrl-Space then the snippet is not inserted, the interface to find the snippet pops up and I have to select the snippet as if I had only typed Ctrl...
If I type the snippet shortcut in the editor and press Ctrl-Space then the snippet is not inserted, the interface to find the snippet pops up and I have to select the snippet as if I had only typed Ctrl-Space without for typing the shortcut - I'm using 6.7.0.1273

Sean
784 3 / Create an account to join the discussion.
Steven Soto
Follow / 5 Dec 2014 at 7:42pm / Toad for MySQL Beta Program
Latest post by on 8 Dec 2014 at 5:56pm

Toad for MySQL v7.5.0.402 Beta is now available

Expand content
Toad for MySQL v7.5.0.402 Beta is now available A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now...

Toad for MySQL v7.5.0.402 Beta is now available

A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now!

http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

110 2 / Create an account to join the discussion.
Steven Soto
Follow / 20 Nov 2014 at 9:26am / Toad for MySQL Beta Program
Latest post by on 26 Nov 2014 at 6:59pm

Toad for MySQL v7.5.0.362 Beta is now available

Expand content
Toad for MySQL v7.5.0.362 Beta is now available A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now...

Toad for MySQL v7.5.0.362 Beta is now available

A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now!

http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

79 1 / Create an account to join the discussion.
snolan_484
Follow / 28 Oct 2014 at 5:06pm / Toad for MySQL Beta Program
Latest post by on 24 Nov 2014 at 4:58pm

Exception when opening a new Editor

Expand content
I am using the new 7.5.0.291 beta and it has been really stable for about 4 days, but today I'm getting exceptions. Three exceptions windows open on top of each other when I open a new Editor, the...

I am using the new 7.5.0.291 beta and it has been really stable for about 4 days, but today I'm getting exceptions. Three exceptions windows open on top of each other when I open a new Editor, the messages in the windows are:

This one shows in three separate Error Message windows:

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.Editor.EditorForm.ExecuteSmartIdle(BarItem barItem)

This one shows in its own Error Message window:

System.ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Stack Trace:
at System.Collections.ArrayList.get_Item(Int32 index)
at DevExpress.XtraBars.BarItemLinkReadOnlyCollection.get_Item(Int32 index)
at Quest.Toad.Editor.EditorForm.ExecuteSmartIdle(BarItem barItem)

After the exception occurs the Execute script button on the toolbar is grayed out and I cannot use it, but pressing F5 or selecting Execute SQL on the Editor both still work and do execute the SQL.

The first time it happened, I had been using Toad for about 4 days ever since I first installed the new beta on 10/24, I then closed Toad and started it again and it worked normally for a few minutes and then the exception occurred again.

88 2 / Create an account to join the discussion.
Steven Soto

Toad for MySQL v7.3.0.312 Beta is now available

Expand content
Toad for MySQL v7.3.0.312 Beta is now available A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now...

Toad for MySQL v7.3.0.312 Beta is now available

A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now!

 http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

52 0 / Create an account to join the discussion.
snolan_484
Follow / 28 Oct 2014 at 7:19pm / Toad for MySQL Beta Program

Exception if dropping all triggers

Expand content
If I have the Triggers tab in the Object Explorer selected and I execute SQL to drop all triggers, then I get the following exception in Toad 7.5.0.291: System.ArgumentOutOfRangeException Index was out...

If I have the Triggers tab in the Object Explorer selected and I execute SQL to drop all triggers, then I get the following exception in Toad 7.5.0.291:

System.ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Stack Trace:
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at Quest.FastData.FastTable.RowCollection.GetFastRow(FastTable fastTable, Int32 index)
at Quest.FastData.FastTable.System.Collections.IList.get_Item(Int32 index)
at Quest.FastData.FastRowCollection.get_Item(Int32 index)
at Quest.Toad.MySQL.Trl.TriggerTrl.get_Source()
at Quest.Toad.MySQL.Trl.TriggerTrl.SourceTrl.get_Source()
at Quest.Toad.MySQL.Dov.ScriptViewControl.Source(ITrl trl)
at Quest.Toad.MySQL.Dov.ScriptViewControl.DataUpdated(Object sender, EventArgs args)
at Quest.Toad.Cache.LiveCache.UpdatedProxy(Object sender, EventHandler handlers)

35 0 / Create an account to join the discussion.
Steven Soto
Follow / 23 Oct 2014 at 11:56pm / Toad for MySQL Beta Program
Latest post by on 24 Oct 2014 at 6:48pm

FIRST Toad for MySQL v7.5.0.291 Beta is now available!

Expand content
The first beta for Toad for MySQL 7.5 has been posted and is now available for immediate download. Just head over to the download section and get it right now! http://www.toadworld.com/products/toad...

The first beta for Toad for MySQL 7.5 has been posted and is now available for immediate download. Just head over to the download section and get it right now!

http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

 

95 1 / Create an account to join the discussion.
southsideschmitty
Follow / 21 Apr 2014 at 2:07am / Toad for MySQL Beta Program
Latest post by on 26 Sep 2014 at 11:58pm

SSH connection

Expand content
I downloaded the beta version to see if connections via SSH (to something like AWS) were better supported in the product. I didn't dig around in the details, but could not find that it was. Am I missing...

I downloaded the beta version to see if connections via SSH (to something like AWS) were better supported in the product. I didn't dig around in the details, but could not find that it was. Am I missing something?

Unanswered 253 3 / Create an account to join the discussion.
coewar
Follow / 30 Aug 2014 at 3:07pm / Toad for MySQL Beta Program
Latest post by on 22 Sep 2014 at 9:57pm

Toad can not handle interrupted connections

Expand content
To make it confused, just cause a connection to DB to be interrupted and then try to use all functionality. The weird thing is that Editor windows likely will work, but things like DB explorer or Session...

To make it confused, just cause a connection to DB to be interrupted and then try to use all functionality. The weird thing is that Editor windows likely will work, but things like DB explorer or Session monitor will fail and totally hang and mess up Toad requiring you to kill the whole app.

The error window constantly pops up, locking the entire application.

This is with ver 7.3.0.3144  but in general it does not matter.. Toad has been plagued with this for years. Starting with Ver 7 is has been MUCH BETTER! But still there is some fundamental flaw in error handling and consistency across the application.

I will try the latest beta update.

134 1 / Create an account to join the discussion.
coewar
Follow / 30 Aug 2014 at 3:12pm / Toad for MySQL Beta Program
Latest post by on 11 Sep 2014 at 4:15pm

BUG - Only SOME!!! of the Server global variables do not output the...

Expand content
For a long time I thought setting the WAIT_TIMEOUT and INTERACTIVE_TIMEOUT values did not work in MySQL. I was really shocked to find that actually it worked fine, but it was TOAD that would always display...

For a long time I thought setting the  WAIT_TIMEOUT and INTERACTIVE_TIMEOUT values did not work in MySQL. I was really shocked to find that actually it worked fine, but it was TOAD that would always display the wrong values!!! (seen in DB explorer)

No matter what the setting was set to, for both of those it would always show a value of 2000000.

Even if inside an Editor window I run this:

show global variables like '%timeout%'

I get the CORRECT value.

This blew me away. :)

Unanswered 111 1 / Create an account to join the discussion.
coewar
Follow / 30 Aug 2014 at 3:16pm / Toad for MySQL Beta Program
Latest post by on 9 Sep 2014 at 4:30pm

Why can't you guys post Toad release notes for each update?

Expand content
Every time there is an update, there is always a mystery as to what was changed. And the Install habitually continues to show Release notes for some PREVIOUS versions.

Every time there is an update, there is always a mystery as to what was changed.

And the Install habitually continues to show Release notes for some PREVIOUS versions.

Unanswered 127 1 / Create an account to join the discussion.
coewar
Follow / 3 Sep 2014 at 5:39pm / Toad for MySQL Beta Program
Latest post by on 3 Sep 2014 at 5:47pm

Toad is not canceling queries nor is it even checking if the query...

Expand content
If you start a query that is taking a long time, and hit the Cancel button, the UI says it's cancelled but if you run 'show processlist' you will still see it running. And.. if you start...

If you start a query that is taking a long time, and hit the Cancel button, the UI says it's cancelled but if you run  'show processlist'  you will still see it running.

And..  if you start a long query and then go and kill that session from somewhere else, Toad will still continue sitting there waiting for it.

Unanswered 157 1 / Create an account to join the discussion.
coewar
Follow / 28 Oct 2013 at 3:37pm / Toad for MySQL Beta Program
Latest post by on 30 Aug 2014 at 3:08pm

Old bug still here: Schema compare does not work if stored connection...

Expand content
When creating a connection in Conn Manager, if you use SSH in drop down, the Schema compare system can't handle that. It should just use all the information in the Conn Manager.. and the connection...

When creating a connection in Conn Manager, if you use SSH in drop down, the Schema compare system can't handle that. It should just use all the information in the Conn Manager.. and the connection is already established.

This has never worked to my knowledge.

389 5 / Create an account to join the discussion.
jkehrel
Follow / 27 Aug 2014 at 3:02pm / Toad for MySQL Beta Program

Toad for MySQL v7.3.0.3241 Errors

Expand content
Hi. I have two mysql databases with 61 columns each. Each of them has about 120.000 records. If I do a compare with the compare wizard, everything works fine and I see that 53738 records are different...

Hi. I have two mysql databases with 61 columns each. Each of them has about 120.000 records. If I do a compare with the compare wizard, everything works fine and I see that 53738 records are different.

I save the compare options in a .dcp file. I open this file to redo the comparison and click on start. Now Toad tries to compare more records than available and hangs. See Picture 1

Ok new game. Compare with wizard again. Only show the 53738 different records. I try to save them to an Excel file. Does not matter if .xls or .xlsx.

After some time Toad gets an exception because of memory errors. System is Win7 Pro 64bit with 8 GB of RAM and about 30GB of free hard disk.

Yours

Dr. Jürgen Kehrel

108 0 / Create an account to join the discussion.
Steven Soto
Follow / 26 Aug 2014 at 12:18am / Toad for MySQL Beta Program

Toad for MySQL v7.3.0.3241 Beta is now available

Expand content
A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now! http://www.toadworld.com/products/toad-for-mysql...

A new beta for Toad for MySQL has been posted and is now available for immediate download. Just head over to the download section and get it right now!

http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/default.aspx

124 0 / Create an account to join the discussion.
coewar
Follow / 21 Aug 2014 at 5:59pm / Toad for MySQL Beta Program

Toad is not supporting using an SSH private key for SSH connections

Expand content
The only way to create a connection is by using username and password. It does have the private key option for SSL type connections. So seems like the work is mostly done, just need to add it to the...

The only way to create a connection is by using username and password.

It does have the private key option for SSL type connections. So seems like the work is mostly done, just need to add it to the SSH type connections.

Unanswered 263 0 / Create an account to join the discussion.
coewar
Follow / 30 May 2014 at 10:10pm / Toad for MySQL Beta Program
Latest post by on 21 Aug 2014 at 5:54pm

BUG! Explore database objects does not show info for the right connection...

Expand content
I noticed something in ver 7.2 and just verified in 7.3. If I would connect to a database, then click on the "Explore database objects" button, it would come up fine. But if I click on another...

I noticed something in ver 7.2 and just verified in 7.3.

If I would connect to a database, then click on the "Explore database objects" button, it would come up fine.

But if I click on another database connection and connect, and do the same thing, it actually is showing me the info for the 1st connection! Though the window tells me it's looking at the 2nd conn.

I know for a fact because they have different tables. Hitting F5 in the window has no impact.

However, when I hit Shift+F5, THEN the one reporting the 2nd connection shows me the correct information! BUT GUESS WHAT!!??  Then the one that was for the 1st connection starts showing me the info for the 2nd connection! Hitting F5 and Shift+F5 does not revert it.. so it's just stuck that way.

Even if I close all the Database explorer windows, and then double-click to make conn 1 active, opening up the explorer window gives me the info for conn 2.

I even DISCONNECTED conn2, and re-opened the window for conn1, and still showing me conn2 stuff. This time when I hit F5 it did refresh correctly.

There is something being crossed in the code here. :)

Unanswered 374 8 / Create an account to join the discussion.
coewar
Follow / 21 Aug 2014 at 5:33pm / Toad for MySQL Beta Program

Toad ALTER TABLE dialog window does not show "unsigned"...

Expand content
I have seen where when I load a table that has int UNSIGNED fields, the UI has a "False" for Unsigned attribute.

I have seen where when I load a table that has int UNSIGNED fields, the UI has a "False" for Unsigned attribute.

57 0 / Create an account to join the discussion.