Last Updated on December 1, 2019 by Christopher G Mendla
If you are using Fabrik for form generating and databases in Joomla, there are a couple of tricks required when you move to a new domain or even a new host. The following are some notes on moving to a new host that uses Cpanel.
- I usually do a backup of the site using akeeba and restore the site to the new host using akeeba’s quickstart. When you are setting up the new hosting, take a careful note of the mysql settings and credentials.
- Be sure that you don’t skip restoring the database in Kickstart
- Once you have the site installed go to Components, Fabrik, Connections. Take a look at the connection(s) there.
- If you are using Cpanel, go to the MySql Databases screen
- Be sure to add the user for your connection to the site’s database with full permissions.
- I usually delete the existing connections and establish a new connection. Then you set up a new connection. In most cases the host will be localhost. Configure the connection, save and close it.
- BE SURE TO MAKE THAT CONNECTION THE DEFAULT!.
You should now have reestablished Fabrik’s connection to your MySql database. I did have a problem where Fabrik would not connect using the credentials I was using for the site itself. Rather than try to work that out, I simply set up another connection. Note – You should not be connecting to the database using root as that opens up security holes.
UPDATE – I had a couple of lists that were returning a 500 SQL error. I went into phpmyadmin and backed up both fabrik_lists and form_sessions. After that I looked at the connection_id. All the the working lists had an ID of 1. The lists that were throwing the error had an id of 3. I simply sent them to an ID of 1. _ WARNING. Messing with the data tables directly can cause your site to break. Use at your own risk.