SalesCart add-on components.
This FAQ contains answers to questions that pertain to
the SalesCart add-on components. If you are looking for answers to questions regarding
customization of your SalesCart web, see our 'Advanced' FAQ
page. If you are looking for answers to questions regarding setup problems, error
messages, and common setup issues and mistakes, see our 'Setup'
FAQ page.
This FAQ is being updated on a regular basis, come back
and check for new issues, and tips.
Note: sometimes error message
wording may not be 'exactly' the same as that listed below.
UPS Auto Calculator - CGI Error The specified
CGI application misbehaved by not returning a complete set of HTTP headers. The headers it
did return are: Died at G:\your-web-directory\cgi-bin\upscalc.pl line 246.
or
CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
Can't open upsshipping.htx for reading (No such file or directory) - Check
with your ISP at C:\Inetpub\wwwroot\AllBodyTraining\cgi-bin\upscalc.pl line
258.
AuthorizeNet - Upon entering the receipt page
we received the following errors: [state=37000][error 3503][Microsoft][ODBCMircosoft
Access 97 Driver]Syntax error in update statement. The order although was processed
through Authorize net.
UPS Auto Calculator - UPS Auto Calculator
returns a page but there are no UPS shipping options to choose from and there are no
errors reported.
AuthorizeNet - After Returning from the
AuthorizeNet session: I get the following error.
Error Performing Query
[State=07001][Error=-3010][Microsoft][ODBC Microsoft Access 97 Driver] Too
few parameters. Expected 5.
-
UPS Auto Calculator - When error checking is turned on to Debug=2, the
error message indicates that the Socket Failed
-
I have the Email confirmation program and
get the following error whenever the program tries to send an email
confirmation.
CGI Error
The specified CGI application misbehaved by not returning a complete set
of HTTP headers. The headers it did return are:
Can't open a mail file: Permission denied
-
I have the Email confirmation program and
get the following error whenever the program tries to send an email
confirmation.
Microsoft VBScript runtime error '800a0046'
Permission denied
/cgi-bin/merc-conf.asp, line 59
-
I have the UPS Auto Calculator and after I
provide a zip code, I get no results returned and get the following
message
'D:\Web
Sites\mysite\public_html\cgi-bin\upscalc.px' script produced no
output
-
My UPS Calculator is missing UPS Ground Commercial! Where did it go?
-
My
SurePay Gateway Plug-in stopped working and nothing happens when I click
on the continue order button.
-
Online Order
Retrieval Plug-In - When I go to the online/orderbyrange.asp page the
following error occurs:
-
The dynamic database plug-in for my SalesCart X Search results not paging
at all. What do I need to do?
This is caused by the extension of the Perl script not being
compatible with the server running Perl. Contact your server adminstrator. A quick fix for
some NT servers is to replace the extension .pl with .px . for the upscalc.pl file. As
noted in the UPS autocalculator read me, the extension is based on the servers Perl
handling settings.
There are 2 different ways to solve this problem.
1. Install the PERL ISAPI dll and rename the upscalc.px. This is the best
option perl programs run about 10 times faster against the isapi dll instead of the perl
.exe. The perl isapi dll also does not require headers making programming much
easier. The PERL isapi dll can be obtained at activestate
http://www.activestate.com/overview.htm.
The last reported exact link is http://www.activestate.com/pw32/plis.htm.
2. Edit the UPSCalc.pl file and go to the "very top of the working part of the
program" and look for these lines.
$add_profit = 0;
$debug = 0;
$error = 0;
$ShipCountry = "US";
$rstring .= "upsshipping.htx";
$estring .= "upserror.htx";
$errorcode = "<center><H2>No Error
Specified<\/H2></center>";
Change the $rstring and $estring so that they incorporate the "absolute"
folder/directory path of exactly where these two files are. For example,
$add_profit = 0;
$debug = 0;
$error = 0;
$ShipCountry = "US";
$rstring .= "C:/inetpub/wwwroot/myweb/cgi-bin/upsshipping.htx";
$estring .= "C:/inetpub/wwwroot/myweb/cgi-bin/upserror.htx";
$errorcode = "<center><H2>No Error
Specified<\/H2></center>";
Upon entering the receipt page we received
the following errors: [state=37000][error 3503][Microsoft][ODBCMircosoft Access 97
Driver]Syntax error in update statement. The order although was processed through
Authorize net.
This is caused by a bug in the
Update-AuthorizeNet script which
is provided by "AuthorizeNet". This script is suppose to set your
"Return URL Method" to post, however it does not. You need to go to your
AuthorizeNet Configuration page, go to your Web Link Options, and change the Return URL
Method to POST.
On March 1, 1999, UPS changed their UPS algorithm.
Although this error can be symbolic of another FAQ, typically, this is
because you have an older version of the UPS calculator which is not compatiable with the
new way UPS is doing things. Here's a way to check. Edit the UPSCalc.pl or
.px
file. The first few lines of the code should look like the following:
$add_profit = 0;
$debug = 0;
$error = 0;
$ShipCountry = "US";
$rstring .= "upsshipping.htx";
$estring .= "upserror.htx";
$errorcode = "<center><H2>No Error
Specified<\/H2></center>";
As you can see, the 4th line provides a default value for the
variable $ShipCountry, if this is not located in your file than you have an old version,
and you need to update this file with this hot fixed file.
After selecting the link, choose save to disk but rename the extension either .pl or
.px
and replace the current file in your cgi-bin folder with the same name with this file.
AuthorizeNet - After Returning from the
AuthorizeNet session: I get the following error.
Error Performing Query
[State=07001][Error=-3010][Microsoft][ODBC Microsoft Access 97 Driver] Too
few parameters. Expected 5.
This problem is caused when you do not replace the default
shop.mdb database that shipping with SalesCart 1.0 with the default shop.mdb database that
ships with AuthorizeNet. The AuthorizeNet transaction provides addition parameters
about the transaction that must be stored in the new database. The message is
complaining that it wants to store 5 parameters in the database but the version you have
does not allow it to.
UPS Auto Calculator - When error checking
is turned on to Debug=2, the error message indicates that the Socket Failed
Cause:
This is a very rare
error where your ISP has a proxy server or establish settings where the
localhost is defined indidually. You should not implement this fix
unless you are absolutely sure this is your problem.
Resolution:
Edit the UPSCalc.px script
and make the following changes.
Added the following at line 136:
$localhost = "www.yourdomain.com";
Changed line 151:
($name, $aliases, $type, $len, $localaddr) = gethostbyname ($localhost);
and coment out line 152.
I have the Email confirmation program and get
the following error whenever the program tries to send an email confirmation.
CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
Can't open a mail file: Permission denied
Cause:
This is caused by
incorrect NT file permissions for the cgi-bin folder. The script needs
to be able to read, write and create a temporary mail file and then to
subsequently delete that file after sending the e-mail.
Resolution:
Set the NTFS
permissions or have your ISP set the file permissions by highlighting the cgi-bin
folder using the windows explorer, right click on the folder and select
properties. Highlight the IUSR account and make the permission Change
(RWXD). Click on both check boxes to propagate the permissions to
lower directories. Click OK.
I have the Email confirmation program and get
the following error whenever the program tries to send an email confirmation.
Microsoft VBScript runtime error '800a0046'
Permission denied
/cgi-bin/merc-conf.asp, line 59
Cause:
This error results
with the Microsoft SMTP service is not installed on the IIS server you are
hosting your web site with.
Resolution:
Install and
check off the Microsoft SMTP service during the installation process of Option
Pack 4.0.
I have the UPS Auto Calculator and after I provide
a zip code, I get no results returned and get the following message
'D:\Web Sites\mysite\public_html\cgi-bin\upscalc.px' script produced no
output
Cause:
This error results
when a space has been inadvertently added to the order number on the view
order form button of a product page.
Resolution:
Edit your
product page and click within the button labeled View Order. Right click
and select Form Properties. Click on the Advanced button. Edit the
Order# field and remove the extraneous space after the field definition.
My UPS Calculator is missing UPS Ground Commercial! Where
did it go?
Cause:
UPS has changed the way
their shipping information is presented
to the UPS Calculator
Resolution: two versions the really explanatory one, and the
quick one.
1. Here is the really explanatory one:
You need to update your UPS Calculator. Follow these steps:
- Open up the localweb you wish to fix in FrontPage
- Open the "cgi-bin" folder
- Right click on upscal2.px and choose "Open With..."
- Select the Text Editor from the dialog and press "OK"
* You should now have the file open in Notepad
- From the "Search" menu, select Find
- in the text box, type "$upsmax" (no quotes), Press "Find
Next", then
"Cancel"
- "$upsmax" should be highlited in notepad.
- The line should read "$upsmax = $j-1;" (without quotes)
- Highlite the "-1" portion of the line, and press the Delete or
Backspace
key
- The line should now read "$upsmax = $j" (without quotes)
- From the "File" menu, select "Save"
- Exit Notepad
- Now publish your site to your remote web.
After following the above procedures your site should now list the UPS Ground Commercial on your shipping page.
2. Here is the really quick one:
You need to update your UPS Calculator. Follow these steps:
- Editthe upscal2.px file in the cgi-bin folder
- Search for te text "$upsmax" (no quotes)
- The line should read "$upsmax = $j-1;" (without quotes)
- Change the line to read "$upsmax = $j" (without quotes)
- Save the file
- Now publish your site to your remote web.
After following the above procedures your site should now list
the UPS Ground Commercial on your shipping page.
Back to Top
My SurePay Gateway
Plug-in stopped working and nothing happens when I click on the continue order
button.
SurePay has changed the testing URL for their
gateway. The address that the SurePay plug-in ships with no longer works. An
error will occure when testing.
New testing address:
https://xml.test.surepay.com
Database Results Error Description: [Microsoft][ODBC
Microsoft Access Driver] Characters found after end of SQL statement.
Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for
ODBC Drivers
For resolution please see the following Knowledge
Base Article at MicroSoft:
http://support.microsoft.com/support/kb/articles/Q229/3/00.ASP
Back
to Top
The dynamic database
plug-in for my SalesCart X Search results not paging at all. What do I
need to do?
Download the latest patch for the
SalesCart X Dynamic Database Plug-in!
Click Here
Back
to Top
|
