Barzee
Barzee

Reputation: 905

How to see errors in MySQL Workbench 6.1?

I recently upgraded my development machine to use MySQL Workbench 6.1. I am trying to enter some data into a table using the workbench and "Select rows..." When I click the "Apply" button to insert the data, the workbench reports that an error occurred (see the image below), but it doesn't tell me what the error is. Workbench 5.* used to show the errors. I cannot find any way to get Workbench 6.1 to show me the errors. How can I see the error messages?

Screen shot of MySQL Workbench stating an error occurred but not showing the error message

Upvotes: 31

Views: 31250

Answers (5)

Rohit Kumar Jha
Rohit Kumar Jha

Reputation: 1

If it is mac you can use [this is before we cant see the error log][1]

Upvotes: 0

Prince Billy Graham
Prince Billy Graham

Reputation: 3578

If you are on linux machine this solution will work. It is already there you have to move your mouse and expand it: At first it will look like this: initial state

you have to hover the mouse until the cursor icon change to resize icon.upward enter image description here

then click it and pull enter image description here

and then you can hover on cross sign scroll right to see the error message completely. enter image description here

Upvotes: 86

Siva Reddy
Siva Reddy

Reputation: 51

If you are not seeing any sql errors or exceptions this could be one off your problems. Toggle the button in the picture button panel of mysqlworkbench

Upvotes: 5

Brett Sutton
Brett Sutton

Reputation: 4554

I eventually worked out that the panel could be opened by hovering my mouse at just the top of the status bar (at the bottom of the UI).

The hit area is tiny so you really have to 'feel' around for the drag point.

Upvotes: 24

Barzee
Barzee

Reputation: 905

To cause MySQL Workbench to show error messages, I had to change a preference. From the Workbench menu, click "Edit" -> "Preferences..." Open the "SQL Queries" tab. Check "Confirm Data Changes".

Upvotes: 0

Related Questions