Topic-icon Update to the com_jfbconnect_j2.5_v4.3.0

Active Subscriptions:

None
11 years 5 months ago #27911 by joeliu
Dear

When I update to the com_jfbconnect_j2.5_v4.3.0, install component error. How could I do?

File Attachment:


Failed deleting mod_sclogin_j2.5_v1.1.4.zip
Failed deleting plg_user_jfbconnectuser_j2.5_v4.2.1.zip
Failed deleting plg_system_jfbcsystem_j2.5_v4.2.5.zip
Failed deleting plg_content_jfbccontent_j2.5_v4.2.1.zip
Failed deleting lib_sourcecoast_j2.5_v1.0.6.zip
JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'params' SQL=ALTER TABLE `solomo_jfbconnect_user_map` ADD COLUMN `params` TEXT;
SQL =
ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `params` TEXT;
Component Update: SQL error file DB function failed with error number 1060
Duplicate column name 'params' SQL=ALTER TABLE `solomo_jfbconnect_user_map` ADD COLUMN `params` TEXT;
SQL =
ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `params` TEXT;
The topic has been locked.
Support Specialist
11 years 5 months ago #27928 by alzander
Those errors seem to indicate that v4.3 is already installed. Was version 4.3 already installed on this system before you tried to install it again? If so, then the tables that 4.3 is trying to create are already there, and that's why the error is being thrown. If 4.3 was installed, you likely can just ignore those errors.

If 4.3 wasn't already installed, let us know, as that'd be a big problem. You shouldn't ever downgrade our extensions or else issues like this will occur as tables are modified with many releases. There's no way to properly downgrade and revert the tables as the 'old' version won't know what's changed in the 'new' version to undo those changes.

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

None
11 years 5 months ago #28347 by seansin
Hi Alzander,

I have the exact same error and yes, I HAD installed 4.3.0 and then reverted back to 4.2.5 (by uninstalling and then clean re-installing) because I was troubleshooting for some errors that I was getting.

The question is, now what ?

Now that I am getting this error, what is the best advise ? Un-install and clean re-install ??

Thanks,

Sean.
The topic has been locked.
Support Specialist
11 years 5 months ago #28353 by alzander
Sean,
The warnings during installation are just that, warnings. You shouldn't run into any issues by downgrading and upgrading, we just don't conceal the warnings while we're trying to re-update the database.

If you are running into actual issues after the install process, let us know and we'll help you diagnose and fix them.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
11 years 5 months ago #28356 by seansin
Alzander,

The actual issue that I face is that my JFBConnect does not upgrade after this warning. I am still on version 4.2.5 with a "Install component Error" message.

So should i go for an un-install and re-install and re-configure ?

Sean.
The topic has been locked.
Support Specialist
11 years 5 months ago #28359 by alzander
Ahh.. If you're using the Automatic Updater built-in to JFBConnect, try downloading the original package files from the My Subscriptions area and installing that way.

If that doesn't work, can you paste a picture of the error page you're seeing? We don't test downgrades and upgrades with every release, but, to my knowledge, it shouldn't break. Either way, we can definitely get you fixed up without loosing any of your configuration or user settings.. just may take a little investigation.

The main problem is that when you uninstall, we don't uninstall or revert the database tables. That's so that you don't have to reconfigure everything again and your users don't have to re-connect their FB accounts. Because of that, when there are updates to the database, if you revert and then upgrade again, those updates fail.. we can get you past those issues though.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
11 years 5 months ago #28360 by seansin
Hi Alzander,

Yes I was trying the automatic update built into JFBConnect.

I tried downloading the 4.3.0 package and installing by uploading it through extensions manager on top of the old version but got the same error and it didn't update.

The screenshot is attached and I tried it on my localhost xampp copy.

Think we can update it without me having to lose the settings and the users ?

Thanks.

File Attachment:
The topic has been locked.
Active Subscriptions:

None
11 years 5 months ago #28366 by seansin
Hi Alzander,

If we cannot upgrade JFBC either through the built-in automatic upgrade OR by over-writing files through manual upgrade just because we have tried different versions of it before . . . or decided to downgrade it before . . . and just because JFBC wants to leave behind some DB tables which it cannot deal with in later installations and give errors..... I think its a shortcoming rather than a useful feature to have in your extension.

You should change it to leave a clean DB and at least be able to install again if required by having it drop older tables.

I have used many joomla extensions that don't have a problem even if they have previous DB tables left behind . . . I think you just need to insert 'drop tables' or something in your installation....?? You would know better.

If you drop the concerned tables manually . . . and then try to re-install, would it install properly ?

Anyways, pls let me know what is the best option for doing this now apart from having to do a clean re-install, re-configure, re-connect . . . if any.

Thanks.
The topic has been locked.
Support Specialist
11 years 5 months ago #28368 by alzander
The difficulty is that it's not easy to develop it both ways. Joomla, by default, will drop all tables when you uninstall. That, we've found, is rediculous as users like to uninstall just to install the next release. That causes all past connections and configuration data to be deleted. We prevent that, but it does cause issues with downgrading when we have database updates.

While we agree that we could make the situation better, the honest truth is that no one usually downgrades.. or at least if they have, it hasn't been a problem in the past. It's something we've added to our tracker to support better in the future, but again, some of the installation work is handled by Joomla.. so we have to work within their confines for some of it. For now, hopefully the below will get you going.

With that said, there's 3 options I can suggest that will get you going. In all cases below, replace xyz with your table prefix.
Update JFBConnect to signal that the 4.3.0 database definition is already installed:
UPDATE xyz_jfbconnect_config SET `value` = '4.3.0' WHERE `setting` = 'db_version';
Look at the xyz_schemas table and find the value for the extension ID that JFBConnect is using (that ID can be found in the Manage Extensions area). If it's not 4.3.0, update it as well.

Roll back the DB changes manually
Delete the following Database tables:
xyz_opengraph_action
xyz_opengraph_action_object
xyz_opengraph_activity
xyz_opengraph_object

Delete the column "params" from xyz_jfbconnect_user_map.

Fresh install
Uninstall JFBConnect using the Joomla installer
Delete the following tables:
xyz_jfbconnect_config
xyz_jfbconnect_notification
xyz_jfbconnectrequest
xyz_jfbconnect_user_map
xyz_opengraph_action
xyz_opengraph_action_object
xyz_opengraph_activity
xyz_opengraph_object
Re-install JFBConnect v4.3 like it's new

Hope those get you going. Please, please make backups first before you try anything. We'll help however we can, but if you get too far off course, it makes it more difficult. Again, this is something we'll look into for future releases, but unfortunately, this is the best I can offer right now.

Thanks, and keep us posted how it goes,
Alex
The topic has been locked.