Community Forums

Upgrade installs wrong Data Base

Please post any issues you are having concerning installation of OpenCart v0.x.

Upgrade installs wrong Data Base

Postby weniggary » Sun Oct 05, 2008 4:18 pm

Just installed the upgrade and my data base was replaced with the motorcycle demo. Is that the same thing as the home page being incorrect in some of the other post? Checked the server my old DB is still ok. Is this a setting or what do I need to transfer in my old theme files back to the server?

Thanks, can't seem to find another post that tells me what I think I need.
Gary
weniggary
 
Posts: 11
Joined: Wed Apr 30, 2008 2:34 pm
Location: Kansas City, MO, USA

Re: Upgrade installs wrong Data Base

Postby perlgerl » Sun Oct 05, 2008 8:50 pm

The db settings are towards the end of the file config.php which is in your root (i.e. "shop" directory).

There's also a second config.php for the admin stuff, in the admin subdirectory.
perlgerl
 
Posts: 11
Joined: Mon Aug 04, 2008 4:37 pm

Re: Upgrade installs wrong Data Base

Postby weniggary » Mon Oct 06, 2008 12:22 am

Both files have my correct DB and correct password, any other ideas? Thanks for the help.
weniggary
 
Posts: 11
Joined: Wed Apr 30, 2008 2:34 pm
Location: Kansas City, MO, USA

Re: Upgrade installs wrong Data Base

Postby perlgerl » Fri Oct 10, 2008 12:56 am

I'm stumped.  When you install, it over-writes the database.  I found that out the hard way.

What about trying to restore your good database?  Make a sql backup and then restore it through the admin panel.
Admin > Configuration > Backup/Restore > Restore
perlgerl
 
Posts: 11
Joined: Mon Aug 04, 2008 4:37 pm

Re: Upgrade installs wrong Data Base

Postby bruce » Fri Oct 10, 2008 2:23 am

Yes, the installer will clear an existing database.

The sql in the install folder contains "drop table if exists" statements.
bruce
 
Posts: 1094
Joined: Wed Dec 12, 2007 6:26 am

Re: Upgrade installs wrong Data Base

Postby weniggary » Mon Oct 13, 2008 12:25 am

Long story short, my backup DB is blank and the one on the web is full of motorcycles. As a newbie I see I made several errors here, but I think overwriting the existing DB should be something that has a big red flag in the installation instructions and maybe even a pop-up window to warn people. Thanks for all the helpful comments, at least I resolved the problem.
weniggary
 
Posts: 11
Joined: Wed Apr 30, 2008 2:34 pm
Location: Kansas City, MO, USA

Re: Upgrade installs wrong Data Base

Postby Qphoria » Mon Oct 13, 2008 1:30 am

Installation means installation. What you wanted to do was use the "Upgrade" script. A new install is no different than installing windows. It overwrites (formats) the harddrive first and then writes the new one.
Image Image
Donate!|OpenCart Basics|GeoZones
Help me get more development cloud storage - Click Here to get DropBox
User avatar
Qphoria
Administrator
 
Posts: 18212
Joined: Mon Jul 21, 2008 7:02 pm
Donate to Qphoria

Re: Upgrade installs wrong Data Base

Postby bruce » Mon Oct 13, 2008 1:45 am

And where would this "upgrade" script be??  ;)
bruce
 
Posts: 1094
Joined: Wed Dec 12, 2007 6:26 am

Re: Upgrade installs wrong Data Base

Postby Qphoria » Mon Oct 13, 2008 1:51 am

Should be there ... at least i know there is one in 0.7.9. Never checked 0.7.8

-EDIT-
Ahh  I see. 0.7.8 doesn't have one. Well there's your first problem :) 0.7.8 is dead to me. viva la 0.7.9
I guess it took care of itself.
Last edited by Qphoria on Mon Oct 13, 2008 1:52 am, edited 1 time in total.
Image Image
Donate!|OpenCart Basics|GeoZones
Help me get more development cloud storage - Click Here to get DropBox
User avatar
Qphoria
Administrator
 
Posts: 18212
Joined: Mon Jul 21, 2008 7:02 pm
Donate to Qphoria

Re: Upgrade installs wrong Data Base

Postby Qphoria » Mon Oct 13, 2008 3:34 am

Next version will have better informational messages about install.
Image Image
Donate!|OpenCart Basics|GeoZones
Help me get more development cloud storage - Click Here to get DropBox
User avatar
Qphoria
Administrator
 
Posts: 18212
Joined: Mon Jul 21, 2008 7:02 pm
Donate to Qphoria


Return to Installation & Upgrade Support

Who is online

Users browsing this forum: No registered users and 2 guests

Hosted by Arvixe Web Hosting