Open Jessinra opened 4 years ago
I get the error
Cannot desctructure property `name` of 'undefined' or 'null'.
when I use a table with a column called name
(with backticks around it). I put the backticks around "name" because it's a keyword in MySQL/MariaDB.
That said, the queries (inserts in my case) run successfully.
Ive had the same issue. In two of my projects. postgresql
@spiderrobb please confirm that you are using the latest versions of the extensions.
Describe the bug Unable to 'Show Table Records' with Postgres Connector
Logs [1598850286310] INFO (ext): EXECUTING COMMAND => sqltools.showOutputChannel [1598850312313] INFO (ext): EXECUTING COMMAND => sqltools.showRecords [1598850312314] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1598850312315] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1598850312316] INFO (ext): Connection explorer changed. Will be updated. ns: "conn-man:explorer" [1598850312402] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1598850312403] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1598850312448] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1598850312450] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1598850313320] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1598850313320] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1598850313322] INFO (ls): REQUEST RECEIVED => connection/RunCommandRequest [1598850313367] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1598850313367] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1598850313369] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1598850313370] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1598850313609] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1598850313610] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1598850313613] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1598850313614] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1598850314232] ERROR (ext): ERROR: Execute query error Cannot read property 'total' of undefined, 'Cannot read property 'total' of undefined' ns: "error-handler" [1598850314233] ERROR (ext): ERROR: Error while showing table records Cannot read property 'total' of undefined, {"code":-1,"data":{"driver":"PostgreSQL","driverOptions":{}}} ns: "error-handler"
To Reproduce Steps to reproduce the behaviour:
Expected behaviour The records of tables shown on a new tab
Screenshots
Desktop (please complete the following information):