Upgrade Question...

30 Jul 2006, 2:55 AM

#1

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Upgrade Question...

Ok sorry if this sounds DUMB. I need to upgrade from 1.3.0.1 to 1.3.0.2, now I need to know do I install all the files via FTP and run the SQL File named mysql_upgrade_zencart_1301_to_1302. Do I need to run any other files in the ZCInstall file??

:cry:

30 Jul 2006, 2:57 AM

#2

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

I should mention 1.301 is a FRESH copy no mods yet.

30 Jul 2006, 3:02 AM

#3

drbyte

Sensei

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

Re: Upgrade Question...

I need to know do I install all the files via FTP and run the SQL File named mysql_upgrade_zencart_1301_to_1302. Do I need to run any other files in the ZCInstall file??

You've got it wrong.

You need to upload ALL the files from the zc_install folder.
Then use your browser to open zc_install/index.php on your server
Choose Database-Upgrade option at the bottom of the System Inspection page.
Follow the prompts to complete the upgrade.

DO NOT simply run the .SQL file via some other means.

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

30 Jul 2006, 3:09 AM

#4

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

Dr Byte, Do I have to set permission first? I tried uploading via FTP and it says something about permissions.

30 Jul 2006, 3:41 AM

#5

drbyte

Sensei

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

Re: Upgrade Question...

If you're only running the database-upgrade portion, you don't need to change permissions on the configure.php files.

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

30 Jul 2006, 3:45 AM

#6

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

It was due to a FTP problem, I am trying the upgrade now. Sorry.

30 Jul 2006, 3:58 AM

#7

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

i got an error message. ARRGGHHH I pressed Install, as per instructions. :down:

Warning: main(includes/modules/pages/system_setup/header_php.php): failed to open stream: No such file or directory in /home/public_html/zc_install/index.php on line 25

Fatal error: main(): Failed opening required 'includes/modules/pages/system_setup/header_php.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/zc_install/index.php on line 25

30 Jul 2006, 4:02 AM

#8

drbyte

Sensei

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

Re: Upgrade Question...

DrByte:

Choose Database-Upgrade option at the bottom of the System Inspection page.
Maybe I should have also said to NOT press "install" ... the database-upgrade button is beside it ....

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

30 Jul 2006, 4:04 AM

#9

drbyte

Sensei

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

Re: Upgrade Question...

zenned:

Warning: main(includes/modules/pages/system_setup/header_php.php): failed to open stream: No such file or directory in /home/public_html/zc_install/index.php on line 25

Warning: main(includes/modules/pages/system_setup/header_php.php): failed to open stream: No such file or directory in /home/public_html/zc_install/index.php on line 25

Fatal error: main(): Failed opening required 'includes/modules/pages/system_setup/header_php.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/zc_install/index.php on line 25
These messages suggest that your FTP program didn't upload all the zc_install files properly.

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

30 Jul 2006, 4:06 AM

#10

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

OK. I will do it again, B4 i do, do I put the files inside of Zencart files or outside OR does it not matter?

30 Jul 2006, 4:20 AM

#11

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

:shocking: Ok i followed your directions.........

1062 Duplicate entry 'Administrator' for key 2
in:
[INSERT INTO zen_query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]

is what I got?

30 Jul 2006, 4:20 AM

#12

drbyte

Sensei

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

Re: Upgrade Question...

The zc_install folder goes to the same place it did for the original install.

Your Store area contains folders like this:
/admin
/email
/includes
/images
/zc_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.

30 Jul 2006, 4:23 AM

#13

drbyte

Sensei

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

Re: Upgrade Question...

zenned:

1062 Duplicate entry 'Administrator' for key 2
in:
[INSERT INTO zen_query_builder ( query_category , query_name , .......
This suggests you've run the upgrade before, or your site already had a fix in it suggested in the forums for adding the ability to send yourself a sample newsletter from the Admin ?

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

30 Jul 2006, 4:54 AM

#14

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

oh well I quit. see ya

30 Jul 2006, 5:07 AM

#15

drbyte

Sensei

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

Re: Upgrade Question...

It's not so hot when your host doesn't keep their Fantastico auto-installer up to date, and forces and old version on you.

You should log a ticket with their help desk and remind them to 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.

30 Jul 2006, 7:33 PM

#16

zenned

Zen Follower

Join Date:: Dec 2005
Posts:: 119
Plugin Contributions:: 0

Re: Upgrade Question...

i did, they said it takes at least a month. They said all the fantasico installs are like this. I dunno. thanks for your help dr byte.