By mohamedn on

Hi all,

We've just moved our site to a new host (basically copied over all files and dumped the DB) but we are now getting the following error on any pages that try to build a view off flexinode content: 

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 ('125','94','97','98','92','126','96','93','91','95')) ORDER BY node.created' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (node.status = '1') AND (node.type IN ('flexinode-2')) AND (.tid IN ('125','94','97','98','92','126','96','93','91','95')) ORDER BY node.created DESC LIMIT 0, 7 in /home/916/domains/qatarliving.com/html/includes/database.mysql.inc on line 120.

Has anyone faced something like this or do you have any idea about how I would look at solving it...

Thanks in advance!

⋅ Categories: Drupal 4.7.x

Comments

anner’s picture

anner commented

I had something like this last week. I had added a content type to one of my vocabularies. I basically had to go through each view and add one of my filters back. My Taxonomy is one of ... filter was corrupted.