Hidden Results Grid on MySQL Workbench and macOS High Sierra

MySQL Workbench logo

UPDATE: Oracle has released version 6.3.10!

I recently updated my MacBook Pro to macOS High Sierra. Like every other OS update, this one was fairly uneventful – with the exception of having to do a hard reboot to get the Mac to come back up after the upgrade. That was definitely a nail-biter!

Once the Mac rebooted, everything appeared to be as it should be. All was fine and dandy – or so I thought.

Though I have not had any other major issues, it would appear that High Sierra has broken the current version of MySQL Workbench (6.3.9). When trying to run a query, the Results Grid never appears. A status declaring that the query completed is shown, and the Action Output window will even tell how many rows were returned. However, the rows themselves cannot be seen.

MySQL Workbench with missing Results Grid

It took quite a bit of searching to find this – apparently not too many folks have encountered this problem as yet – but I did find confirmation on Stack Overflow that this is now a known issue, and that the next release should have it fixed.

It is interesting that Oracle has closed the official bug report, despite the fact that no patch or new version is available. A user has devised a workaround that involves installing his build of MySQL Workbench, but that is not ideal in many production environments, for obvious security concerns. The only other solution given was to downgrade to an older version of MySQL Workbench – 6.1.7.

An excerpt of the comments show several users’ reactions to the bug report having been closed with no solution offered:

[20 Oct 10:32] Bob Davenport
Changing back to open

[20 Oct 10:36] Bob Davenport
I’ve changed back to open as its not fixed till the release is available.
I never clsed it perhaps the pperson who closed it could come forward and explain how a bug rendering a product 99% unusable can be marked as closed?

[20 Oct 12:12] Mike Lischke
This bug entry was closed as part of our internal processes. Please don’t touch the status of a bug anymore, once it closed.

[20 Oct 15:25] Bob Davenport
Mike Lischke

Why is a bug closed when their is no fix ?
Or can you advides the date the fix was released?

Very disappointing that the attitude of yours is so poor.

Maybe next time i wont bother to post a bug report or how to fix.
Also mustn’t forget Mike Lischke who also wasted time with the “Works on My PC” attitude in the firs place.

A discredit to the community.

[20 Oct 15:34] Michael Brogley
I agree with Bob. Based on my experience running just such an effort, a critical status bug should only be changed to “Status: Closed” if a fix has been tested and released. Otherwise any Oracle manager that’s tracking open bugs will be misled on the product’s status. Playing bug status games like this basically cuts the nerves between the user community and management, leading to misallocation of resource problems downstream, and managers and executives getting blindsided by angry users.

Is there no “Pending” status in this system?

[20 Oct 15:37] Darren Coleman
Why would a bug be closed if the problem is not fixed?

I’ve never heard of a bug tracking system where people close bugs without actually resolving the problem??

Is it just inconvenient for Oracle to see this (very simple) bug on their TODO list? It’s ridiculous enough as it is that a community member has to go out of their way to patch a bug that existed and was reported more than once while macOS High Sierra was in BETA.. but to close the bug without resolution is just egregious.

[20 Oct 15:57] Mike Lischke
The typical workflow for a bug report in this bug database is like this:

  • The bug gets reported.
  • A support person checks the validity and clarifies things when necessary.
  • The bug is transfered to our internal bug system where the developers are notified.
  • The developers fix the bug.
  • QA tests the fix.
  • The documentation team takes a note for the change log and sets the bug to closed (both internally and externally).
  • Once all bugs for a release are closed the new version is released.

Hopefully this makes the process more clear.

[21 Oct 15:12] Bob Davenport
Mike Lischke/ Oracle Can you please advise:

How many bugs are currently open and closed and a release date please?

The bug renders the application unable to display any query results on high sierra. This isn’t an insignificant or cosmetic issue, it’s a show stopper.

If some other bugs are still unfixed could you advise a cut-off date when a release will be provided?

Is this also affecting Oracle Enterprise customers?
I think it is.

For what it’s worth…

I was performing some beta testing for apple and found the fault so decided to report to Oracle.

I provided Oracle with a suggested fix which is relatively easy to implement and is verified as working.

The fix would be effortless & without risk to deploy as a ‘patch’ if in an Agile development environment was utilised.

I would have thought Oracle would be up to date on this technology by now.

[22 Oct 22:19] Aaron Langley
It’s becoming apparent that Oracle’s senior management intends to starve MySQL of oxygen in the hope it’s user base with move on to other alternatives.

Obviously not an ideal situation. Hopefully, Oracle will release a patch soon!

Performance and Availability Issues when Using Linux Hosting for WordPress on GoDaddy

Change Domain on cPanel Hosting page

I have used GoDaddy for hosting this blog for several years now, and I can say that I have not always been happy about it. I have used a free service called Monitor.Us to let me know when the website was down, and until recently, it was down quite a lot more than I thought it should be. Also, it seemed slower than I thought it should be much of the time.

I began looking at other possibilities for hosting, partially because GoDaddy doesn’t have the greatest reputation for WordPress website performance, despite their generally positive reviews regarding domain registration. I looked at BlueHost and HostGator, both of whom get better reviews than GoDaddy for WordPress hosting.

I wondered about the difficulty of moving my site when I realized I had another option: using cPanel at GoDaddy. This is the standard for Linux Web Hosting there now – I think the “classic” hosting I had been using is not even available any longer for new websites.

I had heard good things about cPanel; in fact, one of my friends here in Houston works there and had told me about their implementation at GoDaddy. I called GoDaddy support, and the person I talked to set up a new cPanel site for me. Given a few simple instructions, I was able to import my old WordPress site into the cPanel site.

If you’re using the base domain as I am (like example.com), you will set up a subdomain like new.example.com, and import your old WP site into the new site using the import screen shown below. Use your old domain name, choose the FTP option, and your FTP username and password on the next screen to import from your old account. Note: You may want to first log into the admin section of your old WP site to make sure you are on the newest version of WP.

import existing WP install
Select WordPress from the cPanel Hosting screen to get here.

If you need allow_url_fopen in your site, this will need to be added to your php.ini file. It worked automatically in the old hosting environment.

allow_url_fopen = on

After you’re sure that your new site works properly, you will delete the old site through the GoDaddy hosting interface.

Once that’s complete, you can change your new subdomain back to the base domain in the Preferences section of the cPanel Hosting page.

Change Domain on cPanel Hosting page
Change Domain in Preferences section on cPanel Hosting page

Any URL references to your site may need to be manually corrected in the Widgets section of your WP site to point at the correct domain.

If media in your existing posts aren’t showing up, a SQL script similar to the one below should be run against the MySQL database that your site uses.
For further details, look at the source where I found this gem. (If you’ve changed the “wp_” prefix on your tables, adjust accordingly.)

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Inside the WordPress admin Dashboard, you can correct any broken links using the Broken Link Checker plugin.

And that’s it. I’ve found that for the same price I was paying before, I get better performance, more uptime (no downtime since the migration yet!), and a better hosting interface.

TL;DR: If you’re already using GoDaddy for Linux Web hosting, instead of going elsewhere, first consider switching to cPanel at GoDaddy for better performance and availability!

%d bloggers like this: