deleteOldContent.php - deletes playlist configuration

[kachaj7]

• I've read the guidelines for Contributing to Kaltura Projects
• This is not a support request or question that should be posted on the Kaltura forum or submitted to the support team in the form of a ticket

Bug report

Running this cleaning scripts with argument old-versions removes latest playlist files. These files contains a list of entries, shown in playlist.

Kaltura ENV

IX 9.2.1

Is this an all in one instance [single server] or a cluster?

• All in one
• Cluster

If applicable, please provide the MySQL version:
SELECT FROM file_sync LEFT JOIN entry ON (file_sync.OBJECT_ID=entry.ID AND file_sync.VERSION<>entry.DATA) WHERE entry.DATA IS NOT NULL AND file_sync.DC=0 AND file_sync.OBJECT_TYPE=1 AND file_sync.OBJECT_SUB_TYPE=1 AND file_sync.STATUS NOT IN (3,4) ORDER BY file_sync.UPDATED_AT ASC LIMIT 10

If you're having an issue with a specific media asset, please provide a link from which it can be downloaded/played:
The problem in this line

server/alpha/scripts/batch/deleteOldContent.php

Line 647 in 8e46a5a

$join->addCondition(FileSyncPeer::VERSION, entryPeer::DATA, Criteria::NOT_EQUAL);

This compares columns, that have different value always. Because actual version in entry.data is 10008.txt and in file_sync.Version is 10008, so is wrong.

[kachaj7]

Can somebody see the ticket?