Zen Cart Logo
Forums / Installing on a Windows Server / Need help plz. My zen cart doesnt work

Need help plz. My zen cart doesnt work

Locked

Views: 2,747

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
3 Jun 2010, 5:08 PM
#1
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Need help plz. My zen cart doesnt work

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. :no:
can anyone plz provide a step by step explanation wat i should do?
thanks in advance

3 Jun 2010, 6:25 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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.

3 Jun 2010, 8:53 PM
#3
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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:(:(:(

3 Jun 2010, 9:00 PM
#4
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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

3 Jun 2010, 9:03 PM
#5
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Need help plz. My zen cart doesnt work

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

3 Jun 2010, 9:13 PM
#6
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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

3 Jun 2010, 9:16 PM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Need help plz. My zen cart doesnt work

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

3 Jun 2010, 9:21 PM
#8
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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 (:yuck:), 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.

3 Jun 2010, 9:36 PM
#9
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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 :(

5 Jun 2010, 4:08 AM
#10
gcampos avatar

gcampos

New Zenner

Join Date:
May 2007
Posts:
93
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

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.

15 Jun 2010, 1:05 AM
#11
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

hey guys its been kidna 2 weeks. and wat a horrible expirience with everyhting. i stoped using zen cart and installed nopcommerce, but even with nopcommerce i had issues such as shipping errors and directory stuff errors, long story.

neways today i thought i backed up everyhting, so i deleteed all my files , tried to restore and nothing fot restored becuz i baked up database not the files, no all my store is delete. and i must start from scratch.
this is unbeliveble! :(
i going to switch hosting company and transfer my domain. but wat a pain in the ###### choosing hosts. every host i cheked reviews is crap. wth is going on these days? im so upset:(

15 Jun 2010, 1:17 AM
#12
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

host monster,com doesnt even have a zencart in its hosting features.
dont u think they should be removed from this website as certified host??:huh:

15 Jun 2010, 3:26 PM
#13
dessau77 avatar

dessau77

New Zenner

Join Date:
Jun 2010
Posts:
19
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

just an update. I SWTCHED TO LINUX HOSTING AND IT ALL WORKS FINE NOW. I HAVE PURE ORANGE TEMPLATE ALREADY INSTALLED.
HOWever how do i fix the top menus such as shopping cart and curency they are out of place?:flex:

15 Jun 2010, 3:36 PM
#14
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Need help plz. My zen cart doesnt work

dessau77:

just an update. I SWTCHED TO LINUX HOSTING AND IT ALL WORKS FINE NOW. I HAVE PURE ORANGE TEMPLATE ALREADY INSTALLED.
HOWever how do i fix the top menus such as shopping cart and curency they are out of place?:flex:

How do we know what "out of place" means when we can't see your site?

We can only help if we see a graphic representation of the problem, have access to the site URL, and get a good description of WHERE you want it to appear, in relation to where it currently appears.