Have found a cached version on google, looks like it was on the new forum but has been deleted.
Any reason?
G
<b>IMPORTANT SECURITY PATCH FOR EXISTING AND NEW SITES (18/07/90). Follow the steps outlined at <a href="http://forums.oscommerce.com/index.php?showtopic=340995" target="_blank">SECURITY</a>.</b><br /><br />Hi<br />
<br />You may have noticed I answer quite a lot of questions on the forum, or I did when I wrote this, so first a plea, post your questions in the forum or see the comments in my Personal Statement. <br /><br />Most of the answers I give can be found by searching the forum, so whenever you get stuck, use google and use a search term like<br /><br />site:forums.oscommerce.
com xxxxxxxxxxxxxxx<br /><br />in the google search box. Or read this link <a href="http://forums.oscommerce.com/index.php?showtopic=222140" target="_blank"><a href='http://forums.oscommerce.com/index.php?showtopic=222140' class='bbc_url' title='External link' rel='nofollow'>http://forums.oscomm.
..howtopic=222140</a></a><br /><br />
Here are some links to answers and other info I have found useful.<br /><br />The first one is a roadmap for newbies by lindsayanng which gives a good overview of osc.<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=307356&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...=307356&hl=' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...o...=307356&hl=</a>
</a><br /><br />If you want to install osc and are stuck<br /><br />1. Create a blank database via your web hosting control panel. Each contol panel is different and your host's help desk or faqs should be able to help<br /><br />2. Download the latest osCommerce 2.2 RC2A zip file from the downloads section of www.oscommerce.com to your pc, unzip it. You will use the 'catalog' folder but it is worth browsing through the others.<br /><br />3. If you want your shop's URL to be www.yourdomain.com/catalog then upload the whole of the catalog folder to the root directory of your website via FTP. If you want the site to be available at www.yourdomain.com then just upload all of the contents of the catalog folder to the root directory of your website, but not the folder itself.<br /><br />4. Make sure that the permissions on all of the folders are set to 755, and if that does not work then set them to 777 and consider chaging host as you will get hacked. Make sure that the includes/configure.php file and the admin/includes/configure.php file are set to 777. These need to be restricted later. <br /><br />5. Then go to <a href="http://www.yourdomain.com/catalog/install" target="_blank"><a href='http://www.yourdomain.com/catalog/install' class='bbc_url' title='External link' rel='nofollow'>http://www.yourdomai.
..catalog/install</a></a> or <a href="http://www.yourdomain.com/install" target="_blank"><a href='http://www.yourdomain.com/install' class='bbc_url' title='External link' rel='nofollow'>http://www.yourdomain.
com/install</a></a> and follow the on-line install procedure. You will be prompted to enter various pieces of information.<br /><br />5a. Set DB Server to 'localhost', If that doesn't work there may be different db server settings which your host might have told you or it is somewhere on the control panel after you have created the db e.g. db_name.db.999999.hostedserver.
com<br /><br />5.b Your db user name and password (for mysql access) should have been provided to you by your web hosting company but you might have created and new name and password in step 1. <br /><br />5.c The name of the database you should know - because you just set it up. <br /><br />5.d Do not enable SSL unless you already have it installed or intend to shortly, elect to store sessions in the database and not files (untick the box), and do not enable persistent connections.<br /><br />6. After the install is complete create a folder called 'backups' inside the 'admin' folder (via FTP), and delete the install folder. <br /><br />6a. IMPORTANT STEP FOR EXISTING AND NEW SITES (18/07/90). Follow the steps outlined at <a href="http://forums.oscommerce.com/index.php?showtopic=340995" target="_blank">SECURITY</a>.<br /><br />7. Reset permissions on the two configure.php files to 644, 444, or 400 depending on your server setup.<br /><br />8. Password Protect your 'admin' folder using the Password Protect feature in your web hosting control panel.<br /><br />Once you have it installed the first 2 threads in the installation forum covers how to do loads of basic things.<br /><br /><a href="http://forums.oscommerce.com/index.php?showforum=1" target="_blank"><a href='http://forums.oscommerce.com/index.php?showforum=1' class='bbc_url' title='External link' rel='nofollow'>http://
forums.oscomm...php?showforum=1</a>
</a> <br /><br />as does this one :- <a href="http://forums.oscommerce.com/index.php?showtopic=24319&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...c=24319&hl=' class='bbc_url' title='External link' rel='nofollow'>http://forums.oscomm.
..o...c=24319&hl=</a></a>
<br /><br />Also the documentation that comes with the download of your version of osc will be a good first stop or if it is not on your server, download a new copy of your version and read that<br /><br /><br /><a href="http://www%20.%20osCommerce-template-Easy%20.%20com" target="_blank">Video Tutorials</a> and a free template editor.<br /><br /><br />File relationships diagram :- <a href="http://oscommerce-reference.swisscart.com/nav.html?oscommerce-2.2ms2-060817/tep_database-pr2.2-CVS.pdf.html" target="_blank"><a href='http://oscommerce-reference.swisscart.com/....2-CVS.pdf.html' class='bbc_url' title='External link' rel='nofollow'>http://oscommerce-re.
...2-CVS.pdf.html</a></a><br /><br />
The knowledgebase on this site can be read on-line or a copy downloaded, unfortunately it is for the latest version and the screen shots and content will probably differ from your site.<br /><br /><a href="http://www.oscommerce.com/solutions/documentation" target="_blank"><a href='http://www.oscommerce.com/solutions/documentation' class='bbc_url' title='External link' rel='nofollow'>http://www.
oscommerc...s/documentation</a>
</a><br /><br />But the code documentation here is very useful, <a href="http://wiki.oscdox.com/" target="_blank"><a href='http://wiki.oscdox.com/' class='bbc_url' title='External link' rel='nofollow'>http://wiki.oscdox.com/
</a></a>, once you have drilled down the search tool on the right is invaluable. The rest of the site is not finished but good in parts.<br /><br />Try skim reading these 3 threads as well<br /><br /><a href="http://forums.oscommerce.com/index.php?s=&showtopic=327967&view=findpost&p=1366350" target="_blank"><a href='http://forums.oscommerce.com/index.php?s=&...t&p=1366350' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...&...t&p=1366350</a>
</a><br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=310524&hl=security" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...amp;hl=security' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...amp;hl=security</a>
</a><br /><br /><a href="http://www.oscommerce.com/ext/update-20060817.txt" target="_blank"><a href='http://www.oscommerce.com/ext/update-20060817.txt' class='bbc_url' title='External link' rel='nofollow'>http://www.
oscommerc...te-20060817.txt</a>
</a><br /><br />The configuration files are also a dark pit and this link sheds some light on them and their contents<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=193738&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...=193738&hl=' class='bbc_url' title='External link' rel='nofollow'>http:/
/forums.oscomm...o...=193738&
hl=</a></a><br /><br />If you want to change colours and box styles the <a href="http://www.oscommerce.info/kb/osCommerce/Catalog_Area/Design_and_Layout/54" target="_blank">stylesheet is a good place to start.</a><br /><br />When you start to get more technical and want to create links, this might help<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=330479&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...=330479&hl=' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...o...=330479&hl=</a>
</a><br /><br />And for those wanting to install SSL<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=334107&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...=334107&hl=' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...o...=334107&hl=</a>
</a><br /><br />Images<br /><br /><a href="http://www.photoshopgraphics.co.uk/" target="_blank"><a href='http://www.photoshopgraphics.co.uk/' class='bbc_url' title='External link' rel='nofollow'>
http://www.photoshopgraphics.
co.<b style="color:black;background-color:#ff66ff">uk</b>/</a></a><br />IStockPhoto<br />
<a href="http://us.fotolia.com/
" target="_blank"><a href='http://us.fotolia.com/' class='bbc_url' title='External link' rel='nofollow'>http://
us.fotolia.com/</a></a>.<br /><a href="http://www.bigstockphoto.com/" target="_blank">
BigStockPhoto</a><br /><a href="http://www.magictoolbox.com/" target="_blank">magictoolbox</a>
<br /><a href="http://www.wellstyled.com/tools/colorscheme2/index-en.html" target="_blank">colour scheme generator</a><br /><br />Buttons/
icons<br /><br /><a href="http://dryicons.com/" target="_blank">dryicons.com/
</a><br /><a href="http://buttons.qds-team.com/web/workspace" target="_blank">buttons.qds-team.
com/web/workspace</a><br /><a href="http://www.oscbuttons.com/" target="_blank">www.
oscbuttons.com/</a><br /><a href="http://www.advancewebsoft.com/free-oscommerce-cre-loaded-zen-cart-oscmax-button-generator-p.html" target="_blank">www.
advancewebsoft.com</a><br /><br />
How to upgrade a template, good start if you ignore the flame war.<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=327471&hl=" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...=327471&hl=' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...o...=327471&hl=</a>
</a><br /><br />By now you might be trying to install contributions and are stuck on how to "run" the SQL<br /><br />1) Go to your ISPs admin area for your site.<br /><br />2) Click on the icon for Database administration or Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk. You might have to click on Manage Database or some link like that.<br /><br />3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.<br /><br />4) Click on "SQL" on the navigation bar.<br /><br />5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.<br /><br />6) For both methods click "Go"..<br /><br />7) If all goes well, your SQL query will run successfully<br /><br />For another explanation see:-<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=278204&hl=phpmyadmin+mysql+code" target="_blank"><a href='http://forums.oscommerce.com/index.php?sho...dmin+mysql+code' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...dmin+mysql+code</a>
</a><br /><br />Or for a contribution to allow you to run SQL Script from Admin<br /><br /><a href="http://www.oscommerce.com/community/contributions,4567" target="_blank"><a href='http://www.oscommerce.com/community/contributions' class='bbc_url' title='External link' rel='nofollow'>http://www.
oscommerc...y/contributions</a>
,4567</a><br /><br />Whilst we are on the subject of MySQL, this link will solve most problems when upgrading to <a href="http://addons.oscommerce.com/info/4654" target="_blank">MySQL5/Left Join/1054 error</a>/.<br /><br />For a comprehensive way of changing EVERYTHING to <b style="color:black;background-color:#ff66ff">UK</b> (<b style="color:black;background-color:#ff66ff">UK</b>-Based: Default osCommerce Installation)<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=130454" target="_blank"><a href='http://forums.oscommerce.com/index.php?showtopic=130454' class='bbc_url' title='External link' rel='nofollow'>http:
//forums.oscomm...howtopic=130454</a>
</a> <br /><br />Date formatting: <a href="http://addons.oscommerce.com/info/2816" target="_blank"><b style="color:black;background-color:#ff66ff">UK</b>-Based osCommerce 2.2 </a> & <a href="http://addons.oscommerce.com/info/3778" target="_blank">Date of Birth PullDown</a><br /><br />Another couple of threads might be of interest<br /><br /><a href="http://addons.oscommerce.com/info/4473" target="_blank"><a href='http://addons.oscommerce.com/info/4473' class='bbc_url' title='External link' rel='nofollow'>http:/
/addons.oscommerce.com/info/
4473</a></a> (<b style="color:black;background-color:#ff66ff">UK</b> & Overseas Postage Methods)<br /><a href="http://forums.oscommerce.com/index.php?showtopic=277269" target="_blank"><a href='http://forums.oscommerce.com/index.php?showtopic=277269' class='bbc_url' title='External link' rel='nofollow'>http://forums.
oscomm...howtopic=277269</a>
</a> (Only if you plan to post to <b style="color:black;background-color:#ff66ff">UK</b> only! Removing Country Selection on Register.)<br /><br />Read this link before <a href="http://forums.oscommerce.com/index.php?showtopic=273891" target="_blank">processing CC data on your site</a>.<br /><br />Use a merchant account and do not allow your customers to enter cc details on any non merchant screen unless you are PCI compliant.<br /><br />Use a contribution such as <b style="color:black;background-color:#99ff99">PayPal</b>, Protx etc. <br /><br /><b style="color:black;background-color:#99ff99">Paypal</b> <a href="http://forums.oscommerce.com/index.php?showtopic=331996" target="_blank">Basic Guide</a> and <a href="http://www.omega-cottage.co.uk/articles/webpage-design/e-commerce/paypal-standard-oscommerce.html" target="_blank">PP Guide</a> and <a href="http://forums.oscommerce.com/index.php?showtopic=331996&st=0&p=1383155&#entry1383155" target="_blank">PP Standard</a><br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=313323&st=0&start=0" target="_blank">How to secure your site.</a><br /><br />SEO :- <a href="http://www.google.com/webmasters/docs/search-engine-optimization-starter-guide.pdf" target="_blank"><a href='http://www.google.com/webmasters/docs/sear...arter-guide.pdf' class='bbc_url' title='External link' rel='nofollow'>http://www.google.co.
..arter-guide.pdf</a></a><br /><br />
SEO – Which one :- <a href="http://forums.oscommerce.com/index.php?s=&showtopic=329304&view=findpost&p=1371755" target="_blank"><a href='http://forums.oscommerce.com/index.php?s=&...t&p=1371755' class='bbc_url' title='External link' rel='nofollow'>http://forums.oscomm.
..&...t&p=1371755</a>
</a><br /><br /><a href="http://addons.oscommerce.com/info/5851" target="_blank"><a href='http://addons.oscommerce.com/info/5851' class='bbc_url' title='External link' rel='nofollow'>http://addons.
oscommerce.com/info/5851</a>
</a> - Header Tags SEO V 3.1.2<br /><a href="http://addons.oscommerce.com/info/2823" target="_blank"><a href='http://addons.oscommerce.com/info/2823' class='bbc_url' title='External link' rel='nofollow'>http://addons.
oscommerce.com/info/2823</a>
</a> - Ultimate SEO URLs - 2.1d<br /><a href="http://addons.oscommerce.com/info/6459" target="_blank"><a href='http://addons.oscommerce.com/info/6459' class='bbc_url' title='External link' rel='nofollow'>http://addons.
oscommerce.com/info/6459</a>
</a> - Sitemap SEO <br /><a href="http://addons.oscommerce.com/info/6216-" target="_blank"><a href='http://addons.oscommerce.com/info/6216-' class='bbc_url' title='External link' rel='nofollow'>http://addons.oscomm.
...com/info/6216-</a></a> All Products SEO<br /><a href="http://addons.oscommerce.com/info/6583" target="_blank"><a href='http://addons.oscommerce.com/info/6583' class='bbc_url' title='External link' rel='nofollow'>http://addons.
oscommerce.com/info/6583</a>
</a> - Googlebase <br /><a href="http://addons.oscommerce.com/info/2455" target="_blank"><a href='http://addons.oscommerce.com/info/2455' class='bbc_url' title='External link' rel='nofollow'>http://addons.oscommerce.
com/info/2455</a></a> - Updated Spiders file<br /><a href="http://addons.oscommerce.com/info/2162" target="_blank"><a href='http://addons.oscommerce.com/info/2162' class='bbc_url' title='External link' rel='nofollow'>http://addons.
oscommerce.com/info/2162</a>
</a> - Robots file<br /><a href="http://www.oscommerce.com/community/contributions,952" target="_blank"><a href='http://www.oscommerce.com/community/contributions' class='bbc_url' title='External link' rel='nofollow'>http://www.oscommerc.
..y/contributions</a>,952</a>
- SID killer<br /><a href="http://www.oscommerce.com/community/contributions,2370" target="_blank"><a href='http://www.oscommerce.com/community/contributions' class='bbc_url' title='External link' rel='nofollow'>http://www.
oscommerc...y/contributions</a>
,2370</a> - SEO Assistant<br /><br />Finally for those of you with a slow store<br /><br /><a href="http://forums.oscommerce.com/index.php?showtopic=119077" target="_blank">A Store Speed Optimization in Progress, Step by step from a vanilla install!</a><br /><a href="http://forums.oscommerce.com/index.php?showtopic=121913&hl=" target="_blank">An example of how to debug a nasty query problem</a><br /><a href="http://addons.oscommerce.com/info/2575" target="_blank">Find slow queries</a><br /><a href="http://www.somewhere-in-time.net/tutorial/irfanview/" target="_blank">Reduce Image Size</a><br /><br />Enjoy <br /><br /><b style="color:black;background-color:#ffff66">Geoffrey</b>