1200wd / bitcoinlib

Bitcoin and other Cryptocurrencies Library for Python. Includes a fully functional wallet, Mnemonic key generation and management and connection with various service providers to receive and send blockchain and transaction information.
http://bitcoinlib.readthedocs.io/
GNU General Public License v3.0
596 stars 199 forks source link

When update bitcoinlib version, can't use previous database #407

Closed b0r1ngx closed 1 month ago

b0r1ngx commented 1 month ago

Log:

2024-07-19 14:30:48,202 - bitcoinlib.db - WARNING - BitcoinLib database (0.6.15) is from different version then library code (0.7.0b1). Let's try to update database.
2024-07-19 14:30:48,203 - bitcoinlib.db - WARNING - Error when verifying version or updating database: (sqlite3.OperationalError) duplicate column name: witnesses
[SQL: ALTER TABLE transaction_inputs ADD COLUMN witnesses BLOB]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
OperationalError: (sqlite3.OperationalError) no such column: wallets.anti_fee_sniping
[SQL: SELECT count(*) AS count_1 
FROM (SELECT wallets.id AS wallets_id, wallets.name AS wallets_name, wallets.owner AS wallets_owner, wallets.network_name AS wallets_network_name, wallets.purpose AS wallets_purpose, wallets.scheme AS wallets_scheme, wallets.witness_type AS wallets_witness_type, wallets.encoding AS wallets_encoding, wallets.main_key_id AS wallets_main_key_id, wallets.multisig_n_required AS wallets_multisig_n_required, wallets.sort_keys AS wallets_sort_keys, wallets.parent_id AS wallets_parent_id, wallets.multisig AS wallets_multisig, wallets.cosigner_id AS wallets_cosigner_id, wallets.key_path AS wallets_key_path, wallets.anti_fee_sniping AS wallets_anti_fee_sniping, wallets.default_account_id AS wallets_default_account_id 
FROM wallets 
WHERE wallets.name = ?) AS anon_1]
[parameters: ('tbtc-testnet',)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Also, can you please say, what the default root of database (can't find it in source).