Upgrading your dB on Windows Servers

4 Sep 2006, 1:30 PM

#1

Totally Zenned

Join Date:: Apr 2006
Location:: London, UK
Posts:: 10,475
Plugin Contributions:: 11

Upgrading your dB on Windows Servers - Important

I recommend that if you are upgrading your database on a windows server you ensure that your config files (admin/includes/configure.php and includes/configure.php) are set to READ-ONLY (as they should be inb normal use anyway).

You can safely ignore the warning message that comes up during the upgrade/install process. The upgrade process doesn't require access to these files. But if you give it you risk your config settings being lost.

This is a PHP v windows problem.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

4 Sep 2006, 1:46 PM

#2

drbyte

Sensei

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

Re: Upgrading your dB on Windows Servers - Important

Fixes posted here:
http://www.zen-cart.com/forum/showthread.php?p=256163#post256163

(and was actually coding errors with respect to linux vs windows)

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

4 Sep 2006, 1:56 PM

#3

kuroi

Totally Zenned

Join Date:: Apr 2006
Location:: London, UK
Posts:: 10,475
Plugin Contributions:: 11

Re: Upgrading your dB on Windows Servers - Important

What an honest chap :yes:

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

4 Sep 2006, 1:59 PM

#4

drbyte

Sensei

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

Re: Upgrading your dB on Windows Servers - Important

NEW ZIP RELEASED with bugfixes included:

zen-cart-v1.3.5-full-fileset-09042006.zip
at
http://sourceforge.net/project/showfiles.php?group_id=83781&package_id=171544

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

4 Sep 2006, 2:03 PM

#5

patski

Zen Follower

Join Date:: Nov 2004
Location:: Deal, Kent, UK
Posts:: 325
Plugin Contributions:: 0

Re: Upgrading your dB on Windows Servers - Important

kuroi - for information I'm pretty sure mine were set to read-only and still got wiped...

4 Sep 2006, 2:12 PM

#6

kuroi

Totally Zenned

Join Date:: Apr 2006
Location:: London, UK
Posts:: 10,475
Plugin Contributions:: 11

Re: Upgrading your dB on Windows Servers - Important

patski:

kuroi - for information I'm pretty sure mine were set to read-only and still got wiped...I've not seen that. I've upgraded two windows dBs this morning with configs set to read-only without problem (plus one controlled test case with them readable - ouch). If there are circumstances where even read-only files can be wiped out, that makes it even more critical that people download or apply Dr Byte's fix.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

4 Sep 2006, 2:30 PM

#7

patski

Zen Follower

Join Date:: Nov 2004
Location:: Deal, Kent, UK
Posts:: 325
Plugin Contributions:: 0

Re: Upgrading your dB on Windows Servers - Important

Kuroi - based on what you say then willing to accept they might not have been read only :shocking: - this is the first time I've tried a Windows installation. Funny though that if they weren't then the error message saying they were writeable didn't appear?

Is that normal?

4 Sep 2006, 2:34 PM

#8

drbyte

Sensei

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

Re: Upgrading your dB on Windows Servers - Important

Patski,
There was a bug in the code.

Grab the updated ZIP, and all will be fine...

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

4 Sep 2006, 2:41 PM

#9

patski

Zen Follower

Join Date:: Nov 2004
Location:: Deal, Kent, UK
Posts:: 325
Plugin Contributions:: 0

Re: Upgrading your dB on Windows Servers - Important

Hi Dr B I've done that - sorry I seem to be posting in two threads now. I applied the fix you mentioned and did a fresh reinstall and all okay except for telling me I need a db upgrade - version details supplied there. Does the new zip contain anything else?

And can you confirm whether a Windows installation will tell you if the config files aren't read-only? I've just tested and there is no message even with them not read-only. This may have been the case in 1.3.02 as well.

4 Sep 2006, 7:26 PM

#10

patski

Zen Follower

Join Date:: Nov 2004
Location:: Deal, Kent, UK
Posts:: 325
Plugin Contributions:: 0

Re: Upgrading your dB on Windows Servers - Important

patski:

And can you confirm whether a Windows installation will tell you if the config files aren't read-only? I've just tested and there is no message even with them not read-only. This may have been the case in 1.3.02 as well.

Dr B I know it's been a busy day - just in case you missed this...

By the way the upgrade on a Linux server naturally caused no problems at all!

4 Sep 2006, 7:29 PM

#11

ajeh

Oba-san

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

Re: Upgrading your dB on Windows Servers - Important

Thanks much for the update ... always helpful to know ... :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!