Toad for MySQL - General

Community Discussion

g greaves
Follow / 26 Jun 2015 at 11:52am / Toad for MySQL
Latest post by on 29 Jun 2015 at 8:36am

A Never Ending Loop In Toad for MySQL Chart Designer - Forced To Kill...

Expand content
In the Data window, of the Chart Wizard, I just happened to delete the Argument and Value information which sent Toad for MySQL into a never ending loop with a message box popping up saying "Argument...

In the Data window, of the Chart Wizard,  I just happened to delete the Argument and Value information which sent Toad for MySQL into a never ending loop with a message box popping up saying "Argument isn't compatible with the current argument scale type". I cannot be certain what was in the Series Binding but it was Date type for the X Axis and numeric for Y Axis.

893 1 / Create an account to join the discussion.
g greaves
Follow / 26 Jun 2015 at 11:42am / Toad for MySQL
Latest post by on 29 Jun 2015 at 8:32am

Error Changing Report Header

Expand content
I got this error message while changing the Report header... System.NullReferenceException Object reference not set to an instance of an object. Stack Trace: at DevExpress.XtraVerticalGrid.NormalState...

I got this error message while changing the Report header...

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at DevExpress.XtraVerticalGrid.NormalState.GetFocusedRecordNavigatonInfo(Int32 beginIndex, Int32 endIndex, Int32 step, Boolean forward)
at DevExpress.XtraVerticalGrid.NormalState.GetNextTabNavigatonInfo(Boolean forward)
at DevExpress.XtraVerticalGrid.NormalState.NavigateControl(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.NavigateControl(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.BehaveControl(KeyEventArgs e, Boolean showEditor)
at DevExpress.XtraVerticalGrid.EditingState.KeyDownCore(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.NormalState.KeyDown(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.KeyDown(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.ControlState.ProcessChildControlKey(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.EditingState.ProcessChildControlKey(KeyEventArgs e)
at DevExpress.XtraVerticalGrid.VGridControlBase.RaiseEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.Container.EditorContainer.DevExpress.XtraEditors.Container.IEditorContainer.OnEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.TextEdit.OnEditorKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.BaseEdit.OnKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.TextEdit.OnMaskBox_KeyDown(Object sender, KeyEventArgs e)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at DevExpress.XtraEditors.Mask.MaskBox.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.TextBoxBase.WndProc(Message& m)
at System.Windows.Forms.TextBox.WndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.BaseWndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.MaskStrategy.SimpleStrategy.DoWndProc(Message& m)
at DevExpress.XtraEditors.Mask.MaskBox.WndProc(Message& m)
at DevExpress.XtraEditors.TextBoxMaskBox.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I can reproduce it and it occurs whenever I change the information in the Text field. I changed it from the default to IT Team and to check if it was a one off I changed it to IT DBA Team and got the same error. The application does not crash and I don't have to force quit Toad for MySQL.

829 1 / Create an account to join the discussion.
mwsasser
Follow / 24 Jun 2015 at 3:15pm / Toad for MySQL
Latest post by on 26 Jun 2015 at 2:50pm

Weird error using Compare

Expand content
I keep getting a weird error when using any of the Compare options while connecting to a remote host. In this specific case it is a HostGator server. Keyword not supported: `btkkw;pooling'. I am...

I keep getting a weird error when using any of the Compare options while connecting to a remote host.  In this specific case it is a HostGator server.  

Keyword not supported: `btkkw;pooling'.

I am using Toad for MySQL 7.5.0.966.  This has been happening for a the past month or more.  I noticed it while running 7.3.x, updating hasn't helped.  Otherwise I can connect to the remote server with no problems, view the db, make changes and export with out problems.

Can somebody please help me with this problem?  Maybe make some suggestions?

1046 1 / Create an account to join the discussion.
paulhavey
Follow / 19 Jun 2015 at 4:32am / Toad for MySQL

Toad MySQL Version Control for triggers uses only the tablename not...

Expand content
Toad MySQL Version Control for triggers uses only the tablename not the triggername so you cannot commit multiple triggers INSERT + UPDATE + DELETE for the same table. Each successive commit will overwrite...

Toad MySQL Version Control for triggers uses only the tablename not the triggername so you cannot commit multiple triggers INSERT + UPDATE + DELETE for the same table.

Each successive commit will overwrite the last and then a get latest will drop those triggers from the database.

1437 0 / Create an account to join the discussion.
chuksie2003
Follow / 5 Jul 2011 at 3:07pm / Toad for MySQL
Latest post by on 18 Jun 2015 at 2:42pm

Toadformysql versionable objects

Expand content
I have MySQl 5.1 and interfaces it with subversion edge using ToadForMysql. When i attempt to add objects to subversion it only shows tables, views and triggers. the procedures, functions and scripts are...
I have MySQl 5.1 and interfaces it with subversion edge using ToadForMysql. When i attempt to add objects to subversion it only shows tables, views and triggers. the procedures, functions and scripts are not been included. is there a setting or something i could be missing in my subversion configuration?   or are there objects that can not be versioned from toadformysql?
8175 2 / Create an account to join the discussion.
Elliott
Follow / 11 Jun 2015 at 3:18pm / Toad for MySQL

Customizing connection string to set Allow Zero Datetime=true for...

Expand content
I am using Toad for MySQL to access my database. The database contains datetime values of 0000-00-00 00:00:00. Toad is converting these to null, but I don't want that since the database structure is...

I am using Toad for MySQL to access my database. The database contains datetime values of 0000-00-00 00:00:00. Toad is converting these to null, but I don't want that since the database structure is not allowing these fields to be null. I think I can avoid this problem by adding Allow Zero Datetime=true to the connection string, but I don't know how to do that in Toad for MySQL - i.e. customize the connection string to include that parameter. I tried to manually edit the .xml file that contains the connections strings, but that seemed to have no affect, and my changes were overwritten the next time I exited Toad.

Is there a way to customize the connection string? And if so, will that solve my problem?

1923 0 / Create an account to join the discussion.
Veljko Stanisic
Follow / 11 Jun 2015 at 11:03am / Toad for MySQL

Resignal in stored procedure

Expand content
Toad's SQL editor is signaling incorrect syntax near 'resignal' when resignal is used in a stored procedure. Syntax is actually correct and procedure executes successfully and without errors...

Toad's SQL editor is signaling incorrect syntax near 'resignal' when resignal is used in a stored procedure. Syntax is actually correct and procedure executes successfully and without errors. For example:

declare exit handler for sqlexception
    begin
      rollback;
      call p_log_event();
      commit;
      resignal;
    end;

...


When I have any other error in further code, Messages tab in Results window is always pointing to the line where resignal is called, so i get mislead.

2034 0 / Create an account to join the discussion.
bayridge1
Follow / 9 Jun 2015 at 4:55pm / Toad for MySQL
Latest post by on 11 Jun 2015 at 9:30am

Can't figure out how to connect to a database

Expand content
I am hosted by Godaddy and no matter what I try, I can't connect to my databases. Here's what I'm using. Of course I'm using my real userid, pswd and db name. Is localhost correct or should...

I am hosted by  Godaddy and no matter what I try, I can't connect to my databases. Here's what I'm using. Of course I'm using my real userid, pswd and db name. Is localhost correct or should it be a ip addy? I tried the ipaddy and that didn't work either. Guess I can't paste image here. I have TCP and localhost and port 3306.

2217 2 / Create an account to join the discussion.
benyitzhaki
Follow / 6 May 2015 at 1:59pm / Toad for MySQL
Latest post by on 8 Jun 2015 at 3:51pm

Compare schemas - can i produce clean "alter" statements...

Expand content
I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example: I have added an index to one of the columns, something that should have been...

I'm struggling with an issue when trying to compare schemas of two mysql databases. I'll explain with an example:

I have added an index to one of the columns, something that should have been summed as something like:

ALTER TABLE `tablename`

ADD INDEX `index_name` (`column_name`);

And instead.. it wants me to do the whole "create temp table, copy data to temp table, drop original table,rename temp table to original table name".. that's crazy and moreover, it might (and will) lead to some downtime when trying to update a production db.

Is there a way to change that behavior?

Thanks

4574 1 / Create an account to join the discussion.
Brad Wulf
Follow / 19 May 2015 at 11:06pm / Toad for MySQL
Latest post by on 8 Jun 2015 at 3:48pm

Community Question – Toad MySQL for Amazon RDS

Expand content
Are you using Toad to connect to MySQL or Aurora instances hosted on Amazon RDS? If so, what is working/what isn’t working? Answer in the comments below!

Are you using Toad to connect to MySQL or Aurora instances hosted on Amazon RDS?  If so, what is working/what isn’t working?

Answer in the comments below!

3863 3 / Create an account to join the discussion.
Marijana Sonja
Follow / 17 Jan 2012 at 1:14pm / Toad for MySQL
Latest post by on 8 Jun 2015 at 3:23am

Macro variables

Expand content
Hi, I'm new in Toad and i need help. I have some experiance in writing MySQL in SAS Enterprise Guide. There I could make some macro variables which I could use in a lot of queries, for example: %let...

Hi,
I'm new in Toad and i need help. I have some experiance in writing MySQL in SAS Enterprise Guide. There I could make some macro variables which I could use in a lot of queries, for example:

%let age=25;

proc sql;
create table old25 as
select *
from table
where old=&age;
quit;

proc sql;
create table younger as
select *
from table
where old<&age;
quit;

How can I do that in Toad? I have values which are repeated 10 times or more and I don't want to write them every of that 10 times..... I have found something about bind variables (a have to declare them) but then some window is oped and I have tu put the wright value in it - again 10 times. How can I avoid that?

Please help!

Thanks!

Marijana

8508 2 / Create an account to join the discussion.
chakrirajini
Follow / 6 Jun 2015 at 7:40am / Toad for MySQL
Latest post by on 6 Jun 2015 at 9:01am

TOAD is not storing & displaying unicode characters

Expand content
I have a MYSQL DB. I am storing the multi lingual characters in a table. below is the sample code. CREATE TABLE test_multi_lang ( language_name varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci...

I have a MYSQL DB. I am storing the multi lingual characters in a table. below is the sample code.

CREATE TABLE test_multi_lang
(
    language_name varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci
);

SET NAMES 'utf8';

insert into test_multi_lang
(language_name )
values
('ตัวอย่าง');

insert into test_multi_lang
(language_name )
values
('नमूना');

SET NAMES 'utf8';

SET character_set_results = 'utf8', 
character_set_client = 'utf8', 
character_set_connection = 'utf8', 
character_set_database = 'utf8', 
character_set_server = 'utf8';

select * from test_multi_lang;

When i run the above code in TOAD for MYSQL 7.3.1.290 and select the result set it is displaying as ?????????. but when I run the same code through mysql console it is displaying the unicode characters properly. i changed the properties of my toad as



still i am not getting the result displayed in proper format. how can i solve this problem ?

Thanks in advance.




2375 1 / Create an account to join the discussion.
Enric_Naval
Follow / 25 Feb 2015 at 10:18am / Toad for MySQL
Latest post by on 5 Jun 2015 at 4:35pm

"Format code" doesn't understand SEPARATOR?

Expand content
"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR: For example: SELECT level , GROUP_CONCAT(code SEPARATOR ' ' ) FROM Logs GROUP BY level; SEPARATOR...

"Format code" refuses to format any query containing GROUP_CONCAT + SEPARATOR:

For example:

SELECT
level
, GROUP_CONCAT(code SEPARATOR ' ')
FROM Logs
GROUP BY level;

SEPARATOR is valid since at least MySQL 4.1: http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html#function_group-concat

This bug exists since beta 7.0 http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/f/90/t/20717.aspx

Answered 7901 3 / Create an account to join the discussion.
snolan_484
Follow / 1 Jun 2015 at 4:40pm / Toad for MySQL

Looking at the SaveLog when import is running crashes the import

Expand content
The SaveLog needs to be viewable during an import - if you open it in an editor to view it during the import (there is no indication of status in the wizard, so viewing the log file is the way to know...

The SaveLog needs to be viewable during an import - if you open it in an editor to view it during the import (there is no indication of status in the wizard, so viewing the log file is the way to know how things are proceeding) then the import crashes with an error. The log file can be read-only because I shouldn't be allowed to change it, but it really needs to be viewable.

2712 0 / Create an account to join the discussion.
Alan Ramires
Follow / 29 May 2015 at 2:53pm / Toad for MySQL
Latest post by on 1 Jun 2015 at 4:30pm

Toad for MySQL - field manipulation

Expand content
where can i change a float field (11,0) to (11,2) ? and second, how can i re-order fields ? thanks

where can i change a float field (11,0) to (11,2) ?

and second, how can i re-order fields ?

thanks

2991 2 / Create an account to join the discussion.
snolan_484
Follow / 1 Jun 2015 at 4:05pm / Toad for MySQL

Cancel when editing a query in the Import or Export Wizard exits the...

Expand content
When you edit a query in the Import or Export Wizard there is a Cancel button in the bottom right corner - I would expect that clicking it would cancel any changes I made while editing the query and take...

When you edit a query in the Import or Export Wizard there is a Cancel button in the bottom right corner - I would expect that clicking it would cancel any changes I made while editing the query and take me back to the objects list in the wizard, but it actually completely exits the wizard, losing any changes you may have made without even showing a confirmation. So I can easily lose a lot of work if I had added a number of queries and went back just to look at one of them :-(

2731 0 / Create an account to join the discussion.
pstein
Follow / 31 May 2015 at 11:49am / Toad for MySQL

How to completely hide table column definition sub-pane in "Object...

Expand content
Assume I connect to a database and marked a certain table in the "ObjectExplorer" sub-window on the left. then below the tab pane there is an additional pane with table column field name...

Assume I connect to a database and marked a certain table in the "ObjectExplorer" sub-window on the left.

then below the tab pane there is an additional pane with table column field name, data type and comment.

is there a way to completely disable/hide thus subsubwindow/Pane?

I mean not just by dragging the delimiting border to the minimum but completely disable it?

Peter

2782 0 / Create an account to join the discussion.
pstein
Follow / 31 May 2015 at 11:46am / Toad for MySQL

How to adjust Toad main window border width (make it thin)?

Expand content
As I found out the windows border for the v7 Toad is rather thick (approx 7-8 pixels), How do I make it thin (e.g.1 pixel line)? Peter

As I found out the windows border for the v7 Toad is rather thick (approx 7-8 pixels),

How do I make it thin (e.g.1 pixel line)?

Peter

Unanswered 2760 0 / Create an account to join the discussion.
Enric_Naval
Follow / 27 May 2015 at 8:16am / Toad for MySQL

incorrect accents in column headers (in grid)

Expand content
Toad has issues displaying the accents in the grid, but only in the column name (see example in the image), Not a show-stopping bug, but a bit annoying.

Toad has issues displaying the accents in the grid, but only in the column name (see example in the image),

Not a show-stopping bug, but a bit annoying.

3154 0 / Create an account to join the discussion.
Guest
Follow / 17 Feb 2010 at 2:41pm / Toad for MySQL
Latest post by on 26 May 2015 at 3:45pm

4.6 Database Explorer Encoding

Expand content
Hi, Upgraded to 4.6 and the encoding from Database Explorer is all messed up. Tried to change it but was unable to find it. I need support for characters like á ç ã Tks for all the...

Hi,

Upgraded to 4.6 and the encoding from Database Explorer is all messed up.
Tried to change it but was unable to find it. I need support for characters like á ç ã

Tks for all the help

8841 5 / Create an account to join the discussion.