• Michael

    (@mbrownwebnetinteractivecom)


    I am using contact form 7 and Contact Form 7 to Database Extension ..

    I have a group called Contact form 1 .. that was working just fine .. then I upgraded to WP 3.1 and I can’t see anything .. it’s just blank!!!

    Now .. I had one other DB that is doing fine so either two things happened (this is my logic anyway) ..

    1 – There was a bug with the 3.1 WP upgrade and forms being saved w/ Contact Form 7 to Database Extension ..

    2. Or the db got so big that its lost in space …

    Im desperate to retrieve this Db .. please if anyone has any ideas please share them .. Thank You ..

Viewing 9 replies - 16 through 24 (of 24 total)
  • My theme ‘station’ does not appear to have one exactly called:
    wp-config.php

    Look for wp-config.php in the top level WP directory. It is not part of a theme.

    Ok, the
    define(‘WP_MEMORY_LIMIT’, ’64M’);
    is in the .php.ini place..

    Now how can I retrieve the old info.
    the form which was called either form 2 or vnla voting

    has resumed the day after the error and started from scratch and is now named vnla voting when you select the form to view the data base.. the one that was called form 2 has nothing in it any more (since the error) and all info that was in is vanished due to the memory limit.

    is it gone?

    I would not expect any data to be lost. The insert into the DB should not need much memory.
    There should only be a risk of memory issues when trying to retrieve and display all data in a form. And if that fails, then the page will not display right but would have no effect on the data saved in the DB.

    Can you look at the DB table to see what is there?

    … everyone else on this page is named mike/michael lol

    but uhmm no i bring up form 2 (database, form 2) their is nothing but a white screen. I try to export, but nothing happens either.

    Would these files be stored in my host gator somewhere?

    On HostGator you can log into your cPanel account. Then you can click on phpMyAdmin icon in the Databases section. Then you select your WP database on the left menu. Then you can see all the tables in the database. That is where you can select export the wp_CF7DBPlugin_SUBMITS table as CSV. Click the wp_CF7DBPlugin_SUBMITS table, then click Export, select CSV, Click Go

    Note: be careful in phpMyAdmin, it is very powerful, if you click ‘Empty’, or ‘Drop’, your data can be deleted accidentally and permanently.

    Sweet! that worked. But it came out in excel as like one super long column thats like 70,000 long.

    I managed to extract all the emails from it through some excel formulas that pin pointed them. But the data in this state is to hard to organize. any thoughts on how i can make it look normal?

    Check out westcoastdjs.ca westcoastgirls.ca westcoastnightlife.ca to see what your helping with! it’s greatly appreciated. Thank you.

    Here is a post on how to write a pivot query to get your data. You can export that query’s results to CSV. You can use the query to create a view so you can save it.

    New in version 1.8, it will give you the pivot query. But you have to turn on the option in “Database Options” “Show the query used to display results”. Then go to the “Database” page and show your form. The query will be at the bottom of the page.

    Nice, thank you : )
    i also went into my php and extracted all the fields and played with them in 3 diff excel sheets and got it looking and sorted somewhat correct.

Viewing 9 replies - 16 through 24 (of 24 total)
  • The topic ‘Not saving submissions from Contact Form 7’ is closed to new replies.