osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Catalog opens after database import but Empty

This is a discussion on Catalog opens after database import but Empty within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; Hello, I have been working tirelessly for 4 or 5 days on a fresh install and database import (I have ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 03-28-2008, 06:16 PM
2injoy's Avatar
Lurker
 
Join Date: Mar 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
2injoy is on a distinguished road
Default Catalog opens after database import but Empty

Hello, I have been working tirelessly for 4 or 5 days on a fresh install and database import (I have have read at least 100 threads/posts in effort not to ask any questions). But, unfortunately I am stuck.

Was using regular Oscommerce with no extras added. I have had a store with customers and products etc. so I didn't want to lose my information. Fresh oscmax install worked fine after a few attempts to just import my old dB. Followed the mysqldiff instructions, got the database all compared, exported, imported etc. (only exported the categories, product info, customer info, order info and address book) and modified all the other tables etc. Admin works fine and I can see my categories and products via Admin. But when I click on MyDomain.com – Buy Domains for $8.95 – Free Domain Name Management tools I see the oscmax blue template, no products or catagories can be seen. this message is at the top of the page:

Warning: The downloadable products directory does not exist: DIR_FS_DOWNLOAD. Downloadable products will not work until this directory is valid.

All links on the catalog/index.php when clicked bring up error pages mydomain.comdir_ws_http_catalogcontact_us.php.

FYI: on a windows server, using dreamweaver to ftp.

I am sure that the answer is here in the forum, but I am worn out. I had never heard of oscmax before this week and have managed my way to this point. please help me! I appreciate your help...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 03-30-2008, 10:13 AM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,328
Thanks: 68
Thanked 322 Times in 305 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Catalog opens after database import but Empty

Did you import the products_to_categories table from your osC database? That is the first most obvious question.

Next, the DIR_FS_DOWNLOAD error just means that you need to make the downloads directory writable on your filesystem.

Finally, post the exact error message when clicking on links. From what you posted, your path settings are wrong in your configure.php file.
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 03-30-2008, 01:12 PM
2injoy's Avatar
Lurker
 
Join Date: Mar 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
2injoy is on a distinguished road
Default Re: Catalog opens after database import but Empty

Thanks for the response.
1. Yes, I transferred the products_to_categories table from the osC database
2. exact error-Firefox can't find the server at mydomain.comdir_ws_http_catalogshipping.php.
3. yes, something is wrong with configure.php, but after reading the installation instructions I never see anything that tells you a complete step by step for getting this to work. I didn't make changes to the configure.php so I don't know what it is I am supposed to change. Sorry, I am not a coder...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 03-30-2008, 01:36 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,328
Thanks: 68
Thanked 322 Times in 305 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default Re: Catalog opens after database import but Empty

You don't need to be a coder, but you do need to know what the correct path to your files is.

When you run the installer, you need to tell it what the path to your site is (it asks for it). If you put the wrong info in the installer, your cart will not work correctly.

So, since you have already added data to your database, don't run the installer again, it could wipe out the contents. You will need to edit the configure.php file located at /catalog/includes/configure.php

You need to make the paths in that file match where the files actually are located on your server. That will fix the problem. There is no step-by-step for setting the path, as it is one step > Edit the configure.php paths to match your server and where the files are actually located.

Judging from the error, your configure.php paths are missing all the forward slashes / and also has an incorrect dir_ws_http_ in it. Remove the dir_ws_http_ part from any path and make sure to put forward slashes between the different directory and filenames.

Output should look like:

mydomain.com/catalog/shipping.php
__________________
Michael Sasek
osCMax Developer


  • osCMax Templates - Hundreds of premium quality templates. New designs every month!

  • xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience.

  • osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 03-30-2008, 07:41 PM
2injoy's Avatar
Lurker
 
Join Date: Mar 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
2injoy is on a distinguished road
Default Re: Catalog opens after database import but Empty

okay Michael, thank you again. Yes, I do know how to make edits on the php files, I just meant I couldn't figure out what to change on my own (since I am not a coder), not that I don't know how to change the text... I followed the instructions and opened the catalog/includes/configure.php

thought I fixed everything that needed a '/' and I can now see the names of products and the categories are showing up.

But still when I click on anything, the url's are the same...the paths all say... Firefox can't find the server at mydomain.comdir_ws_http_catalogindex.php.

but there is no dir_ws_http_ mentioned in my file. (at least not that I can see)

here is my configure.php info: maybe this will help. Obviously I am missing one small detail. I am sorry to keep bothering you...I know I am close to success....
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://mydomain.com'); // eg, cPanel® - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://mydomain.com');
define('HTTPS_CATALOG_SERVER', 'https://mydomain.com');
define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', 'D:/hshome/******/mydomain.com/catalog/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required
define('DIR_FS_ADMIN', 'D:/hshome/******/mydomain.com/catalog/admin/'); // absolute pate required
define('DIR_WS_CATALOG', '/catalog/'); // absolute path required
define('DIR_FS_CATALOG', 'D:/hshome/*****/mydomain.com/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FCKEDITOR', DIR_FS_CATALOG . 'FCKeditor/');
define('DIR_WS_FCKEDITOR', DIR_WS_CATALOG . 'FCKeditor/');

// define our database connection
define('DB_SERVER', 'mysql.ixwebhosting.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', '*****_******');
define('DB_SERVER_PASSWORD', '*******');
define('DB_DATABASE', '******_******');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 03-31-2008, 05:02 AM
2injoy's Avatar
Lurker
 
Join Date: Mar 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
2injoy is on a distinguished road
Default Re: Catalog opens after database import but Empty

i uploaded another post that maybe isn't showing up yet so I am sorry if this is a duplicate reply... but after fiddling around with the file catalog/includes/configure.php, when I go to the catalog and click a link...I get 'page cannot be found' and url looks like MyDomain.com – Buy Domains for $8.95 – Free Domain Name Management tools
I cannot find any references to DIR_WS_HTTP anywhere in the configure.php document...

the categories and products are listed on the catalog, but none of them go to anything..(same error type as above)

I must be missing a small detail...I have done 'find/replace' and no recored of DIR_WS_HTTP found

define('HTTP_SERVER', 'http://mydomain.com/'); // eg, cPanel® - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://mydomain.com/');
define('HTTPS_CATALOG_SERVER', 'https://mydomain.com/');
define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', 'http://mydomain.com/catalog/'); // where the pages are located on the server
define('DIR_WS_ADMIN', 'http://mydomain.com/catalog/admin/'); // absolute path required
define('DIR_FS_ADMIN', 'http://mydomain.com/catalog/admin/'); // absolute pate required
define('DIR_WS_CATALOG', 'catalog/'); // absolute path required
define('DIR_FS_CATALOG', 'http://mydomain.com/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FCKEDITOR', DIR_FS_CATALOG . 'FCKeditor/');
define('DIR_WS_FCKEDITOR', DIR_WS_CATALOG . 'FCKeditor/');
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
how to import my old database plus766 osCommerce 2.2 Installation Help 2 01-26-2007 11:24 AM
How do you totally empty the mysql catalog without deleting mymikl osCMax v2 Features Discussion 3 09-05-2006 09:25 AM
Really confused, admin catalog page displays empty??? b5b4you osCMax v2 Installation issues 4 08-11-2006 11:44 AM
Database import sverker osCommerce 2.2 Installation Help 4 11-24-2003 01:26 PM
Must you import the catalog database? fast_talon osCommerce 2.2 Installation Help 2 11-28-2002 05:40 AM


All times are GMT -8. The time now is 08:57 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax