Error

[Guest]

I get a error message when I try go on products or catogories..

 

This is the msg:

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and c.parent_id = '40' and c.categories_id = cd.categories_id a

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '40' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name

 

[TEP STOP]

 

This camed after all products install.. Can someone help me with this one please..

 

http://www.convoymail.no/catalog

[inetchoices]

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '40' and c.categories_id = cd.categories_id and cd.language_id='4' order by sort_order, cd.categories_name

 

What you need to do, is go into the file that this line of code is in (it looks like it's in categories.php) and delete the "and" after "where" (where and c.parent_id=...)

 

I had this problem before, but I can't for the life of me remember which file it was in.

 

Are you getting this error in Admin or when you are on your store page? If in Admin, the line of code is in /admin/categories.php

 

I hope.

 

Khim~

[Guest]

Thats it. Thx wery much. :)

[inetchoices]

You are so welcome!

 

It's nice to be able to help for a change. I'm usually the one asking all the questions :-)

 

I've only been using OSC since August, but I've read through the forums (especially Tips and Tricks) and done searches and read until I was cross-eyed.

 

I'm happy to know that all of my studying hasn't been in vain :-)

 

Best to you and your shop!!

 

Khim~