- Error Message : This page contains secure and non secure items
- I get this message when I try to use the USPS module : United States Postal Service An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. What can I do?
- I have an error : 1016 - Can't open file '.MYI' (errno: 145)
- I have an error : Cannot Add Header Information - Headers Already Sent
- I have an error message : Cannot redeclare tep_db_connect()
- I have an error message : Warning: mysql_connect(): Can't connect to local MySQL server through socket
- I have configured shipping modules, but can only get Free Shipping, help!
- I just added Urgently Needed Admin Contribution and can NOT find it in the menu I added it to!
- I lost my Admin Password - what do I do?
- My text has been replaced by some weird label in ENTIRELY_UPPERCASE_LETTERS - HELP!!
- Why do I get a message : 500 Internal Server Error?
- Error Message : This page contains secure and non secure items
When the user enters a page protected using SSL they get the following error message :
This page contains both secure and non secure items
This is caused by hardcoded images or flash animations. To fix this make sure all images are referenced in the following way:
<?php
echo tep_image(DIR_WS_IMAGES . 'any_image.gif', 'any ALT text', '200', '250');
?>
All images which are also hyperlinks should be referenced using tep_href_link - like so:
<?php
echo '<a href="' . tep_href_link('your_directory/your_page.php') . '">' . tep_image(DIR_WS_IMAGES . your_image.gif) . '</a>';
?>
If you are using images in the stylesheet for backgrounds they should also use the relative address ... e.g. images/my_background.gif
[Back To Top]
- I get this message when I try to use the USPS module : United States Postal Service An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner. What can I do?
You have to sign up at www.uspswebtools.com. You will get your webtool username/password via email. Then call the following number and mention you're using osCommerce:
The ICCC is staffed from 7:00AM to 11:00PM Eastern Time.
Telephone: 1-800-344-7779
They will activate your account right over the phone. Make sure you enter your username/password in shipping admin.
This information courtesy tinafu. Thanks Tina!
[Back To Top]
- I have an error : 1016 - Can't open file '.MYI' (errno: 145)
Problem Summary:
The following error message is shown when a database table is corrupt and can no longer be accessed nor read properly:
1016 - Can't open file '.MYI' (errno: 145)
The error message will always be shown until the database table involved has been repaired.
Solution
The following methods are available to repair damaged database tables, depending on whether the database server is still running or not:
* Using the "myisamchk" command
The part in the commands below must be replaced with the actual database table name as shown in the error message.
Using the "repair table" SQL statement
The following SQL statement can be executed when the database server is still running:
repair table ;
This can be done using phpMyAdmin or, if the backup tool is available you can create a text file containing the command, upload it to your admin/backups directory and "restore" that file. This will feed the command to the server.
Using the "myisamchk" command
The following command, which is part of the MySQL installation, can be executed on the server when the database server is no longer running:
myisamchk /path/to/database/directory/.MYI
References:
MySQL Documentation : Corrupted MyISAM TablesMySQL Documentation : REPAIR TABLE SyntaxMySQL Documentation : myisamchk Invocation Syntax
[Back To Top]
- I have an error : Cannot Add Header Information - Headers Already Sent
Problem Summary :
The following warning message is shown when PHP experiences a problem:
Warning: Cannot add header information - headers already sent by (output started at /directory/to/starting_file.php:XXX) in /directory/to/calling_file.php on line XX
The problem occurs when content has been sent to the client and PHP has been instructed to set header parameters via the header() function, or when starting the session via the session_start() function. PHP can only set HTTP headers when no content has been sent to the client.
Solution
The problem can be solved by walking through the code logic flow in the files involved, which are mentioned in the warning message, to make sure no headers are being set after content has been sent to the client.
A common cause of the problem is the inclusion of "whitespace" (characters that may be printable but not visible to the eye) before the first tag with the files involved. By removing all spaces, tabs and other such characters so that is at the very end of the file, you can prevent content from being sent to the client and headers can be set safely.
Open the file in a text editor -> place your mouse cursor after the very last ?> tag at the very end of the file and press the 'delete' key on your computer keyboard. Make sure that whitespace does not exist before the opening.
[Back To Top]
- I have an error message : Cannot redeclare tep_db_connect()
Generally this is caused by uploading a main directory file into a language directory. Fix this by uploading the correct file to the language directory to which you have just uploaded.
[Back To Top]
- I have an error message : Warning: mysql_connect(): Can't connect to local MySQL server through socket
The error Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket filename or TCP/IP port number when trying to connect to the server.
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
in /var/www/html/store/catalog/includes/functions/database.php on line 19
Unable to connect to database server!
Solution : contact your host's tech support department.
[Back To Top]
- I have configured shipping modules, but can only get Free Shipping, help!
You must have a weight for at least one product before any shipping module will work.
[Back To Top]
- I just added Urgently Needed Admin Contribution and can NOT find it in the menu I added it to!
CRE Loaded has Admin Access with Levels, a multiple security level system to help secure your admin area. In order to use a new contribution in the Admin area, you must use Administration/ File Access to ¨Save¨ the new file into the menu folder in which you want it to appear. As the top level administrator this will allow the file to be visible to you. You may still have to change access levels on it in your Administrative Groups in order to allow or deny access.
[Back To Top]
- I lost my Admin Password - what do I do?
The login user and password for a new Loaded installation prior to version 6.15 was
user: admin @ localhost.com
password: admin
As of version 6.15 this is no longer the case. You must select a user id and password during installation.
If you 'lose' your admin password for any reason - you may be able to restore it if you can still access your database. In the admin table, find your admin login id and change the password field contents to '1060bdf4e47bc8b4ab3fb0cfea9ef70b:77' (without the single quotes). This will change your password to admin. Then logon using your previous user ID and change your password. If you do not recall your user ID, simply open the database table and read it.
Another potential cause would be an admin sessions error. This could be due to a directory not existing, or your host not allowing you access to it for security reasons. In this event, change the sessions system from the default "file based" system to the database "mysql" system.
This can be done by manually editing the includes/configure.php and admin/includes/configure.php files and changing the contents of the session type definition near the end of the file to "mysql".
If its a new store, simply reinstall, selecting mySQL or database based sessions during the install.
[Back To Top]
- My text has been replaced by some weird label in ENTIRELY_UPPERCASE_LETTERS - HELP!!
The osCommerce 2.x language system is very simple.
Generally, for each file in the script which contains code, there is a file in the language tree with the same name that holds all of the text which is displayed by that module.
For example :
checkout_success.php which handles processing of successful orders, gets its text from includes/languages//checkout_success.php.
The language file contain simple definition statements that hold the text you would want to display in the a particular language. includes/languages/english/checkout_success.php holds the English text, includes/languages/french/checkout_success.php holds the French language, etc.
The definitions look like this :
define ('THIS_TEXT_LABEL','Some text to print');
in the example above, THIS_TEXT_LABEL is a php constant.
That is, once it is defined, it is not changed by the script during that session. The contents remain constant.
If a constant is not defined, the name of the constant is output by the script instead.
So, if on the checkout success page you see TABLE_HEADING_COMMENTS printed above the comments text area entry field, you will know that some error in the checkout _success.php language file has caused this constant not to be defined (perhaps you failed to terminate a line above this with a ; , or accidently commented it out).
To change the contents of these constants, it is merely necessary to change the text between the 2nd set of single quotes - taking care to use appropriate PHP character usage rules.
Those rules can be found at http://us3.php.net/types.string .
[Back To Top]
- Why do I get a message : 500 Internal Server Error?
This is a message from the Apache Web Server. It means that the servers configuration does not allow it to serve the page for some reason.
Contact your hosting provider ASAP.
[Back To Top]
|
|
