Log in | Register
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Errors attempting to update from 4.1.2 - 4.2

Topic-icon Errors attempting to update from 4.1.2 - 4.2

Active Subscriptions:

None
14 years 1 month ago #21939 by fb_548860032
When I attempt to update a site form 4.1.2 to 4.2 I get the following errors

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'authorized' SQL=ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `authorized` TINYINT(1) DEFAULT 1;
SQL =

ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `authorized` TINYINT(1) DEFAULT 1;

Component Update: SQL error file DB function failed with error number 1060
Duplicate column name 'authorized' SQL=ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `authorized` TINYINT(1) DEFAULT 1;
SQL =

ALTER TABLE `jos_jfbconnect_user_map` ADD COLUMN `authorized` TINYINT(1) DEFAULT 1;

What can I do to fix this issue please?
The topic has been locked.
Support Specialist
14 years 1 month ago #21963 by alzander
That column that it's saying already exists was just added in the 4.2 release. Not sure why that column would already exist.. can you give a little more information on your upgrade:
* Did you successfully install, and then downgrade at some point, or try to install multiple times for any reason?
* Did you ever manually modify the JFBConnect database tables?

The easiest solution would likely be to simply remove the 'authorized' column from the jos_jfbconnect_user_map table using PHPMyAdmin or something similar. There are other database changes we made with the 4.2 release as well though, which may then become an issue. We may just have to work through each one as you run into them.

If you have any info on special circumstances like mentioned above, that may help narrow down the cause (and solution) as well though.

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

None
14 years 1 month ago #21966 by fb_548860032
Thanks for the reply,

I attempted installation of 4.2 once and it failed, so I tried installing 4.1.2 and that worked. So the probably reason when I attempted 4.2 again that I got the errors was because I'd already tried to install it earlier, the problem then was that it killed my entire Joomla install, front end and backend went to blank pages, luckily I had akeeba on there which had done a roll back upgrade so I unzipped the files and restored them which allowed me in again.

Like I mentioned this is a live site so I will have to make a backup before I start playing around. I didn't copy the original install errors so I just assumed the ones I posted above were actually the same which it appears they may not have been. The install of Joomla is completely new, I have only made the site about 3 days ago and have been working on it since.

If you want to check I can always make a copy of the database and send it to you or just give you access to it on the site. Would that be easier for you to debug?

Just out of curiosity, you can install 4.2.1 over the top of it's self, I'm assuming 4.2 won't do that then?
The topic has been locked.
Support Specialist
14 years 1 month ago #21974 by alzander
Yes, you can re-install the same version, or future versions without problems. Joomla has issues when you rollback to previous versions and then try to upgrade again. Part of that is due to how JFBConnect works (we don't uninstall the database tables when you uninstall, so that you don't loose your configuration settings). However, that causes problems since after you upgrade, the changes have been made, and SQL throws errors for trying re-create the same settings.

As for your original issue when upgrading, We haven't heard of any installation problems like that yet with the new release. If you are using JLinked, you'll need to make sure you upgrade that to v1.2 as well, as there are dependencies between JFBConnect and JLinked now so that JFBC v4.2 only works with JLinked v1.2 or higher. I don't think that's your issue though.

If you do try to re-install again, set Error Reporting to 'maximum' in the Global Config area. That should output an error on white-pages that we can use to diagnose the problem. Other ideas would be to disable all JFBCProfile plugins before you upgrade the component, though that shouldn't be necessary.

Hope that helps. If you have a development site setup, that'd be the best way to test, as a database by itself doesn't tell us everything.

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

None
14 years 1 month ago #22203 by fb_548860032
I've just had the same erros on a completely new install of Joomla. The errors are



JInstaller: :Install: Error SQL DB function failed with error number 1146
Table 'elycompl_jos1.jos_jfbconnect_config' doesn't exist SQL=DELETE FROM `jos_jfbconnect_config` WHERE `setting` = "facebook_update_status_msg";
SQL =

DELETE FROM `#__jfbconnect_config` WHERE `setting` = "facebook_update_status_msg";

Component Install: SQL error file DB function failed with error number 1146
Table 'elycompl_jos1.jos_jfbconnect_config' doesn't exist SQL=DELETE FROM `jos_jfbconnect_config` WHERE `setting` = "facebook_update_status_msg";
SQL =

DELETE FROM `#__jfbconnect_config` WHERE `setting` = "facebook_update_status_msg";

I have now left it at that because the last time I messed about after that error it just killed the entire site and I had to roll back the files to an earlier version to get it to work.

Any ideas how I can fix this please?
The topic has been locked.
Active Subscriptions:

None
14 years 1 month ago #22204 by fb_548860032
Once again completely ignore me! I hadn't spotted the 4.2.1 update, that one installed perfectly :)
The topic has been locked.
Support Specialist
14 years 1 month ago #22208 by alzander
Huw,
No problem. If you happened to download the 4.2.0 release within about 4-5 hours after it was released, that was likely the problem. We re-released really quickly after discovering an installation issue regarding what you mentioned. We didn't up the version number at the time because so few people had downloaded it. The 4.2.1 also has the fix too, which would explain why the upgrade went much smoother there.

Glad to hear it's going smoothly now though, and of course, let us know if you run into anything else!
Alex
The topic has been locked.
  1. Forum
  3. Discontinued Products
  5. JFBConnect Joomla 2.5 Support (CLOSED)
  7. Errors attempting to update from 4.1.2 - 4.2
From the Blog
Facebook | Twitter | LinkedIn | Blog RSS