Wednesday, October 17, 2018

ChronoForms ChronoConnectivity 5 Example

The real benefit to Chronoforms is it is FREE.

I start with installing both ChronoForms and CronoConnectivity from Chronoengine. Go into Chronoforms and create a form. I started one here for customers. I wanted to keep their name, website, and password list. I started with a form called Customers.

After the designer elements of the form were finished  I did not go into set up yet. I went back to the “Forms Manager”, checked the “Customer” form and hit “Create table”. I ended up using the standard setting.

Now I go back into the form and add a couple of pieces to the “Setup” tab. In the “on load” section add “HTML (Render Form)” and “on submit” area add a “DB Save” from the Data Management elements.

You will now be saving the data to the database.

In ChronoConnectivity click “New” credential Manager. I am calling mine “customeredit”.  The Connection Name I called “customeredit”, and set published to “yes”.

Next click on “Models” and enter a new Model. I titled mine “customered” for customer edit. Use the dropdown to select the table where you stored the data from the form.

On the “Front List” tab Click on “Settings”. Select the display type as “Table”. The “Columns list” is the how the data is displayed when it is returned. The breakdown of the columns list is this:

customered.domain.DOMAIN = the model name . the database column name . the heading of the column ( you can make these up.)

The “Sortables” allows this column to be sortable once it is displayed.

On the “Actions” tab click “edit”. The form event will be the name of the form and the action. I called mine “CustomerEdit” and the action is “:load”. I don’t have this form created yet so we will do that next.

Before we leave this connection we need to set it permissions and that is to make the “view” allowed for the public so we can see it.

Go back to Chronoforms, check “Customer” our original form and hit the “Copy” button. Rename this copy “CustomerEdit”. This is what the the “Form event” is looking for.

Go into the form “CustomerEdit” and click on “Designer”

Click on the “Edit” button and set the “Field Name” and the “Field ID” for this “First Name” element to be “customered[firstname]”. This will tie the data coming over to this form together, so the firstname parameter will fill in the “firstname” field. Do the same with the rest of the elements. I also put a hidden field to collect the ID number.

Next go to the “Setup” tab. Add a “HTML (Render Form) element in the “On load” section. From the “External Apps” menu drag a “Connection Action”

Lastly add the name of the connection from ChronoConnectivity. I used the name “customeredit”. The Connection action is “save”.

You can create a menu item for the Form and the Connectivity View to see it all in action .

I will upload a zip file with the forms, connection, and database extract so you can use what I have working. It is easy to take my form and “Restore” it to your Chronoform and do the same thing with the Chrono Connection. The database table is easy to import a single table, and in my zip I have just the one table.

chronos_example_full

I am working on a Chronoform / Connectivitiy version 6 tutorial. Version 5 wasn’t easy to understand and version 6 is looking to be just as complicated. Version 6 does handle the database input better.

I hope this helps someone else out there…

 

ACYMailing Error 500 Layout listing not found.

I wanted to take this component for a test run. It is always on the top row of “Install from Web” tab. It is a hefty install. When finished I clicked on “Lists” to create a list and got the following error:

Error 500 Layout listing not found.

I googled and didn’t find a quick solution other than “did you re-install it”. I ran it again from the “Install from web” tab, and got the same error. I went to the site to download their latest package. It comes down as a .gz. I thought I needed to unzip it first and I did. I didn’t need to do that. I just use the .gz (gun zip).

I was now able to create a list and it retained my only user…me.

I found this article for using Chronoforms with ACYMailing to get subscribers. It worked great. Just a name, email field, and a submit button combined with an PHP script. The user gets an email to confirm they click on the link in the email and ACYMailing took care of the rest.

https://www.acyba.com/acymailing/107-acymailing-chronoform.html#php

I hope this helps someone else out there…

 

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

 

Joomla Extension For Pop Ups

Some websites do a great job of getting your attention for a product but gives the user the power to get rid of the popup at their leisure.

I stumble upon this site where the developer has created an awesome “engage” box extension. Click below to see what I mean.

https://www.tassos.gr/joomla-extensions/engagebox

In the “Demos” box use the drop-down to see all the different types of popups there are.

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.

Facebook Apps / Joomla Modules No Longer Working

We use a couple of Modules in Joomla that tap into Facebook events. This week these broke.

Facebook put out an official statement about cracking down on abuse.

https://newsroom.fb.com/news/2018/03/cracking-down-on-platform-abuse/

Facebook is reviewing all their apps. They are turning off apps that haven’t been used in last three months.

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…

 

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…