FAILED-message after executing ./google2piwik.py -c

[seorie]

When I execute ./google2piwik.py -c I receive this here:

Checking configuration file: [OK]

Checking Google Analytics
Attempting login: [OK]
Simple query on table: [OK]

Checking MySQL Access
Initialize database connection: [OK]
Checking tables: [FAILED]
Tables - piwik_1_log_action, piwik_1_log_visit, piwik_1_log_link_visit_action doesn't exist.
Checking site: [FAILED], site with idsite = 2 wasn't found

BUT: Site-ID is correct in config-file. Furthermore, my configuration defines table_prefix = piwik_1 It seems the table-names above have an additional '_' which might cause the problems with the tables.

Execution of ./google2piwik.py :

Traceback (most recent call last):
  File "./google2piwik.py", line 652, in <module>
    CURRENT_VERSION =         sql.get_version(config.MYSQL_CREDENTIALS["table_prefix"])
  File "/home/dirk/Desktop/piwik/Google2Piwik-master/sql.py", line 120, in get_version
    cursor.execute(select_version_sql)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'usr_web229_16.piwik_1_option' doesn't exist")

===>>> I am running it on Ubuntu Version 12.04 (precise) (32-Bit); python 2.7<<<===

Thanks for your help! Dirk

[clearcode]

What version of Piwik are you currently using?

Checking site: [FAILED], site with idsite = 2 wasn't found

You should also check in your database (table site) if site with id = 2 is present.

[seorie]

Site with id = 2 is present.

[clearcode]

1. What's your table names for log_visit and log_action then?
2. Are you using the latest version of Piwik?

[seorie]

@ 1 : my tables are named e.g "piwik_1log_link_visit_action" (the error message described above shows that the script is searching for piwik_1_log_link_visit_action, so a '_' is inserted after the piwik_1 for some reason...) @ 2: Yes!

[clearcode]

In this case, you need to stay tuned for next release of Google2Piwik which will support newest version. We're currently working on it, so should be available within next week or two.

Thanks for you input!

[seorie]

Great! I can wait some weeks. Thanks for the tool!

[clearcode]

New version of Google2Piwik is all ready! Let us know if your issue is still present.