Self Contained Web Server / Interface (3 Viewers)

[risu]

You can turn conflict management off from WebIntManager if it helps.

 

[penfold]

On a fresh media portal install, mine just crashes when I try to do a tv guide download or go into groups menu :
"Microsoft Visual C++ Runtime Library
Assertion failed!
Program: ...gram files\Oz TV Guide Downloader\oztvmprt.exe
File: ../src/btree.c
Line: 1151

Expression: pBt ->maxLeaf + 23 <= MX_CELL_Size
For info ....
(Press Retry to debug the application - JIT must be enabled)
ABORT RETRY IGNORE "

However, it does have : TV Guide Last Downloaded : updated at the bottom

 

[raf]

Error

I'm getting the following error when trying to add a schedule from a Hauppauge pvr150 analog input, scheduling works fine for DVB-T cards using the latest svn:

Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.

I can add the schedule from within mediaportal.


TIA
Richard

 

[Big_Kev]

New Version 0.2.0.12 Beta

Changes to recording management:

• "Condensed" display for recorded programs.
• Multi-Select for deleting recorded programs.

To use this feature, check the "Use multi-select for managing recordings" box on the appearance page on the manager...

Feedback please, as this was not a small re-write on the code.

Kev

 

[clone_tk422]

Changes to recording management:

• "Condensed" display for recorded programs.
• Multi-Select for deleting recorded programs.

To use this feature, check the "Use multi-select for managing recordings" box on the appearance page on the manager...

Feedback please, as this was not a small re-write on the code.

Kev

Awesome!!

I already posted this but wondering if we can have frames on the recorded programs page so the channel name and logo always stays static at top of page..

Also what is the upgrade procedure? Do we have to uninstall old first and then reinstall new or can we install new over the top of old?

if you really want a challenge, how about a page where you can watch live tv in an embedded flash player so you can always have tv wherever you go with a net connections and a browser

 

[raf]

Updated to new version but still getting this error:

Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.

 

[charli181]

changes to the DB

Updated to new version but still getting this error:

Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.

Big_kev,
wasn't there some changes to the database over the last month or so on contraints on fields. Maybe this is what is causing the error?

 

[Big_Kev]

Updated to new version but still getting this error:

Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.

Big_kev,
wasn't there some changes to the database over the last month or so on contraints on fields. Maybe this is what is causing the error?

That would do it... I will update to the latest SVN and check it out...

Kev

Updated to new version but still getting this error:

Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'TvLibrary.dbo.Schedule'; column does not allow nulls. INSERT fails.

The code below adds the scheduled recordings

               R->Close();
               R->SQL->Clear();

               R->SQL->Add("insert into Schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, quality, directory, priority, keepDate, preRecordInterval, postRecordInterval, canceled, recommendedCard, keepMethod) values (:IDCHANNEL, :SCHEDULETYPE, :PROGRAMNAME, :STARTTIME, :ENDTIME, :MAXAIRINGS, :QUALITY, :DIRECTORY, :PRIORITY, :KEEPDATE, :PRERECORDINTERVAL, :POSTRECORDINTERVAL, :CANCELED, :RECOMMENDEDCARD, :KEEPMETHOD)");
               TDateTime *Temp = new TDateTime(2000, 1, 1);

               int TChannel = Q->FieldByName("idChannel")->AsInteger;
               R->ParamByName("IDCHANNEL")->AsInteger = TChannel;
               R->ParamByName("PROGRAMNAME")->AsString = Q->FieldByName("title")->AsString;
               R->ParamByName("STARTTIME")->AsDateTime = Q->FieldByName("startTime")->AsDateTime;
               R->ParamByName("ENDTIME")->AsDateTime = Q->FieldByName("endTime")->AsDateTime;
               R->ParamByName("MAXAIRINGS")->AsInteger = 5;
               R->ParamByName("QUALITY")->AsInteger = 0;
               [COLOR="Red"][B]R->ParamByName("DIRECTORY")->AsString = " ";[/B][/COLOR]
               R->ParamByName("PRIORITY")->AsInteger = 0;
               R->ParamByName("PRERECORDINTERVAL")->AsInteger = FixedPreRecord;
               R->ParamByName("POSTRECORDINTERVAL")->AsInteger = FixedPostRecord;
               R->ParamByName("SCHEDULETYPE")->AsInteger = SchedType.ToIntDef(0);
               R->ParamByName("CANCELED")->AsDateTime = *Temp;
               R->ParamByName("KEEPDATE")->AsDateTime = *Temp;
               delete Temp;
               Q->Close();
               Q->SQL->Clear();
               Q->SQL->Add("select * from channelmap a, card b where idChannel = :Channel and a.idCard = b.idCard");
               Q->ParamByName("Channel")->AsInteger = TChannel;
               Q->Open();
               Q->First();
               if (!Q->Eof)
                  {
                  R->ParamByName("RECOMMENDEDCARD")->AsInteger = Q->FieldByName("idCard")->AsInteger;
                  R->ParamByName("PRIORITY")->AsInteger = Q->FieldByName("priority")->AsInteger;
                  [COLOR="Red"][B]R->ParamByName("DIRECTORY")->AsString = Q->FieldByName("recordingFolder")->AsString;[/B][/COLOR]
                  if (R->ParamByName("DIRECTORY")->AsString.[COLOR="Red"][B]IsEmpty[/B][/COLOR]())
                     {
                     NonFatalMessage += Trans->Trans[[COLOR="Red"][B]"No recording folder has been set for this channel"[/B][/COLOR]] + "<br>";
                     }
                  }
               else
                  {
                  R->ParamByName("RECOMMENDEDCARD")->AsInteger = -1;
                  NonFatalMessage += Trans->Trans["[COLOR="Red"][B]No recommended card has been set for this channel[/B][/COLOR]"] + "<br>";
                  }

               if (R->ParamByName("DIRECTORY")->AsString.IsEmpty())
                  {
                  Q->Close();
                  Q->SQL->Clear();
                  Q->SQL->Add("select * from card");
                  Q->Open();
                  Q->First();
                  while (!Q->Eof)
                     {
                     if (!Q->FieldByName("recordingFolder")->AsString.IsEmpty())
                        {
                        R->ParamByName("DIRECTORY")->AsString = Q->FieldByName("recordingFolder")->AsString;
                        NonFatalMessage += Trans->Trans["[COLOR="Red"][B]The recording file has been set to[/B][/COLOR]"] + " " + Q->FieldByName("recordingFolder")->AsString + " " + Trans->Trans["[COLOR="Red"][B]as no recording file has been assigned to this card[/B][/COLOR]"] + "<br>";
                        break;
                        }
                     Q->Next();
                     }
                  }

The directory for recorded tv is initially null, then the card recommended for that channel is looked up and the directory is assigned.

I have added code to check that a directory has been assigned.

If it is not assigned, then the program looks through your list of cards and assigns the first non-null directory it finds.

The error was being generated because no value was assigned to the recorded tv directory... so either the channel did not have a recommended card assigned, or the assigned card does not have a folder for recorded tv assigned to it.

Please let me know how it goes, hopefully the new error messages will give a few more clues.

Kev

 

[raf]

Tried new version and latest SVN still get the same error?

To get it to work I needed to open SQL Server Management Studio Express and find the entry which refers the directory column and change it to allow nulls and it works fine then.

 

[Big_Kev]

Tried new version and latest SVN still get the same error?

To get it to work I needed to open SQL Server Management Studio Express and find the entry which refers the directory column and change it to allow nulls and it works fine then.

That would indicate that a null entry for the directory field is being saved...

Have you assigned a directory for recorded tv to any of your cards?

I am not sure where your recording will save if it has a null directory entry.

Kev