Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2007
    Posts
    8
    Plugin Contributions
    0

    Default Database problems

    I don't get why I am having issues, I hope I'm just c/p'ing something in wrong and its just a simple fix.

    Database is set up on my hosting with a username to access it. All names below are pretend. :)

    domain - www.smiley.com

    Installed Database - smil_store
    DB username - smil_jane

    What would go in these spots:

    Store Identifier (Table-Prefix)
    Database Host
    Database Username
    Database Name

    I currently have, but have tried several ways -

    Store Identifier (Table-Prefix) = smil_
    Database Host = smileys.com
    Database Username = smil_jane
    Database Name = store

    Using the information above, what all do I put in. Im not sure if I should be putting in full information like "smil_store" or just "store"

    I feel like it's an error in what I'm putting in, I appreciate any help. Thanks :)

  2. #2
    Join Date
    Sep 2006
    Posts
    542
    Plugin Contributions
    0

    Default Re: Database problems

    When you set up your database you are asked for a name for the database then a password for that database. You may or may not have been asked for the user name if you were then you will need to use it, If you were not asked a user name you can assume it is the same as the database name.

    Some hosts assign you a database name and user name for that database. I am guessing you chose yours.

    define('DB_SERVER', 'localhost'); This is usually localhost but may not be depending on your host and how they have it configured. You should be able to find out in your control panel
    define('DB_SERVER_USERNAME', 'xxxxxx'); This may be the same name as your database name if you did not get to pick a user name
    define('DB_SERVER_PASSWORD', 'xxxxxx');
    define('DB_DATABASE', 'xxxxxx');

    If you have intered all info correctly and still can not connect to the database you host may have database problems...... Happened to me more than once.

    You do not put in a store identifier unless you added a prefix to your database and if you did not then leave it blank.



    Quote Originally Posted by foryou View Post
    I don't get why I am having issues, I hope I'm just c/p'ing something in wrong and its just a simple fix.

    Database is set up on my hosting with a username to access it. All names below are pretend. :)

    domain - www.smiley.com

    Installed Database - smil_store
    DB username - smil_jane

    What would go in these spots:

    Store Identifier (Table-Prefix)
    Database Host
    Database Username
    Database Name

    I currently have, but have tried several ways -

    Store Identifier (Table-Prefix) = smil_
    Database Host = smileys.com
    Database Username = smil_jane
    Database Name = store

    Using the information above, what all do I put in. Im not sure if I should be putting in full information like "smil_store" or just "store"

    I feel like it's an error in what I'm putting in, I appreciate any help. Thanks :)

  3. #3
    Join Date
    Apr 2007
    Posts
    117
    Plugin Contributions
    1

    Default Re: Database problems

    I have a ? concerning this issue also. I did not insert a db prefix when I installed. I should have. Where do I go to edit this? Do I need to do a db update through the zc_install and give it a name there?

  4. #4
    Join Date
    Apr 2007
    Posts
    117
    Plugin Contributions
    1

    Default Re: Database problems

    Quote Originally Posted by A-1 Electronics View Post
    I have a ? concerning this issue also. I did not insert a db prefix when I installed. I should have. Where do I go to edit this? Do I need to do a db update through the zc_install and give it a name there?

    Got it figured out.

 

 

Similar Threads

  1. Database problems
    By jo_h1971 in forum General Questions
    Replies: 13
    Last Post: 3 Nov 2009, 11:09 PM
  2. Database Problems
    By andy in forum General Questions
    Replies: 3
    Last Post: 4 Apr 2009, 02:24 AM
  3. database upgrade problems
    By ridelow in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 10 Oct 2008, 04:53 PM
  4. database upgrade problems
    By keystonewebworks in forum General Questions
    Replies: 0
    Last Post: 13 Oct 2006, 02:44 AM

Posting Permissions

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