OptionCart

Home

Features

Requirements

COMMON INSTALLATION ERRORS

Still having problems? The following are common errors that occur and instructions on how to fix them:

You get the error message: "Unknown MySQL Server Host 'localhost' ... Unable to connect to database"

This usually means that "localhost" is not actually the host that you need to use to connect to your database. Check with your hosting company to see what host name you need to use for the connection, then modify the host name in the dbconfig.php file in the secure directory.

You get the error message: "Unable to select database"

This usually means that your database either doesn't exist, the name is incorrect, or the database doesn't have any tables in it. Make sure that you've created the database and the database tables have been loaded into the database, and that the correct database name is specified in the dbconfig.php file in the secure directory.

Also check to ensure that your user name is associated with the database. After adding a mySQL user and password, make sure to click "Add User to Database" to associate that user with the database.

Finally, check your database prefixes. On some servers (like Alabanza hosts and cPanel servers), you will need to prefix your mySQL database with your hosting user name. So if you create the user name "catuser", your mySQL user name may be "yoursite_catuser".

You get the error message: "Access denied for user: 'databaseuser @ localhost' ... Unable to connect to database"

This usually means that your database user name or password is either incorrect, or not established yet. If you are using a user name and password that is different from your hosting user name and password, make sure that you have added that user name and password that is set in your dbconfig.php file (in the secure directory) into your control panel.

Also check to ensure that your user name is associated with the database. After adding a mySQL user and password, make sure to click "Add User to Database" to associate that user with the database.

Check your mySQL user name. Even though you can create a user name with more than 8 characters, when you call it in your config file, you will only need the first 8 characters. So if your user name is mysite_cataloguser, you will use mysite_catalogu in the dbconfig.php file.

Finally, check your mySQL user name prefixes. On some servers (like Alabanza hosts and cPanel servers), you will need to prefix your mySQL user name with your hosting user name. So if you create the user name "catuser", your mySQL user name may be "yoursite_catuser".

You get the error message: "Unable to access database."

This usually means that the openinfo statement is not placed at the top of your catalog page. Go in to your catalog page and make sure that this code:
<script language=”php”>include(“inc/openinfo.php”);</script> is at the very top of the page, above the <html> tag.

You get the error message: "Domain info is not correct ... Please re-enter variables."

This means that your keycode that is used to unlock your catalog is incorrect. Go into your shop administration area and add the keycode that was given to you with your installation. If you do not have the key code, send us an email with your order number and web site, and we'll send you the unlock code.

You get the error message "Failed opening '/home/yoursite/public_html/secure/dbconfig.php' for inclusion ... No such file or directory"

The dbconfig.php file is not in the folder named secure on your site, it is named something other than dbconfig.php, or else the path to the secure folder is incorrect.

If you've moved the dbconfig.php file to your root directory, make sure to also adjust the path in your open.inc file, located in the inc directory. The default path is "$DOCUMENT_ROOT/secure/dbconfig.php" - you will need to change this, usually to "/home/yoursite/dbconfig.php". Ask your host to send you the path to your root directory if you still have problems.

You get a 403 error (Forbidden page) when you try to access your administration area via http://www.yoursite.com/shopadmin/.

Some web hosts may not recognize PHP pages for index pages. You can access your administration area at http://www.yoursite.com/shopadmin/index.php.

You cannot load the catalog.sql file - instead, you get an error.

You can load the database tables several different ways. The most common method is to use the "Browse" button in the sql upload area of phpMyAdmin, select the catalog.sql file that you've saved to your desktop, and load the database tables. See our database help for details.

If you receive errors, try copying the data from the catalog.sql file and pasting it into the Run SQL query/queries box in phpMyAdmin. Still having problems? Try copying one CREATE query at a time, then pasting it into the Run SQL query/queries box.

If you continue to have problems, you may need to create PHP create statements and load the database via the web browser. This method is not supported by OptionCart, though we can install the database this way for an additional fee.

Your catalog page appears, but there is no catalog products on the page.

Make sure that you have added the include statements into your catalog page. For more information, see our template setup instructions.

Also, if you are using .htm or .html extensions as your catalog page extension, be sure that you have added a MIME type for that extension. Note that for some hosts, this may not be possible. On some servers, if you use FrontPage extensions, you may have problems adding MIME types. If you can't get your system to work, either ask your host for assistance or change the catalog to use a .php extension.

You have installed the catalog. But when you try to update your catalog page, no new information appears on the catalog page.

Make sure that you are not pulling your catalog page directly from the browser when you update the file. If you do this, you won't pull the PHP code in the page, and it won't display any new files.

Instead, pull the file directly from the file you have on your desktop. Or make sure to follow our template setup instructions to create a new catalog page.

You can view most of the catalog components, but you see some errors on the page that says 'Warning: main(inc/file.php): failed to open stream.'

Make sure that you have included the correct codes into your catalog page. For example, if you have used include(“inc/searchbox.php”); instead of include(“inc/search.php”); the system is going to give an error message because the file “searchbox.php” does not exist.

The catalog works okay, except for the Continue Shopping link or wholesale area. I get an error that reads "Warning: Cannot modify header information - headers already sent"

This usually means that your openinfo statement is not at the top of the page. Go in to your catalog page and view the HTML code. The statement:
<script language=”php”>include(“inc/openinfo.php”);</script>
Should be at the very top of the page, above the <html> tag or any other code on that page. Move the statement to the top of the page and FTP the file back into the browser, and the error should disappear.

The image uploader isn’t working.

Access the imgload.php page and change the following:

copy($userfile, $RelImgName);

to:

Move_uploaded_file($userfile, $RelImgName);

Also make sure that the image directory has been chmoded to 777. Note that on some hosts, they may not allow you to upload files. Check with your host for a solution if this is the case.

Instead, pull the file directly from the file you have on your desktop. Or make sure to follow our template setup instructions to create a new catalog page.

Privacy Policy: We respect your privacy. We will never give your email to third party companies nor use it for sales
purposes. Emails are used only for support purposes or to relay information to you about your OptionCart systems.