Need help plz. My zen cart doesnt work

[dessau77]

hey everyone, im having very confusing problems with zen cart. i heard that installation was easy but why for somre reason it is not for me?
im on windows hosting plan, i installed zen cart to hlcstore.com/zencart and all i get is this

0 DB_ERROR_NOT_CONNECTED
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

i did chek FAQ on this, but i got no idea wat they talking about. im not too good at coding.
can anyone plz provide a step by step explanation wat i should do?
thanks in advance

[schoolboy]

The error indicates that the zencart SOFTWARE is not finding (linking) to your database.

I trust you have created a database?

Generally, the error is a result of a misconfiguration in your database PATH info, or you have not given the database username and password sufficient permissions.

In your host c-panel, make sure that the database user has FULL admin rights. Also, make sure the database parameters in the configure.php files are correct.

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', '');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'acct_username');
  define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX');
  define('DB_DATABASE', 'acct_dbasename');

The ones in RED are significant.

Sometimes (if your database is on a separate server) you may need to put the IP address here instead of LOCALHOST.

Does your database use a prefix for the tables? Commonly, this is zen_

Then the THREE defines indicating USER PASSW and DBASE name, must be correct.

[dessau77]

well this is what i have. is this how it should be, or i gotta modify something? for some reason if i wanna correct the .php i cannot save the file, it says "cannot save configure.php"
im trying to edit it in my file manager, is this correct location to do it?

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zen_');
  define('DB_SERVER', 'hlc1015311024690.db.6246889.hostedresource.com');
  define('DB_SERVER_USERNAME', 'hlc1015311024690');
  define('DB_SERVER_PASSWORD', '');
  define('DB_DATABASE', 'hlc1015311024690');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');

im using usavedomains.com and my store is hlcstore.com/zencart/admin

[dessau77]

and this is how my cpanel mysql page looks like.
is anything wrong there?

[kobra]

well this is what i have. is this how it should be, or i gotta modify something?

You need to determine the following for the DB

  define('DB_TYPE
  define('DB_PREFIX'
  define('DB_SERVER'
  define('DB_SERVER_USERNAME',
  define('DB_SERVER_PASSWORD', 
  define('DB_DATABASE',

Where
DB_PREFIX' is what is being used or that there is none
define('DB_SERVER' - is in many cases "localhost" but might be a designation off the server to a server specifically for DB operations
define('DB_SERVER_USERNAME', - - the correct DB user name
define('DB_SERVER_PASSWORD', - - the correct DB password
define('DB_DATABASE', - - the correct DB name

[dessau77]

hey eveyrone, this is FRUSTRATING.... i have no idea wat to do. first of all where am i supposed to determine all that? i cant even save nothing. it doesnt work.
last night i tried uninstalling zen cart and then install again. but same thing happens!!!!!!!!!!1
why does it have to be so dramatic. i did everyhint they showed on yutube how to install. now its not working.
can anyone provide me with step by step instructions PLEASE
IM VERY LOST

[kobra]

When you create a DB you should also have a selection to create a DB user where you also create a DB password for that user
You need to set all of this up on your hosting and enter it in the 2 configure files

As this is hosting specific there is not a tutorial on how your host makes this availabble to you

[schoolboy]

If you cannot "save" a file, it's probably because the file permissions (CHMOD) are set to 0444..

But... you are on a WINDOZE platform (), so you won't be using CHMOD but whatever system windoze applies to file read/write permissions.

Frankly, while Zencart will "work" on windoze, you should be hosting on a Linux box.

It also looks like (from your DB connection address) that your dbase is being housed on a different server from your site. This is common with "cheap 'n nasty" hosting.

My advice would be:

If you are going to do eCommerce seriously (as opposed to just a "hobby") then get yourself a decent host. Use the Certified Hosts link at the top of the screen. Get the thing set up on a Linux box with a proper C-Panel management interface.

I know of one of these hosts that (if you sweet-talk them), "Tony" will probably get a ZC install done for you, leaving you to focus to how the shop works.

[dessau77]

well everyone thanks for help. hmm im gonna try to install it again. i called my host 2 times today its long distance good thing i have long distance plan 5C a minute. calls havent resolved anything. ill try again and see wat happens. if not i guess ill choose nopcommerce or something. if that wont work ill switch hosts.
btw i looked at certified hosts here cheked the online reviews, and most of them have horrible customer service or crappy uptime and etc.
anyways tnks again. ill keep u posted

[gcampos]

yep its a permission thing, if you have RDC available to the server then you can make the changes, but if not then the host has to do it, and if they wont, then switch to a linux box, thats what I did.

I currently have two servers, a windows box and a linux box, and the store I am running is on a linux box. I also checked out the certified hosts and after testing stayed with the current host. I am happy and customer support is usually top notch.