Exception in 2.0.3.8 During Playlist Import

[BrunoJ]

The following exception occurred:

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 rdjInterface.Playlist.LoadM3UPlaylist(String playlistPath, Boolean OnlyEnabled)
   at !8QgZ1\]Thk:6aRq-"Rtyk}G=$.​‭‌‏‏‌‏‏‍‌‎‫​‭‬‭‏​‬‌​‮.‎‏‍‫‪‫‮‮‏‮‫‭‫‮‌‭‮‏‫​‫‏‪‍‮()
   at System.Threading.Tasks.Task`1.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at !8QgZ1\]Thk:6aRq-"Rtyk}G=$.i(Q\]g)Aod\*$%'-9%q=C8NWjX6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state)

[Marius]

You are trying to use an older database?
Please try to run in database setup the "update 2.0.3.7 to 2.0.3.8.sql" database update file located in Setup\Sql folder, or you are able to run in manually in HeidiSQL, this is the line to update the database:

Code (MySQL) Select Expand

ALTER TABLE `songs` ADD COLUMN `bs1770` DOUBLE(11,2) NOT NULL DEFAULT '0.00' AFTER `loudness`;

[BrunoJ]

I didn't notice anything about needing to upgrade database.  Okay, I'll try that.  Thanks

[chrismadog]

You are trying to use an older database?
Please try to run in database setup the "update 2.0.3.7 to 2.0.3.8.sql" database update file located in Setup\Sql folder, or you are able to run in manually in HeidiSQL, ...

Hi Marius,
The problem was the database specified at the top of the update file was incorrect and it was failing to update.
Subsequently, I have changed that and updated - all working as it should now.

Regards,
Chris M

[Fleblan]

Quote from Marius September 20 2002

Please try to run in database setup the "update 2.0.3.7 to 2.0.3.8.sql" database update file located in Setup\Sql folde

My problem is that my version is 2.0.0.4 and the only update file I've found is 2.0.0.6 to 2.0.3.8.

Can I use it?

Thanks in advance!

Franky

[Kiwi]

You can use it as in the attached link - first note from Marius is that upgrading from 2004 to 2006 there were no database changes.

https://www.radiodj.ro/community/index.php/topic,11919.0.html