Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Upgrading from 1.3.x to 1.3.9 / Help! Site can't connect to my database

Help! Site can't connect to my database

Locked

Started by mw4kids on 15 Jun 2009, 4:59 PM · Views: 2,343

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
15 Jun 2009, 4:59 PM
#1
mw4kids avatar

mw4kids

Zen Follower

Join Date:
Oct 2008
Posts:
403
Plugin Contributions:
0

Help! Site can't connect to my database

Hi All,

I put out a thread to my host some time ago, but haven't recieved a response yet and getting a bit desperate to fix this.

I am in the process of trying to upgrade my zencart to 1.3.8 and managed to ftp the new files to my file manager. Then I created a new database and created an new user for that database. I used the same user name that was already being used for my other 2 database I already had (just to be consistant) and just created a new password and then added that user to the database and now when I try to sign on to my site it's say i'm having a connection problem with my database. so i deleted the new database that I created and I still can't connect. Any idea what I may have done wrong?

Thanks!

15 Jun 2009, 7:09 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Help! Site can't connect to my database

There has to be a database ...

1 create a new database

2 add a new username and password

3 add the new username and password to the database

4 import your old data from your old database and import it into your new database

5 edit the 2 configure.php files for the NEW directory with your NEW directory, paths, database etc.

6 run the /zc_install and upgrade your NEW database

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Jun 2009, 7:42 PM
#3
mw4kids avatar

mw4kids

Zen Follower

Join Date:
Oct 2008
Posts:
403
Plugin Contributions:
0

Re: Help! Site can't connect to my database

thanks Ajeh!

I am unclear on step 4 though. I've never imported a db before so not sure how to do it. I'm assuming i would create the new db, access it through my phpMyAdmin and click on import??? where it say's browse, should i be importing the db i had backed up on my local pc?

is that right?

15 Jun 2009, 8:13 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Help! Site can't connect to my database

There are many ways to get an exported copy of your database imported to the new database ...

That would be one of them ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Jun 2009, 8:18 PM
#5
mw4kids avatar

mw4kids

Zen Follower

Join Date:
Oct 2008
Posts:
403
Plugin Contributions:
0

Re: Help! Site can't connect to my database

ok...will give it a shot. :shocking: thanks!!

15 Jun 2009, 8:45 PM
#6
mw4kids avatar

mw4kids

Zen Follower

Join Date:
Oct 2008
Posts:
403
Plugin Contributions:
0

Re: Help! Site can't connect to my database

ok...looks like i was able to transfer the db...yeah! Now when I try to edit the confige files and ftp them to my file manager I can error on my ftp program stating 'critical transfer error'. the only thing i can think of is that the permission is set to 0444 and needs to be changed. Should i change it to something like 0755?

thanks!

15 Jun 2009, 9:00 PM
#7
mw4kids avatar

mw4kids

Zen Follower

Join Date:
Oct 2008
Posts:
403
Plugin Contributions:
0

Re: Help! Site can't connect to my database

yeah:clap: i just went ahead and changed the permissions and it's all good now. thanks soooo much again!!

15 Jun 2009, 9:04 PM
#8
ajeh avatar

ajeh

Oba-san

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

Re: Help! Site can't connect to my database

You are most welcome ... good luck with the upgrade ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!