search

lnbits / boltz

MIT License
1 stars 3 forks source link

v0.5.2 - Failed upgrade (from v0.5.0) #38

Closed Perlover closed 4 weeks ago

Perlover commented 1 month ago

Hello,

LNBits v0.12.8

Your extension cannot be upgraded from v0.5.0 to 0.5.2

Error in logs:

Jul 10 16:04:02 host poetry[3446621]: 2024-07-10 16:04:02.24 | INFO | Downloading extension boltz (0.5.2).
Jul 10 16:04:02 host poetry[3446621]: 2024-07-10 16:04:02.55 | INFO | Extracting extension boltz (0.5.2).
Jul 10 16:04:02 host poetry[3446621]: 2024-07-10 16:04:02.58 | SUCCESS | Extension Boltz (0.5.2) installed.
Jul 10 16:04:02 host poetry[3446621]: running migration boltz.5
Jul 10 16:04:02 host poetry[3446621]: 2024-07-10 16:04:02.59 | WARNING | (sqlite3.OperationalError) near "DROP": syntax error
Jul 10 16:04:02 host poetry[3446621]: [SQL: ALTER TABLE boltz.settings DROP COLUMN boltz_mempool_space_url]
Jul 10 16:04:02 host poetry[3446621]: (Background on this error at: http://sqlalche.me/e/13/e3q8)
Jul 10 16:04:02 host poetry[3446621]: 2024-07-10 16:04:02.59 | ERROR | HTTPException 500: Failed to install extension boltz (0.5.2).
dni commented 1 month ago

hi! are you on postgres or sqlite?

Perlover commented 1 month ago

hi! are you on postgres or sqlite?

sqlite

Perlover commented 4 weeks ago

I would like to remind you that in version LNBits v0.12.10 it is also impossible to upgrade your extension from version v0.5.0 to version v0.5.2!

I see in web admin console the red warning after update: 

Failed to install extension boltz (0.5.2).
500

In logs:

Jul 24 14:07:06 host poetry[767104]: 2024-07-24 14:07:06.44 | INFO | Downloading extension boltz (0.5.2).
Jul 24 14:07:06 host poetry[767104]: 2024-07-24 14:07:06.79 | INFO | Extracting extension boltz (0.5.2).
Jul 24 14:07:06 host poetry[767104]: 2024-07-24 14:07:06.83 | SUCCESS | Extension Boltz (0.5.2) installed.
Jul 24 14:07:06 host poetry[767104]: running migration boltz.5
Jul 24 14:07:06 host poetry[767104]: 2024-07-24 14:07:06.92 | WARNING | (sqlite3.OperationalError) near "DROP": syntax error
Jul 24 14:07:06 host poetry[767104]: [SQL: ALTER TABLE boltz.settings DROP COLUMN boltz_mempool_space_url]
Jul 24 14:07:06 host poetry[767104]: (Background on this error at: http://sqlalche.me/e/13/e3q8)
Jul 24 14:07:06 host poetry[767104]: 2024-07-24 14:07:06.92 | ERROR | HTTPException 500: Failed to install extension boltz (0.5.2).
dni commented 4 weeks ago 
SQLite 3.35.0 introduced support for ALTER TABLE DROP COLUMN.

curious can you check your sqlite version

dni commented 4 weeks ago

should be fixed in 0.5.3

Perlover commented 3 weeks ago

should be fixed in 0.5.3

Just successfully updated the extension to version 0.5.3. Thanks!

You can close the ticket!