Announcement

Collapse
No announcement yet.

connecting to mySQL DB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • connecting to mySQL DB

    HI, totally new with php and mySQL and I need advice. I have uploaded a pre-built zen website with database and all files but when I try to logon, I am told it cannot connect to the database. I know exactly where the problem lies, but I simply cannot get the it right.

    The two files I need to configure correctly (but which I am having trouble with) are includes/configure.php (1) and admin/includes/configure.php (2).

    includes/configure.php (1) asks
    // add your database and website details to the variables below

    define('DB_SERVER_USERNAME', 'CHANGE');
    // your username that you use to log into your web server
    define('DB_SERVER_PASSWORD', 'CHANGE');
    // your password that you use to log into your web server
    define('DB_DATABASE', 'CHANGE');
    // replace username with your web server username
    define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

    define('HTTP_SERVER', 'http://www.CHANGE.co.uk');
    define('HTTP_COOKIE_DOMAIN', '.CHANGE.co.uk');
    // do not include the www

    admin/includes/configure.php (2) asks
    // add your database and website details to the variables below

    define('DB_SERVER_USERNAME', 'CHANGE');
    // your username that you use to log into your web server
    define('DB_SERVER_PASSWORD', 'CHANGE');
    // your password that you use to log into your web server
    define('DB_DATABASE', 'CHANGE');
    // replace username with your web server username
    define('DIR_FS_ADMIN', '/home/CHANGE/public_html/admin/'); // replace username with your web server username
    define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');
    define('DIR_FS_DOCUMENT_ROOT', '/home/CHANGE/public_html');
    define('SITE', 'www.CHANGE.co.uk');
    define('WWW', 'http://www.CHANGE.co.uk');
    define('HTTP_SERVER', 'http://www.CHANGE.co.uk');
    define('HTTP_CATALOG_SERVER', 'http://www.CHANGE.co.uk');

    My problem is that no matter how many times I change the these values, something is not going correctly.

    My sites is Index of /, the zen cart is stored at http://eagleanddove.com/shop and according to cpanel, my database is eagleand_ebookstore.

    I need help in knowing what to put into the CHANGE option on all the configure files, as I just can not get it right. This is the first time I have tried this, so I am a beginner with Zencarts.

  • #2
    In define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

    Replace '/home/CHANGE/public_html/' With '/home/cpanel_username/public_html/shop'

    as zen cart in under "shop" Folder you need to add "shop" after 'public_html'

    IF you still face problem then please contact us on Live chat so that we can fix this problem.

    Comment


    • #3
      Originally posted by Nancy J View Post
      In define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

      Replace '/home/CHANGE/public_html/' With '/home/cpanel_username/public_html/shop'

      as zen cart in under "shop" Folder you need to add "shop" after 'public_html'

      IF you still face problem then please contact us on Live chat so that we can fix this problem.

      OK, will contact you on live chat as I have changed the values you suggested and I am still having problems. Thanks

      Comment


      • #4
        You're welcome
        Rock _a.k.a._ Jack Daniel

        Follow eUKhost on Twitter || Join eUKhost Community on Facebook

        Comment

        Working...
        X