Saturday, November 17, 2018

WAMP Server Reset Root Password

I recently wanted to install Joomla 4 Beta and discovered I need PHP 7 or higher. I am running XXAMP and only PHP 5.6. I also have WAMP installed and have a bunch of sites started in there. My WAMP would start; however, the sites couldn’t connect to the database.

I looked in the “C:\WAMP\apps\myphpadminX.X.X\config.inc.php” file and the password was what I thought it was. I tried a bunch of things including using the MySQL Console but this article got me working again.

https://stackoverflow.com/questions/29070501/regaining-access-to-lost-mysql-password-for-phpmyadmin-on-wamp

The lines in my “wampserver >> MySQL >> my.ini” file in the looked like this:

# The MySQL server
[wampmysqld]
#skip-grant-tables

I assumed the “#” was a comment so I removed it. I didn’t have to add it. It looked like this:

# The MySQL server
[wampmysqld]
skip-grant-tables

Restarted everything and I could log into PHPmyAdmin and all the sites were now connecting.

I hope this helps someone else out there…

 

WordPress Akeeba – Ajax Loading Error

I was restoring a WordPress website using Akeeba kickstart in my WAMP environment. I got the following error.

I moved over to XXAMP I got site installed; however, my SendMail isn’t set up in XXAMP so I couldn’t test the forms. I wanted to restore the site in WAMP.

Ran the Akeeba Kickstart again and this time I choose to run the files restore “directly” and “ignore most errors”.

The website installed, but while working on the site I discovered a lot of odd things. None of my Widgets or Widget positions were available in the dashboard.

I ran the install again, but this time I did not check “Ignore most errors”. This is installed correctly this time.

I hope this helps someone else out there…

 

Upgrade PHP 5.5 To 7 In WAMP

I installed Chronoforms 6 for WordPress and it requires PHP 5.6 or higher. I am running PHP 5.5 and 7.3 is available.

This video got me started:

 

I downloaded PHP here: https://windows.php.net/download/

I moved the PHP.ini, wampserver.conf, and phpForApache.ini files from my PHP 5.5 folder to my new PHP 7 folder.

I made a few changes to the PHP.ini and phpForApache.ini from John Dugan’s instructions.

In my PHP.ini the only line I changed was line 1943.

zend_extension = “c:/wamp/bin/php/php5.5.12/zend_ext/php_xdebug-2.2.5-5.5-vc11-x86_64.dll”
In my phpForApache.ini the only line I changed was line 718.
extension_dir = “c:/wamp/bin/php/php7.0.30/ext/”

WAMP wouldn’t start after I changed the version to PHP 7.

In the wampserver.conf file I needed to change the following two lines:

$phpConf[‘apache’][‘2.4’][‘LoadModuleName’] = ‘php7_module’;
$phpConf[‘apache’][‘2.4’][‘LoadModuleFile’] = ‘php7apache2_4.dll’;

I restarted WAMP and it was up and running.

The first issue I ran into was CURL needed to be enabled, but the fonts on the site I was working on switched from a Sanserif font to a serif font. Not sure why.

I hope this helps someone else out there…

 

Best WordPress Backup Solution – Akeeba

I have used Akeeba for years for Joomla and made moving and backup up sites so easy. I started purchasing the Pro version so I could exclude various directories and back up to Amazon Web Services. With the use of a Cron Job my sites were taking care of themselves.

I was so glad to see Akeeba make their backup solution for WordPress. The best part was the way it ran the 3 SQL statements you need for updating the permalinks automatically. Although this was best solution I had used for backing up and moving a WordPress site it didn’t always work. Sometimes it would never finish running the SQL permalink updates and the site wouldn’t complete the move. In addition, the plugin would tell me I had an update available, but when I tried to automatically update it the site was breaking. I would end up with a blank white website.

Well this latest version of Akeeba Backup / Kickstart software is working really well. When ever I have moved a site the Permalinks update works well, and the latest version updates through the plugin manager without a hitch. I would highly recommend this software to anyone. The pro version is totally worth it.

I hope this helps someone else out there…

 

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…

 

Install Drupal 8 on WAMP

I wanted to play around with Drupal 8. I often use WAMP and I have also install XAMP. They both work well. WAMP can be a tougher install in my opinion especially on Windows 10.

During my Drupal install I ran into Mod_Rewrite, OPCach and XDebug settings that needed to be corrected before the install would complete. I found the following video on YouTube that solved my issues perfectly.

Thanks to the guy who put this together.

I hope this helps someone else out there…

 

Joomla 3.X Strict standards: Only variables should be assigned by reference in – Solved

I was testing a clients website local host and it was throwing a bunch of errors in WAMP.

Strict standards: Only variables should be assigned by reference in

These errors were related to SuperFish Menu Module. I love SuperFish Drop-down menus, but I don’t love the module for Joomla yet.

I found this YouTube video that simply turns off Error messages on the Server settings in the Global Configuration.

https://www.youtube.com/watch?v=CNi8_oCGnWY

I don’t think this is a perfect fix, but it helped me.

I hope this helps someone else out there….

 

Malwarebytes Anti-Ransomware quarantined necessary files in WAMP server

I upgraded a localhost version of a Joomla 3.4.8 website to version 3.5. When I did Malwarebytes Anti-Ransomware quarantined some Apache files and a registration key.

malwarebytes_ransomware_WAMP

When I tried to view the sites front end looked like this.

malwarebytes_ransomware_WAMP_broke

This all happened after the 3.5 upgrade and then I tried to update Akeeba. Mid way through I was warned by Malwarebytes Ransomware about the files. My other sites were still working fine.

 

 

Looking to use #include in WAMP

I am looking for a way to add Server Side Includes not PHP includes with my WAMP. Another programmer used them extensively and I am now working with his files. I plan to change the files over to PHP and include the header and footer that way, but I am curious about getting them to work with my WAMP the way it is set up out of the box.

I found this article, but I was unsuccessful. I will look into further to see if I can get it to work.

http://www.roseindia.net/tutorial/php/phpbasics/Setting-Up-SSI-On-Wamp.html

 

Drupal 7 install on WAMP – now page is forbidden

Playing around with Drupal I suddenly found I was unable to view pages with the “localhost” URL.

Solution was a “.htaccess” file got written to the www folder. I deleted this file and everything was normal again

The issue would come back each time I went into the configuration area. I am trying to figure out how to stop this.

I hope this helps someone else out there…