[support] Another Database Problem

[skessler at denverdataman.com]

Thank you everyone who helped me figure out the last database problem my
site had but it appears I have another. I have tried the repair steps from
the last time and that did not work but these errors are different. Any
help is very much appreciated.



    * user warning: 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 'IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL))
)' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node
LEFT JOIN content_field_odering_filed node_data_field_odering_filed ON
node.vid = node_data_field_odering_filed.vid INNER JOIN node_access na
ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND
na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND (
(.tid IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) ) in
/home/kadimaso/public_html/denverdataman/includes/database.mysql.inc
on line 174.

    * user warning: 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 'IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) )
ORDER BY node_data' at line 1 query: SELECT DISTINCT(node.nid),
node_data_field_odering_filed.field_odering_filed_value AS
node_data_field_odering_filed_field_odering_filed_value FROM node node
LEFT JOIN content_field_odering_filed node_data_field_odering_filed ON
node.vid = node_data_field_odering_filed.vid INNER JOIN node_access na
ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND
na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND (
(.tid IN ('42')) AND ((.tid NOT IN ('40','39') OR .tid IS NULL)) )
ORDER BY node_data_field_odering_filed_field_odering_filed_value ASC
LIMIT 0, 10 in
/home/kadimaso/public_html/denverdataman/includes/database.mysql.inc
on line 174.

I am also getting:

user warning: 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
'IN ('39')) LIMIT 0, 10' at line 1 query: SELECT DISTINCT(node.nid),
node.title AS node_title, node.changed AS node_changed FROM node node
WHERE (.tid IN ('39')) LIMIT 0, 10 in
/home/kadimaso/public_html/denverdataman/includes/database.mysql.inc on
line 174.



The site is Druapl 5.14.

Thanks,
Steve