If Plugins or Custom Variables count differ on both instances, got "Column not found: 1054 Unknown column 'custom_var_k6' in 'field list'"

[adaqus]

Hi,

I have two instances of Piwik: Instance 1 and Instance 2. I am trying to merge data from Instance 1 to Instance 2. Instance 1 has one custom variable more than Instance 2. While running migration:site I get following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'custom_var_k6' in 'field list'

So obviously both instances must have the same number of custom vars. I think it should be at least explicitly stated in documentation, but the best option would be automatically adding additional custom variables.

[mattab]

Hi @adaqus thanks for the report. 👍 for suggested solutions. Pull request welcome!

[mattab]

A similar issue was reported here: Unknown column 'location_provider' in 'field list' #36

Not only Custom Variables can differ, but also other DB fields as fields are added by plugins, and plugins may differ between Instance 1 and Instance 2.