Not data imported/shown in piwik

[dagomar]

I saw someone else who had the same issue, which was then solved by a new version. I do not wish to pollute the issue cue, but perhaps this is a new issue altogether.

I am using google2piwikgui.py, all seems to go well.

I ran sudo php misc/cron/archive.php --url=http://localhost/development/piwik

No data is displayed despite messages indicating that the scripts are working. On inspection, I do not see any changes to the piwik database after I did an import through the gui. Th logs of the gui indicate that data is imported and everything is ok. I have saved the log, although it doesn't show anything significant.

I am running Piwik 1.12, perhaps I should try with an older version?

If there is any information that I can provide that could help solve this, please ask! The tool looks very promising, but sadly I cannot get it to work for now.

[DexterTheDragon]

I'm having this same problem. The script says it's getting visitor information from GA but nothing is inserted into Piwik. Using Piwik 1.12

[DexterTheDragon]

I commented out line 20 of sql.py and ran the script with -v2 this is the output I got. Not sure if it helps.

Please wait, this process - depending on popularity of your site may take some time.
Fetching paths and titles of pages.
Fetching number of unique users in days and months.
Exporting 2013-01-01
sql.py:174: Warning: Incorrect time value: '2013-01-01' for column 'visitor_localtime' at row 1
  cursor.execute(SELECT_NB_VISITS, (date, site_id))
sql.py:99: Warning: Field 'visitor_days_since_order' doesn't have a default value
  cursor.execute(INSERT_LOG_VISIT[version], values)
sql.py:99: Warning: Field 'visit_total_searches' doesn't have a default value
  cursor.execute(INSERT_LOG_VISIT[version], values)
sql.py:99: Warning: Field 'visit_goal_buyer' doesn't have a default value
   cursor.execute(INSERT_LOG_VISIT[version], values)
Number of simulated unique visits:      2
Real number of unique visits:   2

sql.py:192: Warning: Column 'visit_total_actions' cannot be null
  cursor.execute(raw_sql, (start_date, end_date))
Please go to your Piwik installation folder and run misc/cron/archive.sh script.