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

Grégory Viguier
(@greglone)

13 years, 5 months ago

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/

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

Plugin Author Michael Simpson
(@msimpson)

13 years, 5 months ago
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. 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
(@greglone)

13 years, 5 months ago

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.