Number of variables doesn't match number of parameters

[kiwipole]

I’m experimenting with the direct grid pt2 tutorial http://(http://docs.sencha.com/ext-j...irect_grid_pt2 . The original code works 100 percent but when I try to utilise my own MySql table that has one column less than the “owners” table and alter the code in grid.js and querydatabase.php to reflect the change I get the an error:

Number of variables doesn't match number of parameters in prepared statement in
{"type":"rpc","tid":2,"action":"QueryDatabase","method":"createRecord","result":{"id":0,"name":"fred","state":"NJ"}}"

Any pointers to what else should be updated?

[mitchellsimoens]

This is just when you try to load the store?

[kiwipole]

It only happens on:
create: QueryDatabase.createRecord
and
update:QueryDatabase.updateRecord

[kiwipole]

Solved.

I had an incorrect number of the

bind_param ('sssi')

that included an extra string indicator.