Fatal error: Call to undefined function WA_eCDB_ConvertNumber()

A couple times after running all wizards necessary to get a full checkout cart, on the last page after I click the checkout button, instead of loading checkout_success.php, I get either stuck on or sent back to confirm.php with this error (or similar):

Fatal error: Call to undefined function WA_eCDB_ConvertNumber() in /Users/myuser/Sites/mysite/confirm.php on line 148

Line 148 is "$WA_fieldValuesStr =" section from the "// WA eCart Store Cart Summary in Db" function.

I've attached the page for an example.

How is it that the page does not know what the function means ... is there some include missing?

Thanks

move line 266 - 265:

<?php

//WA eCart Include

require_once("WA_eCart/WA_eCart_Database_PHP.php");

?>

to line 1.

That cleared up the problem with that error. Then I get a timezone warning (I get that one all the time, telling me I can't rely n the system timezone but must set it manually). I fix that error by manually removing from the code the parts where it's trying to insert a date/timestamp into the "orderdate" field of the orders table (summary insert) (to be honest, I don't understand why php needs to insert a timestamp, instead of letting mysql insert the time automatically).

After that, the order goes through, but no new records are entered into the orderdetails table (which is called "rosters" in my DB).

try changing the trigger for the eCart store order summery and store order details to use the Button submit order pressed trigger instead of the currant page submit trigger.

Thank you for helping, Jason...

After changing the trigger to "Button submit order pressed" for both order details and order summary in the Server Behaviours, the situation is the same: the order summary goes in nicely but there is no new DB record for the details

By the way it is reaching the checkous_success.php without any errors, it looks normal:

Order Authorized
Thank you for your order

Your order has been authorized and your payment accepted.

.... it's just not inserting the order details.

Is there any sort of debug mode to enable that would cause it to print out more info on what's going wrong internally? I don't know must about the internals of php or eCart yet ...

send me the most recent copy of your confirm page, and I'll give some debug tips.

In case it helps any, I'm attaching the last 3 pages (checkout, confirm, checkout_success php's).

the first thing to check is whether it is getting into the store order details code.

Find the following at line 204 - 207:

<?php 

// WA eCart Store Cart Details in Db

if (isset($_POST["Submit_order"])) // Trigger

{

and change it to:

<?php 

// WA eCart Store Cart Details in Db

if (isset($_POST["Submit_order"])) // Trigger

{

die("in details");

if it gets to the store order details behavior, you should have a blank screen saying "in details"

remove the die statement, then change line 247:

$WA_sql = "insert into ".$WA_table." (".$insertParamsObj->WA_tableValues.") values (".$insertParamsObj->WA_dbValues.")";

to:

$WA_sql = "insert into ".$WA_table." (".$insertParamsObj->WA_tableValues.") values (".$insertParamsObj->WA_dbValues.")";

die($WA_sql);

this will give a blank screen with the SQL being used, copy this and go to PHPMyAdmin paste this into the sql screen and see what happens. This may give an error that you where missing before.

Originally Said By: Jason Byrnes

  Find the following at line 204 - 207:
...
and change it to:

php:

...

die("in details");

if it gets to the store order details behavior, you should have a blank screen saying "in details"  

That much is correct.

Originally Said By: Jason Byrnes

  remove the die statement, then change line 247:

php:

...

die($WA_sql);

this will give a blank screen with the SQL being used, copy this and go to PHPMyAdmin paste this into the sql screen and see what happens. This may give an error that you where missing before.  

No, I just get the regular order confirmation page:

Order Authorized
Thank you for your order

Your order has been authorized and your payment accepted.

And again there is a new row in the summary DB table but not in the details table ("rosters").