Title: Database errors
Last modified: August 21, 2016

---

# Database errors

 *  [dashaluna](https://wordpress.org/support/users/dashaluna/)
 * (@dashaluna)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/db-errors-3/)
 * 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
 * [http://wordpress.org/extend/plugins/relevanssi/](http://wordpress.org/extend/plugins/relevanssi/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [dashaluna](https://wordpress.org/support/users/dashaluna/)
 * (@dashaluna)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/db-errors-3/#post-3771456)
 * 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](https://wordpress.org/support/users/msaari/)
 * (@msaari)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/db-errors-3/#post-3771704)
 * 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.

 * ![](https://ps.w.org/relevanssi/assets/icon-256x256.png?rev=3529670)
 * [Relevanssi - A Better Search](https://wordpress.org/plugins/relevanssi/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/relevanssi/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/relevanssi/)
 * [Active Topics](https://wordpress.org/support/plugin/relevanssi/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/relevanssi/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/relevanssi/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [db](https://wordpress.org/support/topic-tag/db/)
 * [errors](https://wordpress.org/support/topic-tag/errors/)

 * 2 replies
 * 2 participants
 * Last reply from: [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/db-errors-3/#post-3771704)
 * Status: not a support question