search

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.95k stars 2.66k forks source link

Piwik A/B Plugin causes error in archive cron #11664

Closed walter-ma closed 7 years ago

walter-ma commented 7 years ago

Hi,

my company bought the Piwik premium plugin “A/B Testing”. Since the installation and the implementation of the code on our websites we have a problem to archive our data.

The archive cronjob throws following errors: ERROR [2017-05-05 08:16:34] Got invalid response from API request: ?module=API&method=API.get&idSite=40&period=day&date=last52&format=php&segment=visitConvertedGoalId%3D%3D39&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:91:"Mysqli prepare error: Not unique table/alias: 'log_conversion' - caused by plugin AbTesting";}' ERROR [2017-05-05 08:17:16] Got invalid response from API request: ?module=API&method=API.get&idSite=40&period=week&date=last2&format=php&segment=visitConvertedGoalId%3D%3D39&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:91:"Mysqli prepare error: Not unique table/alias: 'log_conversion' - caused by plugin AbTesting";}' ERROR [2017-05-05 08:17:52] Got invalid response from API request: ?module=API&method=API.get&idSite=40&period=month&date=last2&format=php&segment=visitConvertedGoalId%3D%3D39&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:91:"Mysqli prepare error: Not unique table/alias: 'log_conversion' - caused by plugin AbTesting";}' ERROR [2017-05-05 08:18:42] Got invalid response from API request: ?module=API&method=API.get&idSite=40&period=year&date=last2&format=php&segment=visitConvertedGoalId%3D%3D39&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:91:"Mysqli prepare error: Not unique table/alias: 'log_conversion' - caused by plugin AbTesting";}'

Has someone recongized this before and knows how to fix this? I need a solution for this ASAP.

Thanks for any advices. Best regards, Mario

sgiehl commented 7 years ago

Our support team will investigate and get back to you. For future issues with Premium plugins please create a support ticket within your shop account or get in touch with our support team by mail.