Although this appeared to be fixed and the suggested SQL is in theThe Restore function doesn't restore custom favourites list names (WebIf 1.4.8-2, rsvsync 1.1.12).
As well as restoring theitemText
it's necessary to set theitemValue
, which controls whether the custom name is used.
This is the SQL command in the/mod/boot/rsvsync
binary:
And this is what it should do:Code:update setup.TBL_MENUCONFIG set itemText = '%s' where itemName = 'FAV_CUSTOM_STR0%d'
Code:update setup.TBL_MENUCONFIG set itemText = '%s', itemValue = 1 where itemName = 'FAV_CUSTOM_STR0%d'
rsvsync
v1.13 binary, it still seems not to be working in some cases (after a forced retune, eg). Apparently I had to restore the schedule twice to get the favourites list names to be shown.After a forced retune, I had favourites lists named "Favourite 1" and "Favourite 2", which was disappointing.
I restored a saved schedule:
Code:
Listing scheduled events from auto-2020-Aug-07-02:08...
Backup version 2
Disable OTA (BBC Red Button - Fri Aug 07 04:20:00 BST 2020 - 04:40)
BBC News (BBC ONE Lon - Mon Aug 10 04:29:00 BST 2020 - 04:30)
Favourites 1 'Faves'
Favourites 2 'FavesHD'
Favourites 3 'Favourite 3'
Favourites 4 'Favourite 4'
Favourites 5 'Favourite 5'
...
After restoring and restarting once:
Code:
# sqlite3 /var/lib/humaxtv/setup.db
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> select * from TBL_MENUCONFIG where itemName like 'FAV_CUSTOM_STR0%';
35|FAV_CUSTOM_STR01|0|Favourite 1|
36|FAV_CUSTOM_STR02|0|Favourite 2|
sqlite>
{/code]
And after restoring again but before restarting:
[code]
# sqlite3 /var/lib/humaxtv/rsvp.db
SQLite version 3.27.2 2019-02-25 16:06:06
Enter ".help" for usage hints.
sqlite> .tables
fav favnames pending skip
sqlite> select * from favnames ;
1|Faves
2|FavesHD
3|Favourite 3
4|Favourite 4
5|Favourite 5
sqlite>
Unsurprisingly this is also a problem with auto-schedule-restore.
Could there be an issue where the first restore fails to set the custom names but somehow populates previously missing fields in
TBL_MENUCONFIG
and the update
then succeeds?
Last edited: