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…

 

Google Tag Manager In Gantry 5 Hydrogen

Was asked by a customers marketing company to add Google’s Tag Manager to their clients website. I wasn’t currently using Google’s Tag Manager, so I decided to look into and apply to my site running a Gantry 5 Hydrogen theme.

I tried just adding it in the “Settings” section of my template. The “before body” portion worked; however, the code for the head section was showing up on the page and not hidden.

A quick Google search lead me to this page where someone built an Atom to handle this.

https://translate.google.com/translate?hl=en&sl=fr&u=https://www.en-toutes-lettres.fr/services-web/joomla-news/358-google-tag-manager-sur-gantry5&prev=search

This Atom was awesome. I had to use it both the home and default. They suggest just putting in the base outline, but that didn’t work for me.

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

 

K2 – Limit Intro Text

I was surprised I wasn’t able to do this easier, but it looks like others have struggled with this as well. I did get it fixed, and was able to limit the word count. I didn’t make a override yet but I will.

In the latest_item.php file I replaced:

<?php echo $this->item->introtext; ?>

with

<?php echo K2HelperUtilities::wordLimit($this->item->introtext, 50); ?>

Here is the thread that helped me solve it

https://www.joomlaworks.net/forum/k2-en/29406-solved-can-we-have-introtext-word-limit

I hope this helps someone else out there…

 

 

Wamp – Error displaying the error page: Application Instantiation Error

My localhost WAMP on my personal Windows 10 machine just crapped out on me. PHPmyAdmin wouldn’t run I get the following on my screen when I go to my localhost website running in WAMP.

Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.

My WAMP install I did without using a password for the PHPmyAdmin. It ran fine for a year and suddenly not.  What to do? I had stuff not backed up that I really wanted.

  • What if adding a password to the PHPmyAdmin fixes it…it didn’t.
  • Could it be my WAMP install and should I re-install on top of my already installed WAMP?

I looked deeply into the config.in.php file and playing around with that something did work. I used the solution on this page.

https://stackoverflow.com/questions/28541325/1045-cannot-log-in-to-the-mysql-server-in-wamp

Next I was lead to OS Training and an article using MySQL Console in WAMP. I never even knew it was there. It asked from my password. I put in the password I had just created in the config.ini.php file, but that didn’t work. I went back to my original blank password and I was in. I typed in

UPDATE mysql.user SET Password=PASSWORD(“root”) WHERE User=”root”;

That gave me the error.

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Which lead me to updating the password for root.

set PASSWORD = PASSWORD(“What ever password”);

That did the trick. I was back into my websites and PHP my admin.

I hope this helps someone else out there…

 

Google Optimize – Getting started and how it benefits?

I am starting down the path of Google Optimize. I am working on a new site and want to do some comparisons of what parts will do better.

Starting with these places.

Anybody has any advise or suggestions on setting up and using Google Optimize feel free to comment.