search

Fmstrat / plex-db-sync

Synchronizes the database watched status between two Plex servers. This includes watched times, and works for all users on the system without the need for tokens.
152 stars 24 forks source link

date: invalid date , #32

Open dan3805 opened 1 year ago

dan3805 commented 1 year ago

im getting those error , im not sure why

[Fri Jan 13 04:13:37 UTC 2023]   - Checking records that are in both databases
date: invalid date '1673422436'
date: invalid date '1673420639'
[Fri Jan 13 04:13:37 UTC 2023]     - (0/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50b1
date: invalid date '1673422436'
date: invalid date '1673420639'
[Fri Jan 13 04:13:37 UTC 2023]     - (1/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50c9
date: invalid date '1673422436'
date: invalid date '1673422439'
[Fri Jan 13 04:13:37 UTC 2023]     - (2/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50b5
date: invalid date '1673496161'
date: invalid date '1673425327'
[Fri Jan 13 04:13:37 UTC 2023]     - (3/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50a9
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (4/18) Setting server 2 status for: plex://episode/6166dc57b7e9b3348d72a4f3
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (5/18) Setting server 2 status for: plex://episode/6170389185de95527c77e3ac
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (6/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50ad
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (7/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50bd
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (8/18) Setting server 2 status for: plex://episode/5d9c0f232df347001e3f50b9
date: invalid date '1673496161'
date: invalid date '1673496109'
[Fri Jan 13 04:13:37 UTC 2023]     - (9/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d1e
date: invalid date '1673497960'
date: invalid date '1673497902'
[Fri Jan 13 04:13:37 UTC 2023]     - (10/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d22
date: invalid date '1673501560'
date: invalid date '1673501502'
[Fri Jan 13 04:13:37 UTC 2023]     - (11/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d3d
date: invalid date '1673503360'
date: invalid date '1673503303'
[Fri Jan 13 04:13:37 UTC 2023]     - (12/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d2a
date: invalid date '1673505159'
date: invalid date '1673505102'
[Fri Jan 13 04:13:37 UTC 2023]     - (13/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d41
date: invalid date '1673509071'
date: invalid date '1673509162'
[Fri Jan 13 04:13:37 UTC 2023]     - (14/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d32
date: invalid date '1673510875'
date: invalid date '1673510963'
[Fri Jan 13 04:13:37 UTC 2023]     - (15/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d36
date: invalid date '1673512670'
date: invalid date '1673512762'
[Fri Jan 13 04:13:37 UTC 2023]     - (16/18) Setting server 2 status for: plex://episode/5d9c0f236c3e37001ecf1d2e
date: invalid date '1673575864'
date: invalid date '1673552727'
dan3805 commented 1 year ago

another run wiith debug show no error for that part ... i think


[Fri Jan 13 04:36:52 UTC 2023] Processing for <USERNAME> (1)...
[Fri Jan 13 04:36:52 UTC 2023]   - Checking records that are in both databases
[Fri Jan 13 04:36:52 UTC 2023] -=-: select s1.guid, s1.id as id1, s1.updated_at as updated_at1, s1.view_count as view_count1, s1.last_viewed_at as last_viewed_at1, s1.view_offset as view_offset1, s1.changed_at as changed_at1, s2.id as id2, s2.updated_at as updated_at2, s2.view_count as view_count2, s2.last_viewed_at as last_viewed_at2, s2.view_offset as view_offset2, s2.changed_at as changed_at2 from metadata_item_settings1 s1, metadata_item_settings2 s2 where s1.guid=s2.guid and s1.account_id=s2.account_id and s1.account_id=1 and (s1.view_count != s2.view_count or s1.last_viewed_at != s2.last_viewed_at or s1.view_offset != s2.view_offset or s1.changed_at != s2.changed_at);
[Fri Jan 13 04:36:52 UTC 2023]   - Checking records missing from server 2
[Fri Jan 13 04:36:52 UTC 2023] -=-: select * from metadata_item_settings1 where guid in (select guid from metadata_items2) and guid not in (select guid from metadata_item_settings2 where account_id=1) and account_id=1;
[Fri Jan 13 04:36:54 UTC 2023]   - Checking records missing from server 1
[Fri Jan 13 04:36:54 UTC 2023] -=-: select * from metadata_item_settings2 where guid in (select guid from metadata_items1) and guid not in (select guid from metadata_item_settings1 where account_id=1) and account_id=1;
[Fri Jan 13 04:36:55 UTC 2023]     - (0/1) Setting server 1 status for: plex://movie/5d776824e6d55c002040ae65
[Fri Jan 13 04:36:55 UTC 2023] /tmp/plex-db-sync/1.sql: insert into metadata_item_settings (account_id, guid, rating, view_offset, view_count, last_viewed_at, created_at, updated_at, skip_count, last_skipped_at, changed_at, extra_data) values ('1', 'plex://movie/5d776824e6d55c002040ae65', null, 'xxxxxxx', '0', '1673583816', '1673583810', '1673583816', '0', null, xxxxxxxxxxxxxxxxxxxxxxx, '');
brimur commented 1 year ago

FYI I am getting the same error and notice some items are not appearing "on deck" so looks like those items are not being updated.

date: invalid date ‘1689669223’
date: invalid date ‘1687211785’
[Mon  7 Aug 10:18:47 UTC 2023]     - (0/23) Setting server 2 status for: plex://season/602e6192ea35e0002c230366
date: invalid date ‘1689669223’
date: invalid date ‘1687211785’
[Mon  7 Aug 10:18:47 UTC 2023]     - (1/23) Setting server 2 status for: plex://show/5d9c0831e264b7001fc3e862
date: invalid date ‘1690105970’
date: invalid date ‘1676553598’
[Mon  7 Aug 10:18:47 UTC 2023]     - (2/23) Setting server 2 status for: plex://episode/5e165b5161c6140040d9530e
date: invalid date ‘1690108298’
date: invalid date ‘1676553653’
[Mon  7 Aug 10:18:47 UTC 2023]     - (3/23) Setting server 2 status for: plex://season/602e78a1de471d002d082d24
date: invalid date ‘1690108298’
date: invalid date ‘1689147215’
[Mon  7 Aug 10:18:47 UTC 2023]     - (4/23) Setting server 2 status for: plex://show/5e165b5161c6140040d952ff
date: invalid date ‘1690106551’
date: invalid date ‘1676553653’
[Mon  7 Aug 10:18:47 UTC 2023]     - (5/23) Setting server 2 status for: plex://episode/5e165b5161c6140040d9530c
date: invalid date ‘1690107172’
date: invalid date ‘1672918841’
[Mon  7 Aug 10:18:47 UTC 2023]     - (6/23) Setting server 2 status for: plex://episode/5e165b5161c6140040d9530a
date: invalid date ‘1690107687’
date: invalid date ‘1673346514’
[Mon  7 Aug 10:18:47 UTC 2023]     - (7/23) Setting server 2 status for: plex://episode/5e165b5161c6140040d95306
date: invalid date ‘1690108298’
date: invalid date ‘1673604621’
[Mon  7 Aug 10:18:47 UTC 2023]     - (8/23) Setting server 2 status for: plex://episode/5e165b5161c6140040d95308
date: invalid date ‘1691221442’
date: invalid date ‘1689147840’
[Mon  7 Aug 10:18:47 UTC 2023]     - (9/23) Setting server 2 status for: plex://show/618519b150ed2194736f0c70
date: invalid date ‘1690105325’
date: invalid date ‘1689147215’
[Mon  7 Aug 10:18:47 UTC 2023]     - (10/23) Setting server 2 status for: plex://episode/64802341555dd07c49c1d5b7
date: invalid date ‘1690105325’
date: invalid date ‘1689147215’
[Mon  7 Aug 10:18:47 UTC 2023]     - (11/23) Setting server 2 status for: plex://season/64802339555dd07c49c1ceb4
date: invalid date ‘1689666383’
date: invalid date ‘1686473929’
[Mon  7 Aug 10:18:47 UTC 2023]     - (12/23) Setting server 2 status for: plex://episode/5d9c0f8e3c3f87001f39c4dc
date: invalid date ‘1689667806’
date: invalid date ‘1686475353’
[Mon  7 Aug 10:18:47 UTC 2023]     - (13/23) Setting server 2 status for: plex://episode/5d9c0f8eba6eb9001fbefff4
date: invalid date ‘1689669223’
date: invalid date ‘1686476771’
[Mon  7 Aug 10:18:47 UTC 2023]     - (14/23) Setting server 2 status for: plex://episode/5d9c0f8f2192ba001f35e92c
date: invalid date ‘1690012664’
date: invalid date ‘1688216216’
[Mon  7 Aug 10:18:47 UTC 2023]     - (15/23) Setting server 2 status for: plex://episode/630802d9af5ccd7d98d7f131