Correcting a Broken View in MySQL

Recently I had a problem where I renamed a db field to allow for better maintenance (the field name misrepresented it's actual use and conflicted with another use).

In the process, I broke a view that used the table.

MySQL then complained about "...references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"

The view itself became impossible to edit. However you can access the view definition with the following query.

SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'view_name';

Comments

Changing Password - in AD, when you're changing one of your other accounts, not the logged in account

Use Powershell Step 1 - Put your existing password in a Secure String $oldPassword = Read-Host "Your old Password" -AsSecureString Step 2 - Start the password change set-AdAccountPassword -Identity paul-admin -OldPassword $oldPassword Step 3 - Enter your new password You'll be prompted for your new password... Please enter the desired password for 'CN=xxxx,OU=Admin Users,OU=Users,OU=Privileged,DC=CAIS,DC=com,DC=edu,DC=au' Password: ************************** Repeat Password: **************************

Tip to create an underline on a heading shorter than the heading itself

You can use a pseudo element with :before (or :after ): h1 { font - weight : 300 ; display : inline - block ; padding - bottom : 5px ; position : relative ; } h1 : before { content : "" ; position : absolute ; width : 50 %; height : 1px ; bottom : 0 ; left : 25 %; border - bottom : 1px solid red ; } http://jsfiddle.net/9e27b/ This is another solution that centers the heading, the problem here is that the underline gets shorter as the column gets shorter. h2 { display: inline-block; padding-bottom: 15px; position: relative; width: 100% ; text-align: center; } h2:before{ content: ""; position: absolute; width: 8%; height: 1px; bottom: 0; left: 46%; border-bottom: 1px solid red; }

The web.config no extension mime problem Lets Encrypt on IIS/Windows

Tip when using LetsEncrypt in Windows - Feature Requests - Let's Encrypt Community Support In a paragraph, just use the web.config file to set the mime type, eg... After trying to figure out why my Lets Encrypt failed to generate in Windows, and discovering that it's the no extension mime type problem, I wondered whether certbot could fill in the missing gap. All that is needed is the following web.config file to be placed in the same directory as the challenge <?xml version="1.0" encoding="UTF-8"?> <configuration> <system.webServer> <staticContent> <mimeMap fileExtension="." mimeType="text/xml" /> </staticContent> </system.webServer> </configuration> Because there's no mime type for files without an extension on IIS, IIS sends back a 404 when verification happens. The web.config file above sets the mime type. After I created the .well-known

Pauls Blog

Search This Blog