René's URL Explorer Experiment


Title: [Bug]: Incorrect foreign key mismatch error · Issue #4155 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: [Bug]: Incorrect foreign key mismatch error · Issue #4155 · sqlitebrowser/sqlitebrowser

X Title: [Bug]: Incorrect foreign key mismatch error · Issue #4155 · sqlitebrowser/sqlitebrowser

Description: What did you do? With the tables: CREATE TABLE IF NOT EXISTS single_drives( drive_sequential_number INTEGER PRIMARY KEY, drive_serial_number TEXT NOT NULL, drive_model TEXT, base_board INTEGER NOT NULL, cpu_board INTEGER, transistor_boar...

Open Graph Description: What did you do? With the tables: CREATE TABLE IF NOT EXISTS single_drives( drive_sequential_number INTEGER PRIMARY KEY, drive_serial_number TEXT NOT NULL, drive_model TEXT, base_board INTEGER NOT ...

X Description: What did you do? With the tables: CREATE TABLE IF NOT EXISTS single_drives( drive_sequential_number INTEGER PRIMARY KEY, drive_serial_number TEXT NOT NULL, drive_model TEXT, base_board INTEGER NOT ...

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/4155

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Bug]: Incorrect foreign key mismatch error","articleBody":"### What did you do?\n\nWith the tables:\n\n```\nCREATE TABLE IF NOT EXISTS single_drives(\n        drive_sequential_number     INTEGER PRIMARY KEY,\n        drive_serial_number         TEXT NOT NULL, \n        drive_model                 TEXT, \n        base_board                  INTEGER NOT NULL, \n        cpu_board                   INTEGER, \n        transistor_board            INTEGER, \n        filter_board                INTEGER, \n        fpga_firmware               TEXT,\n        dsp_firmware                TEXT, \n        boot_version                TEXT, \n        notes                       TEXT, \n        service_notes               TEXT, \n        previous_sequential_number  INTEGER,\n        UNIQUE(drive_sequential_number),\n        UNIQUE(drive_serial_number),\n        FOREIGN KEY(base_board)                 REFERENCES drive_base_boards(base_board_id)\n            ON UPDATE CASCADE\n            ON DELETE SET NULL,\n        FOREIGN KEY(cpu_board)                  REFERENCES drive_cpu_boards(cpu_board_id)\n            ON UPDATE CASCADE\n            ON DELETE SET NULL,\n        FOREIGN KEY(transistor_board)           REFERENCES drive_transistor_boards(transistor_board_id)\n            ON UPDATE CASCADE\n            ON DELETE SET NULL,\n        FOREIGN KEY(filter_board)               REFERENCES drive_cpu_boards(filter_board_id)\n            ON UPDATE CASCADE\n            ON DELETE SET NULL\n        FOREIGN KEY(previous_sequential_number) REFERENCES single_drives(drive_sequential_number)\n            ON UPDATE CASCADE\n            ON DELETE SET NULL\n\nCREATE TABLE IF NOT EXISTS drive_cpu_boards(\n        cpu_board_id               INTEGER PRIMARY KEY,\n        cpu_board_serial_number    TEXT NOT NULL,\n        UNIQUE(cpu_board_id)\n        UNIQUE(cpu_board_serial_number)\n        )\n```\n(other tables are present in the database, but I don't believe they are relevant to this error)\nI attempted to delete a row from the \"single_drives\" table by highlighting it in the Browse Data tab and pressing delete.\n\n### What did you expect to see?\n\nI expected the row to be deleted.\n\n### What did you see instead?\n\n\u003cimg width=\"499\" height=\"129\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/21433b89-d4a9-4ce2-944a-75c146e33aa1\" />\nI received this error message. This occurs no matter the row I try to delete, and errors based on this same foreign key mismatch occur in other parts of the database as well.\n\nI am able to delete rows from this and other tables when not using the browser, so this seems to be an issue with the browser and not the DB schema itself\n\n### DB4S Version\n\n3.13.1\n\n### What OS are you seeing the problem on?\n\nWindows\n\n### OS version\n\nWindows 11\n\n### Relevant log output\n\n```shell\n\n```\n\n### Prevention against duplicate issues\n\n- [x] I have searched for similar issues","author":{"url":"https://github.com/VamcoDThomson","@type":"Person","name":"VamcoDThomson"},"datePublished":"2026-06-24T19:13:54Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/4155"}

react-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:8af18779-b838-925c-8b02-fcded48a093d
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idCDBE:250B41:1B0A5:24584:6AFD286B
html-safe-nonce3a2383dc39a8727f3f6d37a534260eb9a655539e25f5ffa1ad6523f457b3bd28
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDREJFOjI1MEI0MToxQjBBNToyNDU4NDo2QUZEMjg2QiIsInZpc2l0b3JfaWQiOiI0MzQ5ODE1NTY3NzYzMTg3ODE5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmacd4290b052048a0f4955e1750158b9ae7fefad25cc9119144f853ab0256af0ed8
hovercard-subject-tagissue:4737689725
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/4155/issue_layout
twitter:imagehttps://opengraph.githubassets.com/1c270fdcbd26d788278a67c27f9f36142482859602a24004b33a54ec5ded51ad/sqlitebrowser/sqlitebrowser/issues/4155
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/1c270fdcbd26d788278a67c27f9f36142482859602a24004b33a54ec5ded51ad/sqlitebrowser/sqlitebrowser/issues/4155
og:image:altWhat did you do? With the tables: CREATE TABLE IF NOT EXISTS single_drives( drive_sequential_number INTEGER PRIMARY KEY, drive_serial_number TEXT NOT NULL, drive_model TEXT, base_board INTEGER NOT ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameVamcoDThomson
hostnamegithub.com
expected-hostnamegithub.com
None065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release941021edf0c2ec58298f4a2c8f27ae507d129c92
ui-targetcanary-2
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/4155#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F4155
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F4155
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4155
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4155
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4155
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4155
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4155
[Bug]: Incorrect foreign key mismatch errorhttps://github.com/sqlitebrowser/sqlitebrowser/issues/4155#top
https://github.com/VamcoDThomson
VamcoDThomsonhttps://github.com/VamcoDThomson
on Jun 24, 2026https://github.com/sqlitebrowser/sqlitebrowser/issues/4155#issue-4737689725
https://private-user-images.githubusercontent.com/209531096/612654279-21433b89-d4a9-4ce2-944a-75c146e33aa1.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3OTQ5NzYxNTEsIm5iZiI6MTc5NDk3NTg1MSwicGF0aCI6Ii8yMDk1MzEwOTYvNjEyNjU0Mjc5LTIxNDMzYjg5LWQ0YTktNGNlMi05NDRhLTc1YzE0NmUzM2FhMS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjYxMTE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI2MTExOFQwNDI0MTFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jMDEwMTI2OWJiMzljYmQ2ZTk0ZGE1MzFkYjJhZjJlODBmYTk5MGNkNjZlMmUyMDdkNzk5MTc1Yzc0NDJkYTg2JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZyZXNwb25zZS1jb250ZW50LXR5cGU9aW1hZ2UlMkZwbmcifQ.SlTSF9aV4p2SWXDMyXtldXwk22UtwmxrhJTOzaAFrtA
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4155
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/4155
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.