1. #1
    Sencha User
    Join Date
    Nov 2008
    Posts
    3
    Vote Rating
    0
    kiwipole is on a distinguished road

      0  

    Default Number of variables doesn't match number of parameters

    Number of variables doesn't match number of parameters


    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?

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    37,330
    Vote Rating
    847
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    This is just when you try to load the store?
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/

    Need more help with your app? Hire Sencha Services services@sencha.com

    Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is in print!

    When posting code, please use BBCode's CODE tags.

  3. #3
    Sencha User
    Join Date
    Nov 2008
    Posts
    3
    Vote Rating
    0
    kiwipole is on a distinguished road

      0  

    Default


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

  4. #4
    Sencha User
    Join Date
    Nov 2008
    Posts
    3
    Vote Rating
    0
    kiwipole is on a distinguished road

      0  

    Default


    Solved.

    I had an incorrect number of the
    bind_param ('sssi')
    that included an extra string indicator.

Thread Participants: 1