asked on

osCommerce v2.2 RC1 html files not showing for Products and Categories after server move

osCommerce v2.2 RC1 site moved to new server. All files backed up and ftp'd up to new server and database exported and imported to new server, config.php files changed etc.
Store website is working from in funcitonality with creating an account, logging in and purchasing a product, all database data looks intact for Products.
However when you click on a category or product to see more of description the generated URL to a .html file is not found.
PHP version on my server is 5.1.6
website with problem is www.domain.ie

ASKER CERTIFIED SOLUTION

boon86

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

boon86

here is the missing .htaccess:

# Begin Ultimate SEO V2.2d 
Options +FollowSymLinks
RewriteEngine On 

  # RewriteBase instructions 
  # Change RewriteBase dependent on how your shop is accessed as below. 
  # http://www.mysite.com = RewriteBase / 
  # http://www.mysite.com/catalog/ = RewriteBase /catalog/  
  # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/ 

  # Change the following line using the instructions above  
  
RewriteBase /YOU HAVE TO CHANGE ME/

RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}
RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING}
RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING}
# End Ultimate SEO V2.2d

Open in new window

its for Ultimate SEO plugin, i not sure if that suite you.

Good luck

littlemissg

ASKER

Hi Thanks for reply
Yes I had suspected it is a htaccess issue, I was unable to access the existing .htacess file as I do not have root login to old server just FTP and it is not showing up in FTP client

Do you know of a way to access the old htaccess file via FTP ?

Or how I can determine what the file contents need to be

The above doesn't work, I suspect SEO plugin not installed as the products_description table doesn't have any SEO urls (maybe this is nothing to do with it, just guessing :)

littlemissg

ASKER

found out how to access .htaccess file from FTP client, add file mask of -la
Got file, uploaded all ok
Thanks a million

boon86

1st download : http://downloads.sourceforge.net/filezilla/FileZilla_3.5.1_win32-setup.exe

2nd read: http://www.intrepid.com.au/how-to-view-htaccess-with-filezilla/

you should able to see the .htaccess files

if not, you will need to contact your old hosting to zip and send the .htaccess
to you.

Hope that help.