Baffling Exception Error

[Jhonny]

Have you run the c:\RadioDJv2\Setup\Sql\update 2.0.3.7 to 2.0.3.8.sql file on update?

It make the Column bs1770  it's missing.

[Dr_Anthony]

Yeah, updated DB to 2.0.3.8 by update 2.0.3.7 to 2.0.3.8.sql

[Jhonny]

 

[Dr_Anthony]

 

So what I have to do to fix the problem with Column bs1770 that does not belong in the Table?

[RadioPatrick]

It looks to me like you have 3 options right now:

• Try the database repair tool and see what that does
• Look up some quick SQL for deleting columns from a table, and delete the column yourself. That might make things worse though, and tampering with the tables yourself is not encouraged if you don't know what you're doing.
• Make a new database and re-import everything. If you only imported tracks and didn't set up a bunch of cues or other custom data, this may be your best option if the database repair tool doesn't work.

 -- Patrick

[Jhonny]

So what I have to do to fix the problem with Column bs1770 that does not belong in the Table?

Run the 2.0.3.7 to 2.0.3.8.sql

the Column bs1770  is not yet in use but if not present rdj will not run.

[RadioDJ2022]

Or Run this query in database setup

Code Select Expand

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


[Dr_Anthony]

Or Run this query in database setup

Code Select Expand

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


[RadioDJ2022]

It means you've already created that table/column so the upgrade scripts did their job

There must be something else at play here have you tried a repair on the database from within Heidi SQL


What database software are you using? Version?

[Dr_Anthony]

It means you've already created that table/column so the upgrade scripts did their job

There must be something else at play here have you tried a repair on the database from within Heidi SQL


What database software are you using? Version?

I use MySQL Server 8.0 if you mean that.

[RadioDJ2022]

I use MySQL Server 8.0 if you mean that.

Yes that's where the issues could lay, MySQL8 is crap compared to previous versions and I've used it since MySQL 3.23

Best advice try Maria Db 10.8/10.9 I'm running on Maria DB 10.8 with no serious issues

Backup your database before you Change MySQL Servers

[Dr_Anthony]

Yes that's where the issues could lay, MySQL8 is crap compared to previous versions and I've used it since MySQL 3.23

Best advice try Maria Db 10.8/10.9 I'm running on Maria DB 10.8 with no serious issues

Backup your database before you Change MySQL Servers

So had unistalled MySQL and installed MariaDB and the result is the same:

12 Oct 2023 13:43:42
The column bs1770 does not belong to the Table table. in System.Data.DataRow.GetDataColumn(String columnName)
   v System.Data.DataRow.get_Item(String columnName)
   v rdjInterface.Tracks.LoadTrackInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   v rdjInterface.TrackPlayer.LoadInfo(Int32 trackID, Boolean OnlyEnabled, Boolean RefreshInfo)
   v Plugin_Search.SearchControl.DtSearchMouseDown(Object sender, MouseEventArgs e)
   v System.Windows.Forms.Control.OnMouseDown(MouseEventArgs e)
   v System.Windows.Forms.DataGridView.OnMouseDown(MouseEventArgs e)
   v System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   v System.Windows.Forms.Control.WndProc(Message& m)
   v System.Windows.Forms.DataGridView.WndProc(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   v System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[RadioDJ2022]

HATE TO SAY THIS BUT: I think you'd be better off making a brand new database something has obviously gone Pete Tong when upgrading

I had to start a fresh database a few versions back

Yes ts a PIA but theres been that many changes to the database since earlier versions.

[Dr_Anthony]

HATE TO SAY THIS BUT: I think you'd be better off making a brand new database something has obviously gone Pete Tong when upgrading

I had to start a fresh database a few versions back

Yes ts a PIA but theres been that many changes to the database since earlier versions.

This DB I backed up it's been more than 10 years. Mean use RDJ for this long time. But there is more than 4000 songs, CUEs etc. So will try to describe my situation where I am.

Had an old NTB with Windows 10 where I was using RDJ v2.0.0.6 (I guess) and MySQL Server 5.7.34 and everything works. So now have a new NTB with Windows 11 and installed the latest stable version of RDJ 2.0.4.3. Installed MySQL server 8.0 and it went well and server were runnig. So loaded the backed up database from the old NTB (20230805 131300.sql to be precise), ran RDJ and got error The column bs1770 does not belong to the Table table etc.

So where did I go wrong? 

[RadioDJ2022]

Utilities Tag Sync Synchronise your cue points to your Tags from database that stores your cue points in the file

That should help when it comes to reimporting into a new database If like me you knew your categories in the old database it made rebuilding mine a lot easier