I recently borked something trying to update too many versions at once, yeah yeah I know. Luckily this was a backup drive so nothing was lost(other than my time) but was wondering if there's anyway to look into and undo this and make sure nothing went wrong with my database. Hydrus closed itself after failing to update so I haven't touched it since. Worst case, I'll just have to delete my database and copy over my back up again and I hate that it took me 3 days to copy everything over before.
v559, 2024/09/17 19:39:47: hydrus client started
v559, 2024/09/17 19:39:49: booting controller…
v559, 2024/09/17 19:39:50: booting db…
v559, 2024/09/17 19:40:11: checking database
v559, 2024/09/17 19:40:13: updating db to v541
v559, 2024/09/17 19:40:13: updated db to v541
v559, 2024/09/17 19:40:15: updating db to v542
v559, 2024/09/17 19:40:16: updated db to v542
v559, 2024/09/17 19:40:18: updating db to v543
v559, 2024/09/17 19:40:19: updated db to v543
v559, 2024/09/17 19:40:21: updating db to v544
v559, 2024/09/17 19:40:22: updated db to v544
v559, 2024/09/17 19:40:24: updating db to v545
v559, 2024/09/17 19:40:29: updated db to v545
v559, 2024/09/17 19:40:43: updating db to v546
v559, 2024/09/17 19:40:44: updated db to v546
v559, 2024/09/17 19:40:46: updating db to v547
v559, 2024/09/17 19:40:46: updated db to v547
v559, 2024/09/17 19:40:48: updating db to v548
v559, 2024/09/17 19:40:48: [[[41, 3, [2, 4, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 46]], [[0, "simple_data"], [0, null]]]]]]], [[41, 3, [2, 4, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 46]], [[0, "simple_data"], [0, null]]]]]]], [[41, 3, [2, 3, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 46]], [[0, "simple_data"], [0, null]]]]]]], [[41, 3, [2, 3, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 46]], [[0, "simple_data"], [0, null]]]]]]], [[41, 3, [2, 28, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 47]], [[0, "simple_data"], [0, null]]]]]]], [[41, 3, [2, 13, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [0, 0]]]]]]]], [[41, 3, [2, 13, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [0, 0]]]]]]]], [[41, 3, [2, 13, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [0, 1]]]]]]]], [[41, 3, [2, 13, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [0, 1]]]]]]]], [[41, 3, [2, 14, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [1, 0]]]]]]]], [[41, 3, [2, 14, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [1, 0]]]]]]]], [[41, 3, [2, 14, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [1, 1]]]]]]]], [[41, 3, [2, 14, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [1, 1]]]]]]]], [[41, 3, [2, 11, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [2, 0]]]]]]]], [[41, 3, [2, 11, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [2, 0]]]]]]]], [[41, 3, [2, 11, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [2, 1]]]]]]]], [[41, 3, [2, 11, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [2, 1]]]]]]]], [[41, 3, [2, 12, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [3, 0]]]]]]]], [[41, 3, [2, 12, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [3, 0]]]]]]]], [[41, 3, [2, 12, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [3, 1]]]]]]]], [[41, 3, [2, 12, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [3, 1]]]]]]]], [[41, 3, [2, 9, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [4, 0]]]]]]]], [[41, 3, [2, 9, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [4, 0]]]]]]]], [[41, 3, [2, 9, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [4, 1]]]]]]]], [[41, 3, [2, 9, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [4, 1]]]]]]]], [[41, 3, [2, 10, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [5, 0]]]]]]]], [[41, 3, [2, 10, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [5, 0]]]]]]]], [[41, 3, [2, 10, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [5, 1]]]]]]]], [[41, 3, [2, 10, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [5, 1]]]]]]]], [[41, 3, [2, 15, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [6, 0]]]]]]]], [[41, 3, [2, 15, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [6, 0]]]]]]]], [[41, 3, [2, 15, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [6, 1]]]]]]]], [[41, 3, [2, 15, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [6, 1]]]]]]]], [[41, 3, [2, 16, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [7, 0]]]]]]]], [[41, 3, [2, 16, 0, [3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [7, 0]]]]]]]], [[41, 3, [2, 16, 0, [2]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [7, 1]]]]]]]], [[41, 3, [2, 16, 0, [2, 3]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 148]], [[0, "simple_data"], [0, [7, 1]]]]]]]], [[41, 3, [0, 97, 0, [0]]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 149]], [[0, "simple_data"], [2, [126, 1, [0, null]]]]]]]]], [[41, 3, [2, 6, 0, []]], [42, 5, [0, [21, 2, [[[0, "simple_action"], [0, 149]], [[0, "simple_data"], [2, [126, 1, [2, null]]]]]]]]]]
v559, 2024/09/17 19:40:48: Had a problem saving a JSON object. The dump has been printed to the log.
v559, 2024/09/17 19:40:48: Dump had length 4.66 KB!
v559, 2024/09/17 19:40:48: If the db crashed, another error may be written just above ^.
v559, 2024/09/17 19:40:48: A serious error occurred while trying to start the program. The error will be shown next in a window. More information may have been written to client.log.
v559, 2024/09/17 19:40:48: Traceback (most recent call last):
File "hydrus\core\HydrusDB.py", line 266, in __init__
File "hydrus\client\db\ClientDB.py", line 9830, in _UpdateDB
File "hydrus\client\db\ClientDBSerialisable.py", line 747, in SetJSONDump
File "hydrus\core\HydrusDBBase.py", line 289, in _Execute
sqlite3.OperationalError: table json_dumps_named has no column named timestamp_ms
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "hydrus\client\ClientController.py", line 2212, in THREADBootEverything
File "hydrus\client\ClientController.py", line 1003, in InitModel
File "hydrus\core\HydrusController.py", line 588, in InitModel
File "hydrus\client\ClientController.py", line 207, in _InitDB
File "hydrus\client\db\ClientDB.py", line 239, in __init__
File "hydrus\core\HydrusDB.py", line 287, in __init__
Exception: Updating the client db to version 548 caused this error:
Traceback (most recent call last):
File "hydrus\core\HydrusDB.py", line 266, in __init__
File "hydrus\client\db\ClientDB.py", line 9830, in _UpdateDB
File "hydrus\client\db\ClientDBSerialisable.py", line 747, in SetJSONDump[Expand Post]
File "hydrus\core\HydrusDBBase.py", line 289, in _Execute
sqlite3.OperationalError: table json_dumps_named has no column named timestamp_ms
v559, 2024/09/17 19:40:48: boot error
v559, 2024/09/17 19:40:48: A serious error occurred while trying to start the program. The error will be shown next in a window. More information may have been written to client.log.
v559, 2024/09/17 19:40:52: boot error
v559, 2024/09/17 19:40:52: Traceback (most recent call last):
File "hydrus\core\HydrusDB.py", line 266, in __init__
File "hydrus\client\db\ClientDB.py", line 9830, in _UpdateDB
File "hydrus\client\db\ClientDBSerialisable.py", line 747, in SetJSONDump
File "hydrus\core\HydrusDBBase.py", line 289, in _Execute
sqlite3.OperationalError: table json_dumps_named has no column named timestamp_ms
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "hydrus\client\ClientController.py", line 2212, in THREADBootEverything
File "hydrus\client\ClientController.py", line 1003, in InitModel
File "hydrus\core\HydrusController.py", line 588, in InitModel
File "hydrus\client\ClientController.py", line 207, in _InitDB
File "hydrus\client\db\ClientDB.py", line 239, in __init__
File "hydrus\core\HydrusDB.py", line 287, in __init__
Exception: Updating the client db to version 548 caused this error:
Traceback (most recent call last):
File "hydrus\core\HydrusDB.py", line 266, in __init__
File "hydrus\client\db\ClientDB.py", line 9830, in _UpdateDB
File "hydrus\client\db\ClientDBSerialisable.py", line 747, in SetJSONDump
File "hydrus\core\HydrusDBBase.py", line 289, in _Execute
sqlite3.OperationalError: table json_dumps_named has no column named timestamp_ms
v559, 2024/09/17 19:40:54: doing fast shutdown…
v559, 2024/09/17 19:40:54: shutting down gui…
v559, 2024/09/17 19:40:54: shutting down db…
v559, 2024/09/17 19:40:54: saving and exiting objects
v559, 2024/09/17 19:40:54: cleaning up…
v559, 2024/09/17 19:40:54: shutting down controller…
v559, 2024/09/17 19:40:54: hydrus client shut down