when show table second time, it does not work, nothing to show

[lisonge]

[Xantim]

Two more people in my class also ran into this! Thanks for looking into it!

[weslleyalmeid]

I'm also having this problem and I know a few more people who are also having the same problems

[AlexCovizzi]

@weslleyalmeid @Xantim @lisonge I'll look into it this weekend, in the meantime, can you share the logs? In the configuration set "sqlite.logLevel": "DEBUG" and then run the command "SQLite: Show Output", thanks

[weslleyalmeid]

@weslleyalmeid @Xantim @lisonge I'll look into it this weekend, in the meantime, can you share the logs? In the configuration set "sqlite.logLevel": "DEBUG" and then run the command "SQLite: Show Output", thanks

first I run at 10:12 AM which worked perfectly, then I closed the side flap and at 10:13 I ran the command again and at that moment it didn't work, follow the log link SQLite: Show Output

[lisonge]

@AlexCovizzi

log record

log output

[下午12:25:07][vscode-sqlite][INFO] Activating extension vscode-sqlite v0.8.2...
[下午12:25:07][vscode-sqlite][INFO] Extension activated.
[下午12:25:11][vscode-sqlite][DEBUG] SQLite3 command: 'sqlite3'
[下午12:25:11][vscode-sqlite][DEBUG] Database path: 'e:\Documents\Projects\pixiv-bucket\assets\illust-info.db'
[下午12:25:11][vscode-sqlite][DEBUG] Query: SELECT * FROM `artwork`;
[下午12:25:11][vscode-sqlite][DEBUG] Statements:
[{"sql":"SELECT * FROM `artwork`;","position":{"start":[0,0],"end":[0,23]},"type":"SELECT"}]
[下午12:25:16][vscode-sqlite][DEBUG] SQLite3 command: 'sqlite3'
[下午12:25:16][vscode-sqlite][DEBUG] Database path: 'e:\Documents\Projects\pixiv-bucket\assets\illust-info.db'
[下午12:25:16][vscode-sqlite][DEBUG] Query: SELECT * FROM `artwork`;
[下午12:25:16][vscode-sqlite][DEBUG] Statements:
[{"sql":"SELECT * FROM `artwork`;","position":{"start":[0,0],"end":[0,23]},"type":"SELECT"}]

sqlite file: google drive

but i think this log is useless

[AlexCovizzi]

Looked into it, apparently the webview resources are not found the second time, maybe something was changed in th way that VSCode loads the resources, anyway I'm rewriting that part so it should be fixed in the next release

[luciano-schirmer]

Same issue here!

Looked into it, apparently the webview resources are not found the second time, maybe something was changed in th way that VSCode loads the resources, anyway I'm rewriting that part so it should be fixed in the next release

Thanks

[AlexCovizzi]

Fixed in version 0.9.0