close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Fatal error: Call to undefined function WA_eCDB_ConvertNumber()

Thread began 9/17/2010 12:21 pm by SaladoGuy | Last modified 9/21/2010 12:38 pm by SaladoGuy | 1922 views | 19 replies |

SaladoGuyBeta Tester

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

Sign in to reply to this post

Jason ByrnesWebAssist

move line 266 - 265:

php:
<?php

//WA eCart Include
require_once("WA_eCart/WA_eCart_Database_PHP.php");
?>



to line 1.

Sign in to reply to this post

SaladoGuyBeta Tester

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).

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

SaladoGuyBeta Tester

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

Sign in to reply to this post

SaladoGuyBeta Tester

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 ...

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

SaladoGuyBeta Tester

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

Attached Files
confirm_checkout_and_success.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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

Find the following at line 204 - 207:

php:
<?php 

// WA eCart Store Cart Details in Db
if (isset($_POST["Submit_order"])) // Trigger
{





and change it to:

php:
<?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:

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



to:

php:
$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.

Sign in to reply to this post

SaladoGuyBeta Tester

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").

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...