Reply to thread

Message

Problem with mySQL?

Hi Guys,

I just discoverd this plugin a few weeks ago and I must say it worked great!

However, this week I installed MP V1.1Alpha and as it was a fresh install, I installed mySQL instead of SQLServer. Now if I want to record a program I get the error message:

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

Lookin with SQL Admin I see that in the table "schedule" none of the fields have a default value.

Any ideas?

<blockquote data-quote="PHDNovice" data-source="post: 480653" data-attributes="member: 53815">Problem with mySQL?Hi Guys,I just discoverd this plugin a&nbsp; few weeks ago and I must say it worked great!<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" />However, this week I installed MP V1.1Alpha and as it was a fresh install, I installed mySQL instead of SQLServer. Now if I want to record a program I get the error message:Error: [AnyDAC][Phys][MySQL][LIBMYSQL] Field 'series' doesn't have a default valueLookin with SQL Admin I see that in the table &quot;schedule&quot; none of the fields have a default value.Any ideas? <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" /></blockquote>

[QUOTE="PHDNovice, post: 480653, member: 53815"] [b]Problem with mySQL?[/b] Hi Guys, I just discoverd this plugin a few weeks ago and I must say it worked great!:thx: However, this week I installed MP V1.1Alpha and as it was a fresh install, I installed mySQL instead of SQLServer. Now if I want to record a program I get the error message: [B]Error: [AnyDAC][Phys][MySQL][LIBMYSQL] Field 'series' doesn't have a default value[/B] Lookin with SQL Admin I see that in the table "schedule" none of the fields have a default value. Any ideas? :thx: [/QUOTE]