Error when updating record - Error 501 #259

dnnbuddy · 2019-11-26T13:12:11Z

Hi,

When we update records we always see the following error message in the console.

Error: http://google.github.io/lovefield/error_lookup/src/error_lookup.html?c=501

But the strange thing is after few edit efforts(few times of edits) error message won't appear afterward. Everything is working as expected. But with the initial page load, we always see the error message in the console.

Even with the above error message record is successfully getting updated as expected.

Please advise on any clue on how to proceed with this.

Thanks.
Thusitha

freshp86 · 2019-11-27T02:30:53Z

The error indicates that a parametrized query is executed without all parameters having been specified. Do you have such queries in your code?

dnnbuddy · 2019-11-27T03:12:24Z

We have parameterized queries and we follow the following pattern. Even this simple update throws the same error.

var t = this._tagTable;

var q = db.
    update(t).
    set(t._mode, lf.bind(1)).
    where(t.seq.eq(lf.bind(0)));

q.bind([seq, mode]).exec();

arthurhsu · 2020-01-19T01:26:57Z

Can you post complete code snippet?

I run the following code based on the TODO demo with no problem.

<!doctype html>
<html>
  <head>
    <meta charset="utf-8" />
    <title>Minimal example of using Lovefield</title>
    <script src="lovefield.min.js"></script>
  </head>
  <body>
    <script>

var schemaBuilder = lf.schema.create('todo', 1);

schemaBuilder.createTable('Item').
    addColumn('id', lf.Type.INTEGER).
    addColumn('description', lf.Type.STRING).
    addColumn('deadline', lf.Type.DATE_TIME).
    addColumn('done', lf.Type.BOOLEAN).
    addPrimaryKey(['id']).
    addIndex('idxDeadline', ['deadline'], false, lf.Order.DESC);

var todoDb;
var item;
schemaBuilder.connect().then(function(db) {
  todoDb = db;
  item = db.getSchema().table('Item');
  var row = item.createRow({
    'id': 1,
    'description': 'Get a cup of coffee',
    'deadline': new Date(),
    'done': false
  });

  return db.insertOrReplace().into(item).values([row]).exec();
}).then(function() {
  var q = todoDb
      .update(item)
      .set(item.description, lf.bind(1))
      .where(item.id.eq(lf.bind(0)));
  return q.bind([1, 'hohoho']).exec();
}).then(function() {
  return todoDb.select().from(item).where(item.done.eq(false)).exec();
}).then(function(results) {
  results.forEach(function(row) {
    console.log(row['description'], 'before', row['deadline']);
    document.body.textContent =
        row['description'] + ' before ' + row['deadline'];
  });
});

    </script>
  </body>
</html>

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error when updating record - Error 501 #259

Error when updating record - Error 501 #259

dnnbuddy commented Nov 26, 2019

freshp86 commented Nov 27, 2019

dnnbuddy commented Nov 27, 2019 •

edited

Loading

arthurhsu commented Jan 19, 2020 •

edited

Loading

Error when updating record - Error 501 #259

Error when updating record - Error 501 #259

Comments

dnnbuddy commented Nov 26, 2019

freshp86 commented Nov 27, 2019

dnnbuddy commented Nov 27, 2019 • edited Loading

arthurhsu commented Jan 19, 2020 • edited Loading

dnnbuddy commented Nov 27, 2019 •

edited

Loading

arthurhsu commented Jan 19, 2020 •

edited

Loading