Piwik installation without prefix.
When using a installation of Piwik without prefix the scripts fails to check the verison:
Traceback (most recent call last): File "google2piwik.py", line 653, in
CURRENT_VERSION = sql.get_version(config.MYSQL_CREDENTIALS["table_prefix"]) File "/home/oreygaer/Google2Piwik-master/sql.py", line 138, in get_version cursor.execute(select_version_sql) File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 205, 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 'option WHERE option_name = 'version_core'' at line 1")
I solved it for me by changing in the sql.py the following (on line 136):
t_option = "%soption" % (prefix) if prefix else "option"
to
t_option = "%soption" % (prefix) if prefix else "piwik.option"