WordPress.org

Support

Support » How-To and Troubleshooting » WordPress database error when search

WordPress database error when search

  • argentine

    @argentine

    Just change of hosting
    When I use the search I have this message :
    http://blog.argentine-news.com/

    WordPress database error: [Table ‘argentin_wrdp1.wp_sem_nodes’ doesn’t exist]
    /* sem_search_reloaded */ SELECT posts.*, CASE WHEN sem_nodes.node_name REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ AND sem_nodes.node_name REGEXP ‘([[:<:]]|:space:)s([[:>:]]|:space:)’ THEN 1 ELSE 0 END AS all_in_title, CASE WHEN sem_nodes.node_name REGEXP ‘(([[:<:]]|:space:)exil([[:>:]]|:space:))? ‘ THEN 1 ELSE 0 END AS title_in_same_order, CASE WHEN sem_nodes.node_name REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ THEN 1 ELSE 0 END AS one_in_title, CASE WHEN sem_nodes.node_content REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ AND sem_nodes.node_content REGEXP ‘([[:<:]]|:space:)s([[:>:]]|:space:)’ THEN 1 ELSE 0 END AS all_in_content, CASE WHEN sem_nodes.node_content REGEXP ‘(([[:<:]]|:space:)exil([[:>:]]|:space:))? ‘ THEN 1 ELSE 0 END AS content_in_same_order, CASE WHEN sem_nodes.node_content REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ THEN 1 ELSE 0 END AS one_in_content, MATCH ( sem_nodes.node_name, sem_nodes.node_content ) AGAINST ( ‘exil s’ ) AS mysql_score FROM wp_posts AS posts INNER JOIN wp_sem_nodes AS sem_nodes ON sem_nodes.node_id = posts.ID WHERE ( posts.post_status = ‘static’ OR posts.post_status = ‘publish’ ) AND posts.post_date <= ‘2005-09-23 16:56:59’ AND ( sem_nodes.node_name REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ OR sem_nodes.node_content REGEXP ‘([[:<:]]|:space:)exil([[:>:]]|:space:)’ ) GROUP BY posts.ID ORDER BY all_in_title DESC, title_in_same_order DESC, one_in_title DESC, all_in_content DESC, content_in_same_order DESC, one_in_content DESC, mysql_score DESC, posts.post_title ASC LIMIT 0, 15

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error when search’ is closed to new replies.