You will no longer receive e-mail notifications from this forum.
Log-In to post
Installed new Toad for MySQL 7.7. Imported connections from Toad 7.0.
I am unable to connect to any of my pre-defined connections which still work in Toad 7.0.
Newly created connections do not work either. I have 105 MySQL servers on linux which i administrate
and so far Toad 7.7 has gone backwards and is useless to me.
87 MySQL servers are MySQL Enterprise 5.7 and the remaining units are Enterprise 5.6
Execute all button is disable in the Toad I installed ? how to enable it ?
I would to know if it is possible to start toad for mysql with a command line for example "toad.exe username/password@dbserver "
thanks in advance
There seems to be a bug in the schema comparison between servers.
On one server I have a Default value of '' on a couple of columns, however comparing the the tables on different servers does NOT reveal the Toad 22.214.171.1247
It looks like the default '' that results in an empty string is completely omitted.
Running the create statement on MySQL Workbench results in the following SQL statement - which has the DEFAULT '' as expected.
CREATE TABLE `part` ( `partid` int(11) NOT NULL AUTO_INCREMENT, `specifier` varchar(45) NOT NULL, `serial` varchar(45) NOT NULL, `nonceid` int(11) NOT NULL DEFAULT '-1', `uuid` varchar(45) NOT NULL DEFAULT 'x', `guitype` varchar(45) NOT NULL DEFAULT '', `description` varchar(300) DEFAULT '', `jsonconfig` varchar(10000) DEFAULT NULL, `dynpartref` varchar(45) DEFAULT NULL, `TZ` varchar(100) DEFAULT NULL, PRIMARY KEY (`partid`)) ENGINE=InnoDB AUTO_INCREMENT=21634 DEFAULT CHARSET=utf8;
Any help to get the schema comparison to include this string default would be great.
toad for mysql is the best tool of mysql managent,
but unfortunately, it does not have event management module.
so is there any plan to add event management feature??
really need this!!!
The error mentions a table named 'db" but I don't have a table with that name.
I Recently installed Toad For MySQl. When ever a tried to creating new connection i get this error.
"MySQL Database Error "
"Access denied for user 'root'@'localhost' (using password: YES)"
Is there a way to fix this?
If you send this simple query to MySQL from Toad, it returns an error: SELECT JSON_OBJECT('id', 87, 'name', 'carrot');
I had ver 7.7 and it returned "unknown data type"
Now I tried with 7.9 and it just fails without letting me know why other than:
Category Timestamp Duration Message Line PositionError 7/29/2016 6:26:11 PM 0:00:00.093 <link> - MySQL Database Error: Fatal error encountered during command execution. 1 0
But sending this query through mysql commandline works fine.
This is supposed to work without any database, as shown here:
I'm using MySQL 5.7.11
and Toad for MySQL 126.96.36.1997
After a longer time I revert back to Toad for MySQL. I downloaded the newest version and installed it on 64bit Win 7.
The first start worked fine.
However if I close the setup/connection wizard and Toad main window and start it later again then the whole desktop freezes.
Main Toad window and connection dialog is shown again but I cannot move the cursor any more.
The only solution is then to Ctrl+Alt+Del and to log out + re-login into my Win7 account.
This bug is reproducable.
Whats the reason?
Yes, I re-installed Toad again but the error remains.
toad for mysql autoCommit off, but cann't query the line that commit by another transaction befor i commit my trnasaction.
Hi, i've got version 6.0 and 7.7 , how to use cli UI but not edit window?
As I noticed Toad.exe ist starting WISPTIS.EXE process/program on my Win 7 system.
My computer is a non-tablet-computer but a "normal" desktop PC.
Moreover it is not closing WISPTIS.EXE again at exit of Toad.
Is there an option to disable triggering WISPTIS.EXE from Toad?
when I copy/past the example procedure regarding Get-Diagnostigs from the MySql Reference Manual into Toad for MySql (Version 188.8.131.529) and use the function "Format SQL" I get the following error message:
Parser Messages:12/07/2016 16:08:16: line 11, col 5: Incorrect syntax near 'GET'
Does anyone has an idea?
DB version is 5.7.13-log.
Many thanks in advance...
Procedure taken from here:
CREATE PROCEDURE p ()BEGIN -- Declare variables to hold diagnostics area information DECLARE errcount INT; DECLARE errno INT; DECLARE msg TEXT; DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN -- Here the current DA is nonempty because no prior statements -- executing within the handler have cleared it GET CURRENT DIAGNOSTICS CONDITION 1 errno = MYSQL_ERRNO, msg = MESSAGE_TEXT; SELECT 'current DA before mapped insert' AS op, errno, msg; GET STACKED DIAGNOSTICS CONDITION 1 errno = MYSQL_ERRNO, msg = MESSAGE_TEXT; SELECT 'stacked DA before mapped insert' AS op, errno, msg;
-- Map attempted NULL insert to empty string insert INSERT INTO t1 (c1) VALUES('');
-- Here the current DA should be empty (if the INSERT succeeded), -- so check whether there are conditions before attempting to -- obtain condition information GET CURRENT DIAGNOSTICS errcount = NUMBER; IF errcount = 0 THEN SELECT 'mapped insert succeeded, current DA is empty' AS op; ELSE GET CURRENT DIAGNOSTICS CONDITION 1 errno = MYSQL_ERRNO, msg = MESSAGE_TEXT; SELECT 'current DA after mapped insert' AS op, errno, msg; END IF; GET STACKED DIAGNOSTICS CONDITION 1 errno = MYSQL_ERRNO, msg = MESSAGE_TEXT; SELECT 'stacked DA after mapped insert' AS op, errno, msg; END; INSERT INTO t1 (c1) VALUES('string 1'); INSERT INTO t1 (c1) VALUES(NULL);END;
Toad for MySQL 184.108.40.2069 - Fixed in Toad for MySQL 220.127.116.117
The Windows Tabs (or maybe they are called editor tabs) toolbar has a drop down icon to "Show Window List" that is useful when there are many tabs.
However, if one of the window tabs is under the "Show Window List" drop down icon, then left-clicking the icon acts like a right-click on the tab that is under it.
This isn't a big issue since I can scroll the tabs or select the tab from the "Window" menu.
I'm using Toad for Mysql 18.104.22.1689. When i connection to a db, and right click on a table, and select alter table, and then go to the columns list, and click on a column, the collation property 1) does not show the current collation setting for that column 2) does not list the available collations when i click on the drop down on the combo box to show the contents of the combo box.
Is this an unsupported operation, or am I missing something?
Here's a screen shot. You can see the collation is set to utf8_unicode_ci in the create table sql behind the dialog, but the alter table dialog shows nothing.
Hi,I just installed Toad and am excited about using it,
Im using mysql, and just trying it out I created a database, table and some column that I link to my visual studio project. it connects fine to the database.
However, when adding some random data to the columns in Toad I get a warning/error saying I need to have a key column.
Sure, but in Toad under "Alter Table > Columns", I simply dont see where the option of adding a key column is to be found.
The complete error-text is:
"Dynamic SQL generation for the UpdateCommand is not supported against SelectCommand that does not return any key column information."
new connection, password contains " character, report error as picture show
System.ArgumentException从索引 18 处开始，初始化字符串的格式不符合规范。 (-- trans to english: The format of the initialization string does not conform to the specification. )Stack Trace: 在 System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) 在 System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) 在 System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) 在 System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value) 在 MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor(String connStr) 在 MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value) 在 MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString) 在 Quest.Toad.MySQL.MySQLConnection.CreateConnection() 在 Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection() 在 Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect() 在 Quest.Toad.Db.Connection.Connect(Boolean notify) 在 Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
When I go to web page
then I can only download the newest version of Toad for MySQL.
Since the newest version freezes (see other posting) at second start I want to install an older version.
Is there a way to download older versions somewhere?
when i try to show the explain plan of sql statement using toad for mysql,
but it shows error blew:
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
could anyone help me on this pb?