When we perform an action with lift search we get the following message:
SELECT SQL_CALC_FOUND_ROWS alpha_posts.ID FROM alpha_posts JOIN alpha_icl_translations t ON alpha_posts.ID = t.element_id
AND t.element_type IN ('post_post','post_page') JOIN alpha_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND post_type in ('post','page','attachment') AND ID > -1 AND post_status <> 'auto-draft' ORDER BY alpha_posts.ID ASC LIMIT 0, 250 /* From [/wp-admin/options-general.php?page=lift-search&lift-queue-all] in [/wp-content/plugins/lift-search/wp/lift-batch-handler.php:267]
This has to do with the fact that there are other tables joined here and it should be appended with {$wpdb->posts}.ID > -1
We have corrected this issue on our own end with this but everytime there is an update this gets reset.
Hi,
When we perform an action with lift search we get the following message:
SELECT SQL_CALC_FOUND_ROWS alpha_posts.ID FROM alpha_posts JOIN alpha_icl_translations t ON alpha_posts.ID = t.element_id AND t.element_type IN ('post_post','post_page') JOIN alpha_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND post_type in ('post','page','attachment') AND ID > -1 AND post_status <> 'auto-draft' ORDER BY alpha_posts.ID ASC LIMIT 0, 250 /* From [/wp-admin/options-general.php?page=lift-search&lift-queue-all] in [/wp-content/plugins/lift-search/wp/lift-batch-handler.php:267]
This has to do with the fact that there are other tables joined here and it should be appended with {$wpdb->posts}.ID > -1
We have corrected this issue on our own end with this but everytime there is an update this gets reset.
Mr Alexander