Wamp – Error displaying the error page: Application Instantiation Error

My localhost WAMP on my personal Windows 10 machine just crapped out on me. PHPmyAdmin wouldn’t run I get the following on my screen when I go to my localhost website running in WAMP.

Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.

My WAMP install I did without using a password for the PHPmyAdmin. It ran fine for a year and suddenly not.  What to do? I had stuff not backed up that I really wanted.

  • What if adding a password to the PHPmyAdmin fixes it…it didn’t.
  • Could it be my WAMP install and should I re-install on top of my already installed WAMP?

I looked deeply into the config.in.php file and playing around with that something did work. I used the solution on this page.

https://stackoverflow.com/questions/28541325/1045-cannot-log-in-to-the-mysql-server-in-wamp

Next I was lead to OS Training and an article using MySQL Console in WAMP. I never even knew it was there. It asked from my password. I put in the password I had just created in the config.ini.php file, but that didn’t work. I went back to my original blank password and I was in. I typed in

UPDATE mysql.user SET Password=PASSWORD(“root”) WHERE User=”root”;

That gave me the error.

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Which lead me to updating the password for root.

set PASSWORD = PASSWORD(“What ever password”);

That did the trick. I was back into my websites and PHP my admin.

I hope this helps someone else out there…

 

Google Optimize – Getting started and how it benefits?

I am starting down the path of Google Optimize. I am working on a new site and want to do some comparisons of what parts will do better.

Starting with these places.

Anybody has any advise or suggestions on setting up and using Google Optimize feel free to comment.

Godaddy Hosted Website Attacked – PHP Files In Directories

We have a static HTML site built in 2013 that we maintain. We got a notification from Godaddy that there were malicious files in the website. I started to remove them, but wanted to see what was in them. When I opened one of the files that was 3 level into the website it was extremely complicated. It looks like part of many arrays and just pulling parts of multiple arrays. I believe the end goal is to assemble the final script. It looks like this.

Another interesting thing about this attack is the date of the file. It is from 2013. I had made a complete back of the site on 2/15/2016, but the bad files were from 2013. None of the bad files were in my back in 2016.

Nothing was solved. I removed the old files and updated the .htaccess file. I found it interesting how the date could be manipulated.

I hope this helps someone one else out there….

 

How To Create A Parallax Effect in Gantry

This actually isn’t just for Ganty. It just involves a little CSS. I needed it for a section in a Gantry template, but you can use this anywhere.

I got this set up from good old W3Schools so you know it is solid.

https://www.w3schools.com/howto/tryit.asp?filename=tryhow_css_parallax

It is really just locking down the position of the background image and setting it to cover. I didn’t have to specify the height of the div in my case.

I hope this helps someone else out there…

 

Joomla 3.7.2 – Fabrik Install – Strict standards: Declaration of FabTable::getFields() should be compatible with JTable::getFields($reload = false) in C:\wamp\www\grimeymedia\administrator\components\com_fabrik\tables\fabtable.php on line 119

Wanted to play around in Fabrik again but got this error when trying to install.

Strict standards: Declaration of FabTable::getFields() should be compatible with JTable::getFields($reload = false) in C:\wamp\www\grimeymedia\administrator\components\com_fabrik\tables\fabtable.php on line 119

I had to uninstall the 2o some plugins that some with this component.

 

http://fabrikar.com/forums/index.php?threads/after-updating-to-joomla-3-7-0-fabrik-breaks-admin.46622/

I downloaded the master .zip file from Git Hub.

https://github.com/Fabrik/fabrik

This didn’t install well. Missing XML file error.

I finally just used the Joomla Web Installer. It installed version 3.6 of Fabrik and worked well with my Joomla 3.7.2 core package.

I hope this helps someone else out there…

 

 

 

Contact Form 7 – email not coming from your server configuration error

Had a customer with a configuration issue with the WordPress site.

The original developer had the end users email as the return email address. Contact Form 7 prefer keeping this email address on the same domain, and adding a “Reply to” in the additional headers area. The following link solved this issue for me.

FAQ about Configuration Validator

Which lead me to here.

Setting Up Mail

I hope this helps someone else out there…

 

 

Hide or Remove Video Play Button on IPhone or Safari

Finished a site that has a video in the background. Looked great everywhere I viewed it; however, the client has an iPhone and the play button shows even when the video isn’t suppose to show.

This link helped me solve it.

http://stackoverflow.com/questions/8911247/hide-iphone-html5-video-play-button


*::-webkit-media-controls-start-playback-button {
  display: none!important;
  -webkit-appearance: none;
}

I hope this helps someone else out there…