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….

 

Divi – Turn Off Lazy Load On Images

Started a new project with Divi and needed lazy load to not happen on the home page. Looking around I found the following page which got me started.

Divi Lazy Loading Images

What I needed to do is go to “wp-content\themes\Divi\includes\builder\scripts\frontend-builder-scripts.js”. On line 3375 I needed to change “Offeset: ‘75%'” to “offset: ‘400%'”.

I hope this helps someone 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…

 

Solved – 500 Fabrik has generated an incorrect query for the list

I moved a Joomla 3.7.2 site that has a Fabrik application in it to a new host, and when I did I got the “500 Fabrik has generated an incorrect query for the list…” error.

I made sure the connection was good. The issue turned out to be the “List” was locked.

Another time I go this issue was due to my database connection. I moved the site to a new location but didn’t update the Fabrik “Connection”.

I hope this helps someone else out there…