Self Contained Web Server / Interface (2 Viewers)

[mikh]

Error: [AnyDAC][Phys][MySQL][LIBMYSQL] Field 'series' doesn't have a default value

So is there fix to above?
I had same problem.
I Have 1.1.0 beta + MySQL. MPWebinterface 0_6_0_14.

?

Hi,

I solved this problem by actualy giving the series-field a default value of "1" if I remember correctly in the database design. Only issue I have at this moment is that I get no notifications if there is an recording conflict.

Regards.

THANKS, now it works

I found 'series' field from 'schedule' table in mptvdb using mysql administration.

 

[Alfrescoid]

So is there fix to above?
I had same problem.
I Have 1.1.0 beta + MySQL. MPWebinterface 0_6_0_14.

?

Hi,

I solved this problem by actualy giving the series-field a default value of "1" if I remember correctly in the database design. Only issue I have at this moment is that I get no notifications if there is an recording conflict.

Regards.

THANKS, now it works

I found 'series' field from 'program' table in mptvdb using mysql administration.

YAY! I fixed it too...however, I found the "series" field in the mptvdb database in the "schedule" table, rather than "program"...

It appears a value of 0 or 1 works...I left mine at 0.

mikh, can you confirm you modified the table you reported? It seems odd we'd have two differing locations for the key.

On another note, it seems Big Kev is active again in the forums (sadly, not this thread yet)!

Let's hope he comes back to this excellent project and makes it even better!

Also, for those of you using iPiMP - this fixes a problem I've had with iPiMP since I moved to MySQL and Win 7 - couldn't add a scheduled recording with iPiMP either...now both work!

BTW, how many of you out there use MPWeb and iPiMP togehter?

 

[mikh]

mikh, can you confirm you modified the table you reported? It seems odd we'd have two differing locations for the key.

Sorry! I wrote wrong, 'schedule' table is right.

 

[RickDeckard]

Hi

I am having some troubles with the webinterface manager connecting to MS SQL Server 2008 @ Win7

I get the following error:

Error Connecting to TV Server Database
Failed with the following message
[AnyDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied

Maybe it just ain't suited for sql server 2008?

I had the same problem. In order to get it to work with SQL Server 2008 (full version, not Express) you need to select the MSSQL2000 driver and then add a '\' character (minus the quotes) at the end of the server name in the database configuration section of the config tool.

 

[petillan]

Big F* THX !!!

 

[Krad]

Hello having problems with the setup of the vlc streaming part.

I have tried to follow the guide but it say to
2. Once you have installed VLC, then you will need to copy the following files from your VLC
installation directory to your windows directory…
avcodec-51.dll
libfontconfig-1.dll
libfreetype-6.dll
libgcrypt-11.dll
libgpg-error-0.dll
libiconv-2.dll
libxml2-2.dll
libz-1-2.dll
This is a workaround for some issues with VLC 0.9.4.0 and will enable video to display
correctly in the web page that is launched by the web interface.

I'm using vlc 1.0.3 so can't find these files.

When I switch on the streaming and try to navigat to the web page I get can't display page.

When I switch it off i can see the tv guide?

not sure how to config this part. and the manual is a bit dataed.

 

[PHDNovice]

Well, although all is working fine for me, there is just 1 thing that's not working. When adding a new schedule, there doesn't seem to be any check for conflicts.
I remember that it worked fine in the past with an older MP version and SQL-Server, but now with the latest SVN and MySQL on Win7 x64 it doesn't check anymore.

Is it just me, or are there others with this problem?

OH BIG_KEV where are you ?

 

[pwhooftman]

Hi

I am having some troubles with the webinterface manager connecting to MS SQL Server 2008 @ Win7

I get the following error:

Error Connecting to TV Server Database
Failed with the following message
[AnyDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied

Maybe it just ain't suited for sql server 2008?

Hi,

I solved this problem by actualy giving the series-field a default value of "1" if I remember correctly in the database design. Only issue I have at this moment is that I get no notifications if there is an recording conflict.

Regards.

I couldn't set a default value for the field Series because the datatype was 'bit' , i changed that to 'tinyint' (which is the predecessor of 'bit') and then was able to set a default value '0'

 

[netexplorer]

AW: Self Contained Web Server / Interface

Hi all,
what i miss, is the possibility to define a pre/post recording time for saved queries in Query Manager section. Especially for live shows where the end of the show is sometimes a lot later than defined in EPG. But the Query Manager have no option to define individual limits.

 

[ArnoldGoat]

re #1126: I think you just need to make sure the folder containing VLC.EXE is in your path. No need to copy any files. (Control panel->System->Advanced->Environment variables->system->path->edit)