You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Toad for MySQL great and have the most points for this month!
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
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 18.104.22.1689
Thanks in advance...
Is somebody knows, how to cover this bug in the "Schema compare"?
Current version is "Toad for MySQL 22.214.171.1249", and i faced it every time i used "Schema compare" last two years.
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.
Are there some missing driver installations or Registry entries?
Is there a way to make it portable?
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..
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: 126.96.36.1999
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
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 !
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?
After installing toad188.8.131.526 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
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)
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?
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.
Under Toad for mySQL 184.108.40.2069, 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"?
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.
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.
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.
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 220.127.116.112 on Windows 7 Ultimate 64-bit.
I have the error below when starting for the first time the interface after installation.
Can some one help me with this please ?
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()
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.ExternalExceptionRequested 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.ExternalExceptionRequested 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?
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?