Error In SQL Syntax

[hrsteel]

When I click on a manufacturer from the drop down list I get this error message:
"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 = 16' at line 2
in:
[select from where manufacturers_id = 16]"
How do I fix this please?

[Ajeh]

This sounds like the Table name define for the manufacturers table is not defined ...

If you could go to your Tools ... Developers Tool Kit ... and in the bottom input box search on:
define('TABLE_MANUFACTURERS'

and select Catalog/Admin and click search ...

What comes up for that?

[hrsteel]

I get this:

/home/touring/public_html/includes/database_tables.php

Line #49 : define('TABLE_MANUFACTURERS', DB_PREFIX . 'manufacturers');

Thanks for any help.

[Ajeh]

This makes it a little harder to find ...

You have a syntax error on:
select from where manufacturers_id = 16

as there isn't a table name in it ...

That makes it really really fun to try to find the error ...

you can try a search on:
where manufacturers_id =

and see if any of the select statements that helps you find are missing a table name in them ...

[hrsteel]

This is what I get when I search for where manufacturers_id =
What am I looking for? I don't know what a table name is.

/home/touring/public_html/admin/includes/functions/general.php

Line #698 : where manufacturers_id = '" . (int)$manufacturer_id . "'

/home/touring/public_html/admin/manufacturers.php

Line #43 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #52 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #56 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #94 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #102 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #104 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #109 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #118 : where manufacturers_id = '" . (int)$manufacturers_id . "'");

Line #183 : where manufacturers_id = '" . (int)$manufacturers->fields['manufacturers_id'] . "'");

/home/touring/public_html/admin/media_manager.php

Line #118 : // where manufacturers_id = '" . (int)$manufacturers_id . "'");

/home/touring/public_html/admin/product_types.php

Line #112 : // where manufacturers_id = '" . (int)$manufacturers_id . "'");

/home/touring/public_html/includes/modules/meta_tags.php

Line #134 : $sql = "select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$include_manufacturers_id . "'";

Line #156 : $sql = "select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'";

/home/touring/public_html/includes/modules/pages/redirect/header_php.php

Line #36 : WHERE manufacturers_id = :manufacturersID

Line #49 : WHERE manufacturers_id = :manufacturersID

Line #73 : WHERE manufacturers_id = :manufacturersID

[Ajeh]

Do you get the error if you switch to the Classic Template?

[hrsteel]

Yes I do.

[Ajeh]

Only thing I can suggest then is to review the code for the sidebox for where it is missing the table name or get something like Beyond Compare from scootersoftware.com and compare the code from your site to a clean Zen Cart and see where your code has bad, missing or corrupt code ...