Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Invalid time format for column visitor_localtime when importing MySQL data into MSSQL #9052

Closed
bakhesh opened this issue Oct 19, 2015 · 1 comment
Closed

Invalid time format for column visitor_localtime when importing MySQL data into MSSQL #9052

bakhesh opened this issue Oct 19, 2015 · 1 comment
Assignees
@mattab
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
2.16.0

Comments

@bakhesh
Copy link

bakhesh commented Oct 19, 2015

I have had an issue copying my data from MySQL into MSSQL. Every time I tried to copy data from the piwik_log_visit table, I received the following error....

OLE DB provider "MSDASQL" for linked server "piwik_Instance1" returned message "[MySQL][ODBC 5.3(a) Driver][mysqld-5.5.41-0ubuntu0.14.04.1]Invalid time(hours) format. Use interval types instead".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "piwik_Instance1".

I eventually tracked this down to a single record, which had the visitor_localtime set as '252:49:33'. I am unsure how this value was originally logged

piwikscreen

I'm afraid I don't have any more details, although I will try to answer any questions
@mattab
Copy link
Member

mattab commented Nov 26, 2015

Thanks for the report @bakhesh !

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Nov 26, 2015
@mattab mattab added this to the 2.15.1 milestone Nov 26, 2015
@mattab mattab self-assigned this Nov 26, 2015
mattab added a commit that referenced this issue Nov 26, 2015
@mattab
Make sure local time has valid time format fixes #9052
92ef31d
@mattab mattab mentioned this issue Nov 26, 2015
Merged
@mattab mattab changed the title Incorrect time value in visitor_localtime Invalid time format for column visitor_localtime when importing MySQL data into MSSQL Jan 29, 2016
This was referenced Dec 1, 2023
Open
Open
@sirinartk sirinartk mentioned this issue Dec 1, 2023
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mattab mattab

Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
2.16.0
Development

No branches or pull requests
2 participants
@mattab @bakhesh