Results 1 to 6 of 6

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 ...

      
  1. #1
    Lurker 2injoy's Avatar
    Join Date
    Mar 2008
    Posts
    4
    Rep Power
    0


    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...

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    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 installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Lurker 2injoy's Avatar
    Join Date
    Mar 2008
    Posts
    4
    Rep Power
    0


    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...

  4. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    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 installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    Lurker 2injoy's Avatar
    Join Date
    Mar 2008
    Posts
    4
    Rep Power
    0


    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'
    ?>

  6. #6
    Lurker 2injoy's Avatar
    Join Date
    Mar 2008
    Posts
    4
    Rep Power
    0


    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/');

Similar Threads

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •