Hi, actually it was a down/cross grade. I was trying to run it with 3.3. 2.7 worked fine. Thanks
I am seeing the following problem:
Import an IIS log file from 2010-03-01 : No problem
run archive.php
Import an IIS log file from 2010-03-03 : No Problem
run archive.php
Import an IIS log file from 2010-03-02:
0 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
Parsing log G:\IISLOGS\W3SVC1908953133\ex110302.log...
1600 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
1600 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
1600 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
1600 lines parsed, 0 lines recorded, 0 records/sec (avg), 0 records/sec (current)
Fatal error: Error query: SQLSTATE[01000]: Warning: 1264 Out of range value for column 'time_spent_ref_action' at row 1
In query: INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, server_time, idaction_url, idaction_name, idaction_url_ref, idaction_name_ref, time_spent_ref_action) VALUES (?,?,?,?,?,?,?,?,?)
Parameters: array (
0 => '240716',
1 => 1,
2 => 'J|
You can restart the import of "G:\IISLOGS\W3SVC1908953133\ex110302.log" from the point it failed by specifying --skip=0 on the command line.
Is there a better way to get the parameters that are messed up? Or is there a step that I’m missing between these imports? I was able to do a few months, so long as the dates are in order.