Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Request connection/TestConnectionRequest failed with message: Cannot convert undefined or null to object #431

Closed
ManPython opened this issue Oct 28, 2019 · 5 comments
Labels

Comments

@ManPython
Copy link

Describe the bug
Request connection/TestConnectionRequest failed with message: Cannot convert undefined or null to object

To Reproduce

  1. Trying open any .sqlite3 and test connection
  2. After save of connection the Unable to write into workspace settings. Please open the workspace settings to correct errors/warnings in the file and try again. - we often need use this tool in django, but file is used...so connections settings should offer save profile in any case of failed test

Expected behavior
See some data

Desktop (please complete the following information):
ext v0.21
Version: 1.39.2
Commit: 6ab598523be7a800d7f3eb4d92d7ab9a66069390
Date: 2019-10-15T15:35:18.241Z
Electron: 4.2.10
Chrome: 69.0.3497.128
Node.js: 10.11.0
V8: 6.9.427.31-electron.0
OS: Windows_NT x64 6.1.7601

@mtxr
Copy link
Owner

mtxr commented Nov 3, 2019

What happens if you try to update workspace settings manually?
This is a VSCode error. VScode is unable to save settings in your workspace.

Since we completely rely on VSCode settings API and it looks like a file permissions error, I'll close it for now. But please, keep me updated.

If you have any suggestions on how to do this, let me know.

@mtxr mtxr closed this as completed Nov 3, 2019
@mtxr mtxr added the invalid label Nov 3, 2019
@triage-new-issues triage-new-issues bot removed the triage label Nov 3, 2019
@ManPython
Copy link
Author

When trying change in profile then
You need to fix some issues in your machine first. Check the notifications on bottom-right before moving forward.
When trying select the profile of connection then I see on notification:
You need to install sqlite3@4.0.8 to connect test source: sqltools...
When trying install by "install now" then:

Failed to install dependencies for SQLite: Request DependencyInstaller/install failed with message: 
You need to install node@6 or newer and npm first to install dependencies. Install it and restart to continue.

details:

DEBUG: Settings updated!
INFO: Telemetry enabled!
DEBUG: Event: sessionStarted:extension 
DEBUG: Activation time: 1092.05243ms
INFO: Executing SQLTools.getConnectionStatus
DEBUG: Connection explorer updated.
INFO: Executing SQLTools.selectConnection
INFO: Executing SQLTools.selectConnection
ERROR: Error:  { Error: Request DependencyInstaller/install failed with message: You need to install node@6 or newer and npm first to install dependencies. Install it and restart to continue.
    at e:\Microsoft\.vscode\extensions\mtxr.sqltools-0.21.1\extension.js:1:22985
    at e:\Microsoft\.vscode\extensions\mtxr.sqltools-0.21.1\extension.js:1:23392
    at Immediate.messageQueue.size.setImmediate (e:\Microsoft\.vscode\extensions\mtxr.sqltools-0.21.1\extension.js:1:23936)
    at runCallback (timers.js:694:18)
    at tryOnImmediate (timers.js:665:5)
    at processImmediate (timers.js:647:5)
    at process.topLevelDomainCallback (domain.js:121:23)
 code: -32603, data: undefined }
INFO: Executing SQLTools.showOutputChannel

@mtxr
Copy link
Owner

mtxr commented Nov 4, 2019

Just checking, did you enable setting "sqltools.useNodeRuntime": true, as in https://vscode-sqltools.mteixeira.dev/driver/sqlite#1-prerequisites?

Check here an working example: https://github.com/mtxr/vscode-sqltools/blob/master/.test-database/project.code-workspace#L31

I see you have node 10.11.0 installed, so it's probably just a matter of enabling node binary.

@ManPython
Copy link
Author

"sqltools.useNodeRuntime": true, exist.
But I not instaled node manualy or not do anything with this env. I belive that VSC do this or this ext. Should I do here something? There is no instruction or information that is required to do.

@ManPython
Copy link
Author

Looks that problems exist with sqlite. The test with mysql was ok. HVR I uninstaled this ext due that not speending my needs - I expect some option to write scripts, save these as files in dir and run if required to see data.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants