Various default settings are not read properly on a fresh install

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Reboot PC/Start Task

What is the expected output? What do you see instead?
Date: Sun Mar 01 23:56:57 EST 2009

HTTP ERROR: 500
Unexpected '#' on line 1
RequestURI=/sjq/SJQ

Caused by:
java.lang.RuntimeException: Unexpected '#' on line 1
----------------

What version of the product are you using? On what operating system?
Lastest, I just downloaded it over weekend.

Please provide any additional information below.
1.sqllite file attached
2.My properties file is as follows
port=8080
host=localhost
is_ssl=false

3.Client rules
//Client options
:MAXPROCS 1
// TASK definition
COMSKIPMPEG {
:CPU LOW
:MAX 1
"C:\\comskip\\comskip.exe -n \"%c%\""
}

4.Server Rules

if [IsTV == "true" && IsHD == "false" && FileExists != "%d%\\%p%.edl" &&
Filename =$ ".mpg" && IsActivelyRecording == "false" && ChannelNumber !=
"0|1|1400" && IsScheduledRecording == "true"]
{
COMSKIPMPEG

Original issue reported on code.google.com by richard....@gmail.com on 3 Mar 2009 at 1:57

Attachments:

• sjq.sqlite

[GoogleCodeExporter]

Does the error message continue to be written for the client?  Or is this a case
where maybe at first you pasted something in that caused the error and it was 
then
later corrected?

Are tasks being queued?  Are they being picked up by the client and executed?

Original comment by derek%ba...@gtempaccount.com on 3 Mar 2009 at 5:04

• Changed state: Reviewed
• Added labels: Plugin-SJQ

[GoogleCodeExporter]

I believe it is the last entry in my log but how can I clear the log to be sure?

Also from the GUI I can load the main settings page.  I get a error on ie - 
errors on
page.  Could that be related.

Original comment by richard....@gmail.com on 3 Mar 2009 at 5:07

[GoogleCodeExporter]

Before digging too much deeper into this...

Please upgrade to the latest snapshot version.  From the project home page, 
click the
snapshots link on the right.  Download the latest sjq build (sjq-2.1.2.300.zip) 
and
install that and report back, please.

Original comment by derek%ba...@gtempaccount.com on 3 Mar 2009 at 5:14

[GoogleCodeExporter]

ok.. will try that in about 6 hours when I get back home...  

Original comment by richard....@gmail.com on 3 Mar 2009 at 5:15

[GoogleCodeExporter]

I installed the new version.  I get no errors but I cant get it to queue up 
anything.

Last thing i tried was to replace the more complicated string with 

if [Title == "King of The Hill" ] {
   COMSKIPMPEG
}

my client rule is still as listed above.  If my client and server are the same
machine do I need to declare a MAPDIR?

Basicly what I am doing now is running the queueloader and then checking the
active/completed/failed tasks.  I have nothing in there...

Original comment by richard....@gmail.com on 4 Mar 2009 at 1:11

[GoogleCodeExporter]

Under Tools go to "Media Debugger".  Enter King of the Hill and select an 
airing -
it'll place the file name in the box.  Click the button, go to the server logs 
(under
tools) and tell me what you get.

This will tell us why the simple rule isn't queuing anything.

Original comment by derek%ba...@gtempaccount.com on 4 Mar 2009 at 1:46

[GoogleCodeExporter]

I tried King of the Hill and House, two shows I have recorded.  I get back the 
following
Invalid file name: 'House' is not a registered SageTV media file object!  

Server logs has little.  I ran this is 9:38pm... so it looks like it wrote 
nothing
for that.

Tue Mar 03 19:39:08 EST 2009: SQLite driver implementation: 'native'
Tue Mar 03 19:39:09 EST 2009: QueueLoader started
QueueLoader awakened: sleep interrupted
QueueLoader awakened: sleep interrupted
QueueLoader awakened: sleep interrupted
QueueLoader awakened: sleep interrupted
Tue Mar 03 20:18:03 EST 2009: SQLite driver implementation: 'native'
Tue Mar 03 20:18:03 EST 2009: QueueLoader started
QueueLoader awakened: sleep interrupted

Original comment by richard....@gmail.com on 4 Mar 2009 at 2:38

[GoogleCodeExporter]

As you type in a show name you should get a list of suggestions; you need to 
click on
the suggestion so it replaces what you're typing with the full file name. 
Alternatively, enter a complete file name of a recording in the box then click 
the
button.  Should tell you the debugger started for the file then go back to the 
server
logs for the output.

Original comment by derek%ba...@gtempaccount.com on 4 Mar 2009 at 3:43

[GoogleCodeExporter]

I get no suggestions as I start to type names.
It seems like it i not linked up to the sage server or at least the media 
folders.

Do I need to declare where the media folders are if the server and client are 
the
same machine.

Original comment by richard....@gmail.com on 4 Mar 2009 at 3:51

[GoogleCodeExporter]

In the box type in the full path of the recording file then click the debug 
button:

C:\tv\House-Episode-1234567.mpg

It needs to be the full path of a recording file, then click the debug button.

Original comment by derek%ba...@gtempaccount.com on 4 Mar 2009 at 4:22

[GoogleCodeExporter]

getting better..  that worked... it fired off comskip.. I then changed the 
rules back
to my original rule to try some other shows.  I submitted an episode of NUMB3RS 
and
that came back true for all and was added to queue.

// Comskip on MPEG
if [IsViewingMedia == "false" && IsTV == "true" && FileExists == "%d%\\%p%.mpg" 
&&
FileExists != "%d%\\%p%.edl" && IsActivelyRecording == "false" &&
IsScheduledRecording == "true"] {
:PRIORITY 100
COMSKIPMPEG
}

it worked fine for other shows I submitted..    Is there anything special I 
need to
do to get the shows to be submitted?  I have the settings set to run the queue 
loader
after each scheduled recording complete but it doesn't seem to run against 
anything
if that is supposed to appear in the same server log.

Original comment by richard....@gmail.com on 4 Mar 2009 at 4:53

[GoogleCodeExporter]

Instead of submitting single files through the media debugger, try running a 
full
QueueLoader run by selecting:

QueueLoader -> Run Now

Does that fill the queue as expected?  If not, then you have to submit a file 
to the
debugger that you expected to end up in the queue and look to see why it didn't 
get
in there.

Original comment by derek%ba...@gtempaccount.com on 4 Mar 2009 at 4:58

• Added labels: Type-Support
• Removed labels: Type-Defect

[GoogleCodeExporter]

If I run the queueloader it does not fill up the queue.   But if I submit a 
file from
my sagetv folder using the path V:\Shows\Showname-number.mpg it gets in the 
queue fine.

Is there anything I need to do to tell SJQ where my media folder is?

I dont see any errors but I did notice that if I made updates to the settings 
tab and
then clicked back into that tab later the settings that I entered where not 
there.  I
did notice that save button on the setting tab was grey.  That is the only 
error I
can see.  

Original comment by richard....@gmail.com on 4 Mar 2009 at 2:06

[GoogleCodeExporter]

And this is the problem...

You say running a file through the media debugger adds it to the queue and it 
then
gets picked up by the client and processed.

The problem, is that your settings aren't being initialized properly and so 
right now
SJQ is being told to scan an empty queue on each regular run of the QueueLoader.

Load this URL in your browser:

http://192.168.1.10:8008/sjq/SJQ?proto=2&cmd=readSrvSettings

Replace the IP and port as appropriate for your installation.  What do you get 
in
response?  Hopefully it's a rather long string.

Original comment by derek%ba...@gtempaccount.com on 4 Mar 2009 at 4:16

[GoogleCodeExporter]

Yes adding a file to the media debugger adds it to the queue..  

I do get a long string...   

Where are the settings stored?

{"LastClientClean":"1235948129484","schema":"14","ruleset":"// Comskip on 
MPEG\r\nif
[IsViewingMedia == \"false\" && IsTV == \"true\" && FileExists == 
\"%d%\\\\%p%.mpg\"
&& FileExists != \"%d%\\\\%p%.edl\" && IsActivelyRecording == \"false\" &&
IsScheduledRecording == \"true\"] {\r\n:PRIORITY 
100\r\nCOMSKIPMPEG\r\n}\r\n\r\n//
Comskip on H264\r\nif [IsViewingMedia == \"false\" && IsTV == \"true\" && 
FileExists
== \"%d%\\\\%p%.ts\" && FileExists != \"%d%\\\\%p%.edl\" && IsActivelyRecording 
==
\"false\" && IsScheduledRecording == \"true\"] {\r\n:PRIORITY
80\r\nCOMSKIPH264\r\n}","LastServerClean":"1235948129484","LastRun":"12362112085
74","LastTaskLogClean":"1236211208574","password":"\u000eô­ónEúû®w&¦ìÂ�
�õ","NextRun":"1236218410000"}

Original comment by richard....@gmail.com on 5 Mar 2009 at 12:46

[GoogleCodeExporter]

The settings are stored in the sjq.sqlite db file.  So what happens when you 
try to
load the settings page?  Which browser are you using?

Original comment by derek%ba...@gtempaccount.com on 5 Mar 2009 at 1:10

[GoogleCodeExporter]

This is a fresh installation (as opposed to an upgrade)?  I've found the bug
(assuming I'm right about this being a fresh install), I forgot to populate 
default
settings on a fresh install when I made some changes to the settings code 
awhile back
- can't believe you're the first one to hit it.

This will probably take a couple builds to sort out.  I'll try to whip one up 
before
I turn off the laptop for the evening.

Original comment by derek%ba...@gtempaccount.com on 5 Mar 2009 at 1:16

• Changed title: Various default settings are not read properly on a fresh install
• Changed state: Started
• Added labels: Component-Logic, Component-UI, Milestone-SJQ2.1.2, OpSys-All, Priority-Critical, Type-Defect, Usability
• Removed labels: Priority-Medium, Type-Support

[GoogleCodeExporter]

When i load the settings page I get a page without values.  I put in values but 
the
save button is grayed out.

Yes, a fresh install...  I installed the 2.1.1.236 version and then overlayed 
it with
2.1.1.300 version. 

I will be around for a few hours and will try it out as soon as you post a new 
version.

Original comment by richard....@gmail.com on 5 Mar 2009 at 1:26

[GoogleCodeExporter]

Try snapshot 319 and report back your results.

Original comment by derek%ba...@gtempaccount.com on 5 Mar 2009 at 1:38

[GoogleCodeExporter]

much better....

Original comment by richard....@gmail.com on 5 Mar 2009 at 2:03

[GoogleCodeExporter]

Fixed in trunk r319

Original comment by derek%ba...@gtempaccount.com on 5 Mar 2009 at 2:12

• Changed state: Fixed

[GoogleCodeExporter]

Fix verified.

Original comment by derek%ba...@gtempaccount.com on 10 Mar 2009 at 7:28

• Changed state: Verified