resolved - errors magically dis-appeared!

I added a field to an existing CCK/content type (prayerpost) that already had a view (view A), it was a drop down list field. I created a filter in an additional view (view B) so the following situation exists. If a certain "term" (not sure if related to taxonomy module) is selected in the drop down list of the cck type field, than that piece of content gets sent to view B (a block). However, I did that, and tried selecting the specified term in an existing peice of content, and the original view that contained the cck type mentioned above didnt come up when the URL was selected, just error "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 'NOT IN ('25') OR .tid IS NULL))' at line 1 query: (WHICH WENT ON TO SAY...)

SELECT count( DISTINCT(node.nid)) FROM node node WHERE (node.type IN ('prayerpost')) AND ((.tid NOT IN ('25') OR .tid IS NULL)) in /path/to/me/database/includes/database.mysql.inc on line 172.

I was told by someone on forums (tanoshimi )that it should read something more like this...

SELECT count( DISTINCT(node.nid)) FROM node INNER JOIN term_node ON node.nid = term_node.nid WHERE (node.type IN ('prayerpost')) AND ((term_node.tid NOT IN ('25') OR term_node.tid IS NULL))

so not sure why views module is confused or what caused this, a bug or my own error? Not sure if this related but just before this bit of drupalling the versions of Mysql and PHP changed due to host switch-over.. MySQL version 4.0.16 to 5.0.48 / PHP version 4.3.11. to 5.1.6-3 not sure if that has anything to do with it. i.e. sql syntax.

please help..