Wrong stuff shown in the WP Admin area

  • Resolved morespinach

    (@morespinach)


    9 years, 8 months ago

    Inside WP Admin area, this plugin shows the following for my form “RegistrationForm_2014”:

    Returned entries 1 to 25 of 25 entries in the database

    When I manually go into the PhpMyAdmin and execute the SQL query: 

    SELECT * FROM domain_cf7dbplugin_submits
    WHERE form_name = 'RegistrationForm_2014'
    and field_name = 'firstname'

    This shows me that there are 46 rows!

    Showing rows 0 – 45 (46 total, Query took 0.0138 sec)

    What’s up? I am using the latest versions of everything: WP, Contact Form 7, and Contact Form DB.

    Please help!

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter morespinach

    (@morespinach)

    9 years, 8 months ago

    Btw, fortunately, the database info is correct. There are indeed 46 submissions. But the plugin shows only 25 of them in the WP admin area, which is very confusing and scary.

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 8 months ago

    Run this:

    SELECT * FROM domain_cf7dbplugin_submits
    WHERE form_name = 'RegistrationForm_2014'
    and field_name = 'firstname'
    ORDER BY submit_time

    Are there duplicate submit_time fields or does each row have a unique submit_time?

    Thread Starter morespinach

    (@morespinach)

    9 years, 8 months ago

    Thank you, there are 46 unique submit_time and submit fields.

    What should I do with this info?

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 8 months ago

    I will need to look at your site. If you are willing to give me a login, contact me at info@cfdbplugin.com

    Thread Starter morespinach

    (@morespinach)

    9 years, 8 months ago

    Thanks. Written to your email with password. Much appreciated.

    Thread Starter morespinach

    (@morespinach)

    9 years, 8 months ago

    Thank you very much for your help Michael. This is a very handy plugin.

    For those who might face the same issue again: the problem in my case was the timestamp’s value from old PHP and how it was getting stored in the old MySQL. I had upgraded both php and Mysql. MySQL 5.6 has a new way of storing temporal fields (such as datetime etc).

    In my case, PHP also showed “microtime(time)” in exponential form, which when converted into a timestamp for storage into the DB was not creating unique values.

    Michael fixed it. And now I know how to show my older values with a unique timestamp.

    Thanks

    Thread Starter morespinach

    (@morespinach)

    9 years, 8 months ago

    Closing.

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 8 months ago

    I will push an update of the plugin (version 2.8.6) to handle this issue.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Wrong stuff shown in the WP Admin area’ is closed to new replies.