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

[SamLiu]

Please help.

When I edit a product, when I click "Preview", I can see "For more information, please visit this products webpage".

However, in a real page, this statement and the link does not show up.

Please help me resolve this problem.

I am using Zen Cart v. 1.3.8a.

Sam

[Ajeh]

There are two URLs possible on a Product ...

One is the specific Product URL where you can click the link and go to a specific URL that was added at the time the Product is added/edited ... Catalog ... Categories/Products ...

The other, is the Manufacturers' URL that is added to the Manufactuer information in the Catalog ... Manufacturers ... when added/edit ...

The URL added to the individual Product is controlled in the Catalog ... Product Type ... EDIT LAYOUT ...

Show Product URL
Display URL on Product Info 0= off 1= on

The URL from the Manufacturer is controlled in the sideboxes from the Tools ... Layout Boxes Controller ... and turn on the Manufacturers Info box:
sideboxes/manufacturer_info.php

which will show when on the Products Info page ...