Totally Zenned
- Join Date:
- Jul 2005
- Location:
- Brooklyn NY
- Posts:
- 498
- Plugin Contributions:
- 0
changing servers!! and its not working Please help!!
I am moving servers and this is what I have done so far.
- Uploaded and installed the same verson of zencart on the new server.
- copied the old site to the new server saving the config files from the new install.
- did a back up of the old data base
- 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'
in:
[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?