Akeeba WordPress Site – Error Connecting to Database

I have done this a million times; however, today it ain’t working. I have a new wordpress site and Akeeba backup. Everything is the latest and greatest. When I used Kickstart to move the site to new hosting I get “Error Connecting to Database”.

There was a message to repair the database so I clicked link and got this page.

https://api.wordpress.org/secret-key/1.1/salt/

It wants to add the “secrets” in the config.php file with the values that this links provide. Well this didn’t help my issue.

What solved my issue was to manually update the database with the following SQL statement.

UPDATE wp_options SET option_value = replace(option_value, 'http://localhost/wordpress', 'http://www.livesite.com/wordpress') WHERE option_name = 'home'OR option_name = 'siteurl';

This is just a sample and you replace my URLs with your URLs. This didn’t work on all the test sites, but it did work on 70% of them.

The solution was to make sure in the “wp_options” table make sure “siteurl” and “home” have the the site’s URL in there.

I hope this helps someone else out there…

Photoshop Won’t Open .TIF Windows

I recently scanned several images as .TIF. When I opened one of them I got the following error:

could not complete your request because there is not enough memory (ram)

I tried adding a DWORD entry in the registry called “OverridePhysicalMemoryMB”, but this didn’t help.

I solved the issue by opening the file in Paint and just hitting Save.

I hope this helps someone else out there…

SEO – URL Character Count Limit

I would assume that it is not unlimited, but I haven’t actually set a standard for myself for this piece like I have for the Title and Description. I realized today there absolutely a limit and the number is “70” characters. This includeswww“, “the domain name“, possibly a “category“, and then the page URL with the file extension such as “.html”.

On a page I had lengthy URL, but it got worse when the category and domain name was included. Here is an example of what I had.

www.domain.com/services/all-the-services-we-perform-in-one-super-long-line.html

Google has this url indexed as….

www.domain.com/services/all-the-services-we-perform-in-one-super-lo…

If I wanted the word “line” to be important it was being cut off. When considering your page url or slug make sure to include the full path.

I hope this helps someone else out there…

SEO – Clean Up Unused DIVI Project

Finishing off a DIVI WordPress site and refining the SEO. The first run through the SEO using Yoast Plugin I used Google’s “site:yourdomain.com, and made the URLs what I wanted. A few days later I was checking Google again to see the progress on the rankings and discovered Google had now indexed the DIVI Projects categories. The theme I was using had some sample projected that I ended up not using; however, they got indexed.

Final conclusion is if you are not using it get rid of it. In my case I was linking to pages I didn’t want public.

I hope this helps someone else out there…

Chronoform Submits in Test but Not Live

I had a working Chronoforms 5 form that I just changed a few dates and suddenly stopped working. I tried debugging the form; however, the form wasn’t submitting to the next page for the debugger to even show me the variables. I found my answer here.

https://www.chronoengine.com/forums/posts/t96579/form-sending-on-test-form-but-not-on-live-site

In the Form go the “Set up” tab. In the “on load” section you will have a “HTML (Render Form)” action. Edit this and toward the bottom you will see “Relative URL“, set this to “No“. It has something to do with SEO options.

I hope this helps someone else out there….

DIVI CSS Changes Not Showing

While working with a template purchased from DIVICake the home page had 3 blurbs and I needed 4. I copied the modules from the third to a new 4 column and everything looked good. When I exited the page builder the new column and blurb were spaced wrong and other CSS styles were not working correctly.

After suffering some time I looked into DIVI’s caching and this fixed my issue. Here is the path.

DIVI >> Theme Options >> Builder >> Advanced     

Turn off “Static CSS Generation” till the site goes live.

I hope this helps someone else out there…

Fabrik Change Required Field Icon

The default icon for a required field is an eye, and I wanted a red star. It wasn’t hard and this following article got me started.

https://www.chrismendlatech.com/2011/08/changing-the-required-icon-for-fabrik-forms-in-joomla-from-an-envelope-to-a-star/

Start by going into the Element’s properties by going to “Elements” and then double-click on the element you want to add the requirement. This assume you have a validation on element already if not click the Add button to add one. I used the “notempty” plugin. At the bottom you will see a field for “icon”. It pulls from the “/media/com_fabrik/images” folder and I choose one of the .png files that was there, so in the field I just added the text “notempty.png”.

I hope this helps someone else out there.

Remove A Google Analytics Account

I had lost a web account and now needed to clean up the old site; moreover, I wanted to remove the Analytics Account since it wasn’t going to be used anymore. Here are the steps I had to take.

  • Log into your Analytics Account
  • Click on the Admin button
  • Click on the account you want to delete.
  • At the top click on the “Move to Trash” button.

I hope this helps someone else out there…

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