Database errors

  • Hello,

    I’ve installed plugin in the dev environment and it works fine. I’ve migrated the whole setup (files + DB) onto staging environment.

    However, on staging I’m getting the following DB errors:

    WordPress database error: [Table 'db_name.prefix_relevanssi' doesn't exist]
SELECT COUNT(DISTINCT doc) FROM R433bx_relevanssi

WordPress database error: [Table 'db_name.prefix_relevanssi' doesn't exist]
SELECT COUNT(*) FROM R433bx_relevanssi

WordPress database error: [Table 'db_name.prefix_relevanssi' doesn't exist]
SELECT doc FROM R433bx_relevanssi ORDER BY doc DESC LIMIT 1

WordPress database error: [Table 'db_name.prefix_relevanssi' doesn't exist]
SELECT COUNT(DISTINCT(doc)) as cnt, term FROM R433bx_relevanssi GROUP BY term ORDER BY cnt DESC LIMIT 25

    I’ve deactivated and activated plugin – no luck, it still doesn’t work. I’ve check there are tables there with data.

    Any idea how to fix this?

    Many thanks,
    Dasha

    https://www.ads-software.com/extend/plugins/relevanssi/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter dashaluna

    (@dashaluna)

    I’ve been looking at it further and it seems that the tables are named incorrectly?

    My DB index is ‘R43my’ starts with capital letter. However, I’ve discovered that in the DB the tables are named as following:

    r43my_relevanssi
    R43my_relevanssi_cache
    R43my_relevanssi_excerpt_cache
    R43my_relevanssi_log
    R43my_relevanssi_stopwords

    Please note that the table r43my_relevanssi is named with all the small letters. I wonder if it breaks before of that.

    Hopefully the plugin author can look into it.

    Many thanks, Dasha

    Plugin Author Mikko Saari

    (@msaari)

    Relevanssi gets the table prefix from $wpdb->prefix, so if there’s a problem, it’s a WP problem, not a Relevanssi problem.

    That said, I think somebody else had a problem when using a database prefix that was in uppercase. You should probably try using a lowercase database prefix.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database errors’ is closed to new replies.