Title: Error: SQL logic error or missing database · Issue #47 · sqlcipher/sqlcipher · GitHub
Open Graph Title: Error: SQL logic error or missing database · Issue #47 · sqlcipher/sqlcipher
X Title: Error: SQL logic error or missing database · Issue #47 · sqlcipher/sqlcipher
Description: On c19c72f I cannot perform any operation on encrypted databases. As soon as PRAGMA key = 'some_key'; is executed, then next SQL operation fails with "Error: SQL logic error or missing database". This error also occurs after performing a...
Open Graph Description: On c19c72f I cannot perform any operation on encrypted databases. As soon as PRAGMA key = 'some_key'; is executed, then next SQL operation fails with "Error: SQL logic error or missing database". T...
X Description: On c19c72f I cannot perform any operation on encrypted databases. As soon as PRAGMA key = 'some_key'; is executed, then next SQL operation fails with "Error: SQL logic error or missing...
Opengraph URL: https://github.com/sqlcipher/sqlcipher/issues/47
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error: SQL logic error or missing database","articleBody":"\nOn c19c72f512d203e830fd86e6921ae42d1ea39fa4 I cannot perform any operation on encrypted databases. As soon as PRAGMA key = 'some_key'; is executed, then next SQL operation fails with \"Error: SQL logic error or missing database\". This error also occurs after performing an ATTACH with a KEY specified.\n\nI am on OSX 10.8.2. I used Xcode 4.6 (with the repo provided project) to generate an amalgamation. I then used the CMakeLists.txt file below to compile shell.c and sqlite3.c, and linked it with the OS provide libcrypto from OpenSSL.\n\nHere's the \"CMakeLists.txt\" file that I used:\n\ncmake_minimum_required(VERSION 2.8.8)\nproject(SQLite3)\n\nset(CMAKE_MODULE_PATH ${CMAKE_CURRENT_LIST_DIR}/CMake ${CMAKE_MODULE_PATH})\n\nfind_package(OpenSSL)\nif(NOT OPENSSL_FOUND)\n message(FATAL_ERROR \"OpenSSL is required for SQLCipher\")\nendif()\n\nset(SQLITE3_FOUND TRUE CACHE INTERNAL \"SQLite3 Found\")\nset(SQLITE3_LIBRARIES SQLite3 ${OPENSSL_LIBRARIES} CACHE INTERNAL \"SQLite3 Libraries\")\nset(SQLITE3_INCLUDE_DIRS ${CMAKE_CURRENT_LIST_DIR}/include CACHE INTERNAL \"SQLite3 Include Directories\")\nset(SQLITE3_INCLUDE_DIR ${CMAKE_CURRENT_LIST_DIR}/include CACHE INTERNAL \"SQLite3 Include Directories\")\n\nadd_definitions(\n -D_LARGE_FILE=1\n -D_FILE_OFFSET_BITS=64\n -D_LARGEFILE_SOURCE=1\n -DSQLITE_ENABLE_RTREE=1\n -DSQLITE_HAS_CODEC\n -DSQLITE_TEMP_STORE=2\n -DSQLITE_THREADSAFE\n)\n\ninclude_directories(${SQLITE3_INCLUDE_DIRS} ${OPENSSL_INCLUDE_DIRS})\n\nadd_library(SQLite3 STATIC\n ${CMAKE_CURRENT_LIST_DIR}/sqlite3.c\n ${CMAKE_CURRENT_LIST_DIR}/include/sqlite3.h\n ${CMAKE_CURRENT_LIST_DIR}/include/sqlite3ext.h\n)\n\noption(BUILD_SQLITE3SHELL \"Build the SQLite3 shell (sqlite3 executable)\" ON)\n\nif(BUILD_SQLITE3SHELL)\n add_executable(SQLite3_Shell ${CMAKE_CURRENT_LIST_DIR}/shell.c)\n target_link_libraries(SQLite3_Shell ${SQLITE3_LIBRARIES})\n set_target_properties(SQLite3_Shell PROPERTIES OUTPUT_NAME sqlite3)\nendif()\n","author":{"url":"https://github.com/Type1J","@type":"Person","name":"Type1J"},"datePublished":"2013-03-12T17:20:47Z","url":"https://github.com/sqlcipher/sqlcipher/issues/47"}
| 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:98f200cf-cfe7-f243-be1c-08012b46b732 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | CE68:32C295:1B264D:2558CB:6AFD5FA1 |
| html-safe-nonce | 676dc19183ca312d3901000244fe4d6c7e3cdab8c1ab53a56e289a03a8c0836e |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRTY4OjMyQzI5NToxQjI2NEQ6MjU1OENCOjZBRkQ1RkExIiwidmlzaXRvcl9pZCI6IjUzNzc3MDc1NjM2MTE0MTQ0MzQiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 91db1855283c310a87e8db53563cebdfd7debe50a1b0365119250d0ec33e1802 |
| hovercard-subject-tag | issue:11934966 |
| 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/sqlcipher/sqlcipher/47/issue_layout |
| twitter:image | https://opengraph.githubassets.com/2d302090f826b6c8c3823a2089140bf578c738cabc961aa91aca8f0f27e3a98f/sqlcipher/sqlcipher/issues/47 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/2d302090f826b6c8c3823a2089140bf578c738cabc961aa91aca8f0f27e3a98f/sqlcipher/sqlcipher/issues/47 |
| og:image:alt | On c19c72f I cannot perform any operation on encrypted databases. As soon as PRAGMA key = 'some_key'; is executed, then next SQL operation fails with "Error: SQL logic error or missing database". T... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | Type1J |
| hostname | github.com |
| expected-hostname | github.com |
| None | 66653c2e55a6fff2930be1bdf07ee4f8aa137e3956d056c822563be6f878755e |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlcipher/sqlcipher git https://github.com/sqlcipher/sqlcipher.git |
| octolytics-dimension-user_id | 649049 |
| octolytics-dimension-user_login | sqlcipher |
| octolytics-dimension-repository_id | 38617 |
| octolytics-dimension-repository_nwo | sqlcipher/sqlcipher |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 38617 |
| octolytics-dimension-repository_network_root_nwo | sqlcipher/sqlcipher |
| 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 | b6f01f7cb9f35f8c09949773241a3d49dd04b340 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width