New 2 Zen - Data Migration
Morning, as the subj states I am new to Zen but really like the look / feel being a php / mysql guy. Not sure where the question fits so 'general' it is.
I have a client with 3 carts (soon to be 4). They have 2 seperate mysql databases;
let's say db1 and db2
db1 is a regular store with customer pricing
db2 has 2 stores, another customer one and a contract store, so the mysql layout has;
products and contractproducts for example
db1 is outdated and I wish to take db2 contract store and implement in db1;
I did a backup of the db, removed the customer cart in db1. In the export I removed the customer cart keeping only the constore info. Did a find/replace of constore with '' so all the tables matched the original install so I now have an export with table names;
I did an upload into db1, with all tables except the configuration one (as it looks, that is what keeps mysql server info), so I will use the original db1 config table (as that has the db1 info and all the table names match)
After all that, I went to the /store to get;
1054 Unknown column 'startdate' in 'field list'
I poked around on this site and the few posts pointed to a includes/counter.php but I am not sure why that would have anything to do with the data simply being changed.
You can goto the /store/admin page which looks fine, upong login the red banner shows you need to update the db version, yet if you follow, goto tools, versions, check it says you are using the latest. This is hosted by godaddy so I don't have shell, nor access to update anything in that respect but should be fine as the check showed.
The only other note is on the restore, I did empty the admin_logs table as it was huge and there is no real reason to need it on a re-init of the cart.
So.... after all that, the question is simply how to update products from another cart. Do I simply take the few tables with the prod, categories, etc. and try that? Also, I will chk the custom section, but since they will have 4 stores, I am going to write a few product pages that will allow for one page updates etc. to multiple stores at once.
Thanks for any posts or advice on the above issue.
By flambeau in forum All Other Contributions/Addons
Last Post: 24 Jul 2009, 06:18 PM
By Magician742 in forum General Questions
Last Post: 17 Jun 2006, 04:31 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC