If this is your first visit, check our documentation. To post, register or login.
Forums / Upgrading from 1.3.x to 1.3.9 / 1.3.5 update problem?

1.3.5 update problem?

Locked

Started by knuckle_101 on 16 Sep 2006, 8:08 PM · Views: 1,381

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
16 Sep 2006, 8:08 PM
#1
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

1.3.5 update problem?

Any Idea what is causing this error during the upgrade process?

1146 Table 'andi_shop.zen_product_music_extra' doesn't exist
in:
[show index from zen_product_music_extra]

PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
Business Class Web Hosting - Linux and cPanel Powered

16 Sep 2006, 9:22 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: 1.3.5 update problem?

No idea. Sounds like you're missing something in your database...

.
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.

16 Sep 2006, 9:29 PM
#3
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

Re: 1.3.5 update problem?

I did a search for it. anyway to troubleshoot it? It works fine on a test site but when I uploaded the files to the live site this db error shows.

What is your call on the situation?

PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
Business Class Web Hosting - Linux and cPanel Powered

16 Sep 2006, 9:34 PM
#4
drbyte avatar

drbyte

Sensei

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

Re: 1.3.5 update problem?

It says "zen_product_music_extra" doesn't exist.

I suggest you create the table and then rerun the upgrade.

.
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.

16 Sep 2006, 9:39 PM
#5
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

Re: 1.3.5 update problem?

I tried that and it asked for a value, not sure what in

Field Type Length/Values1 Attributes Null Default2 Extra 

and how many fields

PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
Business Class Web Hosting - Linux and cPanel Powered

16 Sep 2006, 9:41 PM
#6
drbyte avatar

drbyte

Sensei

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

Re: 1.3.5 update problem?

if the table is missing, you have a bigger problem ... are you sure that all the "rest" of the tables for that database exist ?

You said that upgrading in a test area was fine.... what's the difference between your test db and your live one? Sounds like you didn't test on a copy of your live database.

I suggest you backtrack and re-do your test upgrade before proceeding with the live site...

To create that table, look up its definition in the mysql_zencart.sql file in the zc_install/sql folder.

.
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.

16 Sep 2006, 9:59 PM
#7
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

Re: 1.3.5 update problem?

I recreated the table, somehow the owner of the website totally deleted the music gentry of the sql for what reason beats me.

All well and working now.

I made sure he doesnt remove any sql file tables for upgrading purposes and advised him to just disable the feature.

Thanks for you help.

Rob

PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
Business Class Web Hosting - Linux and cPanel Powered