Application of SQL Patch question

16 Sep 2006, 7:39 PM

#1

brad512

New Zenner

Join Date:: Mar 2006
Location:: BC, Canada
Posts:: 79
Plugin Contributions:: 0

Application of SQL Patch question

Perhaps in hindsight I approached this upgrade in an unorthodox manner:

I upgraded the includes folder directory by doing a file by file comparison.
Upgraded the admin folder, again with a file comparison
Applied the patches found in the zc_install/sql folder.
Reinstalled contributions such as IH2 and user tracking

Is this approach flawed, particularly the mysql patches?

It is still sitting on my home machine, I will deploy some time today...still looking for flaws.

Thanks

Brad

Version 1.3.7

16 Sep 2006, 7:47 PM

#2

drbyte

Sensei

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

Re: Application of SQL Patch question

brad512:

Applied the patches found in the zc_install/sql folder.
If you use your browser and run zc_install/index.php and choose Database Upgrade and let IT apply the patches, you'll be safer.

The admin "SQL Patch" tool is not intended for system upgrades. It is intended for working with mods/contributions only.

.
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, 7:56 PM

#3

brad512

New Zenner

Join Date:: Mar 2006
Location:: BC, Canada
Posts:: 79
Plugin Contributions:: 0

Re: Application of SQL Patch question

Thanks..I guess I'll have to rename my admin folder back to "admin"...I had changed it as per recommendations. when I run the localhost/zc_install/index.php it complains abount not finding the configure.php

thanks

Brad

Version 1.3.7

16 Sep 2006, 9:23 PM

#4

drbyte

Sensei

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

Re: Application of SQL Patch question

Yes, that's one caveat; however for the 2 minutes it takes, it shouldn't be a huge problem. There's no need to edit the /admin configure.php file for this process... just rename the 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, 11:52 PM

#5

brad512

New Zenner

Join Date:: Mar 2006
Location:: BC, Canada
Posts:: 79
Plugin Contributions:: 0

Re: Application of SQL Patch question

Thanks

I was glad to hear that i didn't need to change the settings inside of configure.php...Mind you that wouldn't have been a big effort either.

I did have one problem : I couldn't access /zc_install...kept giving me an error - said I should contact the webmaster.

I did look at .htaccess and uncomment the last two lines as it indicated - but still the same problem. I finaly deleted the .htaccess an every think went okay.

Version 1.3.7