Counter 2.0.3 not working with piwik 2.2.0

[globulopolis]

Counter 2.0.3 not working with piwik 2.2.0

[aureq]

As a side note, the .zip file I downloaded matches the master branch.

[Globulopolis]

From previous release I've been added some new for counter parameters. I'm too busy and lazy :) for create update script.
For update

1. recreate counter
2. update counter parameters via sql editor(phpmyadmin, sqlyog or something else)

in table "piwik_counter_sites"
found "params" field and add just before }
,"tpl_by_countries":"","tpl_by_countries_elem_id":""}

[aureq]

Hi @Globulopolis

Thanks for the update. To me, recreating 98 counters isn't really an option. So I came with a different approach. Feel free to include it in the README file.

• Perform a mysqldump on the table piwik_counter_sites: mysqldump -h localhost -u piwik -pPassW0rd --create-options --complete-insert=false --extended-insert=false piwik piwik_counter_sites > piwik_counter_sites.sql
• Copy the dump for backup purpose: cp piwik_counter_sites.sql piwik_counter_sites.sql.orig
• Add the missing bits: cat piwik_counter_sites.sql | sed -e 's#nbvisit\"}#nbvisit\",\"tpl_by_countries\":\"\",\"tpl_by_countries_elem_id\":\"\"}#g' > piwik_counter_sites.fixed.sql
• Inject the modified table dump into production: mysql -h localhost -u piwik -pPassW0rd piwik < piwik_counter_sites.fixed.sql

Make sure you have the double backslash before the double quotes (\")