';
$lcp_display_output .= '';
// (Sofian: Uncomment this line to use a placeholder by changing the path to your placeholder image.
// Delete the line or leave it commented to leave an empty space.)
// $lcp_display_output .= '
';
$lcp_display_output .= '';
endif;
// (Sofian: Here we open an additional container DIV to wrap our content)
$lcp_display_output .= '
';
endwhile;
// Close the wrapper I opened at the beginning:
// (Sofian: We work with DIVs so this stays empty)
$lcp_display_output .= '';
// If there's a "more link", show it:
$lcp_display_output .= $this->get_morelink();
// Get category posts count
$lcp_display_output .= $this->get_category_count();
//Pagination
$lcp_display_output .= $this->get_pagination();
$this->lcp_output = $lcp_display_output;
```
* Plugin Contributor [zymeth25](https://wordpress.org/support/users/zymeth25/)
* (@zymeth25)
* [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14845317)
* Ok, I see you have `WP_DEUG` and `WP_DEBUG_LOG` both set to `false`. Please set
them both to `true` [in your wp-config.php](https://wordpress.org/support/article/debugging-in-wordpress/),
then visit a page with an LCP list. Once you have done that, in your WordPress
installation open `wp-content/debug.log` and paste here any entries that appeared
in that file after visiting the page.
* Also, because what you are experiencing is a database query error, go ahead and
install [Query monitor](https://wordpress.org/plugins/query-monitor/) and check
if it indicates any problems when running the LCP plugin.
* Thread Starter [veenm](https://wordpress.org/support/users/veenm/)
* (@veenm)
* [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14849057)
* Hi, this is what i found in the debug.log after opening a page with LCP. I installed
Query monitor, but still finding out how it’s working (sorry being unexperienced)
I appreciating your great help very much!
* ```
[08-Sep-2021 03:52:10 UTC] WordPress databasefout You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 3 bij query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (18264) AND (
wp_term_relationships.term_taxonomy_id IN (363)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, -1 gemaakt door require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/nirvana/single.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, ListCategoryPosts::catlist_func, CatListDisplayer->display, CatList->get_posts, CatList->set_lcp_parameters, query_posts, WP_Query->query, WP_Query->get_posts
```
* Plugin Contributor [zymeth25](https://wordpress.org/support/users/zymeth25/)
* (@zymeth25)
* [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14853930)
* The error itself is pretty obvious, at the end of the query there is `LIMIT 0,-
1`, the first value is the offset and the second is the limit, neither are allowed
to be negative hence the error. The former corresponds to the `offset` shortcode
parameter and the latter to `numberposts`. I assume you have `numberposts` set
to `-1` in your shortcode or in the options page, is that correct?
* What we must figure out is how this value (`-1`) found its way to the SQL query.
SQL queries are run and created by WordPress, the LCP plugin only uses WP’s built
in API to query posts. In theory it means SQL queries are always valid as long
as there are no bugs in WordPress Core and there are no compatibility issues
between PHP and the database used.
* If you set `numberposts` to `-1` it means, as per the docs, that you do not want
the output to be limited, there should be no `LIMIT` in the SQL query. This is
how it has always worked and how it works in my tests.
* If you are using `numberposts=-1` try removing it or setting to a different (
positive) value. I do not see how WP can pass this invalid value to the query
but maybe there are issues on the server you are using.
* If you are **not** using `numberposts=-1` this is even more bizarre, I would
suggest disabling all other plugins to determine if this is caused by one of
them, this is the best first step to start debugging.
* Thread Starter [veenm](https://wordpress.org/support/users/veenm/)
* (@veenm)
* [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14863311)
* Feeling very small and shy to you… I had (stupid) option 4:
* > `numberposts=-1-`
* PHP 7.4 still accepted this, but PHP8 did not.
* Thank you so much for your really great help! You teached me a lot about debugging,
but I feel sorry and apologize for being so stupid…
- This reply was modified 4 years, 9 months ago by [veenm](https://wordpress.org/support/users/veenm/).
* Plugin Contributor [zymeth25](https://wordpress.org/support/users/zymeth25/)
* (@zymeth25)
* [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14865952)
* No worries, glad I could help :D. Indeed a value of `-1-` could cause issues,
I tested `-1` in PHP 8 and there were no problems.
* But the truth is you have probably found a bug in WP implementation of PHP 8,
because previous versions properly sanitized this wrong value.
Viewing 13 replies - 1 through 13 (of 13 total)
The topic ‘PHP8’ is closed to new replies.
* 
* [List category posts](https://wordpress.org/plugins/list-category-posts/)
* [Frequently Asked Questions](https://wordpress.org/plugins/list-category-posts/#faq)
* [Support Threads](https://wordpress.org/support/plugin/list-category-posts/)
* [Active Topics](https://wordpress.org/support/plugin/list-category-posts/active/)
* [Unresolved Topics](https://wordpress.org/support/plugin/list-category-posts/unresolved/)
* [Reviews](https://wordpress.org/support/plugin/list-category-posts/reviews/)
* 13 replies
* 2 participants
* Last reply from: [zymeth25](https://wordpress.org/support/users/zymeth25/)
* Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/php8-9/#post-14865952)
* Status: resolved';
$lcp_display_output .= '';
endif;
// (Sofian: Here we open an additional container DIV to wrap our content)
$lcp_display_output .= '';
//Show the title and link to the post:
$lcp_display_output .= $this->get_post_title($post, 'h3');
//Show comments:
$lcp_display_output .= $this->get_comments($post);
//Show date:
$lcp_display_output .= ' ' . $this->get_date($post);
//Show date modified:
$lcp_display_output .= ' ' . $this->get_modified_date($post);
//Show author:
$lcp_display_output .= $this->get_author($post);
//Custom fields:
$lcp_display_output .= $this->get_custom_fields($post);
/**
* Post content
*/
$lcp_display_output .= $this->get_content($post, 'p', 'lcp_content');
/**
* Post excerpt
*/
$lcp_display_output .= $this->get_excerpt($post, 'p', 'lcp_excerpt');
// Get Posts "More" link:
// (Sofian: We add a class to right-align)
$lcp_display_output .= '
' . $this->get_posts_morelink($post) . '
';
//Close li tag
// (Sofian: Closing our div)
$lcp_display_output .= '