Hi this is a really great addon I've used it in the past (with old version of xbmc), went to use it today (1.3.3) with xbmc frodo 12 Alpha 5, but got an error.
It processed like 7000 files and got 1 error (13sec to run it), it seems no database updates were made (as it nothing has been marked as watched when I check my video folder), I'm not sure if it was a rollback or if the sql that was ok was never committed.
The error from the log:
Code:
...
21:42:56 T:2300 NOTICE: Watched Flag: [httpapi-sql] exec: UPDATE files SET playCount = 1 WHERE strFilename LIKE "Futurama - S03E05 - Amazon Women In The Mood.avi" OR strFilename LIKE "Futurama - S03E06 - Bendless Love.avi" OR strFilename LIKE "Futurama - S03E07 - The Day The Earth Stood Stupid.avi" OR strFilename LIKE "Futurama - S03E08 - That's Lobstertainment!.avi" OR strFilename LIKE "Futurama - S03E09 - The Birdbot Of Ice-Catraz.avi" OR strFilename LIKE "Futurama - S03E10 - Luck Of The Fryrish.avi" OR strFilename LIKE "Futurama - S03E11 - The Cyber House Rules.avi" OR strFilename LIKE "Futurama - S03E12 - Insane In The Mainframe.avi" OR strFilename LIKE "Futurama - S03E13 - Bendin' In The Wind.avi" OR strFilename LIKE "Futurama - S03E14 - Time Keeps On Slipping.avi" OR strFilename LIKE "Futurama - S03E15 - I Dated A Robot.avi" OR strFilename LIKE "Futurama - S04E01 - Roswell That Ends Well.avi" OR strFilename LIKE "Futurama - S04E02 - A Tale Of Two Santas.avi" OR strFilename LIKE "Futurama - S04E03 - Anthology Of Interest II.avi" OR strFilename LIKE "Futurama - S04E04 - Love And Rocket.avi" OR strFilename LIKE "Futurama - S04E05 - Leela's Homeworld.avi" OR strFilename LIKE "Futurama - S04E06 - Where The Buggalo Roam.avi" OR strFilename LIKE "Futurama - S04E07 - A Pharaoh To Remember.avi" OR strFilename LIKE "Futurama - S04E08 - Godfellas.avi" OR strFilename LIKE "Futurama - S04E09 - Futurestock.avi" OR strFilename LIKE "Futurama - S04E10 - A Leela Of Her Own.avi" OR strFilename LIKE "Futurama - S04E11 - 30% Iron Chef.avi" OR strFilename LIKE "Futurama - S04E12 - Where No Fan Has Gone Before.avi" OR strFilename LIKE "Futurama - S05E01 - Crimes Of The Hot.avi" OR strFilename LIKE "Futurama - S05E02 - Jurassic Bark.avi" OR strFilename LIKE "Futurama - S05E03 - The Route Of All Evil.avi" OR strFilename LIKE "Futurama - S05E04 - A Taste Of Freedom.avi" OR strFilename LIKE "Futurama - S05E05 - Kif Gets Knocked Up A Notch.avi" OR strFilename LIKE "Futurama - S05E06 - Less Than Hero.avi" OR strFilename LIKE "Futurama - S05E07 - Teenage Mutant Leela's Hurdles.avi" OR strFilename LIKE "Futurama - S05E08 - The Why Of Fry.avi" OR strFilename LIKE "Futurama - S05E09 - The Sting.avi" OR strFilename LIKE "Futurama - S05E10 - The Farnsworth Parabox.avi" OR strFilename LIKE "Futurama - S05E11 - Three Hundred Big Boys.avi" OR strFilename LIKE "Futurama - S05E12 - Spanish Fry.avi" OR strFilename LIKE "Futurama - S05E13 - Bend Her.avi" OR strFilename LIKE "Futurama - S05E14 - Obsoletely Fabulous.avi" OR strFilename LIKE "Futurama - S05E15 - Bender Should Not Be Allowed On TV.avi" OR strFilename LIKE "Futurama - S05E16 - The Devil's Hands Are Idle Playthings.avi" OR strFilename LIKE "Futurama - S06E01.avi"
21:42:56 T:2300 NOTICE: Watched Flag: [httpapi-sql] encode: UPDATE+files+SET+playCount+%3D+1+WHERE+strFilename+LIKE+%22Futurama+-+S03E05+-+Amazon+Women+In+The+Mood.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E06+-+Bendless+Love.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E07+-+The+Day+The+Earth+Stood+Stupid.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E08+-+That%27s+Lobstertainment%21.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E09+-+The+Birdbot+Of+Ice-Catraz.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E10+-+Luck+Of+The+Fryrish.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E11+-+The+Cyber+House+Rules.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E12+-+Insane+In+The+Mainframe.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E13+-+Bendin%27+In+The+Wind.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E14+-+Time+Keeps+On+Slipping.avi%22+OR+strFilename+LIKE+%22Futurama+-+S03E15+-+I+Dated+A+Robot.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E01+-+Roswell+That+Ends+Well.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E02+-+A+Tale+Of+Two+Santas.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E03+-+Anthology+Of+Interest+II.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E04+-+Love+And+Rocket.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E05+-+Leela%27s+Homeworld.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E06+-+Where+The+Buggalo+Roam.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E07+-+A+Pharaoh+To+Remember.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E08+-+Godfellas.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E09+-+Futurestock.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E10+-+A+Leela+Of+Her+Own.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E11+-+30%25+Iron+Chef.avi%22+OR+strFilename+LIKE+%22Futurama+-+S04E12+-+Where+No+Fan+Has+Gone+Before.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E01+-+Crimes+Of+The+Hot.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E02+-+Jurassic+Bark.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E03+-+The+Route+Of+All+Evil.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E04+-+A+Taste+Of+Freedom.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E05+-+Kif+Gets+Knocked+Up+A+Notch.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E06+-+Less+Than+Hero.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E07+-+Teenage+Mutant+Leela%27s+Hurdles.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E08+-+The+Why+Of+Fry.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E09+-+The+Sting.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E10+-+The+Farnsworth+Parabox.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E11+-+Three+Hundred+Big+Boys.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E12+-+Spanish+Fry.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E13+-+Bend+Her.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E14+-+Obsoletely+Fabulous.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E15+-+Bender+Should+Not+Be+Allowed+On+TV.avi%22+OR+strFilename+LIKE+%22Futurama+-+S05E16+-+The+Devil%27s+Hands+Are+Idle+Playthings.avi%22+OR+strFilename+LIKE+%22Futurama+-+S06E01.avi%22
21:42:56 T:3520 ERROR: SQL: SQL error or missing database
Query: UPDATE files SET playCount = 1 WHERE strFilename LIKE "Futurama - S03E05 - Amazon Women In The Mood.avi" OR strFilename LIKE "Futurama - S03E06 - Bendless Love.avi" OR strFilename LIKE "Futurama - S03E07 - The Day The Earth Stood Stupid.avi" OR strFilename LIKE "Futurama - S03E08 - That's Lobstertainment!.avi" OR strFilename LIKE "Futurama - S03E09 - The Birdbot Of Ice-Catraz.avi" OR strFilename LIKE "Futurama - S03E10 - Luck Of The Fryrish.avi" OR strFilename LIKE "Futurama - S03E11 - The Cyber House Rules.avi" OR strFilename LIKE "Futurama - S03E12 - Insane In The Mainframe.avi" OR strFilename LIKE "Futurama - S03E13 - Bendin' In The Wind.avi" OR strFilename LIKE "Futurama - S03E14 - Time Keeps On Slipping.avi" OR strFilename LIKE "Futurama - S03E15 - I Dated A Robot.avi" OR strFilename LIKE "Futurama - S04E01 - Roswell That Ends Well.avi" OR strFilename LIKE "Futurama - S04E02 - A Tale Of Two Santas.avi" OR strFilename LIKE "Futurama - S04E03 - Anthology Of Interest II.avi" OR strFilename LIKE "Futurama - S04E04 - Love And Rocket.avi" OR strFilename LIKE "Futurama - S04E05 - Leela's Homeworld.avi" OR strFilename LIKE "Futurama - S04E06 - Where The Buggalo Roam.avi" OR strFilename LIKE "Futurama - S04E07 - A Pharaoh To Remember.avi" OR strFilename LIKE "Futurama - S04E08 - Godfellas.avi" OR strFilename LIKE "Futurama - S04E09 - Futurestock.avi" OR strFilename LIKE "Futurama - S04E10 - A Leela Of Her Own.avi" OR strFilename LIKE "Futurama - S04E11 - 30
21:42:56 T:3520 ERROR: CVideoDatabase::ArbitraryExec failed
21:42:56 T:2300 NOTICE: Watched Flag: [httpapi-sql] responce: <li>Error:SQL Exec Failed
...
That's all I see from the log, not sure if that helps you find the bug or not, just thought I'd bring it up in-case there is something that needs fixing.
Quick update I removed futurama from my xml at it worked great, love the script.
This is the xml if it helps you find the bug, perhaps a long file name or strange character in the filename.
Code:
...
<file Count="1" Id="8697" lastPlayed="2012-09-18 23:24:30">Futurama - S01E01 - Space Pilot 3000.avi</file>
<file Count="1" Id="8698" lastPlayed="2012-09-18 23:24:30">Futurama - S01E02 - The Series Has Landed.avi</file>
<file Count="1" Id="8699" lastPlayed="2012-09-18 23:24:30">Futurama - S01E03 - I, Roommate.avi</file>
<file Count="1" Id="8700" lastPlayed="2012-09-18 23:24:30">Futurama - S01E04 - Love's Labours Lost In Space.avi</file>
<file Count="1" Id="8701" lastPlayed="2012-09-18 23:24:30">Futurama - S01E05 - Fear Of A Bot Planet.avi</file>
<file Count="1" Id="8702" lastPlayed="2012-09-18 23:24:30">Futurama - S01E06 - A Fishfull Of Dollars.avi</file>
<file Count="1" Id="8703" lastPlayed="2012-09-18 23:24:30">Futurama - S01E07 - My Three Suns.avi</file>
<file Count="1" Id="8704" lastPlayed="2012-09-18 23:24:30">Futurama - S01E08 - A Big Piece Of Garbage.avi</file>
<file Count="1" Id="8705" lastPlayed="2012-09-18 23:24:30">Futurama - S01E09 - Hell Is Other Robots.avi</file>
<file Count="1" Id="8706" lastPlayed="2012-09-18 23:24:30">Futurama - S02E01 - A Flight To Remember.avi</file>
<file Count="1" Id="8707" lastPlayed="2012-09-18 23:24:30">Futurama - S02E02 - Mars University.avi</file>
<file Count="1" Id="8708" lastPlayed="2012-09-18 23:24:30">Futurama - S02E03 - When Aliens Attack.avi</file>
<file Count="1" Id="8709" lastPlayed="2012-09-18 23:24:30">Futurama - S02E04 - Fry & The Slurm Factory.avi</file>
<file Count="1" Id="8710" lastPlayed="2012-09-18 23:24:30">Futurama - S02E05 - I Second That Emotion.avi</file>
<file Count="1" Id="8711" lastPlayed="2012-09-18 23:24:30">Futurama - S02E06 - Brannigan, Begin Again.avi</file>
<file Count="1" Id="8712" lastPlayed="2012-09-18 23:24:30">Futurama - S02E07 - A Head In The Polls.avi</file>
<file Count="1" Id="8713" lastPlayed="2012-09-18 23:24:30">Futurama - S02E08 - Xmas Story.avi</file>
<file Count="1" Id="8714" lastPlayed="2012-09-18 23:24:30">Futurama - S02E09 - Why Must I Be A Crustacean In Love.avi</file>
<file Count="1" Id="8715" lastPlayed="2012-09-18 23:24:30">Futurama - S02E10 - Put Your Head On My Shoulders.avi</file>
<file Count="1" Id="8716" lastPlayed="2012-09-18 23:24:30">Futurama - S02E11 - The Lesser Of Two Evils.avi</file>
<file Count="1" Id="8717" lastPlayed="2012-09-18 23:24:30">Futurama - S02E12 - Raging Bender.avi</file>
<file Count="1" Id="8718" lastPlayed="2012-09-18 23:24:30">Futurama - S02E13 - A Bicyclops Built For Two.avi</file>
<file Count="1" Id="8719" lastPlayed="2012-09-18 23:24:30">Futurama - S02E14 - How Hermes Requisitioned His Groove Back.avi</file>
<file Count="1" Id="8720" lastPlayed="2012-09-18 23:24:30">Futurama - S02E15 - A Clone Of My Own.avi</file>
<file Count="1" Id="8721" lastPlayed="2012-09-18 23:24:30">Futurama - S02E16 - The Deep South.avi</file>
<file Count="1" Id="8722" lastPlayed="2012-09-18 23:24:30">Futurama - S02E17 - Bender Gets Made.avi</file>
<file Count="1" Id="8723" lastPlayed="2012-09-18 23:24:30">Futurama - S02E18 - The Problem With Popplers.avi</file>
<file Count="1" Id="8724" lastPlayed="2012-09-18 23:24:30">Futurama - S02E19 - Mother's Day.avi</file>
<file Count="1" Id="8725" lastPlayed="2012-09-18 23:24:30">Futurama - S02E20 - Anthology Of Interest I.avi</file>
<file Count="1" Id="8726" lastPlayed="2012-09-18 23:24:30">Futurama - S03E01 - The Honking.avi</file>
<file Count="1" Id="8727" lastPlayed="2012-09-18 23:24:30">Futurama - S03E02 - War Is The H-Word.avi</file>
<file Count="1" Id="8728" lastPlayed="2012-09-18 23:24:30">Futurama - S03E03 - The Cryonic Woman.avi</file>
<file Count="1" Id="8729" lastPlayed="2012-09-18 23:24:30">Futurama - S03E04 - Parasites Lost.avi</file>
<file Count="1" Id="8730" lastPlayed="2012-09-18 23:24:30">Futurama - S03E05 - Amazon Women In The Mood.avi</file>
<file Count="1" Id="8731" lastPlayed="2012-09-18 23:24:30">Futurama - S03E06 - Bendless Love.avi</file>
<file Count="1" Id="8732" lastPlayed="2012-09-18 23:24:30">Futurama - S03E07 - The Day The Earth Stood Stupid.avi</file>
<file Count="1" Id="8733" lastPlayed="2012-09-18 23:24:30">Futurama - S03E08 - That's Lobstertainment!.avi</file>
<file Count="1" Id="8734" lastPlayed="2012-09-18 23:24:30">Futurama - S03E09 - The Birdbot Of Ice-Catraz.avi</file>
<file Count="1" Id="8735" lastPlayed="2012-09-18 23:24:30">Futurama - S03E10 - Luck Of The Fryrish.avi</file>
<file Count="1" Id="8736" lastPlayed="2012-09-18 23:24:30">Futurama - S03E11 - The Cyber House Rules.avi</file>
<file Count="1" Id="8737" lastPlayed="2012-09-18 23:24:30">Futurama - S03E12 - Insane In The Mainframe.avi</file>
<file Count="1" Id="8738" lastPlayed="2012-09-18 23:24:30">Futurama - S03E13 - Bendin' In The Wind.avi</file>
<file Count="1" Id="8739" lastPlayed="2012-09-18 23:24:30">Futurama - S03E14 - Time Keeps On Slipping.avi</file>
<file Count="1" Id="8740" lastPlayed="2012-09-18 23:24:30">Futurama - S03E15 - I Dated A Robot.avi</file>
<file Count="1" Id="8741" lastPlayed="2012-09-18 23:24:30">Futurama - S04E01 - Roswell That Ends Well.avi</file>
<file Count="1" Id="8742" lastPlayed="2012-09-18 23:24:30">Futurama - S04E02 - A Tale Of Two Santas.avi</file>
<file Count="1" Id="8743" lastPlayed="2012-09-18 23:24:30">Futurama - S04E03 - Anthology Of Interest II.avi</file>
<file Count="1" Id="8744" lastPlayed="2012-09-18 23:24:30">Futurama - S04E04 - Love And Rocket.avi</file>
<file Count="1" Id="8745" lastPlayed="2012-09-18 23:24:30">Futurama - S04E05 - Leela's Homeworld.avi</file>
<file Count="1" Id="8746" lastPlayed="2012-09-18 23:24:30">Futurama - S04E06 - Where The Buggalo Roam.avi</file>
<file Count="1" Id="8747" lastPlayed="2012-09-18 23:24:30">Futurama - S04E07 - A Pharaoh To Remember.avi</file>
<file Count="1" Id="8748" lastPlayed="2012-09-18 23:24:30">Futurama - S04E08 - Godfellas.avi</file>
<file Count="1" Id="8749" lastPlayed="2012-09-18 23:24:30">Futurama - S04E09 - Futurestock.avi</file>
<file Count="1" Id="8750" lastPlayed="2012-09-18 23:24:30">Futurama - S04E10 - A Leela Of Her Own.avi</file>
<file Count="1" Id="8751" lastPlayed="2012-09-18 23:24:30">Futurama - S04E11 - 30% Iron Chef.avi</file>
<file Count="1" Id="8752" lastPlayed="2012-09-18 23:24:30">Futurama - S04E12 - Where No Fan Has Gone Before.avi</file>
<file Count="1" Id="8753" lastPlayed="2012-09-18 23:24:30">Futurama - S05E01 - Crimes Of The Hot.avi</file>
<file Count="1" Id="8754" lastPlayed="2012-09-18 23:24:30">Futurama - S05E02 - Jurassic Bark.avi</file>
<file Count="1" Id="8755" lastPlayed="2012-09-18 23:24:30">Futurama - S05E03 - The Route Of All Evil.avi</file>
<file Count="1" Id="8756" lastPlayed="2012-09-18 23:24:30">Futurama - S05E04 - A Taste Of Freedom.avi</file>
<file Count="1" Id="8757" lastPlayed="2012-09-18 23:24:30">Futurama - S05E05 - Kif Gets Knocked Up A Notch.avi</file>
<file Count="1" Id="8758" lastPlayed="2012-09-18 23:24:30">Futurama - S05E06 - Less Than Hero.avi</file>
<file Count="1" Id="8759" lastPlayed="2012-09-18 23:24:30">Futurama - S05E07 - Teenage Mutant Leela's Hurdles.avi</file>
<file Count="1" Id="8760" lastPlayed="2012-09-18 23:24:30">Futurama - S05E08 - The Why Of Fry.avi</file>
<file Count="1" Id="8761" lastPlayed="2012-09-18 23:24:30">Futurama - S05E09 - The Sting.avi</file>
<file Count="1" Id="8762" lastPlayed="2012-09-18 23:24:30">Futurama - S05E10 - The Farnsworth Parabox.avi</file>
<file Count="1" Id="8763" lastPlayed="2012-09-18 23:24:30">Futurama - S05E11 - Three Hundred Big Boys.avi</file>
<file Count="1" Id="8764" lastPlayed="2012-09-18 23:24:30">Futurama - S05E12 - Spanish Fry.avi</file>
<file Count="1" Id="8765" lastPlayed="2012-09-18 23:24:30">Futurama - S05E13 - Bend Her.avi</file>
<file Count="1" Id="8766" lastPlayed="2012-09-18 23:24:30">Futurama - S05E14 - Obsoletely Fabulous.avi</file>
<file Count="1" Id="8767" lastPlayed="2012-09-18 23:24:30">Futurama - S05E15 - Bender Should Not Be Allowed On TV.avi</file>
<file Count="1" Id="8768" lastPlayed="2012-09-18 23:24:30">Futurama - S05E16 - The Devil's Hands Are Idle Playthings.avi</file>
<file Count="1" Id="8769" lastPlayed="2012-09-18 23:24:30">Futurama - S06E01.avi</file>
<file Count="1" Id="8770" lastPlayed="2012-09-18 23:24:30">Futurama - S06E02.avi</file>
<file Count="1" Id="8771" lastPlayed="2012-09-18 23:24:30">Futurama - S06E03.avi</file>
<file Count="1" Id="8772" lastPlayed="2012-09-18 23:24:30">Futurama - S06E04.avi</file>
<file Count="1" Id="8773" lastPlayed="2012-09-18 23:24:30">Futurama - S06E05.avi</file>
<file Count="1" Id="8774" lastPlayed="2012-09-18 23:24:30">Futurama - S06E06.avi</file>
<file Count="1" Id="8775" lastPlayed="2012-09-18 23:24:30">Futurama - S06E07.avi</file>
<file Count="1" Id="8776" lastPlayed="2012-09-18 23:24:30">Futurama - S06E08.avi</file>
<file Count="1" Id="8777" lastPlayed="2012-09-18 23:24:30">Futurama - S06E09.avi</file>
<file Count="1" Id="8778" lastPlayed="2012-09-18 23:24:30">Futurama - S06E10.avi</file>
<file Count="1" Id="8779" lastPlayed="2012-09-18 23:24:30">Futurama - S06E11.avi</file>
<file Count="1" Id="8780" lastPlayed="2012-09-18 23:24:30">Futurama - S06E12.avi</file>
<file Count="1" Id="8781" lastPlayed="2012-09-18 23:24:30">Futurama - S06E13 - The Futurama Holiday Spectacular.avi</file>
...