veenm

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

Scheme: perfectlist

<?php
/*
Plugin Name: List Category Posts - Template "Sofians Perfect Post List - https://sundari-webdesign.com/wordpress-the-quest-to-my-perfect-list-view-for-posts-events-and-articles"
Plugin URI: https://picandocodigo.net/programacion/wordpress/list-category-posts-wordpress-plugin-english/
Description: Template file for List Category Post Plugin for WordPress which is used by plugin by argument template=value.php
Version: 0.9
Author: Radek Uldrych & Fernando Briano
Author URI: https://picandocodigo.net https://radoviny.net
*/

/*
Copyright 2009 Radek Uldrych (email : [email protected])
Copyright 2009-2015 Fernando Briano (https://picandocodigo.net)

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 3 of the License, or any
later version.

This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
USA
*/

/**
* The format for templates changed since version 0.17. Since this
* code is included inside CatListDisplayer, $this refers to the
* instance of CatListDisplayer that called this file.
*/

/* This is the string which will gather all the information.*/
$lcp_display_output = '';

//Show category link:
$lcp_display_output .= $this->get_category_link('strong');

//Show the conditional title:
$lcp_display_output .= $this->get_conditional_title();

//Add 'starting' tag. Here, I'm using an unordered list (ul) as an example:
// (Sofian: We work with DIVs so this stays empty)
$lcp_display_output .= '';

/* Posts Loop
 *
 * The code here will be executed for every post in the category. As
 * you can see, the different options are being called from functions
 * on the $this variable which is a CatListDisplayer.
 *
 * CatListDisplayer has a function for each field we want to show. So
 * you'll see get_excerpt, get_thumbnail, etc.  You can now pass an
 * html tag as a parameter. This tag will sorround the info you want
 * to display. You can also assign a specific CSS class to each field.
*/
global $post;
while ( have_posts() ):
  the_post();

//Start a List Item for each post:
// (Sofian: Here we open the DIV for each post. If the post has a thumbnail, we get it. 
//  Else we can define a placeholder or leave an empty space next to the indented text.)
  if (has_post_thumbnail($post->ID)):
    $lcp_display_output .= '<div class="postlist withthumb">';
    $lcp_display_output .= '<span class="thumbmagic">';
    $lcp_display_output .= $this->get_thumbnail($post);
    $lcp_display_output .= '</span>';
  else: 
    $lcp_display_output .= '<div class="postlist withthumb">';
    $lcp_display_output .= '<span class="thumbmagic">';
// (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 .= '<img src="https://your-domain.com/wp-content/uploads/default-thumb.jpg" alt="placeholder"></img>';    
    $lcp_display_output .= '</span>';
  endif; 

// (Sofian: Here we open an additional container DIV to wrap our content)     
  $lcp_display_output .= '<div class="lcp-container">';

  //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 .= '<div class="morelink">' . $this->get_posts_morelink($post) . '</div>';

  //Close li tag
  // (Sofian: Closing our div)
  $lcp_display_output .= '</div></div>';

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;

### wp-core ###

version: 5.8
site_language: nl_NL
user_language: nl_NL
permalink: /%postname%/
https_status: true
user_registration: 0
default_comment_status: closed
multisite: false
user_count: 1
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /www
wordpress_size: 482,50 MB (505941984 bytes)
uploads_path: /www/wp-content/uploads
uploads_size: 25,88 GB (27786438920 bytes)
themes_path: /www/wp-content/themes
themes_size: 12,72 MB (13336720 bytes)
plugins_path: /www/wp-content/plugins
plugins_size: 281,90 MB (295595007 bytes)
database_size: 929,95 MB (975126528 bytes)
total_size: 27,55 GB (29576439159 bytes)

### wp-dropins (1) ###

advanced-cache.php: true

### wp-active-theme ###

name: Nirvana NoLink (nirvana-nolink)
version: 0.7
author: Cryout Creations
author_website: https://www.cryoutcreations.eu
parent_theme: Nirvana (nirvana)
theme_features: core-block-patterns, editor-style, widgets-block-editor, title-tag, post-thumbnails, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, automatic-feed-links, post-formats, menus, custom-background, custom-header, widgets
theme_path: /www/wp-content/themes/nirvana-nolink

### wp-parent-theme ###

name: Nirvana (nirvana)
version: 1.6.1
author: Cryout Creations
author_website: https://www.cryoutcreations.eu
theme_path: /www/wp-content/themes/nirvana

### wp-themes-inactive (1) ###

Twenty Twenty-One: version: 1.4, author: het WordPress team

### wp-mu-plugins (1) ###

Health Check Troubleshooting Mode: author: (undefined), version: 1.7.2

### wp-plugins-active (55) ###

3D FlipBook: version: 1.11.2, author: iberezansky
404page - your smart custom 404 error page: version: 11.3.0, author: Peter Raschendorfer
AddToAny Share Buttons: version: 1.7.46, author: AddToAny
Advanced Editor Tools (previously TinyMCE Advanced): version: 5.6.0, author: Automattic
Ajax Search Pro: version: 4.21, author: Ernest Marcinko
Akismet Anti-Spam: version: 4.1.12, author: Automattic
Broken Link Checker: version: 1.11.15, author: WPMU DEV
Classic Editor: version: 1.6.2, author: WordPress Contributors
Complianz - Terms and Conditions: version: 1.0.11, author: Really Simple Plugins
Complianz Privacy Suite (GDPR/CCPA) premium: version: 5.4.0.1, author: Really Simple Plugins
Cryout Serious Theme Settings: version: 0.5.13, author: Cryout Creations
Disable Search: version: 1.8.3, author: Scott Reilly
Easy Smooth Scroll Links: version: 2.23.0, author: PootlePress
eCommerce Product Catalog for WordPress: version: 3.0.35, author: impleCode
Email Address Encoder: version: 1.0.22, author: Till Krüss
EP Pushcrew (now VWO Engage): version: 1.0.0, author: Shafiqul
FooBox Image Lightbox (Premium): version: 2.7.16, author: FooPlugins
H5P: version: 1.15.3, author: Joubel
Health Check & Troubleshooting: version: 1.4.5, author: The www.remarpro.com community
Inline Footnotes: version: 2.3.0, author: Gavin Rehkemper
List category posts: version: 0.85, author: Fernando Briano
Loco Translate: version: 2.5.3, author: Tim Whitlock
Maps Marker Pro ?: version: 4.19, author: MapsMarker.com e.U.
Matomo Analytics - Ethical Stats. Powerful Insights.: version: 4.4.1, author: Matomo
NextGEN Gallery: version: 3.15, author: Imagely
Ninja Forms: version: 3.5.7, author: Saturday Drive
OMGF: version: 4.5.5, author: Daan from FFW.Press
One Click Accessibility: version: 2.0.3, author: One Click Accessibility
Page-list: version: 5.2, author: webvitaly
Photo Gallery: version: 2.5.82, author: Photo Gallery Team
Product Gallery Advanced: version: 1.5.3, author: Norbert Dreszer
Product Page Customizer: version: 1.13.4, author: Norbert Dreszer
Product Search PRO: version: 1.7.1, author: Norbert Dreszer
Protect Uploads: version: 0.3, author: Alexis Blondin
Re-add text underline and justify: version: 0.3, author: Brice Capobianco
Really Simple SSL: version: 5.0.10, author: Really Simple Plugins
Really Simple SSL pro: version: 5.2.0, author: Really Simple Plugins
Redirection: version: 5.1.3, author: John Godley
Relevanssi Premium: version: 2.15.3.1, author: Mikko Saari
ResponsiveVoice Text To Speech: version: 1.7.2, author: ResponsiveVoice
ShortPixel Image Optimizer: version: 4.22.5, author: ShortPixel
Tabby Load Accordion Closed: version: 1.2.0, author: cubecolour
Tabby Reopen Current Tab On Reload: version: 1.1.0, author: Michael Atkins
Tabby Responsive Tabs: version: 1.2.3, author: cubecolour
Tabby Responsive Tabs Customiser: version: 1.0.1, author: cubecolour
TablePress: version: 1.14, author: Tobias B?thge
TablePress Extension: DataTables Buttons: version: 1.5, author: Tobias B?thge
TablePress Extension: Pagination Length Change "All" entry: version: 1.2, author: Tobias B?thge
TablePress Extension: Responsive Tables: version: 1.8, author: Tobias B?thge
TaxoPress: version: 3.2.2, author: TaxoPress
WD manager: version: 1.4.4, author: WebDorado
Wordfence Security: version: 7.5.5, author: Wordfence
WP-Optimize - Clean, Compress, Cache: version: 3.1.12, author: David Anderson, Ruhani Rabin, Team Updraft
wp-Typography: version: 5.7.2, author: Peter Putzer
Yoast SEO: version: 17.0, author: Team Yoast

### wp-plugins-inactive (7) ###

Better Search Replace: version: 1.3.4, author: Delicious Brains
footnotes: version: 2.7.3, author: Mark Cheret
Media File Renamer: version: 5.2.7, author: Jordy Meow
Modern Footnotes: version: 1.4.10, author: Prism Tech Studios
Shift8 CDN: version: 1.57, author: Shift8 Web
Tidio Chat: version: 4.3.0, author: Tidio Ltd.
WP Accessibility Helper: version: 0.6.0.6, author: Alex Volkov

### wp-media ###

image_editor: WP_Image_Editor_GD
imagick_module_version: Niet beschikbaar
imagemagick_version: Niet beschikbaar
gd_version: bundled (2.1.0 compatible)
ghostscript_version: unknown

### wp-server ###

server_architecture: Linux 4.19.101-stretch980030 x86_64
httpd_software: Apache
php_version: 8.0.8 64bit
php_sapi: fpm-fcgi
max_input_variables: 5000
time_limit: 120
memory_limit: 256M
max_input_time: 60
upload_max_size: 128M
php_post_max_size: 128M
curl_version: 7.52.1 OpenSSL/1.0.2u
suhosin: false
imagick_availability: false
server-headers: 
	date: Mon, 06 Sep 2021 14:46:46 GMT
	server: Apache
	set-cookie: PHPSESSID=090b531553f848364dfbf5e9a5adf3c5; path=/; secure; HttpOnly
	pragma: no-cache
	expires: Wed, 11 Jan 1984 05:00:00 GMT
	cache-control: no-cache, must-revalidate, max-age=0
	strict-transport-security: max-age=63072000; includeSubDomains; preload
	content-security-policy: "upgrade-insecure-requests"
	x-xss-protection: 1; mode=block
	x-content-type-options: nosniff
	referrer-policy: no-referrer-when-downgrade
	expect-ct: max-age=7776000, enforce
	x-frame-options: sameorigin
	permissions-policy: 
	wpo-cache-status: not cached
	wpo-cache-message: WordPress login cookies were detected
	link: <https://www.archeologiegorinchem.com/wp-json/>; rel="https://api.w.org/"
	content-encoding: gzip
	vary: Accept-Encoding
	content-type: text/html; charset=UTF-8
	x-transip-backend: web586
	x-transip-balancer: balancer7
htaccess_extra_rules: true

### wp-database ###

extension: mysqli
server_version: 10.1.48-MariaDB-1~stretch
client_version: mysqlnd 8.0.8

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /www/wp-content
WP_PLUGIN_DIR: /www/wp-content/plugins
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

Hi Zymeth

Tnx for reacting

Shortcode example:
[catlist name= Bagijnenwal excludeposts=this thumbnail=yes thumbnail_size=medium excerpt=yes excerpt_size=21 posts_morelink=”Lees verder…” template=perfectlist]

WP 5.8
Using your ltest update of LCP

All Best
Martin

Hi

If I open a page with a list:

FastCGI: server "/var/run/php80-cgi/php-cgi" stderr: ) 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_postsdate 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, referer: https://www.archeologiegorinchem.com/

and:
FastCGI: server "/var/run/php80-cgi/php-cgi" stderr: wp_term_relationships.term_taxonomy_id IN (363), referer: https://www.archeologiegorinchem.com/

Its abacadabra to me, maybe you see something?
Thank you a lot
Martin (www.archeologiegorinchem.com)

Hello Maybellyne

Thanks quick response.

Google telling uploading is ok now.

Thank you for your help!

Hoi Aert,

Here everything seems up to date. I checked some other sites using Complianz. Looks like maybe the latest Dutch translations did not reach everyone

Groeten
Martin

Hi Aert

Is Dutch language. “Usage” translated into Dutch = “Gebruik”
I guess you also a little familiar with Dutch language ??

Kind regards
Martin

Dear Mikko

Sorry putting question here, but thanks a lot anwering this quick way!
Have nice day, Martin

@anabelaabreu i watched your site but its seems ok now. What action you did?

I Got same problem, it just stopped. Last week even made fresh installation, but without any result. I got same problem in other browsers. It just keeps opening

Yes I expect too. It appears in every resultpage. Whatever i’m searching.

All best
Martin

Hi Tobias

Problem solved! The solution: the product plugin did not like i did put in some <br> In the css… Tablepress was not to blame ?? Thanks for helping me! Greetings from The Netherlands

Kind regards
Martin

Hi Tobias,

All opened and closed but i did not get any warning. Debugging still same message:
Undefined offset: 2 in /www/wp-content/plugins/tablepress/controllers/controller-frontend.php on line 867

What do you think?

Kind regards
Martin

Hi Tobias

You mean with an active debug plugin, or just open and close them? About a 100 ?? i go try.

Kind regards
Martin