RadioDJ v2.0.1.2 BETA Released!

[Marius]

NEW BETA OUT FOR TESTING!

With Vanlen's help i fixed a bug which called the database procedure more than one time and by fixing this, the program operation should be even more smooth when switching tracks.

Please test with a new database again. 

Thanks!

[DJ Garybaldy]

When you say new database do you mean a complete fresh one or is it OK to use a database back up from before 2.0.1.0?

[Marius]

A complete fresh database. I know it's time consuming to create one and import some tracks, but the database schema was changed between these beta versions and only in this way we can test it properly.
Once all will work fine, it should be easy to make a update script for the existing databases.

Thanks for all the effort in helping me.

[Jhonny]

  will do with new database.
about tts error.Template file doesn't exists! Make sure that you have the Plugins\Plugin_TTS\NowPlaying.xml file if you want to use the TTS functionality!
content disabled plugins:
c:\RadioDJv211\Disabled Plugins\Plugin TTS\TTS-Templates\ wrong folder name must be Plugin_TTS\
c:\RadioDJv211\Disabled Plugins\Plugin TTS\Plugin_TTS.dll
c:\RadioDJv211\Disabled Plugins\Plugin TTS\Plugin_TTS.xml
c:\RadioDJv211\Disabled Plugins\Plugin TTS\README.txt

[Marius]

Thanks Jhonny. Fixed for the next release.

[DJ Garybaldy]

A complete fresh database. I know it's time consuming to create one and import some tracks, but the database schema was changed between these beta versions and only in this way we can test it properly.
Once all will work fine, it should be easy to make a update script for the existing databases.

I don't think I have the time to try with a fresh database, I'll let everyone else beta test instead in that case, I'm going to go back to my database on v2.0.0.6 until we can just update our current database to newer versions when all the bugs are ironed out etc...

[Jhonny]

Code Select Expand

Database Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '205782312925 SECOND, duration = 151,968072562359, `artist` = 'Connie Francis',`t' at line 1 (TRUNCATE `queuelist`;
INSERT INTO `queuelist` SET `songID` = '16',ETA = NOW() + INTERVAL 138,205782312925 SECOND, duration = 151,968072562359, `artist` = 'Connie Francis',`title` = 'Valentino',`album` = 'A 60s Single';
INSERT INTO `queuelist` SET `songID` = '8',ETA = NOW() + INTERVAL 290,173854875284 SECOND, duration = 147,419637188209, `artist` = 'Brenda Lee',`title` = 'I''m Sorry',`album` = 'A 60s Single';
INSERT INTO `queuelist` SET `songID` = '44',ETA = NOW() + INTERVAL 437,593492063493 SECOND, duration = 140,270476190476, `artist` = 'Roy Orbison',`title` = 'Only The Lonely',`album` = 'A 60s Single';
INSERT INTO `queuelist` SET `songID` = '5',ETA = NOW() + INTERVAL 577,863968253969 SECOND, duration = 159,742380952381, `artist` = 'Bo Diddley',`title` = 'Road Runner',`album` = 'A 60s Single';
INSERT INTO `queuelist` SET `songID` = '50',ETA = NOW() + INTERVAL 737,606349206349 SECOND, duration = 204,486462585034, `artist` = 'Tielman Brothers',`title` = '18Th Century Rock',`album` = 'A 60s Single';
INSERT INTO `queuelist` SET `songID` = '40',ETA = NOW() + INTERVAL 942,092811791384 SECOND, duration = 133,91410430839, `artist` = 'Neil Sedaka',`title` = 'Oh Carol',`album` = 'A 60s Single';
)

[Marius]

You are killing me Jhonny 

I see that your locales are using the comma (","), as the decimal separator, that's where the error comes out. Trying a trick and get back.

Please download again the latest beta, run the installer over your old (2.0.1.2) beta and test it now. The only changed file is RadioDJ.exe, no database changes this time.

[Jhonny]

[Vanlen]

Once Again Fresh Install Win10/MariaDB

[Nice Fix]  Confirmed Play Count +1 and marked as played.
[Fix]  Search showed Artist Title etc as before

No errors as yet in the error log

Will build songs and jingles and add rotations and let it run for a few Hours.
(like the cartoon @Jhonny)
Cheers

[Jhonny]

queuelist still empty.
Will do a total new install maybe that works.

[Marius]

@Jhonny: No errors logged with the latest beta, only the fact that queuelist is empty?
Did you re-downloaded the latest version, right? It was renamed to "SetupRadioDJ2012fbeta2.exe" to avoid confussions.

[Jhonny]

Yes empty,  on new install with SetupRadioDJ2012fbeta2.exe empty to

[Jhonny]

Last error from log

Database Insert Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '539727891156 SECOND, duration = 175.924829931973, `artist` = 'The Drifters',`tit' at line 1 (TRUNCATE `queuelist`;
INSERT INTO `queuelist` SET `songID` = '144',ETA = NOW() + INTERVAL 174,539727891156 SECOND, duration = 175.924829931973, `artist` = 'The Drifters',`title` = 'Money Honey',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '146',ETA = NOW() + INTERVAL 350,464557823129 SECOND, duration = 135.6710430839, `artist` = 'The Everly Brothers',`title` = 'All I Have To Do Is Dream',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '95',ETA = NOW() + INTERVAL 486,135600907029 SECOND, duration = 121.898231292517, `artist` = 'Les Paul & Mary Ford',`title` = 'Tiger Rag',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '25',ETA = NOW() + INTERVAL 608,033832199546 SECOND, duration = 159.89081632653, `artist` = 'Dean Martin',`title` = 'If',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '150',ETA = NOW() + INTERVAL 767,924648526076 SECOND, duration = 131.611768707483, `artist` = 'The Everly Brothers',`title` = 'This Little Girl Of Mine',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '63',ETA = NOW() + INTERVAL 899,53641723356 SECOND, duration = 169.521133786848, `artist` = 'Hank Williams',`title` = 'Jambalaya \(On The Bayou\)',`album` = 'A 50s single';
INSERT INTO `queuelist` SET `songID` = '124',ETA = NOW() + INTERVAL 1069,05755102041 SECOND, duration = 116.346099773243, `artist` = 'Rosemary Clooney',`title` = 'Come On-A My House',`album` = 'A 50s single';
)

[Jhonny]

I don't know how to change the separator, to a point in mariadb