Toad for MySQL - General

Community Discussion

Kal_elSpider
Follow / 30 Jul 2015 at 3:41pm / Toad for MySQL

Toad for SQL Error

Expand content
Hi, I installed Toad for sql 6.1 and works fine, but yesterday i executed the program and appear a error, i downloaded the most recent version 6.6 and replaced the 6.1 version, but to execute the version...

Hi, I installed Toad for sql 6.1 and works fine, but yesterday i executed the program and appear a error, i downloaded the most recent version 6.6 and replaced the 6.1 version, but to execute the version appears the next error:

System.Security.VerificationException
La operación no puede desestabilizar el tiempo de ejecución.
Stack Trace:
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonListCore(List`1 positiveList)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.SortButtonList(BaseButtonCollection buttons)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.EnsureButtons(Graphics g, Rectangle bounds, BaseButtonPainter buttonPainter)
   en DevExpress.XtraEditors.ButtonPanel.BaseButtonsPanelViewInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcButtons(BaseTabPageViewInfo info, Rectangle bounds)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcPageViewInfo(BaseTabRowViewInfo row, BaseTabPageViewInfo info, Point& topLeft)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect, Size buttonsSize)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcRowsViewInfo(Rectangle rect)
   en DevExpress.XtraTab.ViewInfo.BaseTabHeaderViewInfo.CalcViewInfo(Graphics g, Rectangle r, TabHeaderLocation hLocation)
   en DevExpress.XtraTab.ViewInfo.BaseTabControlViewInfo.CalcViewInfo(Rectangle bounds, Graphics g)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.DocumentGroupInfo.CalcCore(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseElementInfo.DevExpress.XtraBars.Docking2010.Views.IBaseElementInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalcGroups(Graphics g, Rectangle bounds, Int32[] intervals, DocumentGroup[] groups, Int32[] splitLengths, Rectangle[]& rects)
   en DevExpress.XtraBars.Docking2010.Views.Tabbed.TabbedViewInfo.CalculateCore(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseViewInfo.Calc(Graphics g, Rectangle bounds)
   en DevExpress.XtraBars.Docking2010.Views.BaseView.EnsureLayoutCalculated(GraphicsCache cache)
   en DevExpress.XtraBars.Docking2010.DocumentManager.PatchChildrenCore()
   en DevExpress.XtraBars.Docking2010.DocumentManager.PatchActiveChildren()
   en System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   en System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   en System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   en System.Windows.Forms.Control.InvokeMarshaledCallbacks()

I dont known what this mean, i executed by Admin, and this doesnt works, if somebody can help me with this error to solve. Thanks a lot.

68 0 / Create an account to join the discussion.
manoj_cer
Follow / 27 Jul 2015 at 7:30pm / Toad for MySQL
Latest post by on 29 Jul 2015 at 1:48pm

Reinstallation not working Toad for Sybase

Expand content
Today, i got the Toad Freeware period expired notification and asked me to download the latest version(for my Toad for sybase). I downloaded and installed 2.1.0.2921. Even after installing i am getting...

Today, i got the Toad Freeware period expired notification and asked me to download the latest version(for my Toad for sybase). I downloaded and installed 2.1.0.2921. Even after installing i am getting the same notification and I am unable to start the application. I tried this multiple times with the same result. I tried manually uninstalling and reinstalling, still with the same issue. Even restarted the computer as well before installation, but same result. Any idea on what I need to do. Please let me know

Thanks

M

Unanswered 124 2 / Create an account to join the discussion.
MrPrastastic
Follow / 27 Jul 2015 at 6:22pm / Toad for MySQL

Exporting blobs as ASCII instead of hex

Expand content
Hi, I've got an existing table which has a number of blobs in it which I need to read as ASCII. I have two questions: 1) They show up in the view as hex - if I click on them it lets me view them...

Hi, I've got an existing table which has a number of blobs in it which I need to read as ASCII. I have two questions:

1) They show up in the view as hex - if I click on them it lets me view them as ASCII but it makes scanning through the data tricky. Is there a way to have them viewed in the table as ASCII?

2) More importantly, when I export to excel / csv they are formatted as hex - I can do a manual conversion but there a lot of data and the rows are comparatively large (1500+ characters) so using a formula to convert isn't really feasible. Is there a way to export directly as ASCII?

I noticed this question had been asked previously but that was in 2012 and got absolutely no replies. Thanks in advance.

81 0 / Create an account to join the discussion.
jhvheusden
Follow / 17 Jul 2015 at 12:31pm / Toad for MySQL

BUG: In compare schema tool, source and target database are swapp...

Expand content
In compare schema tool, source and target database are swapped. So the script generated applies the changes in the target database to the source database, instead of the other way. Please can this bug...

In compare schema tool, source and target database are swapped.

So the script generated applies the changes in the target database to the source database, instead of the other way.
Please can this bug be corrected? This is quite annoying!

(I have seen many complaints about not working compare schema tool, maybe the swapped entries are the root cause of these complaints?)

Regards, Jan-Hendrik

128 0 / Create an account to join the 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.

1358 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.

1272 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?

1475 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.

1867 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?
8594 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?

2363 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.

2451 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.

2657 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

4960 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!

4298 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

8925 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.




2815 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 8319 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.

3125 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

3418 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 :-(

3148 0 / Create an account to join the discussion.