Reply to thread

Message

<blockquote data-quote="dvdfreak" data-source="post: 223131" data-attributes="member: 21313">Aha, this is the error I was looking for.&nbsp; Look at this part:&quot;... where Title = @Title and () and ...&quot;The two brackets are wrong.&nbsp; And the reason is that the schedule is referencing TvChannels that are no longer there.&nbsp; That perfectly explains it actually, since you deleted them.Try editing your schedules one-by-one and make sure the TV channels are correctly set (you'll probably notice the list will be empty instead of showing the channels).&nbsp; Then save the schedules again and all will be well again.I have to think about how I could fix this for a next release.&nbsp; Either I remove the brackets and make the query work again, but then all channels will be included.&nbsp; Or I throw an error about the schedule containing unknown TV channels.&nbsp; What would be the best thing to do...?No, that won't work for the same reason as above.But I don't think the database has been upgraded since release 1.0.8.0, so you won't have a problem upgrading.&nbsp; If you really want to make sure you can still make a backup of the entire database before you upgrade, so you can always roll back to that.</blockquote>

[QUOTE="dvdfreak, post: 223131, member: 21313"] Aha, this is the error I was looking for. Look at this part: "... where Title = @Title and () and ..." The two brackets are wrong. And the reason is that the schedule is referencing TvChannels that are no longer there. That perfectly explains it actually, since you deleted them. Try editing your schedules one-by-one and make sure the TV channels are correctly set (you'll probably notice the list will be empty instead of showing the channels). Then save the schedules again and all will be well again. I have to think about how I could fix this for a next release. Either I remove the brackets and make the query work again, but then [U]all[/U] channels will be included. Or I throw an error about the schedule containing unknown TV channels. What would be the best thing to do...? No, that won't work for the same reason as above. But I don't think the database has been upgraded since release 1.0.8.0, so you won't have a problem upgrading. If you [U]really[/U] want to make sure you can still make a backup of the entire database before you upgrade, so you can always roll back to that. [/QUOTE]

Verification