Opened 13 years ago

Closed 13 years ago

Last modified 13 years ago

#9280 closed Bug Report (Upstream Bug)

Python Bindings (Python 2.7 and oursql) - Year out of range

Reported by: anonymous Owned by: Raymond Wagner
Priority: minor Milestone: 0.25
Component: Bindings - Python Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

With trunk r27327 the initial mirobridge environment error is now resolved. This has however uncovered another issue that affects both jamu and mirobridge. I've patched oursql 0.9.2 but I'm not 100% sure if this is the bindings or oursql.

Jamu: Traceback (most recent call last):

File "/usr/share/mythtv/mythvideo/scripts/jamu.py", line 6382, in <module>

main()

File "/usr/share/mythtv/mythvideo/scripts/jamu.py", line 6367, in main

process.processMythTvMetaData()

File "/usr/share/mythtv/mythvideo/scripts/jamu.py", line 5608, in processMythTvMetaData

metadata = mythvideo.searchVideos(exactfile=self.rtnRelativePath(videopath, u'mythvideo'), host=localhostname.lower()).next()

File "/usr/lib/python2.7/site-packages/MythTV/utility.py", line 176, in call

for row in cursor:

File "cursor.pyx", line 185, in oursql.Cursor.fetchone (oursqlx/oursql.c:16675) File "statement.pyx", line 502, in oursql._Statement.fetchone (oursqlx/oursql.c:11283)

ValueError?: year is out of range

Mirobridge: 2010-11-23 18:39:22,849 INFO No items downloading Traceback (most recent call last):

File "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py", line 2649, in <module>

main()

File "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py", line 2326, in main

videostodelete = getOldrecordedOrphans()

File "/usr/share/doc/mythtv-docs-0.24/contrib/imports/mirobridge/mirobridge.py", line 1121, in getOldrecordedOrphans

recorded_array = list(mythdb.searchRecorded(chanid=channel_id, hostname=localhostname))

File "/usr/lib/python2.7/site-packages/MythTV/utility.py", line 176, in call

for row in cursor:

File "cursor.pyx", line 185, in oursql.Cursor.fetchone (oursqlx/oursql.c:16675) File "statement.pyx", line 499, in oursql._Statement.fetchone (oursqlx/oursql.c:11234)

ValueError?: year is out of range

Change History (2)

comment:1 Changed 13 years ago by Raymond Wagner

Resolution: Upstream Bug
Status: newclosed

Those are the errors you see if you have not applied the patch detailed in r27184. Note that you must install Cython delete oursqlx/oursql.c prior to building the module to get the changes added.

comment:2 Changed 13 years ago by Raymond Wagner

Milestone: unknown0.25
Note: See TracTickets for help on using tickets.