Ticket #12290: commercial-flagging-not-queued-workaround.patch0

diff --git a/mythtv/libs/libmyth/programinfo.cpp b/mythtv/libs/libmyth/programinfo.cpp
index 14f4b0a..511e828 100644
--- a/mythtv/libs/libmyth/programinfo.cpp
+++ b/mythtv/libs/libmyth/programinfo.cpp
@@ -5804,11 +5804,11 @@ void ProgramInfo::SaveFilesize(uint64_t fsize)
     updater->insert(chanid, recstartts, kPIUpdateFileSize, fsize);
 }
 
-uint64_t ProgramInfo::GetFilesize(void) const
-{
-    LOG(VB_GENERAL, LOG_DEBUG, "FIXME: ProgramInfo::GetFilesize() called instead of RecordingInfo::GetFilesize()");
-    return filesize;
-}
+//uint64_t ProgramInfo::GetFilesize(void) const
+//{
+//    LOG(VB_GENERAL, LOG_DEBUG, "FIXME: ProgramInfo::GetFilesize() called instead of RecordingInfo::GetFilesize()");
+//    return filesize;
+//}
 
 
 /// \brief Gets recording file size direct from the database.
@@ -5816,23 +5816,31 @@ uint64_t ProgramInfo::GetFilesize(void) const
 /// In theory this should be redundant, the ProgramInfo updater should sync
 /// all instances on frontends and backends without the need
 /// for any one to go checking the database.
-// uint64_t ProgramInfo::QueryFilesize(void) const
-// {
-//     LOG(VB_GENERAL, LOG_DEBUG, "FIXME: ProgramInfo::QueryFilesize() called instead of RecordingInfo::GetFilesize()");
-//
-//     MSqlQuery query(MSqlQuery::InitCon());
-//
-//     query.prepare(
-//         "SELECT filesize "
-//         "FROM recorded "
-//         "WHERE chanid    = :CHANID AND "
-//         "      starttime = :STARTTIME");
-//     query.bindValue(":CHANID", chanid);
-//     query.bindValue(":STARTTIME", recstartts);
-//     if (query.exec() && query.next())
-//         return query.value(0).toULongLong();
-//
-//     return filesize;
-// }
+uint64_t ProgramInfo::GetFilesize(void) const
+{
+
+    uint64_t db_filesize = 0;
+
+    MSqlQuery query(MSqlQuery::InitCon());
+
+// When failing, recordedfile.filesize = filesize = 0
+    query.prepare(
+        "SELECT filesize "
+        "FROM recorded "
+        "WHERE chanid    = :CHANID AND "
+        "      starttime = :STARTTIME");
+    query.bindValue(":CHANID",    chanid);
+    query.bindValue(":STARTTIME", recstartts);
+    if (query.exec() && query.next())
+    {
+        db_filesize = query.value(0).toULongLong();
+        LOG(VB_GENERAL, filesize == 0 ? LOG_ERR : LOG_DEBUG,
+            QString("GetFilesize(), db_filesize=%1, filesize=%2.")
+                .arg(db_filesize).arg(filesize));
+        return db_filesize;
+    }
+
+    return filesize;
+}
 
 /* vim: set expandtab tabstop=4 shiftwidth=4: */