RadioDJ - Free Radio Automation Software Forum

RadioDJ v1.7+ => v1.7+ - Support Forum => Topic started by: cutmaster on August 22, 2019, 05:41:00 PM

Title: SOLVED: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install
Post by: cutmaster on August 22, 2019, 05:41:00 PM
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.
Title: Re: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install
Post by: cutmaster 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 :)
Title: Re: SOLVED: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install
Post by: Kilrock on August 23, 2019, 12:28:46 AM
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
Title: Re: SOLVED: RadioDJ 1.8.2 seems not updating DB/songs on a fresh Win10 install
Post by: cutmaster on August 24, 2019, 11:13:24 AM
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
(https://www.dropbox.com/s/0trlawyncchzenz/Capture-1.jpg?raw=1)

Now, on the left box, you'll see the radiodj161 database, click the