File Renaming Utility: AddEpisode

[pointlisse]

Is there any issue with running addepisode under vista? I'm using the same PP.bat file as I did in XP, and all other calls (comskip, comclean) are working. Any input appreciated!

Andrew

[pointlisse]

Nevermind... I got it to run. I set all .exe's to run as administrator. SQLlite somehow went missing, so once I changed priveledges and replaced the missing file, I was back in business with Vista.

[Pioneer4x4]

ok. as you can see, i'm pretty much stumped, so i am grasping at straws. I am pretty sure that addepisode is trying to rename one of the files, either the video file or a comskip file, and is not able to because another program is accessing it. it is renaming the file in the gbpvr database. (this I can fix, as it shouldnt change the database if it doesnt rename the video file...i'll do that in the next few days, but it wont fix your problem completely)

You can try a few more things before i make up a debug version of addepisode specifically for this problem.

Try changing to these settings in the comskip.ini file:

verbose=0
delete_logo_file=1

The following setting group is throttling back your comskip to keep it from using up the cpu. I deleted it from mine. (just a suggestion, probably doesn't have anything to do with the problem)

[CPU Load Reduction]
play_nice_start=-1
play_nice_end=-1
play_nice_sleep=10

Basically, these settings will reduce the number of files that comskip produces. If you still have problems, try running everything manually:

rename the batch files so gbpvr cant find them. record something. then run comskip on the file. (easiest way is to drag and drop the file onto comskip) when that is finished (the command window will disappear) run addepisode on the file. (from the command line, using the same command as you have in your batch file, but replacing the %1 with the full path and filename of the video file with quotes around it)

let me know

I read a past message about suggesting running comskip 1st with a /wait.

Does this make sense?
If you run addepisode first, then comskip, addepisode is still processing when comskip fires up and locks the mpeg. Addepisode is still trying to finish, but can't.
How about running addepisode first with the /wait, then comskip? How does addepisode pass the new filename to comskip?

[HeeZy01]

ok, i get the "SQL error: database is locked" error when trying to rename back-to-back recorded episodes. actually, i recorded four 30 minute episodes in a row. here is what it says in the log,

Code:

F:\MyVideos\My Name Is Earl\My Name Is Earl_20070531_20002030 Renamed to F:\MyVideos\My Name Is Earl\My Name Is Earl-Larceny of a Kitty Cat (2006-10-12)-(Thu-05-31-2007) at 20:30 05/31/2007
$iRval<> $SQLITE_OK , $sOutput=
SQL error: database is locked
$iRval<> $SQLITE_OK , $sOutput=
SQL error: database is locked
F:\MyVideos\The Wonder Years\The Wonder Years_20070531_21302200 Renamed to F:\MyVideos\The Wonder Years\The Wonder Years-S0059117- Hero (1992-03-11)-(Thu-05-31-2007) at 22:02 05/31/2007

the first show was renamed properly, but the second and third episodes were not. and the last episode was renamed fine.


is there a fix for this?

[turkey]

ok, i get the "SQL error: database is locked"

no fix. sorry.

sql should not have a problem with concurrent database accessing, but that is the only thing that i can think that may cause this error. I get it every once in a while as well, and have never been able to accurately replicate the error, or for that matter fix it. Sorry.

[HeeZy01]

is there a way to manually rename the files that weren't renamed, and still have the newly renamed files in the db?

EDIT: did a test run and it seems when my computer is "Locked", (WIN+L, or crtl+alt+del), the db is locked. i did another test right after which i scheduled a couple of recordings and i locked my pc before the recordings started. the recordings did not record. all there is are 0 KB .mpg files. and then the renamings are hit or miss.

can someone else test this.? i guess GBPVR doesn't like it when my PC is locked.

[Pioneer4x4]

ok, i get the "SQL error: database is locked" error when trying to rename back-to-back recorded episodes. actually, i recorded four 30 minute episodes in a row. here is what it says in the log,

the first show was renamed properly, but the second and third episodes were not. and the last episode was renamed fine.


is there a fix for this?

I too have noticed that AddEpisode fails on back-back shows. I will have to look at my files more.

[Pioneer4x4]

I too have noticed that AddEpisode fails on back-back shows. I will have to look at my files more.

I get the same thing in my logs. I created a shortcut to postprocessing.bat on my desktop. Then I drag the .mpg file that didn't rename onto it and it renames the file fine! I might try putting a delay in the batch file to see if that helps.

[haystraw]

Hello.

I think I might have missed a step. When I run it from the command line it does nothing. I put it in my PostProcessing.bat file..nothing. No error.

any ideas what I can check?

[Pioneer4x4]

Hello.

I think I might have missed a step. When I run it from the command line it does nothing. I put it in my PostProcessing.bat file..nothing. No error.

any ideas what I can check?

This is my postprocessing.bat

start /wait addepisode %1 "{episode}"
the start /wait was in because I was trying something with comskip. Now I just run comskip manually on shows I want it on. I keep a copy of the 3 comskip files in each shows folder and I just drag the mpg onto the comskip.exe.