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