Database Error Message.

[stevewa]

contact me in a private message with your email address.
if you have remote access into your pc I will try to help

[charmingnathan]

Thanks @djgarybaldy, and @stevewa for your messages.

Not sure if this is an issue for @marius to look into, or whether I should take up stevewa's good offer or remoting into the server?!

@djgarybaldy: Your suggestion that the Databases had crashed, would mean that two separate Databases on two different servers had crashed, at roughly the same time?!

Being a sad Computer Geek, I tried an experiment which has taken most of today.

Installed on 'second server', I have Virtual Box installed, so decided to install a fresh copy of Widows 7, on there.

I only installed the Software required for RadioDJ to work: SQLServer, .NET framework, and Radio DJ (2.0.4.5), then I attempted to restore the same back-up. When trying to update the Database for the first couple of attempts, I received the same error message, as previously.

Then this worked correctly, tried to Restore the Back-up, and this also installed correctly.

Once all the songs were successfully loaded, I then carried out a Back-Up of this, assuming that if RadioDJ had an issue restoring from a Back-Up taken from 2.0.0.6 to 2.0.4.5, this maybe resolved when restoring from the same version.

Tried this on both servers, and neither worked.

Not sure which is the next step to take, any ideas?!

Cheers.

[charmingnathan]

Hello All,

There has been no reply to the previous messages posted, so decided to provide an update instead!

Removed MariaDB 5.5 from the 'second server', and re-installed, copying the Data folder elsewhere.

Tried again, same result with RadioDJ remaning empty, this was the message in the Edception Log:

6 Mar 2024 11:25:55
Cannot find table 0.  at System.Data.DataTableCollection.get_Item(Int32 index)
  at Plugin_TracksManager.FormTracksManager.SearchResults(String Keyword, Int32 NewStart)
  at Plugin_TracksManager.FormTracksManager.set_RefreshGUI(Boolean value)
  at Plugin_TracksManager.FormTracksManager.FormTracksManagerLoad(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.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)

Used the same installation files from Widows 7 in VirtualBox environment.

This just gets better?!

Cheers.

[stevewa]

I think you keep trying to build a new car, when you just need to fix a flat tire. 

You should only need to work on one server.
Have there been any more detailed error messages in Windows Event Viewer under source=RadioDJ ?

[charmingnathan]

I think you keep trying to build a new car, when you just need to fix a flat tire. 

You should only need to work on one server.
Have there been any more detailed error messages in Windows Event Viewer under source=RadioDJ ?

Believe it or not, only working on the one server!

The 'second server', referred to, was setup as a duplicate server (not literally) to work on, in case the main server develops an issue, as it currently has.

This way, I don't have to stop the service streaming.

Went into the Event Viewer, as you suggested, and the following seems to be the only error message showing:

10
  5
  PCA2
  Not available
  0
  Database Setup.exe
  4.0.0.1
  Database Setup
  Database Setup
  BROADCAST MEDIAWARE, LLC
  1
  200   
   
  C:\Users\Nathan\AppData\Local\Temp\{5a9b2970-df52-4c63-91e0-8ce96d3193c4}\appcompat.txt
  C:\Users\Nathan\AppData\Local\Microsoft\Windows\WER\ReportArchive\NonCritical_Database Setup.e_fdd28789fbec31d3085dee5510193d043392e_2abe5832
   
  0
  b3a87246-e23e-11ee-b4a6-50e54957d029

Hope this helps?!

Cheers.

[stevewa]

I can't make any conclusions from that error msg.

is your main server / computer still able to run RadioDJ and stream, or is it broken?
I've lost track of what the latest problem is. 

if you still want a remote connection help, let me know, but i might not be able to get to it until monday

[charmingnathan]

Thanks for your message, stevewa, and apologies for any confusion caused.

There are two servers - one of which is live streaming, the other is a back-up, with appropriate Software installed, so if the first goes down, hopefully this can be replaced.

Generally, am receiving similar, if not, the same error messages from both Computers attempting this process.

The majority of the work is being carried out on the 'second server', so as not to cause issues with live streaming. Hope this is clear, so far?!

The issue is that I use version 2.0.0.6, and wish to install the Database from this version to 2.0.4.5, but while the songs appear, there are continuous exception error messages, and one is unable to go into the details of any song, or move onto the playlist area.

Have removed and re-installed Mariadb, which made no difference at all.

Whenever I attempt a repair of MySQL I receive the following message, before the installer gets going:

"Error. Internal Error There is an error in XML Docment (0,0),) The installer will now close."

Hope that clarifies the situation for you, and anyone trying to help?!

Cheers.

***EDIT*** Just to advise, the error message, despite all the troublshooting carried out, remains the same:

16 Mar 2024 16:00:50
Column 'bs1770' 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.Playlist.LoadPlaylist(Int32 playlistID, Boolean OnlyEnabled)
   at |nh)7\,_(B\&SJiAEVf129_H#Object , EventArgs )
   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.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)

Looks like being a Database issue, but could this be correct, with two independent Databases on two different Computers, affected at the same time?!

Would seem that any attempt to install the Database from version 2.0.0.6 to any more updated version runs into trouble, and doesn't work, before even trying to import the Database!

On the setup of using the Databause Utiliies, and clicking on "Select Update File", and running 2.0.0.6 to 2.0.3.8, the following error message is received:

"Completed with errors: Cannot write to file radiodj2036\db.opt Errcode 2 - No such File".

The Update File 2.0.3.7 to 2.0.3.8 does complete satisfactory, but the same error message is received in the Log File.

This is from the Event Viewer/Windows Log:

"ERROR: System.ArgumentException: Column 'bs1770' 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.Playlist.LoadPlaylist(Int32 playlistID, Boolean OnlyEnabled) at %dWiIHXt^cI%@;ZG8Z-3?kY\&‎‮(Object , EventArgs ) 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.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) 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.Playlist.LoadPlaylist(Int32 playlistID, Boolean OnlyEnabled) at %dWiIHXt^cI%@;ZG8Z-3?kY\&.‪‌‌‏‎‌‪‎‮(Object , EventArgs ) 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.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)"

Willing to post the Database file if anyone would like to take a look, but doubt that is the issue?!

Cheers.