I am moving servers and this is what I have done so far.
1. Uploaded and installed the same verson of zencart on the new server.
2. copied the old site to the new server saving the config files from the new install.
3. did a back up of the old data base
4. imported the old data base into the new data base on the new server.
Now here are the problem I am getting:
in the data base inport it says "Import has been successfully finished, 0 queries executed."
When I go to the site this is what it says:
1054 Unknown column 'c.parent_id' in 'on clause'
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='1' WHERE c.categories_id=cd.categories_id AND cd.language_id='1']
Can some one please help me with this I have been working on it for 3 days and can make it work?