Topic-icon Using JFBC 4.2 on new website

Active Subscriptions:

None
I am currently using version 4.02 on our J1.5 website.

I am building a new J2.5 version of the website in which I will incorporate version 4.2.

When it is all working I will clone it from its test subdomain to the current domain using Akeeba Backup.

Can I export/import all my current users and their Facebook credentials from the J1.5 site into the J2.5 site?

many thanks, Mike.
The topic has been locked.
Support Specialist
14 years 3 weeks ago #22740 by alzander
Mike,
The tables for JFBConnect have changed a bit from 4.0.2 to 4.2, so you'd need to make sure you don't just move the tables from the old site to the new one. However, if you're just transferring the actual data from the xxx_jfbconnect_user_map and xxx_jfbconnect_config tables, it should work. The new columns will simply fill in their defaults automatically.

4.2 also has a few new tables that didn't even exist in 4.0, so you'll need to make sure these are in the new installation. They are empty by default and just filled as Facebook requests are sent to your users.

An option would be to upgrade your J1.5 site to 4.2 and then transfer those tables over. The structure and functionality between our J1.5 and J2.5 versions are the same, so you shouldn't run into issues there.

Hope that helps,
Alex
The topic has been locked.
Active Subscriptions:

None
14 years 3 weeks ago #22744 by fb_100000552265523
Hi Alex,

Thanks for prompt reply.

Is upgrade to v4.2 in J1.5 site just like any standard module or component upgrade. No special issues?

Is there then a special export function to get th data out to import into the new J2.5 site or is this a manual copy parts of the database problem?

Many thanks, Mike.
The topic has been locked.
Support Specialist
14 years 3 weeks ago #22759 by alzander
Just install the component like you're doing it for the first time. JFBConnect will update the main component automatically. You'll need to also manually update any modules or extra plugins you have installed by re-installing the newest versions of those.

Once installed, we don't have an export function. Any way you can move the 4 tables of JFBConnect over will do (there are only 2 if you're using 4.0 though). Shouldn't be too tough with Akeeba or if you know you're way around some SQL queries. Obviously, have backups first!

Hope that helps!
Alex
The topic has been locked.
Active Subscriptions:

None
14 years 3 weeks ago #22767 by fb_100000552265523
Hi Alex,

Thanks for info. Can you point me to a resource that explains how to copy/move SQL tables?

How do I identify the JFBConnect tables?

Also will there be any problem on the test domain with the Facebook API?

The test domain is a sub-domain of my current site.

Thanks, Mike.
The topic has been locked.
Support Specialist
14 years 3 weeks ago #22809 by alzander
The JFBConnect tables are named xxx_jfbconnect_... where xxx is your Joomla DB prefix. There are 2 tables in all versions up until 4.0:
xxx_jfbconnect_user_map
xxx_jfbconnect_config
4.1.0 added 2 more tables:
xxx_jfbconnect_requests
xxx_jfbconnect_notifications

For doing the database transfer of those tables, if you have command line access, you'll want to look into "mysqldump". There are other tools though, including Akeeba, which can move specific tables from one Joomla site to another.

Finally, for running on your test domain, if it's a subdomain of the main domain you already have the app on, it should run without any problem. If it's a different domain, you should get a new app just for that domain and to test with. Once it's all working there, move to the live site and just use the live site api/secret key and everything else will just work.

Hope that all helps!
Alex
The topic has been locked.
Active Subscriptions:

None
14 years 3 weeks ago #22817 by fb_100000552265523
Hi Alex,

Brilliant. Thank you.

Mike.
The topic has been locked.
Support Specialist
14 years 3 weeks ago #22822 by alzander
Glad we could help! If you run into issues, just let us know.

Finally, if you haven't already, after you get everything up and running (again), please consider leaving a rating and review on the Joomla Extension Directory for JFBConnect, or our support. It's certainly not required, but very appreciated!
extensions.joomla.org/extensions/social-...ook-integration/7215

Thanks, and good luck,
Alex
The topic has been locked.