Trouble saving to DB using shortcode on protected page

  • Resolved Lucy Lehman

    (@mfp-ll)


    10 years, 2 months ago

    Thanks for this great plugin. Everything is working great in the WP Admin area. However, I would like to use this plugin for a small group who will edit only one table. I have set up a protected page using the User Access Manager plugin with the dbte shortcode. Display, add, edit functions work great but nothing saves to the DB, just an endless “saving” icon.

    Any suggestions?

    https://www.ads-software.com/plugins/wp-db-table-editor/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author bobbysmith007

    (@bobbysmith007)

    Hmmm… This usually indicates something went wrong while attempting to save the record.

    If this exact table works in admin, there could just be a problem with using it on protected pages. (I have only ever used it on admin pages). I will try to duplicate this on a test site (without permissions / other plugin stuff).

    The way to debug this is to view the request in the js-console (f12 in firefox or chrome). Clicking save will cause the request to show up in either the console or the net tab or both at which point you can expand the request to see the response. For more (any) inforation, turn on debugging (briefly for the test, dont leave it on for security reasons).

    In the wp-config.php:
    define('WP_DEBUG', true); // TODO: remove this line

    Thread Starter Lucy Lehman

    (@mfp-ll)

    Thanks for your help. Here is the error I get in the js-console:
    ReferenceError: ajaxurl is not defined

    Plugin Author bobbysmith007

    (@bobbysmith007)

    https://www.ads-software.com/support/topic/ajaxurl-is-not-defined?replies=4

    Alright this points directly to the answer, ajaxurl is not available by default on the public facing side (only admin). I think this should be an easy fix. I will try and get to it soon.

    Thanks for the debugging assistance

    Plugin Author bobbysmith007

    (@bobbysmith007)

    I think that this should be resolved now. Sorry for delaying notification

    Thread Starter Lucy Lehman

    (@mfp-ll)

    Thank you! Works on the front-end now. I appreciate your time.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Trouble saving to DB using shortcode on protected page’ is closed to new replies.

Tags