SalesCart Setup
and Common Issues
This FAQ contains answers to questions that pertain to
setup problems, error messages, and common setup issues and mistakes. 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 SalesCart add-on components, see our
'Add-ons'
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.
Cannot add (SalesCart) product
link in the "insert FrontPage Component" selection box, it doesn't exist!
"Microsoft JScript runtime
error '800a01c2' Wrong number of arguments or invalid property assignment
/myweb/mall/getorder.asp, line 20"
HTTP Error 403 403.1 Forbidden:
Execute Access Forbidden. This error can be caused if you try to execute a CGI, ISAPI, or
other executable program from a directory that does not allow programs to be executed.
Microsoft OLE DB Provider for ODBC
Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified /mall/getorder.asp, line 10
Front Page "crashes" when trying to
create a SalesCart web.
'ODBC; Zero length string' error. When
customers delete credit card information when placing an order.
Error Performing
Query[State=37000][Error=-3100][Microsoft][ODBC Microsoft Access 97 Driver] Syntax error
(missing operator) in query expression.
HTTP:1.00 INVALID APPLICATION NAME.
FrontPage requires 32-bit TCP/IP networking.
You do not have 32-bit TCP/IP networking installed. Would you like to see help on how to
install it?
The sales tax shows on the confirm order page,
but disappears on the reciept page.
Error Performing Query; The query file
C:\InetPub\wwwroot\cgi-bin\shop.idc could not be opened. The file may not exist or you may
have insufficient permission to open the file.
'The contents of a FrontPage component have
been modified. These contents will be overwritten when you save this page.' When a
SalesCart product page is opened in FrontPage editor.
Microsoft OLE DB Provider for ODB Drivers
error 80004005....operation must use an updatable query.
I select the 'View Confirmed Orders' button,
in the oders database, and no orders are shown, even though I know there are confirmed
orders.
Trial Version: The file will not extract. When
I double click the self extracting execuatble I get; "WinZip
Self-Extractor header corrupt. Possible cause: bad disk or file transfer error."
I am seeing a "NaN" error in the
total field on the confirmation page if I enter several (5-15) separate items. This seams
to be an intermittent error.
When I try to open my web at http://my-machine-name
I get the following error, "There is no server on port 80:".
How do I download my database to view my
orders? I keep getting errors, or the database locks up and I can't place orders.
How do I upload my database after I have
changed it? I keep getting "not allowed" or "in use" errors.
Is SalesCart 1.0 and 1.2 compatiable with
FrontPage2000?
I have plenty of disk space but
I get the following disk space error when I try and install the software:
"Not enough Disk Space" Dialog box: Not enough disk space
on the target while attempting to copy files.
To continue first free disk space on the target drive then click OK.
I'm trying to install Option
Pack 4.0 so that I can install SalesCart. However, Option Pack 4.0
keeps stoping half-way through the install complaining that it was unable to
write and initialize the Transaction server in the registry.
I'm trying to install
SalesCart. However,
the SalesCart install is complaining that Option Pack 4.0 (MTS).... is not
installed.
The view order checkout page and
order database shows a subtotal as the year as 100, 101 or greater, rather than 2000. So for instance 11/1/2000 becomes
11/1/100
I've created a trial site. I can't add (SalesCart)
product link in the "insert FrontPage Component" selection box, it doesn't
exist!
Answer: This is a "feature" of
FrontPage and the purpose appears to be to protect you from installing software from
someone you don't know which turns out to be a virus or something worse.
To make the
component show up, follow these directions.
Directions: First, open FrontPage
Explorer on the Windows95 (client) machine where SalesCart is installed.
Select
File, then Open FrontPage Web, click on the "More Webs" button and type
127.0.0.1 in the field marked "Select a Web Server or Disk Location".
After typing in 127.0.0.1, press the Enter Key. In the field marked, "FrontPage
Webs Found at Location", select the very first top web and press OK.
In
FrontPage Explorer, click on Tools, then on web settings and view the FrontPage Web
settings. Click on the configuration tab and view the Web Name.
If the
field is not "grayed" out or contains a name, repeat the above procedure because
you don't have the root web opened.
Once you have confirmed that the web name is grayed out, select
Tools and Recalculate Hyperlinks from the FrontPage Explorer menu. Now, open up your
SalesCart web in FrontPage Explorer and select Tools and Recalculate Hyperlinks as
well. Edit one of the pages and select the component from the Insert menu.
The
first time it will warn you that you are installing foreign software, click OK on the box
and continue.
I have installed the demo on a win 95 machine with MS
personal Web Server. When I try to go to the Lobby page from the default page, Mall
Entrance, I get the following error, "Microsoft JScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment /myweb/mall/getorder.asp, line
20". What am I doing wrong?
Answer: This is caused by an incorrect and outdated
version of the MS personal Web Server. Microsoft has now released more than 4
versions of that server, but has not done the greatest job in documenting the different
versions in FrontPage. In fact, even the latest version of the PWS must be
downloaded on the NT IIS site which will be confusing until you get to the very end of the
process. Go to our download.htm
page and get the latest version of the MS personal web server (IIS/PWS 4.0, NT4.0 option
pack).
There are two possible causes of this problem. They both have
to do with the permission settings of the WEB site. The first has to do with your Front
Page permissions. The second is the permission settings for the IUSR_servername account
set at your WEB hosting company.
To set the Front Page permissions, open Front Page Explorer and
open the SalesCart web site you are working on, do the following;
In FrontPage explorer select 'Folders' view. Expand the list
under the folder 'http://127.0.0.1/test' by pressing the '+'.
The following folders need to have their permissions set:
'cgi-bin'; 'mall'; and 'orderdb'.
To change the permissions of the folders, right click on the
folder and select properties. You will see the following, (mall directory used for
example):
All three boxes (only two boxes will appear on some WEB
sites) should be checked. This allows programs and scripts to be run and files to be
browsed.
The 'orderdb' directory should have the 'Allow files to be
browsed' box unchecked. This prevents users from seeing your orders database,
'shop.mdb'.
Apply the changes to each directory.
If the above settings are correct and you still get an
error, you will need to contact your web hosting provider; To have your web
hosting company change the permissions of your IUSR_servername account; Call you web
hosting company and ask to have the permissions for the IUSR_servername account changed to
'CHANGE' for the 'cgi-bin'; 'mall'; and 'orderdb' directories of your web.
You do not have a DSN set up for your database. An ODBC, DSN is
required to run SalesCart, this procedure will create a DSN on your local machine named
'shop'. When you publish your SalesCart WEB to your internet hosting server, the internet
hosting provider will have to create a DSN for you, on the server. See the SalesCart help
file for more details on server requirements and DSN's.
Open the Windows Control Panel, (Start / Settings /
Control panel)
Open the '32 bit ODBC' tool.
Select the 'System DSN' tab, this is where you create your
system level DSN.
Select the 'Add' button and select the 'Microsoft Access
Driver [*.mdb]' and select 'Finish'.
A configuration window will open, 'ODBC Microsoft Access
Setup'. In the 'Data source name' field type "shop".
In the description field, type "Test WEB shop DSN"
or whatever you'd like for a description.
Under the 'Database' box select the 'Select..' button. This
will open a 'Select database' path tool. The database is found in the 'orderdb' directory
of your web site. The default path is 'C:/WEBSHARE/WWWROOT/TEST/ORDERDB', however
the path is dependent on your computer, and PWS setup.
Select 'OK', and select 'OK' again to exit out of the ODBC
tool.
Close control panel.
This is caused by having a demo version of SalesCart that is
out of date, (over 30 days old). If you have purchased SalesCart you need to use the
uninstall program and uninstall the original SalesCart demo. Then you install the full
version of SalesCart. We have seen some instances of uninstallation not correcting this
problem. If this is the case go to the SalesCart priority support page and fill out a
support request. instructions will be e-mailed to you.
If you want to allow persons to be able to delete the credit
card information do the following.
In Access, open the shop.mdb database.
Open the database for editing.
Open table view and select the 'payment' table.
Select design view, from the view menu.
Select the 'CardType' field and change the 'Allow Zero
Length' to Yes.
Do the same thing for the 'CardName',
'CardNumber', and
"CardExpire' fields.
Save and close the database.You will now be able to delete
the card information fields.
This is caused when you create a new product page and do not
save it with the .ASP extension, and / or place the new product page in the mall
directory. SalesCart product pages are Active Server Pages, but by default Front Page will
save them with the .htm extension. A new product page requires you to rename it with a
.ASP extension and place it in the mall directory.
This is a problem with ASP running on IIS3.0 caused where your
ISP has more than one ASP directory with the same name. If your ISP has more than
one customer running SalesCart or if you have more than one shopping cart running on the
same system, you must rename the /mall directory to have a unique name. Do the
following: Open up FrontPage Explorer and open your SalesCart shopping web, right
click on the folder /mall and select rename. Give the folder a unique name like
/mall2 or /mall3 or /your_company_name. Republish the site to the server.
This is a known error that occurs on some systems. The issue has to do with the a
faulty version of winsock32.dll. You can go to the Microsoft support article at:
http://support.microsoft.com/support/kb/articles/Q179/2/67.asp
this will give you the workaround.
This is a bug in SalesCart 1.0 that is being fixed with the next version. This bug will
only be seen on some browsers, (IE 4.01). The work around is as follows: Before continuing, make a backup copy of the 'reciept.htx' file in
the cgi-bin directory.
-
Open FrontPage and open your SalesCart web.
-
Open the 'confirm.htx' file from the 'cgi-bin' directory in FrontPage editor.
-
Select HTML viewing.
-
Select (highlight) for copying from 12th line of code that states "//begin
script" to the 59th line that states "//end script". Select 'Copy' from the
file menu.
-
Close the 'confirm.htx' file in FrontPage editor.
-
Open the 'reciept.htx' file from the 'cgi-bin' directory in FrontPage editor.
-
Select HTML viewing.
-
Select (highlight) for replacing from 12th line of code that states "//begin
script" to the 59th line that states "//end script". Select 'Paste' from
the file menu.
-
Select and delete two lines, no. 55 & 56 that state;
document.theend.elements[0].value = document.showtotal.total.value;
document.theend.elements[1].value = document.showtotal.taxes.value;
-
Save and close the reciept.htx file.
This is a permission setting problem, and is most likely a permission setting on the
server. See the section on setting the IUSR_server-name permissions HERE.
You will need to have your host provider set these settings for you.
This is a feature of Microsoft FrontPage. FrontPage checks to see of there are non
FrontPage web bots running on the page. It then gives the error message listed above to
let you know there is an unknown web bot on the page. Go ahead and select 'OK'. This
message will be repeated for each instance of a SalesCart product on a given product page.
The key here is the "operation must use an updatable query".
The error is stating that an update is not being allowed. This is a permission issue. The
answer is the same for the; HTTP Error 403 403.1 Forbidden:
Execute Access Forbidden. This error can be caused if you try to execute a CGI, ISAPI, or
other executable program from a directory that does not allow programs to be executed.
.
This is a bug in the current database that will be fixed with the next release the fix
is as follows:
-
Open the database in Access. If you have Access '97 it is preferable that the database
is converted to Access '97, but this is not required, see note below.
-
Open the database for editing and select the 'Queries' tab.
-
Select (single click) the 'ConfirmedOrder' query and select 'design' view.
-
On the 'Criteria' row, under 'Grandtotal' you will see <>0
, add a set of
quote marks around the 0 ..... <>"0" .
-
Save the database, this will fix the problem.
Note for users of Access '97 using an Access '95 database: You will not be able to
save the query directly. Instead use the 'File Save as / Export' command to save 'within
the current database' as ..."temp". Then open the "temp" query and use
the 'File Save as / Export' command to save 'within the current database' as
..."ConfirmedOrder", at which point you will be asked if you want to overwrite
the old query.
This is caused by a virus on your machine. Read all
details on removing the virus before attempting virus removal.
This has been found to be a virus that affects self-extracting zip files. The SalesCart
software that you downloaded is not infected, rather your system has been previously
infected. The name of the virus is W95.CIH and you can get a Norton Anti Virus program to
remove the virus at http://www.symantec.com/avcenter/kill_cih.html
. Read the directions on virus removal before attempting to remove the virus, or
you could spread it to all you files!
This appears to be an intermittent bug seen in an earlier person of
SalesCart. Upgrade to SalesCart 1.2 or later.
This is due to your Microsoft Personal Web Server either being off, or not installed
properly. If you have PWS installed select the PWS properties from control panel or the
taskbar and make sure it's running. If the PWS is installed and running, and you still get
the error contact Microsoft Technical Support
. If the PWS was not previously installed, see the downloads section of this support site.
Problems can occur when you do not download your database in a specific manner. The
issue is that Microsoft creates a .LDB 'lock database' file on the database on the server
when the database is in use, either by a customer on the we or someone viewing the
database directly. This does not mean that the database will only allow a single shopper
at a time, IIS handles multiple requests to single open databases via the ODBC DSN driver.
However, it does mean that opening the database directly from FrontPage will cause
the .LDB file to be created outside of the ODBC DSN driver, which will prevent others from
opening the database, including IIS. Therefore, do not open ANY
database directly from FrontPage. Whether it's a
SalesCart orders database or a products database, or any other type of database which you
are using for dynamic internet creation. The work around is as follows;
The procedure for FrontPage or FTP downloading is the same. This
example will describe the method for FrontPage, but FTP is basically the same.
-
Open the web in FrontPage explorer; (File / Open FrontPage web / More Webs / www.my-domain-name.com).
You should be opening the internet server web, not your local web on your local machine.
-
Open the orderdb folder, right click the database you want to download
(default is shop.mdb) and select copy.
-
Click on orderdb folder, and select 'Paste' from the 'Edit' menu. This
will create a file named "Copy_of_database-name(1).mdb" into the
orderdb folder.
-
Select the "Copy_of_database-name(1).mdb", and download it to your
local machine. In FrontPage use the 'File / Export' tool. Or if using FTP simply download
the file.
-
You can now open the database and retrieve your orders from the copy of the database on
your local machine.
The error is based on the same issues as those listed on question 18,
the issue now however is how to upload the database without causing problems.
When the database is in use by IIS ODBC, the .LAB locked database file is created. This
prevents the database from being written to outside of IIS. Therefore when your try to
upload your updated database you receive a "not allowed" or "in use"
error. The work around is to wait for a time period when the database is not in use. The
.LAB file is automatically removed when all connections to the database are closed. You
can then copy the database up. If you have a heavily trafficked site, it may be necessary
to wait until late evening, or even at worst case to temporarily deny access to your site
via the FrontPage permissions.
Yes, both SalesCart 1.0 and SalesCart 1.2 are "upgrade" compatiable with
FrontPage2000. The only real difference between the two programs is the
"physical" location of a few of the SalesCart files. That means if you
currently have SalesCart installed on FrontPage98 and click on the "upgrade"
button during the FrontPage2000 install process, FrontPage 2000 will automatically
"move" all of the SalesCart programs and files to the new location for you.
However, if install FrontPage2000 first, and then try and install SalesCart second,
SalesCart will put the files in the old "now wrong" location.
ComCity
currently has a version of SalesCart in Beta that solves this minor installation problem
and also provides an updated manual for the FrontPage 2000 interface and this should be
released shortly. All current users of SalesCart 1.0 and SalesCart 1.2 will receive
this as a FREE upgrade.
If you currently have FrontPage2000 and want to use SalesCart 1.0 or SalesCart 1.2,
follow this simple procedure to copy the files to the new locations that FrontPage2000
expects:
|
Step
|
Copy files FROM:
|
TO:
|
|
1
|
C:\Program Files\Microsoft
FrontPage\bots
\Shop Folder
Using the Windows Explorer,
highlight the entire Shop folder and select Copy from the Edit
Menu. Locate the destination C:\Program
Files\Microsoft Office\Office\bots and select Paste |
C:\Program
Files\Microsoft Office\Office \bots
\Shop Folder |
|
|
|
2
|
C:\Program Files\Microsoft
FrontPage\Webs\Salescart.tem Folder
Using
the Windows Explorer, highlight the entire Shop folder and
select Copy from the Edit Menu. Locate the destination C:\Program
Files\Microsoft Office\Templates\1003\Webs and select Paste |
C:\Program
Files\Microsoft Office\Templates\1033\Webs\Salescart.tem
Folder
|
"Not enough Disk Space" Dialog box:
Not enough disk
space on the target while attempting to copy files.
To continue first free disk space on the target drive then click OK.
The error means that you do not have FrontPage installed or do not have
the correct version of FrontPage installed for the particular software
version you have downloaded. The program believes theres not enough
space because you are trying to install the software to a place where the
software your suppose to have resides but doesn't.
Solution: Install the correct version of FrontPage either 98 or
2000 before installing the software.
This is a bug in PWS. Microsoft documents this on their web site
at http://support.microsoft.com/support/kb/articles/Q246/0/81.ASP?LNG=ENG&SA=ALLKB&FR=0
Solution#1:
The error is an error with Option Pack 4.0 and with Windows98.
There is a second version of Option Pack 4.0 from Microsoft that corrects
this problem. The specific problem has to do with the
MTSSETUP.DLL file.
Oddly enough the 'new' dll file has the same version # as the 'old' one
but the file sizes are different. The URL where to download this file is
listed below. If PWS4 is working, we suggest you DO NOT bother with this
patch.
Click here to get the updated patch/file.
Place this file in the same folder that has the setup.exe file for PWS4.
If
your running it off the CD you'll have to copy the contents of the folder
onto your HD.
Detailed Instructions to patch
Microsoft Option Pack 4.0 CD Install
-
Create a temporary directory on your c:\ drive.
Open File Manager by clicking on Start, then programs then Windows
Explorer. Click on C:\ and then File, New, Folder, type in the new
name of the folder as fixpws.
-
Insert your windows98 CD into the drive of your
computer. Highlight the CD drive "x" for the CD, open
the add-ons folder and then double click on PWS. Select Edit and
then Select all from the Menu and then Edit and Copy from the menu and
then go to the C:\fixpws folder and select Edit and then Paste from the
Menu.
-
Highlight the C:\fixpws
folder and on the right side of Windows Explorer select the mtssetup.dll
file and press the delete button.
-
Download the mtssetup.dll file from the link shown
above (http://www.salescart.com/support/files/mtssetup.dll and copy it
to the C:\fixpws folder and overwrite the existing file if you did not
delete it.
-
Now click on Start and Run and type C:\fixpws\setup.exe
and select OK.
Solution#2:
You can also simply repair the registry.
We recommend Solution #1,
but this method is quicker. Simply click below, download the file,
then double click on the file and install the registry patch.
PWS Transaction Server Registry Patch
There are two possible causes for this problem:
-
You really don't have Option Pack 4.0 installed.
-
You have a "bad" installation of Option Pack 4.0 installed.
Troubleshoot this problem first by determining what version of PWS you
have installed. We really suggest that you read the manual for this
because it contains a lot of information on this subject.
Click on Start, then control panel, if you have an Icon labeled Personal
Web Server...you have the old incorrect version of the web server which is
really now obsolete. Refer to the manual. You can download a copy
of the manual even if you do not currently have the software by going
here.
If not, then click on Start then Find Files and search for the file pws.exe
in the Windows\system folder. If you have that file, then you problem is
that you have a "bad" installation of Option Pack 4.0. Refer
to FAQ #22. If you do not have that file, then you have not installed Option
Pack 4.0. Refer to the manual. You can download a copy of the
manual even if you do not currently have the software by going
here.
This is a Y2k error with JavaScript running on Netscape 4.6 or greater.
This is not seen in earlier versions of Netscape or on Internet Explorer.
Download this hotfix for the view.htx page and replace your view.htx page in
the cgi-bin folder with this file instead.
Click to Download Updated view.htx file
|
