Author Topic: SOLVED: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install  (Read 719 times)

cutmaster

  • Jr. Member

  • Offline
  • **
  • 76
    • The Revival of WOW FM with Radio DJ
Hello everyone,
Because I'm actually need to migrate my radios from a Windows virtual server to a physical machine running Windows 10, I've done the following :
- dump of the radiodj161 database from my actual mySQL DB
- fresh install of radiodj 1.8.2.0 on the win10 machine
- fresh install of mySQL server 5.7.2.7 (which is the version that seems to work with RDJ 1.8.2, tried with mySQL 8.0.17 but radidj database setup program was unable to connect)
- reimport of the database
- launch of database setup that connects correctly (everything is green).
Now running RadioDJ works well BUT... It doesn't update the song "date_played", "artist_played" & "count_played". It is easy for me to see it because I've created a new genre of music where all titles have a count to 0.
Otherwise I can see directly on the database that the column "tartist_played" is the only one to be updated (by the way what's the difference between artist_played & tartist_played ?).
Can someone help me on this ?
Thanks.
The Revival of WOW FM with Radio DJ

http://www.cloudrad.io/cutmaster

Best Dance Music from 80's, 90's to today

cutmaster

  • Jr. Member

  • Offline
  • **
  • 76
    • The Revival of WOW FM with Radio DJ
Re: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install
« Reply #1 on: August 22, 2019, 06:22:21 PM »
Okay well after long researches, I've finally found the reason.
It seems to appear with newer version of mySQL server that doesn't understand "admin@%" as an owner of the stored procedure "UpdateTracks".
Changing it to "admin@localhost" has solved the problem.
Hope it can help someone there :)
The Revival of WOW FM with Radio DJ

http://www.cloudrad.io/cutmaster

Best Dance Music from 80's, 90's to today

Kilrock

  • Jr. Member

  • Offline
  • **
  • 97
Dear Cutmaster,

Can you help me any further on this issue? I've read your solution to the database issue. It seems we share the same problem. What I don't understand is how I can check the owner status, like you described, and change it eventually to solve the problem. Not too much knowledge of databases around in here (didn't expect the need for so much knowledge up 'till now).

Configuration specs:
Windows 7, 64 bit
RDJ 2.0.0.6
DotNet 4.6.2.
Maria DB 10.03

Marcel
First explore, than think, do, screw up & ask for help...

cutmaster

  • Jr. Member

  • Offline
  • **
  • 76
    • The Revival of WOW FM with Radio DJ
Hello Kilrock,

Well for an easier access to those data (because it'll be more easy to understand than command-lines code), install HeidiSQL on your computer.
Install it, run it, give it access to your mySQL database and you'll see something similar to


Now, on the left box, you'll see the radiodj161 database, click the
  • to open it, you'll see at its end the procedure </> UpdateTracks
    Click on it, you should see something like


    My version of HeidiSQL is in French, but if you look at to top right of the image, you'll see "Définisseur : admin@localhost" which will probably look like "owner" or "creator"... Change its content, either by nothing (it'll be replaced by the default user) or by admin@localhost...
    That's it :)
The Revival of WOW FM with Radio DJ

http://www.cloudrad.io/cutmaster

Best Dance Music from 80's, 90's to today