Zen Follower
- Join Date:
- Jul 2006
- Posts:
- 154
- Plugin Contributions:
- 0
Server upgraded mysql and there are problems - upgrading questions on 1.3.6 to 1.3.7
I have a problem with the server that I installed a 1.3.6 cart, which has been running perfectly with no problems....additions and security bugs have always been added..... However the problem is that the server upgraded their mysql database to mysql5, which also changed the direction of the original config files for from "localhost" to another address. The server wanted me to change the configuration so that they could disable the other server...however when I just adjusted the config files, I got this error when trying to go to a product or category on the cart: "invalid column....'p.products_id' not found..."
First, can I proceed without having to upgrading the cart (as the client would prefer not to do it at this time), and what would need to be changed other than the config files in order not to receive those errors.... How should I proceed? Or if I have to do a full upgrade, how do I proceed with this mysql change...so that there is little to no down time on the site? There was custom work done to the cart, but those directories of course were set in overrides as templates (so that's not a problem)...also the admin directory was changed for security reasons. I'm not sure how to do this upgrade and if so, do I need to just do an entire new install? Or is there a manual installation that can be done to fix the immediate problem, and I can do the upgrade later as the client requests? This one really has me stumped. (still a newbie)
I appreciate your great expertise and advise as always...thanks for your help.
Kinget