Branch: refs/heads/fixes/32
Home: https://github.com/MythTV/mythtv
Commit: 72024244b8b5ba88af5ba0dd5dfc68cc5e1c9027
https://github.com/MythTV/mythtv/commit/72024244b8b5ba88af5ba0dd5dfc68cc5e1c9027
Author: Bill Meek <bmeek@mythtv.org>
Date: 2023-05-15 (Mon, 15 May 2023)
Changed paths:
M mythtv/libs/libmythbase/mythdbcon.cpp
Log Message:
-----------
mythdbcon: force QMetaType::QDateTime values to use MythDate::kDatabase
This cares for a recent ibqt5sql5-mysql update in at least one
distribution where it isn't removing timezone information from
a query causing it to fail.
Log example without patch:
MSqlQuery::exec(DBManager16) UPDATE recorded SET recgroup = 'Deleted', recgroupid = 3 WHERE chanid = '10901' AND starttime = '2023-04-08T05:00:00.000Z' ; <<<< Took 0ms
Log example with patch:
MSqlQuery::exec(DBManager1) UPDATE recorded SET recgroup = 'Deleted', recgroupid = 3 WHERE chanid = '10901' AND starttime = '2023-04-07 05:30:00' ; <<<< Took 0ms
Results seen by users on the Forum and mailing list.
Credits to Mark, Roland and Klaas.
See: https://forum.mythtv.org/viewtopic.php?p=25833#p25833
The Debian solution is due 4/31/2023.
_______________________________________________
mythtv-commits mailing list
mythtv-commits@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-commits
Home: https://github.com/MythTV/mythtv
Commit: 72024244b8b5ba88af5ba0dd5dfc68cc5e1c9027
https://github.com/MythTV/mythtv/commit/72024244b8b5ba88af5ba0dd5dfc68cc5e1c9027
Author: Bill Meek <bmeek@mythtv.org>
Date: 2023-05-15 (Mon, 15 May 2023)
Changed paths:
M mythtv/libs/libmythbase/mythdbcon.cpp
Log Message:
-----------
mythdbcon: force QMetaType::QDateTime values to use MythDate::kDatabase
This cares for a recent ibqt5sql5-mysql update in at least one
distribution where it isn't removing timezone information from
a query causing it to fail.
Log example without patch:
MSqlQuery::exec(DBManager16) UPDATE recorded SET recgroup = 'Deleted', recgroupid = 3 WHERE chanid = '10901' AND starttime = '2023-04-08T05:00:00.000Z' ; <<<< Took 0ms
Log example with patch:
MSqlQuery::exec(DBManager1) UPDATE recorded SET recgroup = 'Deleted', recgroupid = 3 WHERE chanid = '10901' AND starttime = '2023-04-07 05:30:00' ; <<<< Took 0ms
Results seen by users on the Forum and mailing list.
Credits to Mark, Roland and Klaas.
See: https://forum.mythtv.org/viewtopic.php?p=25833#p25833
The Debian solution is due 4/31/2023.
_______________________________________________
mythtv-commits mailing list
mythtv-commits@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-commits