Author Topic: Problem Opening 1.7.0  (Read 1863 times)

Farquarh

  • Full Member

  • Offline
  • ***
  • 119
Problem Opening 1.7.0
« on: July 09, 2014, 04:03:37 AM »
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

Code: [Select]
************** Exception Text **************
System.ArgumentException: Column 'precise_cue' does not belong to table Table.
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at rdjInterface.Tracks.LoadTrackInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   at rdjInterface.TrackPlayer.LoadInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   at RadioDJ.ClassPlaylist.AddToPlaylist(Int32 SongID, Int32 sweeperID, Int32 Position, Boolean trackRefresh, Int64 sweeperPlay, Boolean isRequest)
   at RadioDJ.ModuleAutoDJ.ChooseTrack()
   at RadioDJ.MainForm.TimerUI_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3655 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RadioDJ
    Assembly Version: 1.7.0.0
    Win32 Version: 1.7.0.0
    CodeBase: file:///C:/RadioDJ/RadioDJ.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3644 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3645 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3644 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
PluginInterface
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.2
    CodeBase: file:///C:/RadioDJ/PluginInterface.DLL
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
MdiTabControl
    Assembly Version: 1.1.4874.26969
    Win32 Version: 1.1.4874.26969
    CodeBase: file:///C:/RadioDJ/MdiTabControl.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3654 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3654 (GDR.050727-3600)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Devart.Data.MySql
    Assembly Version: 6.60.268.0
    Win32 Version: 6.60.268.0
    CodeBase: file:///C:/RadioDJ/Devart.Data.MySql.DLL
----------------------------------------
Devart.Data
    Assembly Version: 5.0.367.0
    Win32 Version: 5.0.367.0
    CodeBase: file:///C:/RadioDJ/Devart.Data.DLL
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
VU_MeterLibrary
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/RadioDJ/VU_MeterLibrary.DLL
----------------------------------------
JCS.Components.NeroBar
    Assembly Version: 1.3.0.0
    Win32 Version: 1.3.0.0
    CodeBase: file:///C:/RadioDJ/JCS.Components.NeroBar.DLL
----------------------------------------
Bass.Net
    Assembly Version: 2.4.10.3
    Win32 Version: 2.4.10.3
    CodeBase: file:///C:/RadioDJ/Bass.Net.DLL
----------------------------------------
Bass.Net
    Assembly Version: 2.4.9.1
    Win32 Version: 2.4.9.1
    CodeBase: file:///C:/RadioDJ/Plugins/Bass.Net.dll
----------------------------------------
Plugin_AuxPlayers
    Assembly Version: 2.5.0.1
    Win32 Version: 2.5.0.1
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_AuxPlayers.dll
----------------------------------------
Plugin_Carts
    Assembly Version: 2.6.0.0
    Win32 Version: 2.6.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Carts.dll
----------------------------------------
Plugin_History
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_History.dll
----------------------------------------
Plugin_PlayingInfo
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_PlayingInfo.dll
----------------------------------------
Plugin_Playlist
    Assembly Version: 3.5.3.0
    Win32 Version: 3.5.3.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Playlist.dll
----------------------------------------
Plugin_PlaylistBuilder
    Assembly Version: 3.1.1.0
    Win32 Version: 3.1.1.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_PlaylistBuilder.dll
----------------------------------------
Plugin_Requests
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Requests.dll
----------------------------------------
Plugin_SayTime
    Assembly Version: 3.6.0.0
    Win32 Version: 3.6.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_SayTime.dll
----------------------------------------
Plugin_Search
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Search.dll
----------------------------------------
Plugin_SongDetails
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_SongDetails.dll
----------------------------------------
Plugin_SoundProcessing
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_SoundProcessing.dll
----------------------------------------
Plugin_TCPServer
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_TCPServer.dll
----------------------------------------
Plugin_TracksManager
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_TracksManager.dll
----------------------------------------
Plugin_Utilities
    Assembly Version: 3.2.0.0
    Win32 Version: 3.2.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Utilities.dll
----------------------------------------
SPB
    Assembly Version: 1.0.3529.753
    Win32 Version: 1.0.3529.753
    CodeBase: file:///C:/RadioDJ/SPB.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


AndyDeGroo

  • Guest
Re: Problem Opening 1.7.0
« Reply #1 on: July 09, 2014, 10:18:39 AM »
Your database is missing new columns that were added in RDJ 1.6.5.8 RC7. Please use Database Setup.exe to upgrade your tables.

RadioFreeUSA

  • New User

  • Offline
  • *
  • 11
Re: Problem Opening 1.7.0
« Reply #2 on: July 13, 2014, 10:30:23 PM »
I have the same issue.  It's not what you suggested as a fix.

My Process to update:

1. Export/unload/backup database (any term you like, only one process) from 1.6.5.7
2.  Shutdown and delete existing DB from sqlworkbench on db server computer (i have 2 machines. 1 "aserv" or Audio Server and one "prod1" machine or production room/ control room machine.  The "aserv" has the db on it also.)
3. Update contents of RadioDJ folders on both machines.
4. From the 'control room machine' run Databasesetup that came with 1.7.x package.  Install a new DB with a new name
5. Confirm and connect to the new db on both the aserv and control machines. Also through mysql workbench.  The DB is working perfectly. RadioDJ.exe on both machines will launch.  It looks new, no audio, no events, brand new install.
6. From the control room machine, run databasesetup.exe and choose restore database, pick my fresh database backup file. It will load correctly.
7. Launch RadioDJ.exe on both machines.  This works, the audio is there, all events are there.
8. Failure point: Attempt to add audio to the 'log' or playlist area.  Nothing happens. Can not drag or double click any audio event and get it into the playlist or log as i call it. 
9. Attempting to work around the db problem by updating the db with the files included in databasesetup 'update db' will result in the above error.

Conclusion: there is some error in my database that is preventing it's correct operation.  My DB is available on request if needed for troubleshooting.

Thanks~

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5721
    • Radio DJ
Re: Problem Opening 1.7.0
« Reply #3 on: July 13, 2014, 10:57:50 PM »
I already wrote that when a backup is restored it will rewrite the database structure, so any modifications that are made will be lost.
Please follow the steps exactly as i wrote them and avoid improvising if you're not sure what you are doing.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

RadioFreeUSA

  • New User

  • Offline
  • *
  • 11
Re: Problem Opening 1.7.0
« Reply #4 on: July 13, 2014, 11:08:47 PM »
Oh...

The light just came on.

I get it.

Thanks~

Where's the 'bang head against wall emoticon??    ;D