2.2.0 Install - Error creating table, Error updating table

I am upgrading from 2.1.5 to 2.2.0-pl2 and getting the following errors.

The only options i have a re back and retry, going back didn't give me any other options and retrying doesn't change anything.

Any thoughts?


Error creating table for class modDashboard

Error creating table for class modDashboardWidget

Error creating table for class modDashboardWidgetPlacement

Error creating table for class sources.modAccessMediaSource

Error creating table for class sources.modMediaSource

Error creating table for class sources.modMediaSourceElement

Error creating table for class sources.modMediaSourceContext

Error updating table for class modResource
Array
(
[0] => 00000
[1] =>
[2] =>
)

Error updating table for class modResource
Array
(
[0] => 00000
[1] =>
[2] =>
)

Error updating table for class modResource
Array
(
[0] => 00000
[1] =>
[2] =>
)

Error updating table for class modResource
Array
(
[0] => 00000
[1] =>
[2] =>
)

Successfully upgraded table for class modTemplateVar
Modified column `default_text` from `TEXT` to `MEDIUMTEXT` on table ``modx_site_tmplvars``

Successfully upgraded table for class modTemplateVarResource
Modified column `value` from `TEXT` to `MEDIUMTEXT` on table ``modx_site_tmplvar_contentvalues``

Error updating table for class modUser
Array
(
[0] => 00000
[1] =>
[2] =>
)

Error updating table for class modUser
Array
(
[0] => 00000
[1] =>
[2] =>
)

Error updating table for class modUser
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modUserGroup
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modUserGroup
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modContext
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modContext
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modChunk
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modChunk
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modChunk
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modChunk
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modChunk
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modPlugin
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modPlugin
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modPlugin
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modPlugin
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modPlugin
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modSnippet
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modSnippet
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modSnippet
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modSnippet
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modSnippet
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplate
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplate
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplate
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplate
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplate
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplateVar
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplateVar
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplateVar
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplateVar
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modTemplateVar
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class sources.modMediaSource
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class sources.modMediaSource
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modDashboard
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

Error updating table for class modDashboard
Array
(
[0] => 00000
[1] => 1054
[2] => Unknown column 'primary_group' in 'where clause'
)

It looks like maybe your DB user has permission to update tables but not to create them. This may be a restriction created by the host or possibly you didn't give the DB user full permissions when creating the user.

Similar question:
Made a successful upgrade from 2.1.5-pl to 2.2.0-pl2, and the site is running correctly, like before.
But at the end of the installation process I got this Message:

There was no change in the DB permissions (I'm the only user).

What should I do?

Those are normal and can be ignored.

Thanks.

FYI, updating from 2.1.? to 2.2.0 I got the same four closing error messages as ottogal. I carried on and haven't seen any problems.

Hi all,

I got the same problem and i solve it in a different way (update MODx Revolution 2.0.8-pl (traditional) to MODX Revolution 2.5.0-pl (traditional)).

After seen all this errors i run again the setup and only one error stay there (duplicate column in database).
Empty the cache, refresh the page and all fine (I haven't test everything so don't forget to make a backup before an update !!!).

Many thanks to the MODX team to make it possible !
Hope this help.

[ed. note: Steeve last edited this post 10 years, 2 months ago.]