search

andig / videodb

The videoDB media collection software
65 stars 42 forks source link

Insert new dvd ends in database problem because year is invalid after searching in imdb #164

Open TEDDYXXL opened 1 year ago

TEDDYXXL commented 1 year ago

Hi !

I find a possible bug during insert new dvd in my database after i search/find the title in imdb:

Database Problem Out of range value for column 'year' at row 1 UPDATE videodata SET owner_id = 1, md5 = '', title = 'Death in Paradise', subtitle = '', language = '', diskid = '1041', mediatype = '1', comment = '', disklabel = '', imdbID = 'imdb:1888075', year = '1670935624125', ...

Regards,

Dirk

johanneskonst commented 1 year ago

Yes, year 1670935624125 will not happen for a long time. If i add Death in Paradise to my copy (latest master) it correctly fetches 2011 as year. Did you enter year yourself? And what version are you using? The one from release page here? Or the latest master from source?

TEDDYXXL commented 1 year ago

I use the version from git (git clone ...) ! I didn't enter the year by hand. I search/take the entries from imdb.

johanneskonst commented 1 year ago

Thanks @TEDDYXXL but I cannot replicate this. The only way I can get the year overflowing like this is if i enter big numbers by hand... But i have stricter input validation on my wishlist, this will be fixed in due time. Putting it on hold for now... Thanks for helping out VideoDB!

TEDDYXXL commented 1 year ago

After latest update from today everything looks fine. Thanks. Good job.