Topic-icon Won't install

11 years 1 month ago #31730 by fb_564705464
Won't install was created by fb_564705464
Duplicate column name 'access_token' SQL=ALTER TABLE `dwc_jfbconnect_user_map` ADD COLUMN `access_token` VARCHAR(255) DEFAULT NULL;

Comes up with error 1060 and the above language. Please advise.
The topic has been locked.
11 years 1 month ago #31732 by fb_564705464
Replied by fb_564705464 on topic Won't install
Also, it said the renewal was $48, but it charged me the entire $59. Please advise.
The topic has been locked.
Support Specialist
11 years 1 month ago #31742 by alzander
Replied by alzander on topic Won't install
Shawn,
The upgrade/renewal discount is only valid if you renew while your subscription is still active. Your last subscription looks to have expired in January, so unfortunately, you weren't eligible for the discounted price. There is generally less support for users who keep their subscription and extension up to date, and we try to pass that savings on.

As for your issue, JFBConnect should seamlessly upgrade your database tables. The error message your reporting though is indicating there is a problem doing so. Do you know what version of JFBConnect you were using previously? You also posted in the Joomla 3.0 forums, for which JFBConnect v5.0.0 is the first release for that version. Was this a site migrated from Joomla 2.5 (or earlier), or is this a brand new site?

Any information you can tell us about your configuration just before you installed JFBConnect v5.0.0 would really help us to understand the problem and help provide a solution.

Thanks,
Alex
The topic has been locked.
11 years 1 month ago #31743 by fb_564705464
Replied by fb_564705464 on topic Won't install
It was installed on a new site that never had this software before, but one of our guys had attempted to install the old version before realizing it wouldn't work. Now we cannot install the version that's supposed to work with the clean 3.03 Joomla install.
The topic has been locked.
11 years 1 month ago #31744 by fb_564705464
Replied by fb_564705464 on topic Won't install
There was an error upon attempting an earlier version; not sure if it cleaned itself up after not installing. Perhaps not because of the error that's occurring now. I had attempted to use the Extensions Manager to remove any remnants and retry, but it doesn't seems as if it is properly doing this as I'm still unable to get it installed. Without the component installed the fan module, etc. will not work either.
The topic has been locked.
Support Specialist
11 years 1 month ago #31746 by alzander
Replied by alzander on topic Won't install
Without knowing what version you tried to install, I can't recreate the problem or understand what may be happening.

The solution would be to do the following though:
* Uninstall JFBConnect from the Extension Manager
* Use a database manager tool (PHPMySql or something similar) and remove the following tables from your database:
#__jfbconnect_config
#__jfbconnect_user_map
#__jfbconnect_request
#__jfbconnect_notification
Replace #__ with your database prefix.

With that, you should be back to a clean slate and installing the v5.0.0 release should work. If not, let us know any errors you get and we'll help how we can.

Thanks,
Alex
The topic has been locked.
11 years 1 month ago #31751 by fb_564705464
Replied by fb_564705464 on topic Won't install
Table '339331_dwc.dwc_jfbconnect_config' doesn't exist SQL=SELECT value FROM dwc_jfbconnect_config WHERE `setting` = 'db_version'

Error 1146 this time.
The topic has been locked.
Support Specialist
11 years 1 month ago #31755 by alzander
Replied by alzander on topic Won't install
When did you get that message? If that's during installation, it means that the tables weren't recreated during installation. Can you uninstall JFBConnect and try to install again? The tables being created is a part of Joomla's installer process, not JFBConnect. If they aren't being created, that's a sign of something very odd happening with your Joomla site.

After you reinstall, check out the database to see if the 4 tables I had you delete are back. If not, we'll have to figure out what's going on and why your site is behaving different than all others, as we haven't heard of this issue before.

Thanks,
Alex
The topic has been locked.
11 years 1 month ago #31756 by fb_564705464
Replied by fb_564705464 on topic Won't install
That was the result of following the instructions above, deleting those tables. Everything throughout the remains of the site works fine and it's responsive and I have no issues installing or uninstalling or reinstalling anything else. The tables haven't been re-created.
The topic has been locked.
11 years 1 month ago #31757 by fb_564705464
Replied by fb_564705464 on topic Won't install
"during installation", yes.
The topic has been locked.