Zen Cart Logo

Database?

Locked

Views: 5,398

Results 1 to 17 of 17
This thread is locked. New replies are disabled.
03 Jun 2006, 01:10
#1
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Database?

Hello!

I use powweb for my server and I added a Zen Cart through them. For some reason it will not create a DATABASE for me. I have uninstalled and reinstalled several times with no luck. I contacted powweb and I have an open ticket with them.. and I think they may of done something to it but it has said the same thing when I go to the address all day since I called. I have been talking to several people about this but they can not really offer any help when it comes to this issue :(
I would appreciate any help that anyone can give about how to add a DATABASE to my Zen Cart. I really need to get this zen cart working asap.

Thanks!

03 Jun 2006, 01:26
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Database?

You need to use your powweb control panel to create your database first, before installing Zen Cart

03 Jun 2006, 01:26
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Database?

Zen Cart does not create the database ... it uses one that is created ...

Usually you should have a Control Panel where you can create your database, username and password ...

Hopefully an email to your hosting site will get you the details specific to your site ...

03 Jun 2006, 01:36
#4
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

When I created the Zen Cart.. it was just pressing a button.. Then when it got to the data base question, It only had one choice so I did not get to chose anything else I had to accept it.
When I go to their database website my username & pw don't work.

I was getting some 0 DB something something something error when I would try to access the admin section & zen cart address.

what do i do to get the datebase to work?

03 Jun 2006, 01:41
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Database?

You need to talk to your host about why that's happening. Somehow their custom-built "one-click install" isn't.... :O

03 Jun 2006, 01:44
#6
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

can I uninstall this and do it manually? Someone asked me if I was installing it manually or by Fantasico? What is Fantasico?

03 Jun 2006, 02:02
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Database?

Sure - uninstall it.

Then install manually.

You can download the full fileset via the link at the top of this page "Get Zen Cart".
Inside the ZIP file is a /docs folder. You'll find installation instructions in there.

You're still going to need access to your hosting control panel in order to create a MySQL database and user+password for the database.

Alternatively, you may want to do a search on these forums for "powweb" to see if they're really a good hosting company to stick with if you want to do eCommerce esp with a tool like Zen Cart.

03 Jun 2006, 02:20
#8
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

TY!

Okay I created a new MySQL & I read the instructions.. but I feel really stupid. I can not find the INSTALL SCRIPT.. Where is this?

Thanks!

Edit,,
Sorry I found it right under where it said it :smile:

03 Jun 2006, 02:35
#9
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

I'm so sorry,

This is all very new to me

So I am trying to type these address:

If you are running on a your own computer, this will be

http://localhost/{zen-cart-directory}/zc_install/

or if on a live server:

http://{www.mydomain.com}/zc_install/

But I tried with :

my domain name, and then where the folder was(on my desk top) and neither worked. What am I doing wrong?

Thanks

03 Jun 2006, 04:25
#10
kobra avatar

kobra

Black Belt

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

Re: Database?

http://{www.mydomain.com}/zc_install/

But I tried with :

my domain name, and then where the folder was(on my desk top) and neither worked. What am I doing wrong?
First arm yourself with your DB user name and DB pass handy.

Next, use your FTP client and connect to your site. Then upload the contents of the Zencart package(the one on your desktop) to your server space (Again just the contents and not the folder it is in), Either at the root or in a folder like /shop or /store. Root or folder is your choice.

After this is done and you are still in your ftp Client, find the two files that are named dist-configure.php. one is in the /includes directory and the other is in the /admin/includes directory. Rename them to configure.php. also right click on each one and set the permissions to 777 usually by checking all the check boxes.

Leave your ftp client open and just minimize.

Open your browser and now enter http://{www.mydomain.com}/zc_install/

and off you go............

If you do not currently have a FTP client. geta free one here: FTP Client

03 Jun 2006, 04:28
#11
kobra avatar

kobra

Black Belt

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

Re: Database?

:oops: I just noticed that you might be on a winserver.

Edit the permissions set to 777 to "not read only"

03 Jun 2006, 05:05
#12
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

thank you so much for answering!

03 Jun 2006, 18:01
#13
candice avatar

candice

New Zenner

Join Date:
Jun 2006
Location:
Vancouver BC Canada
Posts:
27
Plugin Contributions:
0

Re: Database?

Thank you for your help, we got it up and working!

I am having an issues with one of the files /includes/configure.php It says that it is a potential security rish .. Please set the right user permissions on this file.

i keep setting to READ only but it keeps switching back to READ-and write on one of them(owner) Permissions is at 644.
What is it supposted to be at?

I also have some more questions but I will ask in another forum.

Thanks!

03 Jun 2006, 23:49
#14
vger avatar

vger

Past Contributor

Join Date:
Nov 2004
Location:
Norfolk, United Kingdom
Posts:
3,189
Plugin Contributions:
0

Re: Database?

Mmm? Sorry, but hosting php sites with PowWeb is a bit more problematic than that. PowWeb run PHP as a cgi executable. Each script is auto-installed, and the auto-install adds a reference to the cgi-bin to each root level file.

Also, as far as I am aware, your site has to be installed in a folder called 'catalog' and cannot be installed into the root of the web. Did you have to install it into a folder called 'catalog' - I'd be interested to know.

Vger

04 Jun 2006, 04:41
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Database?

Candice:

I am having an issues with one of the files /includes/configure.php It says that it is a potential security rish .. Please set the right user permissions on this file.

i keep setting to READ only but it keeps switching back to READ-and write on one of them(owner) Permissions is at 644.
What is it supposted to be at?

644 is fine for some sites. It's possible that powweb wants it to be 444.
It's also possible that they won't let you set it to 444 via FTP and instead you'll have to use their hosting control panel's "file manager" to change the permissions setting.

06 Jun 2006, 22:14
#16
theoracle avatar

theoracle

Suspended

Join Date:
Aug 2004
Posts:
3,180
Plugin Contributions:
1

Re: Database?

These are the two best settings that should typically be set on:

  • FTP Web Folder: 755.
  • FTP Web Files: 644.

Never put full writing access under if you're operating a web site under Windows Server (no matter which version or built you might actually be using right now).

Since this is a Windows Server section, there are actually no file manager that can handle this type of settings - since this is only available under a linux OS.

However, if you're experiencing difficulties with your site permissions, you can always send a support ticket to your web hosting service in order, for them, to resolve this problem quickly. :thumbsup:

14 Aug 2007, 19:56
#17
poolprorich avatar

poolprorich

Zen Follower

Join Date:
Aug 2007
Location:
Tampa FL.
Posts:
143
Plugin Contributions:
0

Re: Database?

Vger:

Mmm? Sorry, but hosting php sites with PowWeb is a bit more problematic than that. PowWeb run PHP as a cgi executable. Each script is auto-installed, and the auto-install adds a reference to the cgi-bin to each root level file.

Also, as far as I am aware, your site has to be installed in a folder called 'catalog' and cannot be installed into the root of the web. Did you have to install it into a folder called 'catalog' - I'd be interested to know.

Vger

your right powweb dose run a a gui script, you can how ever install into the htdocs directory. when seting up your database chose create new db,
if you are installing manualy the database is not located at the 'localhost'
it is located on its own domain usualy (mysql01.powweb.com )and you will put this in place of localhost in order to atatch to your database.

ive noticed that in the php.ini file i had to raise the memory per php script to 20M to speed it up