Trying to fix what Fantastico broke..

[Moebiusenterprises]

Well, after long awaiting, Fantastico *finally* provided the 1.3.5 realease (YAY!)
However, when I upgraded, it did two things to mess up my day (so far)

1) it didn't upgrade the DB (which I can run the scripts and do manually, and *have to* since Fantastico adds "zen_" in front of everything..
2) I'm blocked out of Admin, and it won't re-send passwords via e-mail
I've tried fixing this in MySql, but it's not working for me..

I'm pulling out my hair, here... can anyone help???

Vicki

[Moebiusenterprises]

ok folks, I figured out the problem, and all's well now...

Vicki

[misty]

ok folks, I figured out the problem, and all's well now...

Care to share how you achieved this.. may help other users
of Zencart via Fantastico

[Moebiusenterprises]

Care to share how you achieved this.. may help other users
of Zencart via Fantastico

No problem -
towards the end of the DB update, there are two lines regarding updating the authorize net table. That failed (looks like it was already updated), and didn't permit it to complete the db update. I took the 1.3.5 full zipfile and found the offending chunks of code (in zen_install/sql) ... it's the 1.3.0.2 to 1.3.5 db update file.
The only things that didn't run were the two snippets below the lines that failed... the ones that actually update the version markers in the db. I went to MySql, and ran those... voila!

NOTE: Fantastico somehow alters ZenCart and it's DB. all the DB tables have 'zen_' (without the quotes) before the regular table names. You'll have to add this to any sql that you're trying to manually run on a Fantastico installation.

It actually turned out to be a lot easier than I thought it would be.

Vicki
www.moebiusenterprises.com

[misty]

Thanks Vicki, am sure your info is going to help someone else