Manufacturer Link Error

[Ladybug]

When clicking on the Manufacturer link in the box to the right I get the error below. Does anyone know what is wrong and how I can fix it?


Warning: constant(): Couldn't find constant in /hsphere/local/home/mcdennis/digitalscrapbookcountry.com/cart/includes/init_includes/init_add_crumbs.php on line 45

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 'from where manufacturers_id = 13' at line 2
in:
[select from where manufacturers_id = 13]

Thanks

[Ajeh]

Check that you have applied all of the fixes for v1.3.5 ...

http://www.zen-cart.com/forum/showthread.php?t=45377

[handkem]

Where do you apply the following code to the database for this fix? I am having the same problem. I read the thread, but am not sure where to apply this. Any ideas?

#
# Updating table `get_terms_to_filter`
#
ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;
ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MANUFACTURERS', get_term_name_field = 'manufacturers_name' where get_term_name = 'manufacturers_id';
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MUSIC_GENRE', get_term_name_field = 'music_genre_name' where get_term_name = 'music_genre_id';
UPDATE get_terms_to_filter SET get_term_table = 'TABLE_RECORD_COMPANY', get_term_name_field = 'record_company_name' where get_term_name = 'record_company_id';

[Ajeh]

You could use the Tools ... Insert SQL Patches ... for that group to processes in the database ...

[handkem]

That did work for me, thank you for your help.

[Ladybug]

Thank you for your help! That worked perfectly.

Ladybug