Reputation: 905
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?
Upvotes: 31
Views: 31250
Reputation: 1
If it is mac you can use [this is before we cant see the error log][1]
Upvotes: 0
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:
you have to hover the mouse until the cursor icon change to resize icon.upward
and then you can hover on cross sign scroll right to see the error message completely.
Upvotes: 86
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
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
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