All prods not working

[DrizzUK]

I just cannot get the All Products Contributions (all-prods v4.0) to work. It all seems to work until I click on a product when I get this:

 

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 = '3' and c.categories_id = cd.categories_id an

 

I thought I'd followed the instruction to the letter but I guess not.

I only have the shop on my system at the moment so not sure if this might be causing this issue.

 

any help or pointer in the right direction please.

[lmassia]

I just cannot get the All Products Contributions (all-prods v4.0) to work. It all seems to work until I click on a product when I get this:

I thought I'd followed the instruction to the letter but I guess not.

I only have the shop on my system at the moment so not sure if this might be causing this issue.

 

any help or pointer in the right direction please.

<{POST_SNAPBACK}>

 

This line occurs in catalog/includes/boxes/categories.php.

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");

 

Check that you have every item as shown.

 

Hope this helps.

[DrizzUK]

This line occurs in catalog/includes/boxes/categories.php.

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");

 

Check that you have every item as shown.

 

Hope this helps.

<{POST_SNAPBACK}>

 

Thanks so much, I'll check that out tonight and report back :)

[DrizzUK]

Thanks so much, I'll check that out tonight and report back :)

<{POST_SNAPBACK}>

 

OK I managed to sort this I thing. Instead of using the provided catagories.php file I install manually into information.php and I no longer get an error. But now when ever I click the All Products link it just takes me back to the front page and doesn't give me a page with all products listed, or is that not the real purpose?

[DrizzUK]

OK all sorted now. I forgot to activate the All Products option in the admin.

 

Note to self, make sure it reads true and not false :blush: