Centova Technologies Forum
Centova Cast v3 => Bugs and issues => Topic started by: mikek401 on August 22, 2017, 11:47:52 pm
-
About a month ago our hosting company upgraded Centova Cast to v3.2.10
After that, the general rotation playlists that had been working perfectly for 2 years stopped working correctly. The software is now ignoring the "Active From" and "Active Until" in all general rotation playlists.
I tried to re-save the playlists without making any changes but the following error was displayed when pressing Save:
QL Error: Could not execute query in /home/centovacast/system/class_DBObject.php:409
Query: UPDATE playlists SET title="5AM",type="general",scheduled_datetime="2016-01-01 01:00:00",scheduled_repeat="never",scheduled_weekdays="",scheduled_monthdays="date",interval_type="songs",interval_length="20",general_weight="20",status="enabled",general_order="sequential",interval_style="onerandom",stateid="120509",scheduled_lastrun="0000-00-00 00:00:00",scheduled_interruptible="0",scheduled_duration="0",scheduled_style="sequential",general_starttime="04:59:00",general_endtime="05:18:00",track_interruptible="0",accountid=190 WHERE id=1294
Error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'scheduled_lastrun' at row 1
Call: $SQL->misc_query()
It appears to be an error with the way the timestamps are formatted in the new software. A week later they installed "a patch" and now the error above is gone when saving a general rotation playlist, but the
the software continues to ignore "Active From" and "Active Until" in all general rotation playlists. AutoDJ thinks the list is always active. Has anyone else seen this? Any known work-around?
The truely sad part of this is the lack of Centova customer service...our hosting company has requested they look into this bug involving core functionality for over 3 weeks, but nobody has even looked yet!
-
Is anyone using the "Active From" and "Active Until" in general rotation playlists? If you're using Centova Cast v3.2.10, have you verified that the list is active at the correct time?
-
I stopped using activation times because those playlists were playing exclusively and other general rotation playlists were ignored.
-
Thanks for confirming the bug, Graham. It was never the case until the most recent update - it now ignores the "from" and "until" times and plays from that list exclusively (because it's marked as the higher priority than the catch-all list).
Our entire station is built on this core feature because only general rotation lists allow you to play the next spoken word track in the series at the same time every day.
I suspect very many stations are broken but very few admin are monitoring closely enough to notice. i.e. it's playing something so it's up. Still no response from CentovaCast. :(
-
Is Centova still in business? There hasn't been any activity by an admin in weeks in this forum. If yes, would be nice if one could confirm that they have reproduced this bug report in their lab and ETA for a fix?
-
Is Centova still in business? There hasn't been any activity by an admin in weeks in this forum.
That's absolutely NOT true. Roger has posted several times in the past few days.
-
It would take Roger a whole 15 minutes to verify that "Active_From and Active_Until in general rotation playlists is being ignored". My hosting company (over a month ago!) helped me recreate the problem on an entirely new server. Until the update, applied 7/22, it worked perfectly. To date, nobody at Centova has even looked at the server.
-
Put in a support ticket.
-
that was done over a month ago! (by reliastream.com)
-
Hello mikek401,
Unfortunately we couldn't find any support tickets, nor have we received any other reports related to this issue.
If you have a ticket number, we'll be happy to look into it.
Regards.
-
I have asked them to contact you. Other folks have reported this issue on this forum so I'm not sure why you say you haven't heard of the issue. It would take you 10 minutes to create a general rotation playlist on your test server and verify whether it is ignoring the "Active From" and "Active Until" in an upgraded version 3.2.1.
-
It is Centova Cast Ticket # SZ7-LBW4-187
It was opened July 31, 2017 9:34AM and has been completely ignored for 39 days!
-
50 days, and still no response from Centova.
-
I remember, that we have the same problem with datetime on one system. I think it was an an incompatibility with the installed mysql version. I don't know anymore :(
-
Can anyone tell me what is the minimum required version of MySQL for Centova Cast v3.2.10?
-
MySQL v5.0 - v5.6
http://www.centova.com/en/cast/requirements
-
Our hosting company upgraded to the latest MySQL software, but unfortunately it made no difference. It continues to ignore the specified activation period in general playlists ever since upgrading to v3.2.1 on July 22th.
As a result, I've changed all the playlists back to Scheduled, which means we can only play 1 random track from the correct speaker on the correct hour, rather than before where the general rotation list became active at the top of the correct hour and would play the next track in the sequence.
i.e. This feature continues to be broken:
"Activation period
General rotation playlists can also be limited to a specific period of the day. This can be used to play lighter songs in the morning and heavier songs in the afternoon, for example. If no time period is selected, the playlist will be active for the entire day." http://www.centova.com/doc/cast/user_manual/02_reference_manual/12_playlist
More than 2 months often opening a ticket with Centova, they have not offered any help. We even recreated the issue on a completely different server with only 2 playlists; so that looking at logs would be easy for them. If this doesn't suggest 'going out of business' what else would? #horribleCustomerService
-
Same problem here, on my radio stations. The only thing I could do is to play 24/7 a genarl playlist with all songs, I am wondering what is happening with Centova, the autodj is becoming useless in this way
-
Their not going out of business, that I can promise you that.
-
Just to alleviate some of the complains on this thread. There is a very simple procedure for troubleshooting playlists issues.
1.- Enable nextsong debug, under settings > advanced
2.- Reproduce the issue
3.- Look at the station logs
4.- Turn off nextsong debug (as it generates heavy log files)
If you need help interpreting the logs, or you think there is a problem with the track selection method, you can open a ticket to our support department, providing the following information.
1.- An attachment (in zip or tar.gz format) with the full station logs.
2.- The exact portion of the log that you think reflects an error
3.- Login details to the affected station, so that our staff can verify your playlist set configuration
Please bare in mind that you will need to be prepared to NOT modify your playlist set for the duration of your inquiry, otherwise it would be very difficult for our staff to help, and you will likely be asked to re-do the test.
Of course, end-users will have to forward this information through their respective streaming providers.
Regards.
-
Thanks for the reply Roger -- reliastream has opened 2 trouble tickets for this issue. The second one was opened because there was no response to the first ticket (with logs!) in over 2 months! It can be reproduced in 5 minutes on any test server...less time than it took you to write the reply ;)
"Active_From and Active_Until in general rotation playlists is being ignored"
-
This was, indeed, caused by a bug in one of the latest Centova Cast builds, which has now been fixed. Thank you for reporting this issue to us and apologies if it took us longer than expected to correct the problem. Please update your Centova Cast installation, in order to benefit from this as well as a few other bug fixes:
Centova Cast v3.2.10.20171024.stable-520r4040 is now available.
Fixes:
Fix for SQL session mode
Ignore source-related field errors when source is disabled
Fixed bug in which time-unconstrained General Rotation playlists might be ignored
Fixed bug in which errors in admin batch account ops could result in endless loading bar
Fixed potential error when saving an account with autoDJ-disabled mountpoints