Author Topic: the same six songs keep on playing after upgrade  (Read 2377 times)

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
the same six songs keep on playing after upgrade
« on: July 31, 2014, 11:27:05 AM »
help needed.

after an upgrade to version 1.7.2.0 the same six songs keep repeating and has been doing it thru the night

what could be wrong?
Best Regards
Lars Hansen

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 4910
  • Personal Text
    Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: the same six songs keep on playing after upgrade
« Reply #1 on: July 31, 2014, 11:42:16 AM »
help needed.

after an upgrade to version 1.7.2.0 the same six songs keep repeating and has been doing it thru the night

what could be wrong?

Without knowing much about the way your rotations are setup we can't do much.  Can you please post more details about the problem
Proud USER of RadioDJ since 2010

RadioDJ is my most FAVOURITE piece of software EVER

https://djgarybaldy.blogspot.com

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

https://www.paypal.com/paypalme/djgarybaldy

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #2 on: July 31, 2014, 11:55:05 AM »
i think i found a soloution but i cant figure out why radiodj did it...

somehow radiodj did not have a connection to the database.... after add the user and specified password now ir does the rotation and i can request and se the playlist again on my website.....

but

how could radiodj work without connection to the database??

but now radiodj works again and i am wery happy

thanks for the quick response Garybaldy
Best Regards
Lars Hansen

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #3 on: July 31, 2014, 12:26:56 PM »
well after some more testing, there is some bugs..

Robbie williams keep cumming up on my playlist, my artist rule is 360 but it isint more than 15 minuts since robbie last played the same goes for alphaville and some others

any ideas what to do?
Best Regards
Lars Hansen

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: the same six songs keep on playing after upgrade
« Reply #4 on: July 31, 2014, 01:12:03 PM »
Please check the error logs.
From which version did you upgraded?
DOWNLOADS PAGE

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

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #5 on: July 31, 2014, 04:15:28 PM »
i upgraded from 1.7.1
 error logs..... let me see if i can get it done.... well i think i am the right place but damn there is a lot of warnings ;)

hope that af done i right, so here goes :

Lognavn:       Application
Kilde:         MySQL
Dato:          31-07-2014 03:18:21
Hændelses-id:  100
Opgavekategori:Ingen
Niveau:        Advarsel
Nøgleord:      Klassisk
Bruger:        I/T
Computer:      Afvikling-Pc
Beskrivelse:
Beskrivelsen af hændelses-id'et 100 fra kilden MySQL blev ikke fundet. Enten er den komponent, der fremkalder denne hændelse, ikke installeret på den lokale computer, eller også er installationen beskadiget. Du kan installere eller reparere komponenten på den lokale computer.

Hvis hændelsen stammer fra en anden computer, skulle visningsoplysningerne være gemt samme med hændelsen.

Hændelsen indeholdt følgende oplysninger:

TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).



Hændelses-Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MySQL" />
    <EventID Qualifiers="49152">100</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-07-31T01:18:21.000000000Z" />
    <EventRecordID>929</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Afvikling-Pc</Computer>
    <Security />
  </System>
  <EventData>
    <Data>TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

</Data>
  </EventData>
</Event>
Best Regards
Lars Hansen

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: the same six songs keep on playing after upgrade
« Reply #6 on: July 31, 2014, 04:29:14 PM »
That seems to be some kind of problem with MySQL. It's the second time when a user reports this "event id 100" error, so i googled a bit and it seems that is a bug in some MySQL versions.

I see two solutions:
1. change the mysql version, or
2. switch to MariaDB.
DOWNLOADS PAGE

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

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #7 on: July 31, 2014, 04:50:43 PM »
I will try the mariadb tommorow or another version of mysql

Now i am of to work
Ill report back when i have tried the other DB
Best Regards
Lars Hansen

AndyDeGroo

  • Guest
Re: the same six songs keep on playing after upgrade
« Reply #8 on: July 31, 2014, 05:03:46 PM »
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
That is just a MySQL startup warning and doesn't affect its operation. The issue must be something else.

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #9 on: July 31, 2014, 05:16:51 PM »
Well i am not a DB guru, but the list is full of these warningsbut i will try another database when i come home from work

Thanks to all for even look at my little problem...
Best Regards
Lars Hansen

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5744
    • Radio DJ
Re: the same six songs keep on playing after upgrade
« Reply #10 on: July 31, 2014, 09:22:38 PM »
If you don't manage to fix it, just drop me a PM and i will try remotely to help you.
DOWNLOADS PAGE

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

Hansen

  • Full Member

  • Offline
  • ***
  • 233
    • dinFM
Re: the same six songs keep on playing after upgrade
« Reply #11 on: July 31, 2014, 09:41:37 PM »
Thanks Marius Ill let you know tommorow
Best Regards
Lars Hansen