Manufacturers Error

[sicness]

run this SQL query
In ur admin area SQL patch or Phpmyadmin

#
# 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';

[zigzak]

Hi,
There is a link to an SQL code update in the post above yours which fixed the problem for me.

Oops, I was too slow - I see someone else has already posted the code again!

Regards,
David

[notset4life]

Got it this time. There was a "duplicate" error in the first line. After I removed that and ran the rest of the code, it worked.

thanks

[cjmarley]

I'm not getting the error after applying this patch but now when i do a search by manufacturer all I get is the search result page stating "At least one of the fields in the search form must be entered."

[Ajeh]

That was fixed in v1.3.5 ... not sure which version broke it off hand ...

[cjmarley]

Hmmm, I'm still getting that message and I'm running on the newest version. What files besides the template files that affect this function do I need to reupload?

[cjmarley]

help please?

[Ajeh]

Check that you updated the
/includes/index_filters files ...

/includes/pages files ...

/includes/modules/sideboxes files ...

/includes/templates/your_template_dir/sideboxes files ...

There are a lot of peices and parts related ...

Do you have something like Beyond Compare from scootersoftware.com that you can do a comparisson of a clean Zen Cart v1.3.5 and your site files and overrides?