RadioDJ - Free Radio Automation Software Forum

RadioDJ v1.7+ => v1.7+ - Support Forum => Topic started by: Valis on August 13, 2014, 12:55:53 PM

Title: Cannot find table 0
Post by: Valis on August 13, 2014, 12:55:53 PM
Installing MySQL appears to go well, except I get this message when I start up RadioDJ

(http://alanehill.net/graphbin/error.jpg)

Text message goes on:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IndexOutOfRangeException: Cannot find table 0.
   at System.Data.DataTableCollection.get_Item(Int32 index)
   at Plugin_Search.SearchControl.SearchResults(String Keyword, Int32 NewStart)
   at Plugin_Search.SearchControl.CbGenreSelectedIndexChanged(Object sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
   at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
   at rdjInterface.Categories.PopulateGenreList(ComboBox& genreCombo, Boolean WithAny)
   at Plugin_Search.SearchControl.PopulateGenres()
   at Plugin_Search.SearchControl.SetupColumns()
   at Plugin_Search.SearchControl.SearchControlLoad(Object sender, EventArgs e)
   at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
   at System.Windows.Forms.UserControl.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Control.Show()
   at RadioDJ.MainForm.ReloadZones()
   at RadioDJ.MainForm.PopulatePluginList()
   at RadioDJ.MainForm.MainFormLoad(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.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.5477 (Win7SP1GDR.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RadioDJ
    Assembly Version: 1.7.2.0
    Win32 Version: 1.7.2.0
    CodeBase: file:///C:/RadioDJ/RadioDJ.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
    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.5467 (Win7SP1GDR.050727-5400)
    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.5468 (Win7SP1GDR.050727-5400)
    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.5467 (Win7SP1GDR.050727-5400)
    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.5483 (Win7SP1GDR.050727-5400)
    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.2.0.3
    CodeBase: file:///C:/RadioDJ/PluginInterface.DLL
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    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.5476 (Win7SP1GDR.050727-5400)
    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.5476 (Win7SP1GDR.050727-5400)
    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.5483 (Win7SP1GDR.050727-5400)
    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.5420 (Win7SP1.050727-5400)
    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.2
    Win32 Version: 2.5.0.2
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_AuxPlayers.dll
----------------------------------------
Plugin_Carts
    Assembly Version: 2.7.1.0
    Win32 Version: 2.7.1.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Carts.dll
----------------------------------------
Plugin_History
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.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.4.0
    Win32 Version: 3.5.4.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_Playlist.dll
----------------------------------------
Plugin_PlaylistBuilder
    Assembly Version: 3.2.0.0
    Win32 Version: 3.2.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_PlaylistBuilder.dll
----------------------------------------
Plugin_Search
    Assembly Version: 3.1.0.0
    Win32 Version: 3.1.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_TracksManager
    Assembly Version: 3.2.0.0
    Win32 Version: 3.2.0.0
    CodeBase: file:///C:/RadioDJ/Plugins/Plugin_TracksManager.dll
----------------------------------------
Plugin_Utilities
    Assembly Version: 3.4.0.0
    Win32 Version: 3.4.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.


I've searched on this forum but can't find a situation relevant to this ... although I'm sure you'll tell me ;)
Title: Re: Cannot find table 0
Post by: DJ Garybaldy on August 13, 2014, 01:00:53 PM
I'm guessing you've tried upgrading from a 1.6.5.x version straight to the new version?

See this post on the forum about upgrading the database  http://www.radiodj.ro/community/index.php?topic=5258.0 (http://www.radiodj.ro/community/index.php?topic=5258.0) to work with the newer versions.
Title: Re: Cannot find table 0
Post by: Marius on August 13, 2014, 01:04:02 PM
If it's a new install, did you made the RadioDJ database?
Title: Re: Cannot find table 0
Post by: Valis on August 13, 2014, 01:05:27 PM
No. It's a new installation. I've never used RadioDJ before.

I installed the db as per the video. All seemed to check out okay at that point.
Title: Re: Cannot find table 0
Post by: Jhonny on August 13, 2014, 02:08:02 PM
Hat the same error.

Look here http://www.radiodj.ro/community/index.php?topic=5580.msg32769#msg32769 (http://www.radiodj.ro/community/index.php?topic=5580.msg32769#msg32769)

grtz.
Title: Re: Cannot find table 0
Post by: Marius on August 13, 2014, 02:32:23 PM
You must also press Install Database button and then it should work.
Title: Re: Cannot find table 0
Post by: Valis on August 13, 2014, 03:43:09 PM
Okay. Did a re-install. Worked this time.

I'm not certain what I missed out the first couple of times, but it's clear; if you install following the direction exactly, it'll work.

Thanks to all those who responded.