Wednesday, December 12, 2018

Joomla – Fabrik – 0 Unable to connect to the Database:

I had a Fabrik project that I wanted so show someone and when I got there I saw this message.

0 Unable to connect to the Database: This driver is unsupported in PHP 7, please use the MySQLi or PDO MySQL driver instead.

My Joomla was version Joomla! 3.8.6. I had recently upgraded the server to PHP 7, so I found what broke it. I found this article to get me started.

http://fabrikar.com/forums/index.php?threads/if-in-joomla-3-5-you-get-this-driver-is-unsupported-in-php-7-try.43721/

I needed my Joomla! version and I found in the backend >>  System >> System information.

The solution was to change the SQL driver in Administrator side to “MySQLI(PDO)”. You get there by going to Global Configuration >> Server, and it will be in the upper right.

I hope this helps someone else out there…

 

Joomla Kickstart Restore – Blank White Page

Moved site from Localhost to Godaddy hosting and after I restored the site I got a completely blank screen in both the front end and backend. The source was completely blank.

I found this on OSTraining.com that let me see the errors by editing the “configuration.php” file in the CPanel. I changed “public $error_reporting = ‘development’;”.

https://www.ostraining.com/blog/joomla/white-screen-of-death/

I was now getting an error.

Error:
/home/myaccount/public_html/plugins/system/chronoengine_gcore2/chronoengine_gcore2.php on line 65

I recently upgraded the Chronoforms from version 5 to 6 while keeping 5 around. Their website said this was okay to do.

The site was working fine and this error seem to happen because of the restore. The restore was done through Akeeba Kickstart.

https://www.akeebabackup.com/support/akeeba-backup-3x/Ticket/27368-fatal-error-when-restoring-website.html

The end results was file permissions. My hosting account wouldn’t let me select a different PHP version. I had to contact tech support and they were surprised and had to go up to teir 3 to get it resolved. They determined it my CPanel account that was having permission issues to allow me to change the PHP version.

Once that was changed I was still unable to access the sites. I could put a HTML file there but couldn’t run any PHP. The folder permissions on the public folder needed to be reset to “750”. My sub-domain directories needed to be set to “755”. Godaddy said if I right-click on the folder I could change the permissions myself.

 

I hope this helps someone else out there….

 

Install Joomla Akeeba Pro – Automated Backups

I have done this before; however, some times you need a re-fresher. I started with Localhost version. My Local Environment is Windows 7 running WAMP.

I used “Task Scheduler” to be my local Cron service.  I start by right-clicking on the Task Scheduler and “run as administrator“.

  1. Create a task

  2. On the General tab give the job a name so you can identify the task. I checked to “Run whether user is logged on or not“. Do not check “hidden“.
  3. On the Triggers tab click “new“, and set the time you want this to run. I checked to “Stop task” if it is taking longer than an  hour.

  4. In the Actions tab click “new”, and for the Action select “start a program“.  Browse to your WAMP and locate the PHP.exe. For the arguments add the full path to your sites “cli” folder. Mine is “C:\wamp\www\mywebsite\cli\akeeba-backup.php”
  5. The next tabs Conditions and Settings are self explanatory.

Live Site

  • Shared hosting with Godaddy
  • Joomla 3.8.6 site
  • Akeeba 5.5 pro

I needed to get my path to my PHP.exe with the Godaddy shared hosting and the configuration wizard totally figured this out.

/home/mycpanelusername/public_html/cli/akeeba-backup.php

For the PHP path I used

/home/mycpanelusername/php

The path I used for the PHP was no good. I found the next article on Godaddy’s site.

https://www.godaddy.com/help/create-cron-jobs-16086

/usr/local/bin/php -q /home/[user name]/[path to the file]

https://uk.godaddy.com/help/what-is-a-cron-job-3483

I used the following video from Akeeba to get it right.

https://www.akeebabackup.com/videos/1213-akeeba-backup-for-joomla-pro/1623-abtp02-automating-backup.html

My Final path was:

 /usr/local/bin/php /home/myaccount/public_html/cli/akeeba-backup.php

When I ran the configuration I was given the correct path to the Akeeba-backup.php file.

In the CPanel hosting I went to “cron job”, and created a job.

I hope this helps someone else out there.

Responsive IFrame In Joomla 3

This is an issue that I have come across many times and I really liked this last solution I found from this site.

http://howtosurvivejoomla.altervista.org/tutorial/5-responsive-articles-iframe

I use the JCE pro and had a little trouble following the article, but the author did a great job putting the article together. Here is where the “Styles” area is in the Pro version.

Components >> JCE >> Profiles.

In the Profiles section click on “Default“.  Then go to the “Plugin Parameters” tab, and scroll down to the “Styles” section. Click on the “Styles” tab and the right side of the screen will bring up settings.

I was localhost and I just added the new CSS to my “custom” style sheet. I went back to the article and set the style of the IFrame I had already inserted through the JCE Pro and added the new style to it.

I hope this helps someone else out there…

 

Joomla 2.5 Upgrade To 3.X – Use XXAMP Over WAMP

I started a straight forward upgrade of a Joomla 2.5 site to 3.x.

You start with with downloading Joomla 3.5.1 first. Click here to download that package.

I used Akeeba Kickstart to restore a copy of the site locally in a WAMP environment. Restored the site and it need to be upgraded from 2.5.19 to 2.5.28.

First I needed to turn off Akeeba’s “backup system update” plug-in. Go to Plugins >> Sort by “ID” and it will probably one of the last ones. Of course you can always search.

After that the install went fine.

Next we need to set the Joomla Core Updater to be more risky and allow for “Short Term Support” by clicking on the “Options” button.

Select “Short Term Support”.

Click “Save and Close”. Then go back to Joomla Update in the Control Panel.

 

Extensions

  • Akeeba
  • Sourcer
  • JCE
  • JEvents

I got this error:

1093 – An error has occurred.

You can’t specify target table ‘#__template_styles’ for update in FROM clause SQL=UPDATE `#__template_styles` SET home = (CASE WHEN (SELECT count FROM (SELECT count(`id`) AS count FROM `#__template_styles` WHERE home = ‘1’ AND client_id = 1) as c) = 0 THEN ‘1’ ELSE ‘0’ END) WHERE template = ‘isis’ AND home != ‘1’;

That lead me to this article in the Joomla Forums.

https://forum.joomla.org/viewtopic.php?t=910368

So I uninstalled all plugins hoping the JEvents tables would match up if the upgrade to 3.4 goes well and I reinstall JEvents. I removed Akeeba Plugins, but some didn’t want to go away. I removed the JEvents component and the JCE; although, the JCE didn’t want to uninstall either. I then proceeded with a 3.5.1 migration through the Joomla update manager. I got the same error.

Out of fustration I tried the process in XXAMP and the upgrade happened just like it should .

I hope this helps someone else out there….

 

 

 

 

Joomla 3.8 – Error You are not authorised to view this resource.

I got this error because the menu item was set to guest and after a user logged in the error would show.

The reason the menu item was set to guest is because I was using it for a login button. The other menu item was “logout”. When the user logged in it showed and the “login” was unpublished .

I set the user to “Publisher” and “Public” and I redirected the login on the menu item to a “How to update your site” page.

I hope this helps someone else out there…

 

ChronoForms – 1146 Table ‘XXXXXXXXX.#__chronoengine_forms6_blocks’ doesn’t exist

I moved a Joomla 3.8 site with Chronoforms 6 and I got this error:

 1146 Table 'XXXXXXXXX.#__chronoengine_forms6_blocks' doesn't exist

I quickly found this post.

https://www.chronoengine.com/forums/posts/t104239/1146-table-xxxxxxxxx-chronoengine-forms6-blocks-doesnt-exist

I backed up the form. Uninstalled the Chronoforms6 component and plugin. Downloaded the latest versions and restored the form. After that everything worked fine.

I hope this helps someone else out there…

 

Adding A Video To Joomla 3 Article / Page – Using JCE Pro

I needed to add a video to page/article in a Joomla! 3.8 site. I saw the JCE advertises as being able to do this with just a URL. I love the way WordPress embeds YouTube videos and hoped it would be the same experience. It wasn’t, but it wasn’t bad.

The first issue I had was my subscription was expired. That was a cheap fix. Less than 30 bucks and ready. After installing the Pro component I didn’t see where I could add video yet. I tried just the URL but that didn’t work. I solved my issue by adding the special toolbar in the JCE to the normal JCE toolbar. Here is a video of how to set this.

I hope this helps someone else out there…

 

Create A Custom 404 Page In Joomla

When a site gets moved the old indexed URLs lead to users linking to your site through their search may link to a page that no longer exists. Using Google’s Webmaster Tools you can eliminate old URLs, but in the mean time you can pretty quickly create your own 404 page not found error page. The article below is a great resource.

https://docs.joomla.org/Creating_a_Custom_404_Error_Page

The basics are:

  • Create an uncategorized article that is the 404 page. Dress it up any way you like.
  • Create a menu link to the 404 page and set it to be unpublished. Copy the URL of this page to be used later.
  • Copy the “error.php” file from the “Templates/system” directory and paste it in the root of the template your are using.
  • Edit this file and delete out everything after the “or DIE” statement.
  • Add the PHP redirect code in the article.

I hope this helps someone else out there…