Not able to update records

  • Resolved bsuggs13

    (@bsuggs13)


    6 years, 5 months ago

    I keep getting this when I try to update records.

    WordPress database error: [PROCEDURE db1988016109_staging.spt does not exist]

    • This topic was modified 6 years, 5 months ago by bsuggs13.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author pimwick

    (@pimwick)

    This error message looks odd since we do not use any stored procedures in our plugin. With that said, the Bulk Editor does use temporary tables to handle some of the processing. You may need to contact your hosting provider to allow your WordPress database user to create temporary tables to see if this resolves the issue.

    The privilege they need to grant you is “CREATE TEMPORARY TABLES”. See here for details: https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

    Thread Starter bsuggs13

    (@bsuggs13)

    It seems that the issue was only happening on my staging site. Works beautifully on my production site. Thanks!

    Plugin Author pimwick

    (@pimwick)

    Glad to hear it! We hope you enjoy the plugin, have a great weekend.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Not able to update records’ is closed to new replies.

Tags