Errors and notices after installing

  • Resolved swinggraphics

    (@swinggraphics)


    2 years, 11 months ago

    I see these when adding/editing posts after activating the plugin.

    `WordPress database error: [Table ‘localhost_wp.wpftsi_index’ doesn’t exist]
    update wpftsi_index wi left join wp_posts p on p.ID = wi.tid and wi.tsrc = “wp_posts” set wi.force_rebuild = 1 where (wi.force_rebuild = 0) and ((p.ID is null) or (wi.tdt != p.post_modified))

    WordPress database error: [Table ‘localhost_wp.wpftsi_index’ doesn’t exist]
    select p.ID from wp_posts p left join wpftsi_index wi on p.ID = wi.tid and wi.tsrc = “wp_posts” where (wi.id is null) limit 0, 1000

    WordPress database error: [Table ‘localhost_wp.wpftsi_index’ doesn’t exist]
    update wpftsi_index set force_rebuild = 2 where tid = “7” and tsrc = “wp_posts”

    WordPress database error: [Table ‘localhost_wp.wpftsi_index’ doesn’t exist]
    select count(*) n_inindex, sum(if ((force_rebuild = 0) and (build_time != 0), 1, 0)) n_actual from wpftsi_index where tsrc = “wp_posts”

    WordPress database error: [Table ‘localhost_wp.wpftsi_tw’ doesn’t exist]
    select count(*) n from wpftsi_tw

    WordPress database error: [Table ‘localhost_wp.wpftsi_words’ doesn’t exist]
    select count(id) nw_total from wpftsi_words

    Notice: Undefined offset: 0 in /wordpress/wp-content/plugins/fulltext-search/includes/wpfts_index.php on line 1914

    Notice: Trying to access array offset on value of type null in /wordpress/wp-content/plugins/fulltext-search/includes/wpfts_index.php on line 1914

    Notice: Undefined offset: 0 in /wordpress/wp-content/plugins/fulltext-search/includes/wpfts_index.php on line 1915

    Notice: Trying to access array offset on value of type null in /wordpress/wp-content/plugins/fulltext-search/includes/wpfts_index.php on line 1915`

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter swinggraphics

    (@swinggraphics)

    Updating a post also fails with “Updating failed. The response is not a valid JSON response.”

    Plugin Author Epsiloncool

    (@epsiloncool)

    Hi again @swinggraphics

    Please check if you have tables wpftsi_* exists in the database and if not, just start rebuilding the index.

    In case rebuilding the index does not help, check if the DB user has the right to create and modify data tables.

    Hope this will help.

    Thread Starter swinggraphics

    (@swinggraphics)

    A plugin in production should not generate errors. You need to add some checks in your code to make sure you aren’t trying to access something that isn’t available.

    In this case, I was purposefully waiting to run the index until after making some shortcode and post changes that would affect indexing.

    Plugin Author Epsiloncool

    (@epsiloncool)

    Hi @swinggraphics

    Absolutely right. These tables have to be created immediately when the plugin is activated, no matter if indexing is started or not.

    It’s a known issue and we going to fix that in the next versions. Already working on that!

    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Errors and notices after installing’ is closed to new replies.