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.

Cool Way to Display Attachments

While searching for an issue with Photoshop I came across a forum post in Adobe where someone posted a comment with an attachment. The way the attachment was displayed was very cool. Here is a screen clip showing you what I mean.

Can’t wait to get working on this.

I hope this helps someone else out there…

HTML Entities In Gantry & WordPress

I was working in Ganty 5 for a Joomla site and decided to use Gantry for the WordPress blog. I had purchased some “Particles” from Inspiretheme.com. They have a WordPress particle they call Content Pro. It takes the articles and makes them blocks to show in the front page. It worked great; however, the titles were show the HTML Entities and not the character I wanted.

I contacted InspireTheme, but my subscription was over and they wanted me to resubscribe to get support. The fix seemed so easy; however, I didn’t know where to start. With some playing around I found what I was looking for. It turned to be the “content-pro-wordpress.html.twig” file located “wp-content/themes/g5_hydrogen/custom/particles/”. Here is what I needed to change.

{{- display.title.limit ? article.title|truncate_text(display.title.limit) : article.title -}}

Changed to:

{{- display.title.limit ? article.title|truncate_text|raw(display.title.limit) : article.title|raw -}}

What I had to change was to add “|raw” at the end of the variable. Twig is powerful and helpful, but still new to me. The following links were good help to helping me understand TWIG filters.

http://docs.gantry.org/gantry5/advanced/twig-filters

https://wordpress.stackexchange.com/questions/318934/shortcode-returns-escaped-html-tags

I hope this helps someone else out there….

I-Frame In Joomla

Had a customer who deleted an iFrame in a Joomla article. IFrames can be trouble-some in Joomla and the old JCE, but we have JCE Pro installed. I have sometimes switched the editor from JCE to NONE in the Global Configuration. This wasn’t the fix here. When I pasted the IFrame code into the article the iframe tag would be come “<i-frame”.

A Google search on “i-frame” and “Joomla” brought me to a page from RSJoomla. I had to remove some of the JavaScript protection on the post data. You can find this here (Components > RSFirewall! > Firewall Configuration > Active Scanner). It will look like this.

I hit the X so there were no protections other than being on. Here is a link to that article. They offer more suggestions, but only this one worked for me.

https://www.rsjoomla.com/support/documentation/rsfirewall-user-guide/frequently-asked-questions/scrambled-tags-iframe-becomes-i-frame.html?utm_source=readmoredoc&utm_medium=link&utm_campaign=rsfirewall-exception

I hope this helps someone else out there…

Using NSLookup To Fix Email Bounceback

Needed to find the my Reverse DNS to fix an issue with Craigslist not being able to verify my my IP / Domain Name combination. My co-worker reminded me of “NSLookup”.

  • Open the command prompt
  • Type in “nslookup”
  • You will see your Gateway information.
  • Type in “set type=mx” and hit enter
  • Type in the domain name “somewhere.com” and hit enter.

I hope this helps someone else out there….