Deleting Radio Channels hangs TVServer Setup

[grubi]

When trying to delete a radio channel via TVServer setup the app hangs and the channel is not being deleted. Same for "clear" button.

grubi.

[gemx]

Could you please provide some logs (tv.log, error.log)?
Also the svn rev. could be of interest.

[grubi]

Originally Posted by gemx

Could you please provide some logs (tv.log, error.log)?
Also the svn rev. could be of interest.

It's rev. 15939.
Checked this multiple times by recreating the whole db.
Seems that radio channels can be deleted directly after installation and channel scan, but then after reboot when the "all channels" group was being created deletion fails and the display is not refreshed. If you then kill the setuptv and restart it you can see that the channel was removed from the channel mapping but is still present. From which log do you think any additional information can be gathered?

Regards,
grubi.

[SciDoctor]

This is the error log I get with the same problem SVN 15947

18/09/2007 21:24:32 1 Exception :Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Channel where idChannel = @idChannel; ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_RadioGroupMap_Channel". The conflict occurred in database "TvLibrary", table "dbo.RadioGroupMap", column 'idChannel'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
--- End of inner exception stack trace ---
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(Object obj, StatementType st, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Remove(Object obj, IDbTransaction dbTransaction)
at Gentle.Framework.Persistent.Remove()
at TvDatabase.Channel.Delete()
at SetupTv.Sections.RadioChannels.mpButtonDel_Click(O bject sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_RadioGroupMap_Channel". The conflict occurred in database "TvLibrary", table "dbo.RadioGroupMap", column 'idChannel'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
18/09/2007 21:24:32 1 Exception :delete from Channel where idChannel = @idChannel;
18/09/2007 21:24:32 1 site :Gentle.Framework.SqlResult Execute(System.Data.IDbConnection, System.Data.IDbTransaction)
18/09/2007 21:24:32 1 source :Gentle.Framework
18/09/2007 21:24:32 1 stacktrace: at Gentle.Framework.SqlStatement.Execute(IDbConnectio n conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(Object obj, StatementType st, IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Remove(Object obj, IDbTransaction dbTransaction)
at Gentle.Framework.Persistent.Remove()
at TvDatabase.Channel.Delete()
at SetupTv.Sections.RadioChannels.mpButtonDel_Click(O bject sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[grubi]

Log is showing clearly what's going on.
Channel has to be removed from radio group map before deletion due to foreign key constraint.

grubi.

[gemx]

Fixed in rev. 15964

[grubi]

Originally Posted by gemx

Fixed in rev. 15964