date_played in Songs not updating...

[garrywing]

I had a curious thing begin happening overnight. The date_played was only updating on some songs, and not others... so, the same song (least recently played) would continue to play over and over each time a song was called for from that sub-category. Tried Repairing the db in Heidi, restarting RDJ and the computer, no joy.

This is vers. 2.0.4.5 on a clean install Win 10 pro which had been running fine for 3+ weeks. The only thing I can remember changing in the last day or so, was the "Keep History" duration in Options (changed from 90 to 30 days).

Any thoughts?

Garry

[Kiwi]

This thread may shed a light on things for you...

https://www.radiodj.ro/community/index.php/topic,16825.msg92051.html#msg92051

[garrywing]

Thanks for the quick response on that, but I'm not sure that's what's happening. As soon as a song begins to play, the date_played field in the SQL table is updated with date/time stamp. (I can verify this on a backup machine I'm now having to use; same database, same songs, etc.)

On the primary machine, it simply isn't happening, hence the same song gets pulled into Rotation the next time that category comes up. I'm not using Priority, etc., only "least recently played". Need to figure out why the date_played isn't getting updated...

Deleted History, re-installed RDJ. Next, going to re-install MariaDB; it may be a lower level issue that is causing the issue with the SQL table, but it's not throwing any errors.

Garry

[Kiwi]

In HeidiSQL do you have the "UpdateTracks" and "UpdateTracks2" procedures in the Table listings on the primary machine? May pay to check this and see if the backup machine has them...

A thought...

Also, have you checked the RadioDJ logs to see if there are any errors listed?

[garrywing]

Ah... I think we're getting somewhere. The working machine does have an UpdateTracks2 procedure in the SQL table. The 'broken' one does not. Is this something I can copy/paste or import into the non-working machine. It does look like this is the procedure that updates date/timestamp, which somehow got trashed or deleted overnight...?

[Kiwi]

Should be able to copy/paste it into the "non-working machine". Restart RadioDJ. Hope it works! Remember to backup database before attempting...

EDIT:

There is this from Marius when he released Bet 2.0.1.4

https://www.radiodj.ro/community/index.php/topic,12661.0.html

[garrywing]

Yeah, copying it and adding the Parameters did the trick. I only have the UpdateTracks2 (not UpdateTracks) procedure; is that OK? It does seem to be date-stamping now.

THANKS KIWI! Would have probably chased that for hours. I have it making a backup in the middle of the night; otherwise, any idea on how it might have gotten hosed or deleted?

Garry

[Kiwi]

Yes, you only need the UpdateTracks2. Pleased to hear it is working for you.

Don't know why the issue arose. Maybe it didn't download when first installed?