Topic-icon Showing sql error on clicking on save button in autorun

Active Subscriptions:

None
Hello,

I am using joomla 3.2 and latest JFV connect v6.1.1 and after install when i am running Auto run and on "Basic Information Setup" on click on save button it is showing error :-
Unknown column 'extra_query' in 'field list' SQL=UPDATE `xyz_update_sites` SET `name`='JFBConnect Updates',`type`='extension',`location`='www.sourcecoast.com/updates/jfbconnect.x...',`extra_query`=NULL WHERE `update_site_id`='6'

and same error it is showing when i am going to component and on saving configuration too.

Thanks
The topic has been locked.
Support Specialist
The extra_query field was added in Joomla 3.2.0 and should be available on your system. Can you please go to the Extensions -> Extension Manager -> Database area. Check if there are any errors and, even if not, hit the "Fix" button in the top left.

That should update any database tables with their new definitions that may not have happened automatically when you moved to Joomla 3.2.x

Hopefully that will get you going, but if not, please let me know what exact version of Joomla you are using: 3.2.1, 3.2.5, etc?

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

None
I checked the database from Extensions, there is no error is showing there, it is showing database is upto date, and i also tried the fix button.

I am using the Joomla! 3.2.0 Stable.

Thanks
The topic has been locked.
Support Specialist
Thanks for your patience. I had to do a little research. The feature we're using to allow for one-click updates in the admin area is only available in Joomla 3.2.2 and higher.

First and foremost, I'd highly recommend upgrading Joomla. There have been multiple bug and big security fixes implemented in the newer releases, which any 'live' site should be using to prevent issues. That will fix the saving problem altogether.

If you'd prefer not to upgrade for some reason, you can edit the /administrator/components/com_jfbconnect/models/updates.php file. Around line 69, you'll see:
if (version_compare(JVERSION, '3.2.0', '<'))
            return;
Update that to:
if (version_compare(JVERSION, '3.2.2', '<'))
            return;

Finally, this fix will be in the 6.1.2 release, expected out later today. So, you can wait for that as well, if you'd prefer.

I hope that helps, and sorry for the trouble.

Alex
The topic has been locked.
Active Subscriptions:

None
Thanks for quick support, upgrading joomla fixed the issue.

Thanks
The topic has been locked.
Support Specialist
No problem for the support. It's what we're here for.

I'm glad upgrading Joomla fixed the issue. It was the right solution to the problem no matter what, since there's a lot of other benefits to being on the latest release.

Of course, if you run into anything else or have any other issues, just let us know!

Thanks,
Alex
The topic has been locked.