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
Domain: github.com
{"@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-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:89f7f8ee-b784-c651-38cc-ee32b7d59cc6 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | B334:38F810:AB7069:ECAB19:6AFD3CAD |
| html-safe-nonce | df5d95a7b23949230af5a725b2d8be6c6afcbec199d7063538b3b0f5ae5f6b48 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMzM0OjM4RjgxMDpBQjcwNjk6RUNBQjE5OjZBRkQzQ0FEIiwidmlzaXRvcl9pZCI6IjYxMTkwNjA3MDg5MzI3OTU1NjUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 41b4df8e66d52bc37ac418a55ccdb95bc3f241f6217c73be17613be863a0d727 |
| hovercard-subject-tag | issue:354107081 |
| 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/1519/issue_layout |
| twitter:image | https://opengraph.githubassets.com/1bafa8c432333db4d75c15529b12c19f2c8df691ea709c8236956836703842af/sqlitebrowser/sqlitebrowser/issues/1519 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/1bafa8c432333db4d75c15529b12c19f2c8df691ea709c8236956836703842af/sqlitebrowser/sqlitebrowser/issues/1519 |
| og:image:alt | 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... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | VortixDev |
| hostname | github.com |
| expected-hostname | github.com |
| None | bdbacc25b921224ff0befcb9e629560a1255be51aec9991d6e3f95b5e9151474 |
| 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 | 556dd37bb0aceffb25724e151b5d858b3265b40b |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width