Self Contained Web Server / Interface (3 Viewers)

risu

MP Donator
  • Premium Supporter
  • September 22, 2006
    279
    19
    Home Country
    Finland Finland
    You can turn conflict management off from WebIntManager if it helps.
     

    penfold

    Portal Member
    February 3, 2008
    8
    0
    Home Country
    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

    Portal Pro
    January 23, 2005
    90
    3
    Sydney, AUSTRALIA
    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

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    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

    Portal Pro
    April 14, 2007
    95
    1
    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

    Portal Pro
    January 23, 2005
    90
    3
    Sydney, AUSTRALIA
    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

    Retired Team Member
  • Premium Supporter
  • August 3, 2007
    800
    111
    Sydney
    Home Country
    Australia Australia
    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

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    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

    Code:
                   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

    Portal Pro
    January 23, 2005
    90
    3
    Sydney, AUSTRALIA
    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

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    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
     

    Users who are viewing this thread

    Top Bottom