Toad for MySQL - General - Toad for MySQL - Toad World

Toad for MySQL - General

Community Discussion

stephlocke
Follow / 11 Feb 2014 at 11:58am / Toad for MySQL
Latest post by on 11 Feb 2016 at 12:40am

Using Toad with MariaDB when it has PAM authentication

Expand content
I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB . I have tested successfully on the...

I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB.

I have tested successfully on the box (using putty) that I can authenticate using my AD credentials, however when I try to login via Toad I get the following error:

Client does not support authentication protocol requested by server; consider upgrading MariaDB client

I have tried adding the line pam-use-cleartext-plugin to the conf file and restarting the server but no joy. I have downloaded HeidiSQL and confirmed that its use of libmysql.dll means that it can use the PAM authentication. It looks like toad for MySQL utilises myodbc.dll - any ideas how to work around this? I love toad and would much rather be able to use it

11230 8 / Create an account to join the discussion.
Kim Opus
Follow / 8 Feb 2016 at 9:33pm / Toad for MySQL
Latest post by on 9 Feb 2016 at 1:23pm

Query Builder

Expand content
Why am I getting the table name duplicated when I build a simple SELECT statement with the Query Builder? SELECT film.title, film.description FROM film film It also happens when I do a join: SELECT...

Why am I getting the table name duplicated when I build a simple SELECT statement with the Query Builder?

SELECT film.title, film.description
  FROM film film

It also happens when I do a join:

SELECT film.title,
       film.description,
       actor.last_name,
       actor.first_name
  FROM (film_actor film_actor
        INNER JOIN actor actor ON (film_actor.actor_id = actor.actor_id))
       INNER JOIN film film ON (film.film_id = film_actor.film_id)

It's annoying! Using TOAD for MySQL 7.7.0.579

Thanks in advance...

Unanswered 98 1 / Create an account to join the discussion.
mike_angel
Follow / 8 Feb 2016 at 10:13am / Toad for MySQL

Variable 'MySqlDatatype_Bit' does not exist in the resource...

Expand content
Hello! Is somebody knows, how to cover this bug in the "Schema compare"? Current version is "Toad for MySQL 7.7.0.579", and i faced it every time i used "Schema compare"...

Hello!

Is somebody knows, how to cover this bug in the "Schema compare"?

Current version is "Toad for MySQL 7.7.0.579", and i faced it every time i used "Schema compare" last two years.

Unanswered 62 0 / Create an account to join the discussion.
pstein
Follow / 1 Feb 2016 at 7:08am / Toad for MySQL

How to make Toad for MySQL portable/put an USB flash drive?

Expand content
I would like to use Toad for MySQL from USB flash drive. It should run on various (Win 7 based) computer even those where it was originally NOT installed. This seems to be currently not possibly...

I would like to use Toad for MySQL from USB flash drive.

It should run on various (Win 7 based) computer even those where it was originally NOT installed.

This seems to be currently not possibly.

Why?

Are there some missing driver installations or Registry entries?

Is there a way to make it portable?

Thank you

Peter

Unanswered 123 0 / Create an account to join the discussion.
Josh4000
Follow / 27 Jan 2016 at 9:53pm / Toad for MySQL

Missing field list and properties toolbar in data report

Expand content
While messing with the field list (explorer) and properties toolbars in the report design view they both disappeared and I cannot find a way to restore them. I tried uninstal/reinstal but that didn't...

While messing with the field list (explorer) and properties toolbars in the report design view they both disappeared and I cannot find a way to restore them. I tried uninstal/reinstal but that didn't work. If anyone could give me some tips it'd be much appreciated.

It looks like I unpinned the field and properties toolbars on the right of the report preview and closed the windows. Unfortuantely I'm not seeing a way to re-enable them - none of the view or tool options restore them.

Steps to reproduce:

1. Make connection

2. go to tools -> Reports -> Data Report

3. Standard Report -> Enter simple query -> Move fields over to "Fields to Display" and click the "finish" button

4. On the right side of the report you should see a field list and properties menu. This is what's missing - not sure how to get them back.

Any help would be appreciated. Thanks..

Unanswered 164 0 / Create an account to join the discussion.
Shelby
Follow / 21 Jan 2016 at 10:15pm / Toad for MySQL

Toad APPCRASH error

Expand content
Toad has been crashing on me all day long, for seemingly no reason. It will happen while I'm writing a query, not while executing, compiling, saving, etc. I understand that "this failed for no...

Toad has been crashing on me all day long, for seemingly no reason. It will happen while I'm writing a query, not while executing, compiling, saving, etc. I understand that "this failed for no reason" isn't a thing that happens, but there is nothing I can think of that I'm doing to trigger a crash like this. Crash details below, would appreciate any help I can get because I like Toad and would like to continue to use it. 

Problem Event Name:                          APPCRASH

  Application Name:                             toad.exe

  Application Version:                           7.7.0.579

  Application Timestamp:                     564b86a4

  Fault Module Name:                          QP5.dll

  Fault Module Version:                        5.288.15260.18450

  Fault Module Timestamp:                  55fa76e5

  Exception Code:                                  c0000005

  Exception Offset:                                000d7133

  OS Version:                                          6.1.7601.2.1.0.256.48

  Locale ID:                                             1033

  Additional Information 1:                  0a9e

  Additional Information 2:                  0a9e372d3b4ad19135b953a78882e789

  Additional Information 3:                  0a9e

  Additional Information 4:                  0a9e372d3b4ad19135b953a78882e789

199 0 / Create an account to join the discussion.
sebseb3
Follow / 15 Jan 2016 at 10:01am / Toad for MySQL

Keep editor tabs open on close (without saving it)

Expand content
Hello, I'm looking for a feature similar to one that is present in mysql workbench but I have not been able to find it (if it exists). I'd like to know if it is possible to keep editor tabs...

Hello, 

I'm looking for a feature similar to one that is present in mysql workbench but I have not been able to find it (if it exists). 

I'd like to know if it is possible to keep editor tabs open without saving them when closing toad mysql. When reopening toad, all the editor tabs prensent when toad has been closed would be displayed. 

Is this possible ? If not, is there something similar ? 

Thanks in advance ! 

Sébastien 

Unanswered 215 0 / Create an account to join the discussion.
bambinou
Follow / 3 Jan 2016 at 10:41am / Toad for MySQL
Latest post by on 8 Jan 2016 at 8:34pm

Unable to use Toad to delete data from 2 tables

Expand content
Hello, I can select from multiple tables but cannot manage to get 2 related tables on the query builder and delete from both, toad will allow delete on 1 table but not both. For relational database...

Hello,

I can select from multiple tables but cannot manage to get 2 related tables on the query builder and delete from both, toad will allow delete on 1 table but not both. For relational database, this is not too good news....

Any idea how to get around that please?

Thanks you,

Unanswered 366 3 / Create an account to join the discussion.
cshankarvijay
Follow / 3 Sep 2015 at 8:05am / Toad for MySQL
Latest post by on 3 Jan 2016 at 6:49pm

Error When I Create New Connection

Expand content
Hi, After installing toad7.5.0.966 for mysql and try to connect it shows the below error with never ending error messages, i tried to close the messages one by one but again the error messages popping...

Hi,

        After installing toad7.5.0.966 for mysql and try to connect it shows the below error with never ending error messages, i tried to close the messages one by one but  again the error messages popping up please do the needful

System.InvalidOperationException

Object is currently in use elsewhere.
Stack Trace:
at System.Drawing.Image.get_Width()
at System.Drawing.Image.get_Size()
at DevExpress.Skins.SkinImage.GetImageSize()
at DevExpress.Skins.SkinImage.GetImageBounds(Int32 index)
at DevExpress.Skins.XtraForm.FormPainter.get_SizeGripBounds()
at DevExpress.Skins.XtraForm.FormPainter.WMNCHitTest(Message& msg)
at DevExpress.Skins.XtraForm.FormPainter.DoWndProc(Message& msg)
at DevExpress.XtraEditors.XtraForm.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)

Unanswered 939 1 / Create an account to join the discussion.
jkpalmer_14952
Follow / 15 Dec 2015 at 12:56pm / Toad for MySQL
Latest post by on 29 Dec 2015 at 10:28pm

Adding escape character to select result

Expand content
I have some simple HTML code that is stored in a MySQL database table column. A brief example of this HTML data is: <FONT FACE="arial"><hr><h1 style="text-align: center;">SOME...


I have some simple HTML code that is stored in a MySQL database table column.

A brief example of this HTML data is:

<FONT FACE="arial"><hr><h1 style="text-align: center;">SOME TEXT</h1></hr></FONT>

I need to properly 'escape' the / and the " values with a \ so that the HTML data appears as:

<FONT FACE=\"arial\"><hr><h1 style=\"text-align: center;\">SOME TEXT<\/h1><\/hr><\/FONT>

Can this be performed in a MySQL query or does special logic need to be written to introduce the \ character to my result string?

399 3 / Create an account to join the discussion.
njorger
Follow / 8 Dec 2015 at 4:27pm / Toad for MySQL

Default web browser

Expand content
How does one change the web browser that pops up when clicking on a link from within the TOAD application? Internet Explorer seems to be the only option and I do not use IE.

How does one change the web browser that pops up when clicking on a link from within the TOAD application?

Internet Explorer seems to be the only option and I do not use IE.

364 0 / Create an account to join the discussion.
KDF-LA
Follow / 8 Dec 2015 at 3:12pm / Toad for MySQL

Object Details Shows Empty Window under 7.7.0.579

Expand content
Under Toad for mySQL 7.7.0.579, with the Object Details window closed, right clicking an object in the Object Explorer and selecting View Details, opens an empty Object Details windows. The type of the...

Under Toad for mySQL 7.7.0.579,  with the Object Details window closed, right clicking an object in the Object Explorer and selecting View Details, opens an empty Object Details windows.  The type of the object (e.g. table, procedure, etc) does not seem to matter.  After the empty Object Details window is open, re-selecting View Details still shows an empty Object Details window.  However, with the Object Details window open, selecting (via left click) a different object, then shows the details.


Is anyone else seeing this "feature"?

393 0 / Create an account to join the discussion.
soapergem
Follow / 3 Dec 2015 at 10:18pm / Toad for MySQL

New Editor Keyboard Shortcut

Expand content
I just upgraded my copy of Toad for MySQL from 7.3 to 7.7 and was sad to see that the keyboard shortcuts changed. I was used to having Ctrl - N bring up a new editor window; now that keyboard shortcut...

I just upgraded my copy of Toad for MySQL from 7.3 to 7.7 and was sad to see that the keyboard shortcuts changed. I was used to having Ctrl - N bring up a new editor window; now that keyboard shortcut does nothing and I have to go to the File menu with the mouse. Help! How do I get my shortcut back? I tried looking in Tools > Options > Environment > Keyboard but couldn't find any option for opening a New Editor window.

414 0 / Create an account to join the discussion.
jkpalmer_14952
Follow / 29 Nov 2015 at 1:31pm / Toad for MySQL
Latest post by on 1 Dec 2015 at 2:15pm

Error in SQL Syntax

Expand content
Hi, I have a query select artist from library where artist like '%Feat.%'; It is returning an error - "You have an error in your SQL syntax; check the manual that corresponds to...

Hi,

I have a query 

select artist from library

where artist like '%Feat.%';

It is returning an error -

"You have an error in your SQL syntax; check the manual that corresponds to your MuSQL server version for the right syntax to use near 'where artist like '%Feat.%'' at line 1.

I don't understand what's wrong.

Help appreciated.

Jim P.

803 2 / Create an account to join the discussion.
zelium
Follow / 5 Nov 2015 at 4:00pm / Toad for MySQL
Latest post by on 30 Nov 2015 at 2:45pm

How to create the table only when importing csv, xls, and xlsx fi...

Expand content
Hi, I searched the forum and could not find an answer so I am posting a question here. I hope this is not a duplicate question. I use Toad for MySQL as a major importing tool for the data stored in...

Hi,

I searched the forum and could not find an answer so I am posting a question here. I hope this is not a duplicate question.

I use Toad for MySQL as a major importing tool for the data stored in CSV and Excel files (.XLS, .XLSX).  Sometimes, I only want to create tables from the data not populating any rows so that I can take a look at the structure of the table beforehand and make necessary changes in the data type of columns.  By doing this way, I can prevent the import error for big files.  How can I do this?  

The method I am using now is that I import the data until I got the import error (mostly caused by wrong data type assignment of Toad) and click 'No' to proceed the import process ignoring some rows and change the modification later after the import process is finished.  This is not very efficient and sometimes time consuming.

Thanks in advance.

Unanswered 880 1 / Create an account to join the discussion.
Kalle L
Follow / 26 Apr 2012 at 9:10pm / Toad for MySQL
Latest post by on 20 Nov 2015 at 11:01pm

Can not open SQL files while connected

Expand content
I have recently discovererd toad and I am very impressed so far. I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the...

I have recently discovererd toad and I am very impressed so far.

I have however one problem: Toad hangs if I open a SQL file while I have an active connection. If I open the SQL file before i open the connection to the database server, it works OK.

I spent some time googling about this problem, but have'nt found anything. Does anyone have any suggestions?

I am using Toad 6.3.0.642 on Windows 7 Ultimate 64-bit.  

12863 11 / Create an account to join the discussion.
ian in the hills
Follow / 27 Jun 2012 at 5:52am / Toad for MySQL
Latest post by on 11 Nov 2015 at 9:22am

Schema Compare syntax error in trigger

Expand content
Hi, sorry if this is included in another thread. I am using Toad 6.3.0.642 When I do a Schema compare on tables that contain triggers - the script in both the separate top windows and all subsequent scripts...
Hi, sorry if this is included in another thread.
I am using Toad 6.3.0.642

When I do a Schema compare on tables that contain triggers - the script in both the separate top windows and all subsequent scripts/windows lists the triggers as...
FOR EACH ROWBEGIN - with no space between the 'ROW' and 'BEGIN' regardless of whether I have spaces, line breaks or both in my actual database.

this is true for any content after the 'EACH ROW' portion

Once again - sorry if this is a dupe.
9989 1 / Create an account to join the discussion.
felicitydot1
Follow / 26 Oct 2015 at 11:53am / Toad for MySQL
Latest post by on 30 Oct 2015 at 1:57am

Error on first launch of Toad for mySQL

Expand content
Hi I have the error below when starting for the first time the interface after installation. Can some one help me with this please ? Thank you ******************************** System...

Hi

I have the error below when starting for the first time the interface after installation.

Can some one help me with this please ?

Thank you

********************************

System.TypeInitializationException The type initializer for 'System.Windows.Window' threw an exception. Stack Trace: at System.Windows.Window..ctor() at Quest.Toad.StartupWindow..ctor() at Quest.Toad.StartupWindow.CreateStartWindow(Object state) at Quest.Toad.Gui.WPFWindowThread.<>c__DisplayClass6.b__3() at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at System.Windows.Threading.DispatcherOperation.InvokeImpl() at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Threading.DispatcherOperation.Invoke() at System.Windows.Threading.Dispatcher.ProcessQueue() at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled) at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o) at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs) at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler) at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs) at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam) at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg) at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame) at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame) at Quest.Toad.Gui.WPFWindowThread.CreateDispatcherThread() System.TypeInitializationException The type initializer for 'System.Windows.FrameworkElement' threw an exception. Stack Trace: at System.Windows.Window..cctor() System.TypeInitializationException The type initializer for 'System.Windows.Documents.TextElement' threw an exception. Stack Trace: at System.Windows.FrameworkElement..cctor() System.TypeInitializationException The type initializer for 'MS.Internal.FontCache.Util' threw an exception. Stack Trace: at MS.Internal.FontCache.Util.get_Dpi() at System.Windows.SystemFonts.ConvertFontHeight(Int32 height) at System.Windows.Documents.TextElement..cctor() System.UriFormatException Invalid URI: The format of the URI could not be determined. Stack Trace: at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind) at System.Uri..ctor(String uriString, UriKind uriKind) at MS.Internal.FontCache.Util..cctor()

666 1 / Create an account to join the discussion.
pbaker
Follow / 15 Oct 2015 at 4:10pm / Toad for MySQL
Latest post by on 22 Oct 2015 at 10:57pm

Clipboard cut function not fully working

Expand content
After 2+ years of working correctly, the cut function no longer removes text when I use it. The contents are copied to the clipboard, but the text remains in the editor. This is for ctrl+X as well as using...

After 2+ years of working correctly, the cut function no longer removes text when I use it.  The contents are copied to the clipboard, but the text remains in the editor.  This is for ctrl+X as well as using the cut option from the edit menu.  I was on 6.3, but moved to 7.5 today and it has the same behavior which makes me wonder if it's a problem with Windows clipboard.  I'm on Windows 10, but had the issue on Windows 7.  Cut works fine in other applications.  Anyone ran into this?

Also, the copy/cut functions are generally slow (~3-5 second) and I often get these clipboard errors in Toad:

System.Runtime.InteropServices.ExternalException
Requested Clipboard operation did not succeed.
Stack Trace:
at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
at Quest.Toad.Util.Global.CopyToClipboard(String textData)

System.Runtime.InteropServices.ExternalException
Requested Clipboard operation did not succeed.
Stack Trace:
at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
at System.Windows.Forms.Clipboard.SetText(String text)
at Quest.Toad.Util.Global.CopyToClipboard(String textData)

I recall someone mentioning that Toad does 2 passes of the text due to formatting.  Any tricks to make this run faster/better?

Answered 718 1 / Create an account to join the discussion.
alexander.sitte
Follow / 22 Oct 2014 at 4:00pm / Toad for MySQL
Latest post by on 14 Oct 2015 at 4:53pm

[Bug] Autocomplete disappearing instantly (7.3 Stable)

Expand content
Hi, I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature. 1. It does not pop up automatically. For example, when I type a table alias followed by a period(.) I would...

Hi,

I have downloaded Taod for MySQL 7.3 and have a problem with the Autocomplete feature.

1. It does not pop up automatically. For example, when I type a table  alias followed by a period(.) I would expect that autocomplete shows a list of columns of the table.

2. If I activate the autocomplete popup with CTRL+Period it pops up quickly and disappears right away. I am not able to select anything from it.

Is there a fix for this?

Unanswered 10017 2 / Create an account to join the discussion.