Reply to thread

Message

I have fiddled with this when running into the problem. Your solution works, but I suggest another approach (similar to yours and inspired by it but more bullet proof ;-)

My suggestion is to untick the "not null" checkmark. That means having MySQL accepting a null value rather than introducing a dummy value that could potentially cause problems if there is code that assumes this to be NULL.

Proper description here: Fixed Web access to MediaPortal … : bergatrollet.se

PLEASE MIND that my suggestion was stupid! It does NOT work! If you follow my recommendation, it long longer records - at least not series and you can no longer select Schedule in the setup program ... My apologies to anyone following this piece of advice...

<blockquote data-quote="PontusBerg" data-source="post: 611779" data-attributes="member: 98338"><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />I have fiddled with this when running into the problem. Your solution works, but I suggest another approach (similar to yours and inspired by it but more bullet proof ;-)My suggestion is to untick the &quot;not null&quot; checkmark. That means having MySQL accepting a null value rather than introducing a dummy value that could potentially cause problems if there is code that assumes this to be NULL. Proper description here: <a href="http://bergatrollet.se/blog/2010/04/fixed-web-access-to-mediaportal/" target="_blank">Fixed Web access to MediaPortal … : bergatrollet.se</a>PLEASE MIND that my suggestion was stupid! It does NOT work! If you follow my recommendation, it long longer records - at least not series and you can no longer select Schedule in the setup program ... My apologies to anyone following this piece of advice...</blockquote>

[QUOTE="PontusBerg, post: 611779, member: 98338"] :thx: I have fiddled with this when running into the problem. Your solution works, but I suggest another approach (similar to yours and inspired by it but more bullet proof ;-) My suggestion is to untick the "not null" checkmark. That means having MySQL accepting a null value rather than introducing a dummy value that could potentially cause problems if there is code that assumes this to be NULL. Proper description here: [url=http://bergatrollet.se/blog/2010/04/fixed-web-access-to-mediaportal/]Fixed Web access to MediaPortal … : bergatrollet.se[/url] PLEASE MIND that my suggestion was stupid! It does NOT work! If you follow my recommendation, it long longer records - at least not series and you can no longer select Schedule in the setup program ... My apologies to anyone following this piece of advice... [/QUOTE]