Title: [Plugin: Contact Form 7 to Database Extension] Database error
Last modified: August 20, 2016

---

# [Plugin: Contact Form 7 to Database Extension] Database error

 *  [Grégory Viguier](https://wordpress.org/support/users/greglone/)
 * (@greglone)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-error-93/)
 * Hello.
 * Right after activation, and on the plugin settings pages:
 * >  WordPress database error: [Table ‘my_table.foo_cf7dbplugin_submits’ doesn’t
   > exist]
   >  select distinct `form_name` from `foo_cf7dbplugin_submits` order by`
   > form_name`
 * Another thing:
    In “Which fields/columns do you want to display?”, “Which rows/
   submissions do you want to display?”, and “orderby”, the selects are empty (and
   return null). (Okay, this one is understandable, since the table does not exists
   or is empty)
 * Last detail, about translation:
    For “Evaluate this plugin”, in (real) French
   we don’t say “Évalué ce « PlugIn »” but “Évaluer ce « Plugin »” (my eyes are 
   bleeding u_u).
 * Thank you for your plugin.
 * [http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/](http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/)

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

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-error-93/#post-3297350)
 * Evidently the plugin was unable to create the table when activated. This may 
   be a permission problem in MySQL. You might try creating the table by running
   the following queries in PHPMyAdmin (I’m assuming your table prefix is “foo” 
   instead of the default “wp”)
 *     ```
       CREATE TABLE IF NOT EXISTS foo_cf7dbplugin_submits (
                   submit_time DECIMAL(16,4) NOT NULL,
                   form_name VARCHAR(127) CHARACTER SET utf8,
                   field_name VARCHAR(127) CHARACTER SET utf8,
                   field_value LONGTEXT CHARACTER SET utf8,
                   field_order INTEGER,
                   file LONGBLOB)
   
       ALTER TABLE foo_cf7dbplugin_submits ADD INDEX submit_time_idx ( submit_time )
       ALTER TABLE foo_cf7dbplugin_submits ADD INDEX form_name_idx ( form_name )
       ALTER TABLE foo_cf7dbplugin_submits ADD INDEX field_name_idx ( field_name )
       ```
   
 * If you would like to update the french translation, [follow directions on this link](http://cfdbplugin.com/?page_id=7).
   But instead of creating a new translation file, update the existing translation
   file at:
 * wp-content/plugins/contact-form-7-to-database-extension/languages/contact-form-
   7-to-database-extension-fr_FR.po
 *  Thread Starter [Grégory Viguier](https://wordpress.org/support/users/greglone/)
 * (@greglone)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/database-error-93/#post-3297355)
 * Thank you for your answer Michael.
 * Now you mention it, it may be a problem on my side: the site is on a local host
   on a NAS I recently bought. I’ll run the command ASAP (may be directly in the
   plugin, to be sure) and come back for the result (thanks to the new media modal
   window, WP3.5 give me a lot of work these days :/).
    Yes, I changed the table
   prefix for security reasons (but… Wait, it’s only a local site, why I bother 
   people with that ^^).
 * Thanks for the translation link, I’ll take a look (I don’t use such a system 
   for my own plugins, only en_US and fr_FR, shame on me >_<).
 * Greg

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

The topic ‘[Plugin: Contact Form 7 to Database Extension] Database error’ is closed
to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Grégory Viguier](https://wordpress.org/support/users/greglone/)
 * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/database-error-93/#post-3297355)
 * Status: not resolved