Editor stopped working, with an flummoxing error

robsimpson

Editor has stopped working. I am still on the trial (9 days to go apparently)

When I try to edit a field, I get the following output in my server console:

{
  method: 'update',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [ 'HR Managerx', '5' ],
  __knexQueryUid: 'oc3oXGmDHdMrQtFfIB_rV',
  sql: 'update "__twentysix_test" set "job_title" = ? where "id" = ?',
  returning: undefined
}
Unhandled promise error:  [object Promise]error: update "__twentysix_test" set "job_title" = $1 where "id" = $2 - column "Salary Min" does not exist
stack: error: update "__twentysix_test" set "job_title" = $1 where "id" = $2 - column "Salary Min" does not exist
    at Parser.parseErrorMessage (C:\Users\...\serverless3\node_modules\pg-protocol\src\parser.ts:369:69)
    at Parser.handlePacket (C:\Users\...\serverless3\node_modules\pg-protocol\src\parser.ts:188:21)
    at Parser.parse (C:\Users\...\serverless3\node_modules\pg-protocol\src\parser.ts:103:30)
    at Socket.<anonymous> (C:\Users\...\serverless3\node_modules\pg-protocol\src\index.ts:7:48)
    at Socket.emit (node:events:527:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Socket.Readable.push (node:internal/streams/readable:228:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

This is very odd, as:
* column "Salary Min" doesn't appear in the stated query
* "Salary Min" is not in the table at all, nor does that string appear anywhere in the uncompiled code
* "Salary Min" was a field in a table I was working with several days ago, but Editor has been successfully working on my newer tables until now.

Where is this ghost field coming from?

Thanks in desperation,

Rob

robsimpson

Ah, tracked it down to something on the DB.. Nothing to do with DT, sorry!

allan

Thanks for posting back. Good to hear you've got it working now.

Allan

robsimpson

This is an amazing product!