We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 41426
    • 2 Posts
    Hello!

    I am trying to create my own Formit snippet/hook but it doesn't seem to be working. I know my snippet is running because when I tell it to return true, it gives me a warning:

    Warning: PDOStatement::execute() [pdostatement.execute]:
    SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /home/msidev/public_html/fb/core/xpdo/om/xpdoobject.class.php on line
    236

    I just have one line in my snippet:

    return true;

    Here is my chunk:

    [[!FormIt?
    &store=`1`
    &hooks=`spam,CCProcessing,scCreateOrder,redirect`
    &submitVar=`checkout`
    &redirectTo=`[[~5]]`
    &validate=`firstname:required,
    lastname:required,
    address:required,
    city:required,
    state:required,
    zip:required,
    email:required`
    ]]
    [[!FormItRetriever? &redirectToOnNotFound=`[[*parent]]`]]
    <h1>Checkout</h1>
    [[!scGetCart? &view=`0`]]

    <div>Items: [[+cart.total.products]]</div>
    <div>Total: [[+cart.total.price]]</div>
    <div>[[!+fi.error_message]]</div>
    <div>Email: [[!+email]]</div>
    <div>Address: [[!+address]]</div>
    <form action="[[~[[*id]]]]" method="post">
    <fieldset id="Personal">
    <span class="label">First Name:</span>
    <input type="text" name="firstname" value="[[!+fi.firstname]]" />
    <span class="label">Last Name:</span>
    <input type="text" name="lastname" value="[[!+fi.lastname]]" />
    <span class="label">Address:</span>
    <input type="text" name="address" value="[[!+fi.address]]" />
    <span class="label">City:</span>
    <input type="text" name="city" value="[[!+fi.city]]" />
    <span class="label">State:</span>
    <input type="text" name="state" value="[[!+fi.state]]" />
    <span class="label">Zip:</span>
    <input type="text" name="zip" value="[[!+fi.zip]]" />
    <span class="label">Email:</span>
    <input type="text" name="email" value="[[!+fi.email]]" />
    </fieldset>
    [[!scPaymentMethods? &delivery=`[[+fi.deliveryMethod]]`]]
    <input type="submit" name="checkout" value="Send Your Order" />
    </form>

    I am using Simple Cart and their hook runs so I am suspecting that my hook being there is causing the error because if I take my hook out, I don't get an error. It's really weird because all my script does is return true.