Viewing 12 replies - 1 through 12 (of 12 total)
  • I have a similar issue. The database records contact form submissions and they can be viewed via the dashboard, but export shortcodes are broken as of WP 4.4.2 update. I can export data from the dashboard, but not via shortcode, nor can I embed contact forms DB data into pages via shortcode since 4.42.

    Plugin Author Michael Simpson

    (@msimpson)

    @MisterZookeeper – I think you have a different issue. Would you post the export shortcode that you are using, and the resulting URL? (replace your actually site name in your URL with something like “example.com”. I mainly want to see the parameters).

    Also: are you using WPML plugin?

    Thank you for the response, Michael.

    We do not use the multilinqual plugin WPML

    Our shortcodes look like this:

    [cfdb-export-link form="My Form" role="Contributor" linktext="My Link Text"]
    or
    [cfdb-export-link form="My Form" role="Administrator" linktext="My Link Text"]
    or (for debugging)
    [cfdb-datatable form="My Form" role="Administrator" ]
    or
    [cfdb-count form="My Form" role="Administrator" ]

    We ran at various permission levels to rule out issues there. We are calling correct form names – the shortcode worked for more than a year as is until the date of 4.4.2 update when it stopped working with no other changes to the site on our end, except new simple content (posts).

    The export link produces an export file, but it is empty. We created datatable and count shortcodes to use in debugging after the export link shortcode stopped working. When we place an incorrect/void form name in the datatable short code, it renders your HTML datatable wrapper:

    Show <option dropdown renders> entries
    Search: <textbox renders>
    No data available in table
    Showing 0 to 0 of 0 entries

    When we replace void form name with a valid form name in datatable shortcode, the html breaks where the shortcode appears

    e.g. with invalid form name:

    <html>
    <body>
    Content
    [DATATABLE SHORTCODE HERE RENDERS EMPTY HTML WRAPPER]
    More page content
    </body>

    with valid form name:

    <html>
    <body>
    Content
    [DATATABLE SHORTCODE HERE BUT NOTHING RENDERS ON PAGE
    -- not shortcode result and no further content]

    Another factor I considered was size of db results. A couple of shortcodes query forms return around 9,000 results each. If this were an issue, we would expect count and datatable(paginated) shortcodes to work even if a growing export file ran into server limits.

    Plugin Author Michael Simpson

    (@msimpson)

    Thanks for the information. I’m unclear on a few points.

    Your [cfdb-export-link] short code is not working, you listed several other shortcodes … do they work or not?

    I think that you are saying that [cfdb-export-link] fails but everything else works. Is that true?

    If you suspect that the number of values in the export is the problem, you can test that by adding “limit” to the shortcode. For example, to test exporting only 5 items use:
    [cfdb-export-link form=”My Form” role=”Contributor” linktext=”My Link Text” limit=”5″]
    (however I don’t think that is the problem)

    Since you have a lot of results, I suggest adding unbuffered=”true” to the short code for less usage of memory.

    But more directly to the issue: I asked for the URL that the shortcode was producing. You haven’t provided that. I want to understand if the URL that the [cfdb-export-link] produces is bad vs the link is OK but the export function is failing.

    Another thought: delete the plugin and re-installed it. By default you will not loose any data (unless you changed that setting in the CFDB Options page)

    No, all shortcodes are broken. We tested the others after export shortcode broke. The others nominally work unless we call a valid form – i.e. they don’t really work, but they don’t break page rendering until we call a valid form name in the short-code.

    The link produced by export shortcode looks like this:

    <a href="https://www.example.com/wp-admin/admin-ajax.php?action=cfdb-export&form=My+Form+Name">Export My Form</a>

    Plugin Author Michael Simpson

    (@msimpson)

    Thanks for the clarification. The link product looks OK.

    I suggest re-install the plugin and see if that helps at all. It seems like something major is messed up.

    We might try deleting plugin, but we might want to backup data table first.

    Even with

    drop this plugin's Database table on uninstall = false

    delete warning page says:

    You are about to remove the following plugin:
    *  Contact Form DB by Michael Simpson (will also delete its data)
    Are you sure you wish to delete these files and data?
    Plugin Author Michael Simpson

    (@msimpson)

    That’s a standard WordPress message. But it can’t hurt to backup.

    I replaced the plugin by disabling, deleting from server and replacing with fresh download but still get 0 byte export files.

    I thought that was a standard message, but we still want to backup tables before we take a chance of losing records we’d have to restore from deeper backups, so it might be a day before I can tell you results of a full plugin replacement

    Plugin Author Michael Simpson

    (@msimpson)

    Makes sense. Let me know.

    I reinstalled the plugin, but shortcodes still do not produce results.

    Any advice or tips on how to get export shortcodes working again?

    Only thing new I can report is that it does seem to work as a fresh install on another site. But our export shortcode stopped working as of WordPress 4.4 on the site we use most, with no other changes except the WP version update.

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Contact Form DB Broken after WordPress 4.4 update’ is closed to new replies.