{"id":196,"date":"2010-04-27T22:38:02","date_gmt":"2010-04-27T21:38:02","guid":{"rendered":"http:\/\/bergatrollet.se\/blog\/?p=196"},"modified":"2010-06-15T08:01:00","modified_gmt":"2010-06-15T07:01:00","slug":"fixed-web-access-to-mediaportal","status":"publish","type":"post","link":"http:\/\/bergatrollet.se\/blog\/2010\/04\/fixed-web-access-to-mediaportal\/","title":{"rendered":"Fixed Web access to MediaPortal &#8230;"},"content":{"rendered":"<p>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 &#8230; NOT! \ud83d\ude09  This suddenly started generating errors on me! <\/p>\n<p>This is the error received:<\/p>\n<blockquote><p>Error: [AnyDAC][Phys][MySQL][LIBMYSQL] Field &#8216;series&#8217; doesn&#8217;t have a default value<\/p><\/blockquote>\n<p>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&#8217;s a good thing so that it also works, or I just lost the symptom. Anyway, here&#8217;s what to do;<\/p>\n<p>Fire up MySQL Administrator (I have it on the machine but it might be a separate download &#8211; i don&#8217;t remember). Log on and if you forgot, the default password for the user &#8220;root&#8221; is &#8220;MediaPortal&#8221;.<\/p>\n<p>Select &#8220;Catalog&#8221;, followed by &#8220;mptvdb&#8221;. Select table &#8220;schedule&#8221; and then in there you see the field &#8220;series&#8221;. There are possibly several ways to solve this. The MP forum suggests you set the default value to &#8220;1&#8221;. <del datetime=\"2010-06-15T06:52:01+00:00\">This might do it, but it&#8217;s in my opinion possibly fixing it by introducing a source of error.What I did was unticking the &#8220;Not Null&#8221; 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&#8230;<\/del><\/p>\n<p>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&#8217;t been claimed utterly stupid are these;<\/p>\n<p><a href=\"http:\/\/forum.team-mediaportal.com\/516773-post1120.html\">http:\/\/forum.team-mediaportal.com\/516773-post1120.html<\/a><br \/>\n<a href=\"http:\/\/code.google.com\/p\/mp-web-interface\/issues\/detail?id=34\">http:\/\/code.google.com\/p\/mp-web-interface\/issues\/detail?id=34<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8230; &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"http:\/\/bergatrollet.se\/blog\/2010\/04\/fixed-web-access-to-mediaportal\/\"> <span class=\"screen-reader-text\">Fixed Web access to MediaPortal &#8230;<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[92,37],"tags":[],"class_list":["post-196","post","type-post","status-publish","format-standard","hentry","category-htpc","category-mediaportal"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pkM6p-3a","jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":5,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"predecessor-version":[{"id":202,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/posts\/196\/revisions\/202"}],"wp:attachment":[{"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bergatrollet.se\/blog\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}