Author Topic: Overflow error  (Read 10470 times)

0 Members and 1 Guest are viewing this topic.

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Overflow error
« on: December 27, 2009, 02:58:34 am »
viddb
Conversion error from string "27/12/2009 12:14:31 PM"
Overflow occured during type conversion.
Error code: 14.

Occurs when try to duplicate a record for
"Cloudy with a chance of meat balls" http://www.imdb.com/title/tt0844471/ http://www.allmovie.com/work/cloudy-with-a-chance-of-meatballs-474693
Linked to .avi or .mkv file

Initially it occured in my main database with existing .avi record & I  tried to duplicate so I could add HD .mkv record.
control-Delete then add new (HD) recored linked to .mkv file OK but same error when tried to duplicate.

Created a new empty database. Just added record for "Cloudy with a chance of meatballs (HD)" linked to .mkv file, again OK. But when tried to duplicate it I got the above error message.

Note:
I suspect it is something about the data which is retrieved which is causing the trouble as I have processed over 200 other records the same way without this error.
« Last Edit: December 27, 2009, 06:24:15 am by patch »

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Overflow error
« Reply #1 on: January 30, 2010, 05:45:43 am »
viddb
Conversion error from string "@1"
Overflow occured during type conversion.
Error code: 14.

Occurs when try to duplicate a record for
2012 http://www.imdb.com/title/tt1190080/
Up http://www.imdb.com/title/tt1049413/

Anyone else getting similar errors or found a solution?

mgpw4me@yahoo.com

  • Guest
Re: Overflow error
« Reply #2 on: January 30, 2010, 08:28:07 am »
Conversion is failing on the time in the DATE ADDED field.  Go into edit mode, remove the time, save and duplicate to your heart's content. 

The time is added automatically in the current PVD version...

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Overflow error
« Reply #3 on: January 30, 2010, 01:18:51 pm »
Conversion is failing on the time in the DATE ADDED field.  Go into edit mode, remove the time, save and duplicate to your heart's content. 
Thankyou, thankyou, thankyou.

Deleting the date & time didn't work as pvd kept the old value but deleting just the time fixed the problem.
btw I use 12hr date format eg "19/01/2010 8:41:41 PM"

buah

  • Guest
Re: Overflow error
« Reply #4 on: January 30, 2010, 03:20:48 pm »
Just for the record. I had the same problem. But, although PVD had overflow error, actually duplicate was made. You just had to exit and then enter PVD, and the duplicate would "reveal" itself. No need to delete date added.
« Last Edit: January 30, 2010, 03:23:49 pm by buah »