Author Topic: Cannot find table 0  (Read 2927 times)

Valis

  • Guest
Cannot find table 0
« on: August 13, 2014, 12:55:53 PM »
Installing MySQL appears to go well, except I get this message when I start up RadioDJ



Text message goes on:

Code: [Select]
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 ;)

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4929
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Cannot find table 0
« Reply #1 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 to work with the newer versions.
Worlds Biggest Fan of RadioDJ

RadioDJ is my FAVOURITE piece of radio playout software EVER

https://djgarybaldy.blogspot.com/search?q=radiodj

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

paypal.me/djgarybaldy

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5748
    • Radio DJ
Re: Cannot find table 0
« Reply #2 on: August 13, 2014, 01:04:02 PM »
If it's a new install, did you made the RadioDJ database?
DOWNLOADS PAGE

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

Valis

  • Guest
Re: Cannot find table 0
« Reply #3 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.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 4183
  • Personal Text
    Peace, enjoy life, last sleep is longer than live!
Re: Cannot find table 0
« Reply #4 on: August 13, 2014, 02:08:02 PM »
R.T.F.M. means to me, Read The Fantastic Messages.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5748
    • Radio DJ
Re: Cannot find table 0
« Reply #5 on: August 13, 2014, 02:32:23 PM »
You must also press Install Database button and then it should work.
DOWNLOADS PAGE

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

Valis

  • Guest
Re: Cannot find table 0
« Reply #6 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.