The complete error is this:
WordPress database error Table 'wp_cf7dbplugin_st' doesn't exist for query INSERT INTO wp_cf7dbplugin_st VALUES ('1423050752.2563') made by require('C:\Inetpub\vhosts\httpdocs\newsite\wp-blog-header.php'), require_once('C:\Inetpub\vhosts\httpdocs\newsite\wp-includes\template-loader.php'), include('C:\Inetpub\vhosts\httpdocs\newsite\wp-content\themes\mytheme\template-thanksForSponsoring.php'), do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, CFDBShortCodeSavePostData->handleShortcode, do_action_ref_array, call_user_func_array, CF7DBPlugin->saveFormData, CF7DBPlugin->generateSubmitTime
I have turned OFF all generate subtime options I could find. I don’t actually have CF7 installed.. could this be why I am getting errors?!
One more thing to add. The data IS actually saved to the database even though I get those errors.
Looks like the table failed to create during the last upgrade. As you see, that doesn’t break anything. This table just helps ensure you don’t get 2 submissions with the same timestamp.
Go into PHPMyAdmin and add it:
CREATE TABLE IF NOT EXISTS wp_cf7dbplugin_st (submit_time DECIMAL(16,4) NOT NULL, PRIMARY KEY (submit_time))
What an absolute legend you are Michael! That worked for me. THANK YOU!
It’s strange, but I uninstalled the plugin and removed everything then re-installed it afresh and still the table did not create.
Looks like I missed something in the fresh install case. I’ll fix that. Thanks for bringing to my attention.
Pleasure. Glad I could help! Amazing plugin. 🙂
Hi Michael.
Another bug revealed itself. It looks like it has to do with duplicate entries.
WordPress database error Duplicate entry ‘111111111’ for key ‘PRIMARY’ for query INSERT INTO cf7dbplugin_st VALUES …. etc
Could you have a look at this, please? It feels like it’s tied in with the previous issue I raised.
What are you doing when you see this error? If you do it again, do you see the exact same thing?
I’m not really sure. A user reported it. I have updated to latest version and have not been able to replicate so looksl ike it is fixed. Will post a new thread if I find it again. 🙂
I had the same problem of non-existant table.
Recreated it.
Currently, all seems well.
I suggest that it will part of the upgrade for the next version.
Thanks for the plugin!
