Google Chromecast update fail and other issues

Fix – Update stuck or hanging? Can’t connect? Read this troubleshooting guide.

We have used Chromecasts since the first ‘model’ came out, and generally they have run without an issue.  Our first Chromecast appeared to have died, it would no longer connect,  so we bought a new Chromecast 2 and spent an evening trying to set it up.  Everything appeared to be working OK until it tried to fetch an update, at which point it just stayed at 0% (zero percent).  Here’s what we tried and how we eventually fixed it:

  • First we tried switching it off and waiting 30 seconds or so before switching back on.  This has worked for some but not for us, it just went straight to the update screen and stayed at 0%.
  • Next we tried resetting it to factory settings, another online suggestion, by holding the reset button for 25 seconds or so until it rebooted.  We went through the setup procedure again, it tried to fetch an update annnnnnnd stuck once more at 0%.
  • We recently upgraded our broadband and BT had kindly sent us a new Home Hub.  Now I don’t know if other routers have this functionality but when you log on for the first time with a new device you are redirected to a set up page where you can set parental controls etc.  Possibly the Chromecast was being treated as a new device when it tried to get an update, being redirected to this page would certainly confuse it.  To switch off this feature do the following:
    • In your browser go to http://bthomehub.home/
    • Select ‘Advanced Settings’
    • On the next screen enter your username and password and on the following screen select ‘continue to advanced settings’.
    • Select ‘Home Network’ and then ‘Smart Setup’
    • Change ‘Enable Smart Setup’ to ‘No’ and click the apply button.
    • Reset the Chromecast to factory settings once more and try again!
  • Now this didn’t work for us initially but we did discover that our old Chromecast 1 was now able to connect and function correctly once more and I think this was part of the solution to getting the Chromecast 2 up and running also.
  • The final key to the puzzle for us was to ……..

    Change to another HDMI port, I don’t know why that worked but suddenly the update was fetched and we’ve been streaming without an issue ever since.

Edit Any Table v2.1.2

A WordPress plugin/Dashboard Widget that allows you to connect to any database and edit the contents.

This plugin is a dashboard widget to allow you to connect to any MySQL database of your choice (as long as your hosting allows) and search, edit, add and delete records in an easy to use interface. Ideal if you have built a site referencing another database. You can allow other editors/administrators of the site to alter, update, delete, add and correct entries without having to give them the full capabilities of administration tools such as phpMyAdmin.

If you find this plug-in useful then please rate it, thanks.

Installation

To install, download the .zip file from the link below, extract the contents and place the edit-any-table folder in your plugin directory (typically \\your-site\wp-content\plugins\)

Setup

Once installed go to the Dashboard->Plugins page of your WordPress site and activate the plugin:

Edit Any Table activation and settings linkNow go to the Dashboard->Settings->Edit Any Table page and enter the required details:

Edit Any Table Settings

First you’ll need to enter the host (often localhost), the name of the database you wish to connect to and a valid user name and password. Under Admin Settings you can choose to allow Administrators only to have access to the widget or Editors as well. Note: If neither of these boxes are ticked the widget will not display in your WordPress Dashboard. You can choose what to allow the Editor to do i.e. Add, Edit and/or Delete.  Leaving these boxes unchecked will give the Editor view only access.   Display Settings allows you to select the maximum number of columns to display for returned searches. Edit Any Table displays best in a single column dashboard configuration and I find five columns is a comfortable fit but adjust to suit. Here you can also select to apply a friendly name for your connected database, this can help to assure editors (who don’t have access to the settings) they are working on the correct records. Finally, if you don’t want Edit Any Table to display as a widget then you can choose to have it rendered in its own separate admin page. Tables, if you have entered your database credentials correctly and saved them, you will get a list of all the tables.  Select which ones you would like to be accessed via the admin screen.

You will also notice that at the top of the settings page is an option to switch debug mode on or off. Switching it on will display all the SQL sent to your database and may help identify and issues or strange results you may be getting.

Using Edit Any Table

Once configured return to the dashboard and you should see the following widget:

Edit Any Table WidgetNow choose a table from the drop down list and select Open Note: If there is nothing in the list then you have either not entered the correct details in your settings or there are no tables in your database.

Here you can either search or add a new record with the values you have entered. Entering no search criteria returns all the records from the table. To clear any values hit the Reset button. If you enter values that are not of the correct type or in the wrong format when adding a new record these values will be substituted for the database defaults.  Wild cards do not work in searches but by selecting the ‘Fuzzy’ check box Edit Any Table will look for the phrase or part word you entered within any string field i.e.  entering ‘Liz’ in a first name field could return Elizabeth, Liz or Lizzy. Please be aware that fuzzy searches can take a lot longer when searching large datasets. Any time you want to return to this screen just select the Open button again.Search

These are the search results for a search against the AString field using the phrase hello:

Edit Any Table search resultsNow you can edit the record contents or delete a record. To return to the search/add record screen just select Open again. That’s it, enjoy.

Known Issues / Features

  • There is no bulk update or delete
  • After saving you are not returned to the previously displayed records
  • Cannot search blobs
  • Using reserved words as column names can cause issues

Please Note

To use this plugin you need a basic knowledge of database design and setup. Modifying records can have unpredictable results so if you are at all unsure I would suggest creating a test table first before using in anger.

DOWNLOAD LATEST VERSION OF PLUGIN

If you have a support question or have discovered a bug in Edit-Any-Table then please post here