Saturday, December 07, 2019

Joomla 2.5 Site to 3.X Upgrade

The best reason to suffer doing this is to retain the historical data; moreover, keep the page visit counts from the time the 2.5 site was started. I discovered I had to start the conversion with PHP 5.6. I had an old version of XXAMP that allowed me to do this. I tried on PHP 7.X and it didn’t work. I started with a restored Akeeba backup of the old site. I then upgraded the site to 3.X, and worked on the template till the review board okayed the full designs. I restored another version of the current site and moved the JEvents Database tables over to the completed board approved copy.

  • Make an Akeeba backup and download a copy of the original existing site and restore it somewhere. I use XXAMP.
  • Run through the upgrade process. Make sure to upgrade to 2.5.8. Disable the ” System – Backup on update ” plug-in since you can just restore it if you need to. Here are the directions. You will have to migrate to Joomla 3.5.1 first and then upgrade.
  • Disable the “System – Remember Me” plug-in.
  • Go to Joomla Update and hit the “Options” button in the upper right to switch “Joomla Update Configuration” to “Short Term Support” and save and close. You can now update to 3.5.1 automatically.
  • Run the installer. If everything goes well you be up to 3.5.1
  • From there I could upgrade to 3.6.5. You will need to log back in to finish the update.
  • I “Check for update” button and got 3.9.13 update.
  • I turned off the error reporting just to check the site out to view JEvents, and there were no events, so i used “install from the web” to reinstall the component right on top of the existing component and all the events were back.
  • Go into PHPmyAdmin and export the following tables
  • j25_content
  • j25_contentitem_tag_map
  • j25_content_frontpage
  • j25_content_rating
  • j25_content_types
  • j25_jevents_categories
  • j25_jevents_catmap
  • j25_jevents_exception
  • j25_jevents_filtermap
  • j25_jevents_icsfile
  • j25_jevents_repbyday
  • j25_jevents_repetition
  • j25_jevents_rrule
  • j25_jevents_translation
  • j25_jevents_vevdetail
  • j25_jevents_vevent
  • j25_jev_defaults
  • j25_jev_users
  • jos_content
  • jos_content_frontpage
  • jos_content_rating
  • jos_jevents_categories
  • jos_jevents_exception
  • jos_jevents_icsfile
  • jos_jevents_repbyday
  • jos_jevents_repetition
  • jos_jevents_rrule
  • jos_jevents_vevdetail
  • jos_jevents_vevent
  • jos_jev_defaults
  • jos_jev_users
  • Copy over images remembering to skip any images that are already there.

Change DIVI Contact Form Error Message.

Have a client that doesn’t want a comma in the standard DIVI error message: “Please, fill the following fields“. It would be nice for Elegant Themes to build this into their widget. I found my answer on the following page.

https://elegantenthusiast.com/modify-subject-divi-contact-form-emails/

I had to go into a actual file to change it. The file is located in “wpcontent >> themes >> divi >> includes >> builder >> framework.php“. It was around line 195. Changed it and uploaded to the site via FTP.

I hope this helps someone else out there….

Is a @maildrop.cc email address okay

Got an email from a customer who got a quote request with an email address ending in “@maildrop.cc“. I used “mailtester.com” to first test the email and it came back as a valid email address. I went to the domain “maildrop.cc” in the browser and saw this is a service.

They give you a temporary email address for just 24 hours. It is used to fill out forms where you don’t trust how they handle your information. I decided to give it try.

  • Just create an email address that uses the “@maildrop.cc”.
  • You will see the “View Inbox” button. Just click on this to see the messages. You are allowed up to 10 messages.
  • It took about 15 minutes for the emails to show up in the “@maildrop.cc” mailbox.

I hope this helps someone else out there…

WordPress “Another Update in Process”

I recently updated a WordPress site to 5.3 but the update didn’t finish. The instructions were to read the email in admin email. I didn’t get the email. After a Google search I ended up on this page which helped me solve the issue.

https://www.wpbeginner.com/wp-tutorials/how-to-fix-another-update-in-process-error-in-wordpress/

The site was local so i just deleted the entry in the database under the “wp_options” >> ” core_updater.lock “. I was able to run the update without a hitch.

I hope this helps someone else out there…

Akeeba Kickstart Error 1273 – Solved.

I have a Joomla 3.9.x site running on a Windows IIS ver. 10 server that wouldn’t allow me to install Fabrik. I decided to move it to my local XXAMP install it there and if everything goes well I would replace the site on the windows server with this new site that had the Fabrik installed. Running the Akeeba Kickstart the database wouldn’t restore.

I was getting ” ErrNo #1273 Unknown collation: ‘utf8mb4_unicode_ci’ “. This response from Nicolas was the solution I needed.

https://www.akeebabackup.com/support/akeeba-backup-wordpress/Ticket/28015:error-1273-on-angie-restoration.html

I hope this helps someone else out there…

Joomla 404 Page Reverted Default

On a Joomla site running Gantry 5 template I noticed my custom 404 page stopped working. I looked up the process and when I looked at the files on the server I had an custom error page there already; however, the date on the file was in October and I put the custom file up there in March.

I was wondering if I got attacked and my files were changed. I didn’t notice anything other issues, but several files were changed in the g5_hydrogen folder. I then realized that around that time I upgraded my Gantry Template and Hydrogen Theme around October.

My conclusion is if you update the Gantry Hydrogen template, then make sure your custom 404 page is still working. I haven’t tested this in the WordPress version, but I would assume it is the same.

I hope this helps someone else out there…

Paying For Google Maps API

Google started charging for using the Maps Javascript API and other APIs. This was a frustrating change when it happened because it was giving a way for free and easy to set up. I eventually got the the free trail set up after adding my credit card. I was doing a job for a company and couldn’t get the finance people of the customer to get me authorized to set up Google account, so I had to use my own money.

Well Google give you a 300.00 credit to get started and once that was set up I was up and running. The problem came in when I needed more than 5 projects and my free trail ran out. It wasn’t obvious to me when my Maps Module in DIVI wasn’t working. I needed to set up a new Billing Account in Google Cloud Platform. I was able to move some of the other accounts in the free account over to the new account. The following videos were a big help for me getting this worked out.

Understanding the Account Management in GCP:
https://www.youtube.com/watch?v=uINleRduCWM

Setting up Maps Module in DIVI:
https://www.elegantthemes.com/blog/tips-tricks/google-maps-api-key

I hope this helps someone else

Analytics Won’t Link to Search Console

I have connected Google Analytics with Google Webmaster (Search Console) a million times, but something has changed. When I went to link the two from Analytics I got prompted to choose my method “Domain” or “URL”.

I chose “Domain” and used a TXT record in the DNS setting to verify the domain. This worked fine and the site got verified in seconds; however, in Analytics the domain still didn’t show. Some research lead me to the following article.

https://support.google.com/webmasters/thread/5780259?hl=en

There seems to be an issue with the Domain Method. I deleted the Property and added it back as URL instead of Domain. It got verified right-a-way and was now available in Analytics.

I hope this helps someone else out there…

Contact Form 7 Add ReCaptcha

I have used “Contact Form 7” a slew of times, but never added Captcha to it. I doing some research I see they have added it to their latest release 7.5.1. I installed a new install of WordPress and installed the latest version of Contact Form 7, and followed the instructions from the following page.

It was super easy to do. If you are using Contact Form 7 and haven’t implemented ReCaptcha you will want to check it.

I hope this helps someone else out there…

Joomla Tags and SEO Descriptions

One of favorite aspects of using Joomla’s Tag system is the tags show up as separate search items in Google’s index. I noticed one day that the description in the search results isn’t what I would want it to be and wanted to change it. Here is an example of two different tags.

Nice long description that was pulled from the page it eventually links to.
This also links to a page but it doesn’t pull the description. You will also notice this tag is “55” and the other is “bitlocker”.

I was thinking it was because the tag was listed with a number instead of an alias; however, I found the “Bitlocker” tag that was indexed by the number; however, it shows the description I wanted.

This time the numbered tag is pulling the global configuration.

I would love to find a solution for this, so if anyone else knows feel free to comment.