René's URL Explorer Experiment


Title: "not an error" on SQL import · Issue #1519 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: "not an error" on SQL import · Issue #1519 · sqlitebrowser/sqlitebrowser

X Title: "not an error" on SQL import · Issue #1519 · sqlitebrowser/sqlitebrowser

Description: Details for the issue What did you do? I exported multiple tables from a database into a .sql file, and tried to import it into an existing database. What did you expect to see? A message indicating that the import had been completed, or...

Open Graph Description: Details for the issue What did you do? I exported multiple tables from a database into a .sql file, and tried to import it into an existing database. What did you expect to see? A message indicatin...

X Description: Details for the issue What did you do? I exported multiple tables from a database into a .sql file, and tried to import it into an existing database. What did you expect to see? A message indicatin...

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

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"\"not an error\" on SQL import","articleBody":"\u003c!--\r\nThanks for coming here to report a bug. :)\r\n\r\nPlease describe it in this section, fill out the correct check boxes\r\nbelow with an \"x\", then click the \"Submit new issue\" button at the bottom\r\n-->\r\n\r\nDetails for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\nI exported multiple tables from a database into a .sql file, and tried to import it into an existing database.\r\n\r\n#### What did you expect to see?\r\nA message indicating that the import had been completed, or an indication of why the import failed.\r\n\r\n#### What did you see instead?\r\nUpon importing, I received \"Error importing data: Error in statement #3: not an error. Aborting execution and rolling back.\" I copied the content of the .sql file into the \"Execute SQL\" tab and executed it there, where I was given a better indication of where the issue lay. The file includes references to other tables which were also being imported, and as the referenced tables were created later in the file, this seems to have caused the issue. An example of the SQL that caused the issue is \"CONSTRAINT `FK_1332519100` FOREIGN KEY(`ownerId`) REFERENCES `libk_player`(`id`) ON DELETE CASCADE ON UPDATE RESTRICT\", where the \"REFERENCES `libk_player`\" caused issue as libk_player was created later in the file. I had to move the \"CREATE TABLE\" query for the referenced tables above the queries that referenced them, and that resolved the issue.\r\n\r\nUseful extra information\r\n-------------------------\r\n\r\nThe info below often helps, please fill it out if you're able to. :)\r\n\r\n#### What operating system are you using?\r\n\r\n- [x] Windows: (version: 1803 Build 17134)\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### What is your DB4S version?\r\n\r\n- [x] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [ ] Other: ___\r\n\r\n#### Did you also\r\n\r\n- [x] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [x] Search 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/VortixDev","@type":"Person","name":"VortixDev"},"datePublished":"2018-08-26T16:16:25Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1519"}

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:89f7f8ee-b784-c651-38cc-ee32b7d59cc6
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idB334:38F810:AB7069:ECAB19:6AFD3CAD
html-safe-noncedf5d95a7b23949230af5a725b2d8be6c6afcbec199d7063538b3b0f5ae5f6b48
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMzM0OjM4RjgxMDpBQjcwNjk6RUNBQjE5OjZBRkQzQ0FEIiwidmlzaXRvcl9pZCI6IjYxMTkwNjA3MDg5MzI3OTU1NjUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmac41b4df8e66d52bc37ac418a55ccdb95bc3f241f6217c73be17613be863a0d727
hovercard-subject-tagissue:354107081
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/1519/issue_layout
twitter:imagehttps://opengraph.githubassets.com/1bafa8c432333db4d75c15529b12c19f2c8df691ea709c8236956836703842af/sqlitebrowser/sqlitebrowser/issues/1519
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/1bafa8c432333db4d75c15529b12c19f2c8df691ea709c8236956836703842af/sqlitebrowser/sqlitebrowser/issues/1519
og:image:altDetails for the issue What did you do? I exported multiple tables from a database into a .sql file, and tried to import it into an existing database. What did you expect to see? A message indicatin...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameVortixDev
hostnamegithub.com
expected-hostnamegithub.com
Nonebdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474
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
release556dd37bb0aceffb25724e151b5d858b3265b40b
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1519#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1519
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%2F1519
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/1519
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1519
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1519
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/1519
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1519
"not an error" on SQL importhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1519#top
https://github.com/MKleusberg
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
https://github.com/VortixDev
VortixDevhttps://github.com/VortixDev
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issue-354107081
#3https://github.com/sqlitebrowser/sqlitebrowser/pull/3
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
VortixDevhttps://github.com/VortixDev
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1809407721
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-416053488
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/VortixDev
VortixDevhttps://github.com/VortixDev
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-416071491
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-416072767
justinclifthttps://github.com/justinclift
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
on Aug 26, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1809511746
MKleusberghttps://github.com/MKleusberg
on Aug 27, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1811546815
Show better error messages when executing SQL scriptshttps://github.com/sqlitebrowser/sqlitebrowser/commit/ee736eb2dddf2b2d88b5db166d7db3d21901c552
ee736ebhttps://github.com/sqlitebrowser/sqlitebrowser/commit/ee736eb2dddf2b2d88b5db166d7db3d21901c552
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Aug 27, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-416362565
@VortixDevhttps://github.com/VortixDev
tomorrow's nightly buildhttps://nightlies.sqlitebrowser.org/latest/
MKleusberghttps://github.com/MKleusberg
on Aug 27, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1811558570
justinclifthttps://github.com/justinclift
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
on Aug 28, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1811900955
MKleusberghttps://github.com/MKleusberg
on Aug 28, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1813942608
Defer foreign keys during SQL importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/406734a2c9e21407009b5d78008a95ae040176fc
406734ahttps://github.com/sqlitebrowser/sqlitebrowser/commit/406734a2c9e21407009b5d78008a95ae040176fc
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Aug 28, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-416709566
@VortixDevhttps://github.com/VortixDev
mgrojohttps://github.com/mgrojo
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Sep 2, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-1822216222
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Sep 28, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-425504580
@VortixDevhttps://github.com/VortixDev
https://github.com/VortixDev
VortixDevhttps://github.com/VortixDev
on Oct 1, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-425949571
@MKleusberghttps://github.com/MKleusberg
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Jun 3, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#issuecomment-638195458
MKleusberghttps://github.com/MKleusberg
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jun 3, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-3402150807
MKleusberghttps://github.com/MKleusberg
response requestedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22response%20requested%22
on Jun 3, 2020https://github.com/sqlitebrowser/sqlitebrowser/issues/1519#event-3402151177
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1519
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1519
MKleusberghttps://github.com/MKleusberg
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.0 - Where we take over the world! :Dhttps://github.com/sqlitebrowser/sqlitebrowser/milestone/13
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.