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

[TEDDYXXL]

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]

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]

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

[johanneskonst]

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]

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