• We are seeing this error in our php logs on a WordPress site that uses the PublishPress Future plugin.

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘GROUP BY wp_posts.ID#012#011#011#011#011#011 ORDER BY wp_posts.post_date DESC#012#011#011#011#011#011 LIMIT 0, 100 /’ at line 6 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID#012#011#011#011#011#011 FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id #012#011#011#011#011#011 WHERE 1=1 AND ( #012 ( wp_postmeta.meta_key = ‘_pp_workflow_has_manual_trigger’ AND wp_postmeta.meta_value = ‘1’ )#012) AND wp_posts.post_type = ‘ppfuture_workflow’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.id AND wp_posts.post_mime_type NOT IN (‘draft-revision’,’pending-revision’,’future-revision’,’revision-deferred’,’revision-needs-work’,’revision-rejected’) AND wp_posts.post_status NOT IN (‘draft-revision’,’pending-revision’,’future-revision’,’revision-deferred’,’revision-needs-work’,’revision-rejected’) AND wp_posts.post_mime_type NOT IN (‘draft-revision’,’pending-revision’,’future-revision’)#012#011#011#011#011#011 GROUP BY wp_posts.ID#012#011#011#011#011#011 ORDER BY wp_posts.post_date DESC#012#011#011#011#011#011 LIMIT 0, 100 /* From [woodgreen.org.uk/wp-admin/edit.php?s=Mango&post_status=all&post_type=pets&action=-1&m=0&ADMIN_FILTER_FIELD_VALUE&breeds=0&seo_filter&readability_filter&paged=1&action2=-1] in [/nas/content/live/woodgreenprod2/wp-content/plugins/publishpress-future-pro/lib/vendor/publishpress/publishpress-future/src/Modules/Workflows/Models/WorkflowsModel.php:107] */ made by require_once(‘wp-admin/admin-header.php’), WP_Screen->render_screen_meta, WP_Screen->show_screen_options, get_column_headers, apply_filters(‘manage_edit-pets_columns’), WP_Hook->apply_filters, WP_Posts_List_Table->get_columns, apply_filters(‘manage_posts_columns’), WP_Hook->apply_filters, PublishPress\Future\Modules\Workflows\Controllers\PostsList->addPostColumns, PublishPress\Future\Modules\Workflows\Models\WorkflowsModel->getPublishedWorkflowsWithManualTrigger, PublishPress\Future\Modules\Workflows\Models\WorkflowsModel->getPublishedWorkflowsWithMetadataAsOptions, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    And this one also:

    PUBLISHPRESS FUTURE – [WorkflowEngine] Scheduled step runner error: PublishPress\Future\Modules\Workflows\Domain\Engine\VariableResolvers\PostResolver::__construct(): Argument #1 ($post) must be of type object, null given, called in /nas/content/live/woodgreenprod2/wp-content/plugins/publishpress-future-pro/lib/vendor/publishpress/publishpress-future/src/Modules/Workflows/Domain/Engine/ExecutionContext.php on line 709. File: /nas/content/live/woodgreenprod2/wp-content/plugins/publishpress-future-pro/lib/vendor/publishpress/publishpress-future/src/Modules/Workflows/Domain/Engine/VariableResolvers/PostResolver.php:36

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

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.