WordPress.org

Forums

WordPress database error when search (4 posts)

  1. argentine
    Member
    Posted 9 years ago #

    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

  2. Mark (podz)
    Support Maven
    Posted 9 years ago #

    "Just change of hosting"

    Looks like you didn't reinstall the plugin correctly.

  3. argentine
    Member
    Posted 9 years ago #

    I will try to do it again
    Thanks

  4. argentine
    Member
    Posted 9 years ago #

    workin
    Thanks podz

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.