If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / Linux install template- import old datase

Linux install template- import old datase

Started by awebb_designer on 6 Aug 2012, 8:06 PM · Views: 1,609

Results 1 to 14 of 14
6 Aug 2012, 8:06 PM
#1
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Linux install template- import old datase

I have installed the new version of zen cart and have imported the old database. Now I am getting error:
Front End:
Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Back end:
database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install

I cannot get in to the back-end to change anything.
I am using Go Daddy - Linux - with a 1.5 send cart template

Thank you for your help!

6 Aug 2012, 9:50 PM
#2
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Location:
Waikato, New Zealand
Posts:
1,558
Plugin Contributions:
1

Re: Linux install template- import old datase

If you have installed your site where has the zc_install folder gone?

you will need to reupload it if you have deleted it so it can run the database upgrade script

Webzings Design
Semi retired from Web Design

6 Aug 2012, 10:35 PM
#3
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

Godaddy installs on the back end. I did download the latest version of zen cart. I don't know what to do? Where is the database upgrade script?

6 Aug 2012, 10:59 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Linux install template- import old datase

You need to upload the zc_install folder and run www.your_site.com/zc_install

More importantly , you need to do a proper upgrade by reading and following the official upgrade instructions: www.zen-cart.com/upgrade (specifically the "detailed" link with instructions on preserving your customizations, not just the high-level overview you see there).

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

6 Aug 2012, 11:00 PM
#5
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

This is what is on the front end when I upload the zc-install
http://justbetweenusmaternity.com/

The back end is a white page with:
database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install

6 Aug 2012, 11:10 PM
#6
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

Thanks. I am doing that now. Thanks for the https://www.zen-cart.com/upgrade :P

6 Aug 2012, 11:33 PM
#7
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

The old database products are not in there? Should I try to import it again? I am afraid it is going to do the same thing?

7 Aug 2012, 12:08 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Linux install template- import old datase

The most common problem people encounter when importing data from another database is that their new install is using a different DB_PREFIX than their old install did.
Find the DB_PREFIX in your old site's configure.php files and make sure you put the same defined value in your new site's configure.php files (or enter that value when prompted when doing the initial installation, if you're using zc_install to do a proper fresh install).

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

7 Aug 2012, 3:20 PM
#9
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

I fount define('DB_PREFIX', 'zen_');

I have ps and zen in the database.

7 Aug 2012, 3:28 PM
#10
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

I ran the import to database again and the same thing happen
database upgrade required. please run the 1.3.9-to-1.5.0 upgrade via zc_install

7 Aug 2012, 3:41 PM
#11
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

I am upgrading the database again.
SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

7 Aug 2012, 3:56 PM
#12
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

I am back where I started yesterday? Please help :shocking:

7 Aug 2012, 7:39 PM
#13
awebb_designer avatar

awebb_designer

New Zenner

Join Date:
May 2011
Location:
Tulsa
Posts:
30
Plugin Contributions:
0

Re: Linux install template- import old datase

I did a clean install with my old database and not of the information came through?

7 Aug 2012, 7:43 PM
#14
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Linux install template- import old datase

The product is contained in the database tablenames which match the pattern of (DB_PREFIX value) + 'products'
Same with product descriptions: DB_PREFIX value + 'products_description'

So, if your old site has DB_PREFIX set to '' then the data is in a table named 'products'.
If your old site has DB_PREFIX set to 'zen_' then the data is in a table named 'zen_products'.
If your old site has a DB_PREFIX set to 'fred_' then the data is in a table named 'fred_products'.

Thus, if your NEW store isn't using the SAME setting for DB_PREFIX in BOTH your admin and non-admin configure.php files, it will look like your data is missing ... because it's not present in the tables you're telling it to look in.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.