Author Topic: RadioDJ v2.0.1.2 BETA Released!  (Read 892 times)

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
RadioDJ v2.0.1.2 BETA Released!
« on: November 06, 2018, 10:00:34 AM »
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.  :hihi:

Thanks!
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3580
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #1 on: November 06, 2018, 10:05:44 AM »
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?
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

I cannot support older versions - Currently Beta Testing 2.0.1.3

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #2 on: November 06, 2018, 10:09:01 AM »
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.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #3 on: November 06, 2018, 10:09:45 AM »
 :D 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
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #4 on: November 06, 2018, 10:14:38 AM »
Thanks Jhonny. Fixed for the next release.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3580
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • DJ Garybaldy
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #5 on: November 06, 2018, 10:18:40 AM »
Quote
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...
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

I cannot support older versions - Currently Beta Testing 2.0.1.3

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #6 on: November 06, 2018, 10:28:03 AM »
Code: [Select]
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';
)
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #7 on: November 06, 2018, 10:31:07 AM »
You are killing me Jhonny  :D

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.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #8 on: November 06, 2018, 10:47:39 AM »
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Vanlen

  • Hero Member

  • Online
  • *****
  • 1057
    • Voice Talent and production for radio
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #9 on: November 06, 2018, 10:49:59 AM »
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
Forest Green - Radio for the New Age.
www.forestgreenradio.ca

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #10 on: November 06, 2018, 11:02:39 AM »
queuelist still empty.
Will do a total new install maybe that works.

R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #11 on: November 06, 2018, 11:05:15 AM »
@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.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #12 on: November 06, 2018, 11:18:01 AM »
Yes empty,  on new install with SetupRadioDJ2012fbeta2.exe empty to
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #13 on: November 06, 2018, 11:22:06 AM »
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';
)
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.2 BETA Released!
« Reply #14 on: November 06, 2018, 11:23:55 AM »
I don't know how to change the separator, to a point in mariadb
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info