breaks when goals are set

[ks32]

I have a goal setup in piwik: Pattern contains: fr=0

Its giving following error:

Started processing Apache2Piwik/var/log/nginx/access.log file... Finished in 4m30s. Traceback (most recent call last): File "apache2piwik.py", line 856, in apache2piwik(DIR) File "apache2piwik.py", line 764, in apache2piwik add_goals() File "apache2piwik.py", line 509, in add_goals cursor.execute('SELECT lv.idvisit, lva.idsite, lv.idvisitor, lva.server_time, lva.idaction_url, lva.idlink_va, lva.server_time, lv.referer_type, lv.referer_name, lv.referer_keyword, lv.visitor_returning, lv.visitor_count_visits, lv.visitor_days_since_first, lv.location_country, lv.location_continent, la.name FROM '+s.PIWIK_PREFIX+'log_link_visit_action AS lva JOIN '+s.PIWIK_PREFIX+'log_visit AS lv ON (lva.idvisit=lv.idvisit) JOIN '+s.PIWIK_PREFIX+'log_action AS la ON (la.idaction=lva.idaction_url) WHERE idaction_url IN '+idactions+' AND lva.idvisit NOT IN (SELECT idvisit FROM '+s.PIWIK_PREFIX+'log_conversion WHERE idgoal = %s)',(int(goal[1]),)) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND lva.idvisit NOT IN (SELECT idvisit FROM piwik_log_conversion WHERE idgoal ' at line 1")

[ks32]

Also with -w it gives following:

apache2piwik.py -g Traceback (most recent call last): File "apache2piwik.py", line 810, in add_goals() File "apache2piwik.py", line 509, in add_goals cursor.execute('SELECT lv.idvisit, lva.idsite, lv.idvisitor, lva.server_time, lva.idaction_url, lva.idlink_va, lva.server_time, lv.referer_type, lv.referer_name, lv.referer_keyword, lv.visitor_returning, lv.visitor_count_visits, lv.visitor_days_since_first, lv.location_country, lv.location_continent, la.name FROM '+s.PIWIK_PREFIX+'log_link_visit_action AS lva JOIN '+s.PIWIK_PREFIX+'log_visit AS lv ON (lva.idvisit=lv.idvisit) JOIN '+s.PIWIK_PREFIX+'log_action AS la ON (la.idaction=lva.idaction_url) WHERE idaction_url IN '+idactions+' AND lva.idvisit NOT IN (SELECT idvisit FROM '+s.PIWIK_PREFIX+'log_conversion WHERE idgoal = %s)',(int(goal[1]),)) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND lva.idvisit NOT IN (SELECT idvisit FROM piwik_log_conversion WHERE idgoal ' at line 1")