[NSFW] Great Plugin! But.. cron job database error

  • thindpls

    (@thindpls)


    4 years ago

    Been using the plugin a couple months and all was well, ready to buy pro for sure.

    But, updated to new larger server and now when plugin goes to publish post , anyone on site gets a database error screen. After going back and forth with hoisting company, for a few days, they say- “the current issue is related to the database and the SQL queries which are spawned from it. All of the Physical Memory of the server is bein allocated when the following queries are being executed:

    186 | nsfwaccess_wp113 | localhost | nsfwaccess_wp113 | Query | 27 | statistics | SELECT t.*, tt.*, tr.object_id FROM nsfwbb_terms AS t INNER JOIN nsfwbb_term_taxonomy AS tt ON t.t | 0.000
    | 200 | nsfwaccess_wp113 | localhost | nsfwaccess_wp113 | Query | 0 | Sending data | SELECT id FROM nsfwbb_promag_groups WHERE 1 ORDER BY id | 0.000 |

    The issue occurs each time the Cron job which you have set is executed.”

    Auto Post Scheduler Log Messages shows:
    2020-11-07 07:51:20 – DEBUG: aps_auto_post_hook triggered, looking for eligible posts…
    2020-11-07 07:51:20 – DEBUG: eligible posts WP_Query Array ( [posts_per_page] => -1 [cat] => 1212,1718,437,2082,34,438,1185,1722,440,442,428,445,455,457,459,469,426,480,1204,519,1762,1213,1200,566,1210,573,577,579,615,622,637,641,173,660,661,2092,700,706,724,733,734,735,739,754,763,778,786,811,1207,832,434,1219,2059,934,1000,1011,430,1208,1033,1074,2024,1209,1181,2101,1206 [author] => 3,1 [post_type] => Array ( [0] => post [1] => attachment ) [ignore_sticky_posts] => 1 [post_status] => Array ( [0] => publish ) [order] => ASC [orderby] => rand )

    But no new images appear on blog. All other cron jobs seem to be working properly. I have updated all plugins, themes, deleted all but bare bones plugins to get this fixed. The site relies on your plugin for traffic generation. I need it, any ideas? I am willing to pay for support.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author johnh10

    (@johnh10)

    If that’s all in the APS log then the WordPress function WP_Query is using the memory. What is the database error shown on screen? That’s important.

    I see you’re requesting ALL published posts/attachments in those categories to republish every time APS is triggered. Why? How many posts does your site have and how much memory is available to WordPress on this new host?

    Thread Starter thindpls

    (@thindpls)

    First, your response time is fantastic, thank you.
    Second, I purchased the pro version and it solved the problem. Again, great job.

    As far as the previous, the screen showed ” WordPress could not connect to database”.
    My intent was only one post gets republished at a time, from any of those categories.
    I assume I misunderstand those setting.

    The pro version is republishing 2 at a time and I have Max Posts per Query: set to 1. If I set that to 2 it publishes 4, and set to 4 it does 8 and so on and so on. But still we are impressed with your plugin, and we don’t say that often!

    Plugin Author johnh10

    (@johnh10)

    Hmm it shouldn’t do double work. Does the log show 2 instances of the cron job firing? A cron plugin will show you what events are scheduled.

    Thread Starter thindpls

    (@thindpls)

    You are ON It!

    2020-11-07 11:56:49 – Ruleset #1, publish post id 9852, title: crazy4more com – post date set to 2020-11-07 11:56:47, post date gmt set to 2020-11-07 16:56:47
    2020-11-07 11:56:52 – Ruleset #1, publish post id 19850 RECYCLED. Title: Sissy NSFW Access.
    2020-11-07 12:00:09 – Ruleset #1, publish post id 8568, title: crazy4more com – post date set to 2020-11-07 12:00:04, post date gmt set to 2020-11-07 17:00:04
    2020-11-07 12:00:14 – Ruleset #1, publish post id 11514 RECYCLED. Title: crazy4more com.
    2020-11-07 12:24:35 – Ruleset #1, publish post id 3739, title: igocrazyformore.com – post date set to 2020-11-07 12:24:32, post date gmt set to 2020-11-07 17:24:32
    2020-11-07 12:24:38 – Ruleset #1, publish post id 15719 RECYCLED. Title: Interracial NSFW Access.
    2020-11-07 12:24:52 – Ruleset #1, publish post id 28130, title: Oral – post date set to 2020-11-07 12:24:50, post date gmt set to 2020-11-07 17:24:50
    2020-11-07 12:24:55 – Ruleset #1, publish post id 19690 RECYCLED. Title: Sissy NSFW Access.

    Event Frequency:set to 2000s
    Max Posts per Query: 11
    Limit check to Post Types: post

    Cron Events plugin shows:
    wp-auto-poster
    Edit | Run Now | Delete
    {
    “Ruleset”: 1
    }
    2020-11-07 13:06:24
    27 minutes 22 seconds WpAutoPoster_Plugin->processRuleset() wp-auto-poster-1

    wp-auto-poster-1
    This schedule is added by another plugin and cannot be deleted
    2000 (33 minutes 20 seconds) wp-auto-poster-1

    Plugin Author johnh10

    (@johnh10)

    I couldn’t find a plugin named ‘Cron Events’ but you can disable that Ruleset then clear any extra cron event out. There should be only 1 per enabled Ruleset.

    It is also possible if you have a slow database that WordPress is unable to secure a semaphore lock before it spawns an additional cron event, but that is extremely rare – mostly on virtual hosts with low resources.

    Thread Starter thindpls

    (@thindpls)

    Thanks for your help and insights.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[NSFW] Great Plugin! But.. cron job database error’ is closed to new replies.

Tags