[SOLVED] problems when upgrade from 1.9.1 to 2.0.9

Hello people,

When I upgrade community builder from 1.9.1 to 2.0.9 it first returns to me a succes message

The second step : I go to the Tools section, and click on the "check the database" button.
It says =>
Table #__comprofiler_tabs Column useraccessgroupid exists but should not exist
The Core CB database structure differences can be fixed (adjusted) by clicking here : Click here to fix (adjust) all Core CB database differences listed above

If I click the button, it will remove the j25_comprofiler_tabs.useraccessgroupid column, but then, on the front site, I get an error and the site is not working anymore..=>

1054
Erreur: 1054
Unknown column 't.useraccessgroupid' in 'where clause' SQL=SELECT * FROM j25_comprofiler_tabs t WHERE t.enabled=1 AND t.useraccessgroupid IN (-2,1) ORDER BY t.position, t.ordering


I've made a copy of the j25_comprofiler_tabs table, so I replace it by my saved one, and it works again, but I don't understand why I am asked to fix a problem by deleteing a column, that it still needed.



thanx for help
Ben

That column isn't used anymore. Your query maybe coming from a out of date CB plugin trying to use it. I recommend watching the below upgrade video and reading carefully the CB 2.0 Primer Book.

You can find a CB 2.x plugin compatibility table below to grab latest plugin releases.

www.joomlapolis.com/cb-20-addon-status

thanx for your help,
I did what you told me and it works fine now


I now have a last problem.
I want to upgrade CbSubs auto action, and I have a mysql error :

Unknown column 'translate' in 'field list' SQL=UPDATE `j25_comprofiler_plugin_autoactions` SET `title` = 'Redirection https -> http quand connexion', `description` = '', `type` = 'redirect', `trigger` = 'onAfterLogin', `object` = '0', `variable` = '1', `access` = '-1|*|1', `conditions` = NULL, `field` = NULL, `operator` = NULL, `value` = NULL, `exclude` = '', `published` = '0', `ordering` = '14', `params` = '{\"redirect\":{\"url\""http:\\/\\/www.ma-prepa-quotidienne.fr\\/plateforme\\/EspacePerso\\/\",\"message\""\",\"type\""alert\"}}', `translate` = NULL WHERE `id` = '1'


As it's been said, there is no "translate" column in j25_comprofiler_plugin_autoactions....
but if I check the plugin management, it said to me this is the 6.2.3 version?

what did wrong please?
I have to use tue auto action plugin

thanx for your help
Ben


NB :
there is still 3 langage plugin not up to date
CB Paid Subscriptions French
CB Paid Subscriptions - en-GB
CB Paid Subscriptions English

I have done this :
alter table `j25_comprofiler_plugin_autoactions` add column `translate` varchar (255)

then I've done the upggrade and it said to me:
Upload Success
CB Auto Actions
Perform actions at various Community Builder triggers.

so I'm not sure all is OK, because I firstly get the mysql error...

CB Auto Actions error comes from missing a stable release. For example going from 4.x to 6.x. To fix you'd upgrade to 5.x then 6.x so the column will exist as the migration doesn't account for that far back.

it works fine, thanx again