Comments (6)
I upgraded sqlite3 to: SQLite version 3.43.0 2023-08-24 12:36:59.
The only difference in results seems to be
sqlite3 signal.db 'select name, type from sqlite_schema where tbl_name = "messages"'
Error: in prepare, no such column: messages
ct name, type from sqlite_schema where tbl_name = "messages"
error here ---^
But when I switch the single/double quotes, it works fine:
sqlite3 signal.db "select name, type from sqlite_schema where tbl_name = 'messages'"
messages|table
sqlite_autoindex_messages_1|index
messages_id|index
messages_receipt|index
messages_schemaVersion|index
messages_view_once|index
messages_sourceUuid|index
messages_searchOrder|index
messages_unexpectedly_missing_expiration_start_timestamp|index
messages_hasAttachments|index
messages_hasFileAttachments|index
messages_conversation|index
messages_unread|index
messages_conversation_no_story_id|index
messages_unread_no_story_id|index
messages_unseen_no_story|index
messages_unseen_with_story|index
expiring_message_by_conversation_and_received_at|index
messages_by_distribution_list|index
messages_by_storyId|index
messages_call|index
messages_expires_at|index
messages_hasVisualMediaAttachments|index
messages_preview|index
messages_preview_without_story|index
messages_activity|index
message_user_initiated|index
messages_unread_mentions|index
messages_unread_mentions_no_story_id|index
messages_story_replies|index
messages_on_view_once_update|trigger
messages_on_insert|trigger
messages_on_update|trigger
messages_on_delete|trigger
messages_on_insert_insert_mentions|trigger
messages_on_update_update_mentions|trigger
The message count query when directed to signal.db returns:
sqlite3 signal.db "select count(*) from messages"
162646
from sigtop.
Some more information, the .db file opens just fine with SQLiteStudio (3.4.4) but nothing else seems to be able to get it to work.
from sigtop.
I'm trying to access the exported db file using DB Browser for SQLite and I am getting this error:
Could not open database file. Reason: malformed database schema (messages_on_insert_insert_mentions) - near ">>": syntax error
Please show the output of sqlitebrowser -v
.
But when I switch the single/double quotes, it works fine:
My mistake. sqlite3 no longer accepts double-quoted strings.
from sigtop.
This command does not seem to work:
sqlitebrowser -v
zsh: command not found: sqlitebrowser
I was trying to use the GUI for DB Browser for SQLite, and this is the information I can get from it:
DB Browser for SQLite Version 3.12.2
Built for arm64-little_endian-lp64, running on arm64
Qt Version 5.15.6
SQLCipher Version 4.5.1 community (based on SQLite 3.37.2).
from sigtop.
Thanks, that's the information I was after.
I'm afraid your version of sqlitebrowser is too old. It has SQLite 3.37.2, but the Signal Desktop database uses a feature that was introduced in SQLite 3.38.0.
You could try with a nightly build of sqlitebrowser. Maybe it has a newer SQLite version.
from sigtop.
Yep, that was it. Not sure why I didn't catch that bit in the version information. Thanks for the help!
from sigtop.
Related Issues (20)
- Not enough tokens to parse JSON HOT 1
- Sigtop selective export HOT 2
- Precombiled Windows app crashes immediately after opening. HOT 1
- cannot install on linux: "cannot use path@version syntax in GOPATH mode" HOT 2
- sigtop: cannot prepare statement: no such column: uuid HOT 2
- path_windows.go: sanitiseFilename is not robust HOT 10
- If I don't want to run sigtop on the production database of my signal desktop, how do I run it? HOT 1
- Export to HTML and link attachments HOT 6
- Program detected as a virus HOT 2
- "att -M" command throws error "utimes: unsupported flag" HOT 6
- Emoji in chat title HOT 8
- Bash Command not found HOT 1
- brew installation error: "go build: Error: Passed `nil` into T.must" HOT 2
- -i option for messages HOT 1
- Not a database error when running sigtop db HOT 13
- Attachments decryption HOT 2
- Feature: Include contact names in JSON message export HOT 2
- skipping attachment without path HOT 2
- cannot decrypt database key: cannot find encryption key HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sigtop.