SQL error from side box index

[24star]

Hello,

I am having a SQL index problem when click a company from "Manufacturers" or "Record Companies" from the side boxes. When ever I click a company, it produces something like:

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

Please anyone show me what the problem is.
Many thanks!

[superprg]

Not sure but this query is wrong
[select from where record_company_id = 2]

It should be
[select * from TABLE_NAME where record_company_id = 2]

[superprg]

Read this:

http://www.zen-cart.com/forum/archiv...p/t-45369.html

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

[24star]

Amazing!!!

Thank you for the quick reply! It's fixed now. I love this place.

[superprg]

Glad you got it fixed!