Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser
X Title: Single quote not escaped when entering password for SQLCipher encrypted db · Issue #1105 · sqlitebrowser/sqlitebrowser
Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a password. Here’s an example of a db gener...
Open Graph Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p...
X Description: Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1105
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Single quote not escaped when entering password for SQLCipher encrypted db","articleBody":"### Details for the issue\r\n\r\nI was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a password.\r\n\r\nHere’s an example of a db generated using the SQLCipher cli:\r\n```\r\nsqlite> .open test.db\r\nsqlite> PRAGMA KEY = \"test'123\";\r\nsqlite> PRAGMA cipher_page_size=1024;\r\nsqlite> CREATE TABLE t1(a,b);\r\nsqlite> INSERT INTO t1(a,b) VALUES('one for the money', 'two for the show');\r\nsqlite> SELECT * FROM t1;\r\none for the money|two for the show\r\nsqlite> .q\r\n```\r\nWhen you attempt to open it in DB Browser for SQLite (3.10.0) using the passphrase `test'123` it fails.\r\n\r\n### Useful extra information\r\n\r\n* This may be a regression as the previous version was able to open SQLCipher dbs with single quotes.\r\n\r\n\u003c!-- The info below often helps, please fill it out if you're able to. :) -->\r\n\r\n#### I'm opening this issue because:\r\n\r\n- [ ] DB4S is crashing\r\n- [x ] DB4S has a bug\r\n- [ ] DB4S needs a feature\r\n- [ ] DB4S has another problem\r\n\r\n#### I'm using DB4S on:\r\n\r\n- [x ] Windows: ( _version:_ Windows 10 Enterprise)\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ x] Mac OS: ( _version:_ macOS Sierra 10.12.6)\r\n- [ ] Other: ___\r\n\r\n#### I'm using DB4S version:\r\n\r\n- [x ] 3.10.0\r\n- [ ] 3.10.0-beta*\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### I have also:\r\n\r\n- [ ] Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/R4N","@type":"Person","name":"R4N"},"datePublished":"2017-08-25T19:12:43Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1105"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:90c5b3f8-e39e-6782-e014-98e27ac9be82 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | ED1C:161A75:245B2:2F29E:6AFD1815 |
| html-safe-nonce | aead2fecd3dc1e28a0391417f99d50ad585a792b8c4f298135c61efec4fcb87b |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFRDFDOjE2MUE3NToyNDVCMjoyRjI5RTo2QUZEMTgxNSIsInZpc2l0b3JfaWQiOiI3NzQzNTA2NjYyNzE0ODQxMTA5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | e8e11fa3ce433205b0e5f5ea4bc4cf9e344cf8565031fea6e678a4adf3f6057c |
| hovercard-subject-tag | issue:252993682 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1105/issue_layout |
| twitter:image | https://opengraph.githubassets.com/deef39a9195f612cb36db228067bf2eee07650b705c811a72580a2f26a08d552/sqlitebrowser/sqlitebrowser/issues/1105 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/deef39a9195f612cb36db228067bf2eee07650b705c811a72580a2f26a08d552/sqlitebrowser/sqlitebrowser/issues/1105 |
| og:image:alt | Details for the issue I was just testing out the new version of DB Browser for SQLite (3.10.0) with SQLCipher 3.4.1 databases and noticed it doesn’t appear to escape single quotes when entering a p... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | R4N |
| hostname | github.com |
| expected-hostname | github.com |
| None | 065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 941021edf0c2ec58298f4a2c8f27ae507d129c92 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width