Database Error Message.

[charmingnathan]

Dear Forum,

Recently, I started a station which had a different set of jingles to another I manage.

Imported both sets of jingles into RadioDJ, and enabled and disabled approprately, which did not have the affect of having the correct jingles for the correct station.

Then, using phpMyAdmin, I created a new database, installed the latest version of RadioDJ, and tried again.

However, whenever I try and import, or find details of tracks that are apparently installed in RadioDJ, receive a notifcation of an exception, and find this message in the error log:

5 Mar 2024 00:55:45
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.TrackPlayer.LoadInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
  at Plugin_TracksManager.FormTracksManager.DtSearch_MouseDown(Object sender, MouseEventArgs e)
  at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.DataGridView.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.DataGridView.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)

Any ideas please?

Thanks for your help.

Cheers.

[Derek]

If you restored a previous database, you need to run the appropriate update file afterwards from the database utilities.
If you had already done that, or it's a totally new install and new imports without restoring a previous database, post the version of RadioDJ and MariaDB/MySQL that you're using.

[charmingnathan]

If you restored a previous database, you need to run the appropriate update file afterwards from the database utilities.
If you had already done that, or it's a totally new install and new imports without restoring a previous database, post the version of RadioDJ and MariaDB/MySQL that you're using.

Dear Derek,

Thanks for your prompt reply.

Please consider that I haven't tried to do anything like this before, and know very little about Databases, etc.

Not sure what you mean by, "...run the appropriate update file afterwards from the database utilities"?! Have looked at "Utilities", in Radio DJ and can see nothing obvious?!

With the limited knowledge I have, I suspect the issue is to do with trying to import the Database from two different versions of RadioDJ, as have tried importing into the same version (2.0.0.6), and this was fine, however, this didn't resolve the jingles issue.

The versions were 2.0.4.5 and 2.0.0.6.

Mariadb version is 10.4

This is on a Widows 7 platform.

Thanks for trying to help.

[Derek]

The versions were 2.0.4.5 and 2.0.0.6.

Mariadb version is 10.4

This is on a Widows 7 platform.

MariaDB 10.4 should be fine for Windows 7.

If you are trying to use your database from RadioDJ v.2.0.0.6, you'll need to go to the database setup utility (Where you first install a database from).

*** First of all, make sure that you have a backup of your main (RadioDJ v2.0.0.6?) database just in case anything goes wrong during the updating process *** You can use the database setup utility for RadioDJ2006 to do this. Make a copy of that file and save it somewhere you know where to find it. (It's probably in the RadioDJ\Setup\backup folder of the v2.0.0.6 RadioDJ program)

- On the database setup utility program for your new installation of RadioDJ v.2.0.4.5, try installing a new database, but (just to try this) call it radiodj2036
- Now using the same database utility program, restore from your backup of your other (v2.0.0.6?) database where you have saved it to (this will overwrite the new radiodj2036 database you've just installed).
- Then, in the same database setup utility program, look for and click on the tab that says Database Utils and then choose Select Update File and select the 2.0.0.6 to 2.0.3.8 file and run it.

See if the error relating to bs1770 has now gone.

Existing rotations may need editing to make them work after the update on v.2.0.4.5, but if so, you can just go into each line of the rotation, click edit, then just save it and once completed on all lines, save the rotation. This might work and has been successful for many.

[charmingnathan]

MariaDB 10.4 should be fine for Windows 7.

If you are trying to use your database from RadioDJ v.2.0.0.6, you'll need to go to the database setup utility (Where you first install a database from).

*** First of all, make sure that you have a backup of your main (RadioDJ v2.0.0.6?) database just in case anything goes wrong during the updating process *** You can use the database setup utility for RadioDJ2006 to do this. Make a copy of that file and save it somewhere you know where to find it. (It's probably in the RadioDJ\Setup\backup folder of the v2.0.0.6 RadioDJ program)

- On the database setup utility program for your new installation of RadioDJ v.2.0.4.5, try installing a new database, but (just to try this) call it radiodj2036
- Now using the same database utility program, restore from your backup of your other (v2.0.0.6?) database where you have saved it to (this will overwrite the new radiodj2036 database you've just installed).
- Then, in the same database setup utility program, look for and click on the tab that says Database Utils and then choose Select Update File and select the 2.0.0.6 to 2.0.3.8 file and run it.

See if the error relating to bs1770 has now gone.

Existing rotations may need editing to make them work after the update on v.2.0.4.5, but if so, you can just go into each line of the rotation, click edit, then just save it and once completed on all lines, save the rotation. This might work and has been successful for many.

Thank you for your advice, Derek.

Unforunately, this made no difference.

Even re-installed the older version of RadioDJ, and restoring its own Database, which I used on the later version as well.

Works fine for the older version, but exactly the same issue wtih the newer version, the tracks appear, but unable to load on the main screen for playing, and unable to access properties.

Also, receive the same error message in the Exception Log file.

To be fair, I suppose all I did was to repeat what I had already tried using PhpMyadmin.with Radio DJ, although there two files in the Directory for Update File, both from 2022.

Any other ideas?

Cheers.

[Derek]

Unforunately, this made no difference.

all I did was to repeat what I had already tried using PhpMyadmin.with Radio DJ

If you ran the update files with the RadioDJ Database Setup Utility then hopefully someone else has some ideas as that usually works. I have no idea what PhpMyadmin does as I've heard the name but that's all.

Also, did you name the new database as I said? There's a reference to that named database in the 2006 to 2038 update file so it might (or might not!) make a difference.

[Kiwi]

Further to what Derek has said, here is something from Marius in an earlier forum piece...

https://www.radiodj.ro/community/index.php/topic,16374.msg90037.html#msg90037

Hope this helps...

[charmingnathan]

If you ran the update files with the RadioDJ Database Setup Utility then hopefully someone else has some ideas as that usually works. I have no idea what PhpMyadmin does as I've heard the name but that's all.

The phpMyAdmin facility just makes it easier to import, create, and delete Databases, but used Radio DJ, as you suggested.


Also, did you name the new database as I said? There's a reference to that named database in the 2006 to 2038 update file so it might (or might not!) make a difference.

Have tried several attempts, and the first couple of times, I did try slight variations, but have just followed your instructions word for word, and again, no difference.

There are some rather curious issues with this.

With the older RadioDJ Database installed, am not able to play any tracks, or add any, via either adding single tracks, or dragging to the front screen.

If I click on the Exception notification, I am taken to one of the other RadioDJ's running.

I have another duplicate server, not literally, but mostly all the same Software installed, and I exported the Database from the earlier version of RadioDJ, onto an External Hard Drive, and attempted to install this on the 'other' server, which has the latest version installed.

There was an error message about the Database size being too big (was unable to copy, or read easily), and there was no tracks showing at all.

There follows the error message from the Exception Log:

6 Mar 2024 15:40:31
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.TrackPlayer.LoadInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
  at Plugin_TracksManager.FormTracksManager.DtSearch_MouseDown(Object sender, MouseEventArgs e)
  at System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.DataGridView.OnMouseDown(MouseEventArgs e)
  at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.DataGridView.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)

As far as I can see, the issue points to some incompatibility between the Database from the older version, to the newer version of RadioDJ?!

Kiwi, will check the link out, as well.

***EDIT: Is there a specific point when the update Dataabse should be used in the process, and this is in the older Database, not the older, is that correct?!***

Thanks again for your help.

[Derek]

***EDIT: Is there a specific point when the update Dataabse should be used in the process, and this is in the older Database, not the older, is that correct?!***

You have to run the update file on the new installation after restoring your previous database to it, using the database setup utility for both the restore and the update process:

1. Install a brand new database on the new installation (name it radiodj2036)
2. Restore the database you want to use on your new installation. (this should overwrite your new empty radiodj2036 database with your existing information)
3. Run the update file 2006 to 2038

If you restore afterwards, it will undo the update!

If you've done all that and the link Kiwi provided still doesn't solve it, I would have suggested trying a newer version of MariaDB but I think 10.4.12 is the latest version that is compatible with Windows 7. If your version of 10.4 is newer, then that also might be the problem.

[charmingnathan]

Thanks for your clarification, Derek, and Kiwi.

Have now carried out the same procedure on the 'second' Server, and the results are the same!

From the Exception Log File:

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)

This is the error message received from the Database Utility box, which I have had to type out, as Copying is not an option:

"Completed with errors: MySQL Connection MySQL Exception 0x80004005 Got a packet bigger than max_allowed packet bytes at System Runtime Compiler Services".

Also receive a Programme Compatibilty Assistant Dialog Bux during this process, which again points to a compatibility issue between either the two versions of Radio DJ, or the Databases.

Thanks again for trying to help.

Cheers.

[stevewa]

https://www.radiodj.ro/tutorials/video-tutorials/how-to-repair-a-mysqlmariadb-corrupted-database-using-heidisql.html

[charmingnathan]

https://www.radiodj.ro/tutorials/video-tutorials/how-to-repair-a-mysqlmariadb-corrupted-database-using-heidisql.html

While I thank you for your post, and will follow the instructions from the link, since the last post, I have attempted to install the same Database into one of the installations of RadioDJ on the 'second' server, this met with the same error message, and no tunes showing in the Track Manager.

The only slight variation in this setup, is the version of RadioDJ, which was version 2.0.3.9.

Cheers.

***EDIT 1602 hours*** Have conducted more tests, and am convinced this is a compatibility issue with the latest RadioDJ. Tried Heidi, but whether Loading or Running SQL File from a Database, 0 bytes are recorded, and have tried this with three SQL files, so a repair isn't possible.

An error message, from Heidi, reads: "MY SQL ERROR (2006): MYSQL Server has gone away".

However, have installed the latest RadioDJ again, and received the same result, did the same with the older version, and the back-up worked fine, songs, rotations, etc., so this looks like being an issue with the latest version of RadioDJ.

Any further ideas, please?!

Cheers.

[charmingnathan]

Hello,

As a further update to this issue, is it is possible I have found a bug in RadioDJ?!

This afternoon, I have downloaded the most recent versions of RadioDJ, up until 2.0.0.8, and can advise that the same issue occurs in all cases, the first where the Database installs correctly, without a lot of Exceptions in the log. is 2.0.0.8.

Not sure what other troubleshooting can be carried out?!

Thanks for trying to help.

[charmingnathan]

Dear Forum,

As there have been no further messages, have tried to experiment with both Servers, and believe the issue to be more serious that originally thought. Could this be escalated to @djgarybaldy or @marius, please?!

Would appear that I am unable to import any Database from 2.0.0.6 to any more recent version of RadioDJ.

However, as part of the process involved using the update file, before trying to import the Database, this doesn't work on either server, both running 2.0.4.5.

Unfortunately, I receive two different error messages from both servers both in the Database installation screen, so have had to re-type them:

Second Server: "Completed with errors: MySQL Exception 0x80004005: Can't write to file radiodj2036db.opt (Encode 2 ) at System Runtime Consolve". Error message then goes off-screen.

'Live Server': "Completed with errors: MySQL Exception 0x80004005:"You have an error in your SQL Syntax, check the manual that corresponds to your MySQL server version for the right syntax to use near, "IF NO EXISTS ETA DATETIME NULL DEFAULT 2002-01-01 0001 AFTER songID", then this error message goes off-screen.

From the Exception Log (Second Server):

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)

Any help with this would be greatly appreciated.

Thank you.

Cheers.

[ghm72]

Waste of time escalating it to me i don't do any of the programming of RDJ I'm only a moderator

Your database is crashed by the looks of things.

It pains me to say this but it would probably be easier to start a fresh database