Hi There,

I was wondering if anyone could help me please?

I have a Zen Cart install that has fallen over and a friend has asked me to look at it.

Basically, when someone hits the homepage the following error occurs:

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']

I googled this problem and it looks initially like it could be something to do with SEO URLs and the suggested fix is reset the URL cache.

So, I logged into the admin side of the shop and was presented with the admin front page with no problem. BUT, whenever i click on any link in the admin page it asks me to log in again!

So, i basically cant get to any admin functions. i just keep getting logged out and when i log in all i can get to is the admin front page.

Can anyone help please?

Thanks

Trev