Fixed Web access to MediaPortal …

MediaPortal 1.1 RC2 is a major lift compared to the 1.02 I used to run, but there are issues; The web interface that I use to access the installation and schedule recordings is called WebInterface 0.6.0.14 beta (kewl name … NOT! 😉 This suddenly started generating errors on me!

This is the error received:

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

Googling lead me to the MP forum, where quite a few had the same issue. I must say that what I say below does solve the problem (no error message) but I am yet to see if i’s a good thing so that it also works, or I just lost the symptom. Anyway, here’s what to do;

Fire up MySQL Administrator (I have it on the machine but it might be a separate download – i don’t remember). Log on and if you forgot, the default password for the user “root” is “MediaPortal”.

Select “Catalog”, followed by “mptvdb”. Select table “schedule” and then in there you see the field “series”. There are possibly several ways to solve this. The MP forum suggests you set the default value to “1”. This might do it, but it’s in my opinion possibly fixing it by introducing a source of error.What I did was unticking the “Not Null” check-mark. I tried both options and both seem to work, but I would suggest you take my advice on this. My suggestion is having the program accept no value, rather than fooling the checks by introducing a dummy value that could potentially cause error later in the process…

PLEASE mind: Do not follow the suggestion above. It proves that recording stopped working and accessing the guide turned strangely slow. The suggestions found that haven’t been claimed utterly stupid are these;

http://forum.team-mediaportal.com/516773-post1120.html
http://code.google.com/p/mp-web-interface/issues/detail?id=34