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.