search

advanced-online-marketing / AOM

Integrate data from advertising platforms into Piwik and combine it with individual visits - create a whole bunch of new opportunities!
http://www.advanced-online-marketing.com
GNU Lesser General Public License v3.0
20 stars 8 forks source link

Install on matomo 3.9.1 #50

Open w3bservice opened 5 years ago

w3bservice commented 5 years ago

Fehler während Plugin-Aktualisierungen:

/usr/share/matomo/core/Columns/Updater.php: Error trying to execute the migration 'ALTER TABLE piwik_log_visit ADD COLUMN aom_ad_params VARCHAR(1024) NULL, ADD COLUMN aom_platform VARCHAR(255) NULL, ADD INDEX index_aom_platform (aom_platform), ADD INDEX index_visit_first_action_time_aom_platform (visit_first_action_time, aom_platform);'. The error was: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'index_visit_first_action_time_aom_platform' /usr/share/matomo/core/Columns/Updater.php: Error trying to execute the migration 'ALTER TABLE piwik_log_visit ADD COLUMN aom_ad_params VARCHAR(1024) NULL, ADD COLUMN aom_platform VARCHAR(255) NULL, ADD INDEX index_aom_platform (aom_platform), ADD INDEX index_visit_first_action_time_aom_platform (visit_first_action_time, aom_platform);'. The error was: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'index_visit_first_action_time_aom_platform'

Can you help me...thx

rpharrison commented 4 years ago

Suggest you use phpMyAdmin or similar to fix this, I had similar issues. What worked for me was:

  1. Backup SQL DB
  2. Deactivate & completely uninstall AOM
  3. Used phpMyAdmin to drop any old tables with 'aom'
  4. Check and remove references to 'aom' in all tables including columns/indexes
  5. Reinstall