Hi;
on two galleries I have, one with Piwigo 2.8.3, the other with Piwigo 2.8.4, I have the following notice when asking for page admin.php?page=comments (see screenshot attached):
Warning: [mysql error 1064] 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 'all' at line 19 SELECT c.id, c.image_id, c.date, c.author, username AS username, c.content, i.path, i.representative_ext, validated, c.anonymous_id FROM 1pwgtst_comments AS c INNER JOIN 1pwgtst_images AS i ON i.id = c.image_id LEFT JOIN 1pwgtst_users AS u ON u.id = c.author_id WHERE 1=1 ORDER BY c.date DESC LIMIT 0, all ; in /home/myrluc/www/tests/piwigo/include/dblayer/functions_mysqli.inc.php on line 845 Fatal error: Call to a member function fetch_assoc() on a non-object in /home/myrluc/www/tests/piwigo/include/dblayer/functions_mysqli.inc.php on line 226
Piwigo version: 2.8.4 and 2.8.3
PHP version: 5.4.45
MySQL version: 5.5.52-0+deb7u1-log
Piwigo URL: http://tests.myr-luc.net/piwigo
Please find below the PHPinfo. Unfortunately my localhost Apache installation doesn't work, I couldn't test locally.
Many thanks for Piwigo and success for debugging.
PHP Logo PHP Version 5.4.45 System Linux webm369.mp.ha.ovh.net 3.14.79-grsec-hosting-web-3.14 #1 SMP Thu Oct 20 14:47:42 UTC 2016 x86_64 Build Date Apr 11 2016 06:19:21 Configure Command './configure' '--with-openssl=/usr' '--with-mysql=/usr' '--with-mysqli=/usr/bin/mysql_config' '--with-pdo-mysql=/usr' '--prefix=/usr/local/php5.4' '--enable-fpm' '--enable-opcache' '--enable-memcache' '--with-gd' '--with-t1lib=/usr' '--with-xpm-dir=/usr' '--enable-intl' '--enable-gd-native-ttf=/usr' '--with-png-dir=/usr' '--enable-wddx' '--with-config-file-path=/usr/local/php5.4/etc' '--enable-sigchild' '--enable-short-tags' '--disable-rpath' '--enable-libgcc' '--with-zlib=/usr' '--enable-bcmath' '--enable-calendar' '--with-curl=/usr' '--with-gdbm=/usr' '--enable-ftp' '--with-gettext=/usr' '--with-imap' '--with-kerberos' '--with-imap-ssl' '--with-mcrypt=/usr' '--with-mhash=/usr' '--with-jpeg-dir=/usr' '--enable-exif' '--with-regex=system' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-zip' '--enable-inline-optimization' '--enable-soap' '--enable-mbstring' '--enable-mbregex' '--with-gnu-ld' '--with-libxml-dir' '--enable-shared=yes' '--enable-static=yes' '--with-xsl=/usr' '--enable-sockets' '--with-xmlrpc' '--with-iconv' '--enable-pdo' '--with-pdo-pgsql=/usr' '--with-pcre-regex' '--with-freetype-dir=/usr' '--with-pspell' '--with-pgsql=/usr' '--with-bz2' '--with-gmp' Server API FPM/FastCGI Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/php5.4/etc Loaded Configuration File /usr/local/php5.4/etc/php.ini Scan this dir for additional .ini files (none) Additional .ini files parsed (none) PHP API 20100412 PHP Extension 20100525 Zend Extension 220100525 Zend Extension Build API220100525,NTS PHP Extension Build API20100525,NTS Debug Build no Thread Safety disabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring IPv6 Support enabled DTrace Support disabled Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk Zend logo This program makes use of the Zend Scripting Language Engine: Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies with the ionCube PHP Loader v4.5.2, Copyright (c) 2002-2014, by ionCube Ltd., and with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend Technologies PHP Credits Configuration bcmath BCMath support enabled Directive Local Value Master Value bcmath.scale 0 0 bz2 BZip2 Support Enabled Stream Wrapper support compress.bzip2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.5, 10-Dec-2007 calendar Calendar support enabled cgi-fcgi php-fpm active Directive Local Value Master Value cgi.discard_path 0 0 cgi.fix_pathinfo 1 1 cgi.force_redirect 1 1 cgi.nph 0 0 cgi.redirect_status_env no value no value cgi.rfc2616_headers 0 0 fastcgi.error_header no value no value fastcgi.logging 1 1 fpm.config no value no value Core PHP Version 5.4.45 Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html disable_classes no value no value disable_functions _dyuweyrj4,_dyuweyrj4r,dl _dyuweyrj4,_dyuweyrj4r,dl display_errors On Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl On On enable_post_data_reading On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 32767 32759 exit_on_timeout Off Off expose_php On On extension_dir ./ ./ file_uploads On On highlight.comment #FF9900 #FF9900 highlight.default #0000CC #0000CC highlight.html #000000 #000000 highlight.keyword #006600 #006600 highlight.string #CC0000 #CC0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/local/php5.4/lib/php .:/usr/local/php5.4/lib/php log_errors Off Off log_errors_max_len 1024 1024 mail.add_x_header Off Off mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 300 300 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time -1 -1 max_input_vars 16000 16000 memory_limit 512M 512M open_basedir no value no value output_buffering 4096 4096 output_handler no value no value post_max_size 64M 64M precision 14 14 realpath_cache_size 2M 2M realpath_cache_ttl 300 300 register_argc_argv On On report_memleaks On On report_zend_debug On On request_order no value no value sendmail_from me@localhost.com me@localhost.com sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 17 17 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 128M 128M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value ctype ctype functions enabled curl cURL support enabled cURL Information 7.21.0 Age 3 Features AsynchDNS No Debug No GSS-Negotiate Yes IDN Yes IPv6 Yes Largefile Yes NTLM Yes SPNEGO No SSL Yes SSPI No krb4 No libz Yes CharConv No Protocols dict, file, ftp, ftps, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp Host i486-pc-linux-gnu SSL Version OpenSSL/0.9.8o ZLib Version 1.2.3.4 libSSH Version libssh2/1.2.6 date date/time support enabled "Olson" Timezone Database Version 2014.8 Timezone Database internal Default timezone Europe/Paris Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone Europe/Paris Europe/Paris dba DBA support enabled Supported handlers gdbm cdb cdb_make inifile flatfile Directive Local Value Master Value dba.default_handler flatfile flatfile dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.7.8 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled ereg Regex Library System library enabled exif EXIF Support enabled EXIF Version 1.4 $Id: 05041c5f0094cb46d9b516bd624d593b90cc38f9 $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF Directive Local Value Master Value exif.decode_jis_intel JIS JIS exif.decode_jis_motorola JIS JIS exif.decode_unicode_intel UCS-2LE UCS-2LE exif.decode_unicode_motorola UCS-2BE UCS-2BE exif.encode_jis no value no value exif.encode_unicode ISO-8859-15 ISO-8859-15 fileinfo fileinfo support enabled version 1.0.5 filter Input Validation and Filtering enabled Revision $Id: ad78b4a085153b8c7f4d6db5dc69df40e969c343 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value ftp FTP support enabled gd GD Support enabled GD Version bundled (2.1.0 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.4.2 T1Lib Support enabled GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 6b PNG Support enabled libPNG Version 1.2.44 WBMP Support enabled XPM Support enabled libXpm Version 30411 XBM Support enabled Directive Local Value Master Value gd.jpeg_ignore_warning 0 0 gettext GetText Support enabled gmp gmp support enabled GMP version 4.3.2 hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b fnv132 fnv164 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconv iconv support enabled iconv implementation glibc iconv library version 2.11.3 Directive Local Value Master Value iconv.input_encoding ISO-8859-1 ISO-8859-1 iconv.internal_encoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1 imap IMAP c-Client Version 2007e SSL Support enabled Kerberos Support enabled intl Internationalization support enabled version 1.1.0 ICU version 4.4.1 ICU Data version 4.4.0.1 Directive Local Value Master Value intl.default_locale no value no value intl.error_level 0 0 json json support enabled json version 1.2.1 libxml libXML support active libXML Compiled Version 2.7.8 libXML Loaded Version 20708 libXML streams enabled mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled libmbfl version 1.3.2 mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) backtrack check On Multibyte regex (oniguruma) version 4.7.1 Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value memcache memcache support enabled Version 3.0.6 Revision $Revision: 310129 $ Directive Local Value Master Value memcache.allow_failover 1 1 memcache.chunk_size 32768 32768 memcache.compress_threshold 20000 20000 memcache.default_port 11211 11211 memcache.hash_function crc32 crc32 memcache.hash_strategy consistent consistent memcache.lock_timeout 15 15 memcache.max_failover_attempts 20 20 memcache.protocol ascii ascii memcache.redundancy 1 1 memcache.session_redundancy 2 2 mhash MHASH support Enabled MHASH API Version Emulated Support mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.1.73 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/run/mysqld/mysqld.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent Off Off mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent 0 0 mysql.trace_mode Off Off mysqli MysqlI Support enabled Client API library version 5.1.73 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 1 Client API header version 5.1.73 MYSQLI_SOCKET /var/run/mysqld/mysqld.sock Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent Off Off mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 0.9.8o 01 Jun 2010 OpenSSL Header Version OpenSSL 0.9.8o 01 Jun 2010 pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.37 2015-04-28 Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000 PDO PDO support enabled PDO drivers mysql, pgsql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version 5.1.73 Directive Local Value Master Value pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock pdo_pgsql PDO Driver for PostgreSQL enabled PostgreSQL(libpq) Version 8.4.21 Module version 1.0.2 Revision $Id: 8e4cc97fb53f418d98b489c3e9d722e48446e676 $ pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.8.10.2 pgsql PostgreSQL Support enabled PostgreSQL(libpq) Version 8.4.21 PostgreSQL(libpq) PostgreSQL 8.4.21 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit Multibyte character support enabled SSL support enabled Active Persistent Links 0 Active Links 0 Directive Local Value Master Value pgsql.allow_persistent On On pgsql.auto_reset_persistent Off Off pgsql.ignore_notice Off Off pgsql.log_notice Off Off pgsql.max_links Unlimited Unlimited pgsql.max_persistent Unlimited Unlimited Phar Phar: PHP Archive support enabled Phar EXT version 2.0.1 Phar API version 1.1.1 SVN revision $Id: ba734629367f9671b25202408d13914fa63d8396 $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression enabled OpenSSL support enabled Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On posix Revision $Id: 1dfa9997ed76804e53c91e0ce862f3707617b6ed $ pspell PSpell Support enabled Reflection Reflection enabled Version $Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $ session Session Support enabled Registered save handlers files user memcache Registered serializer handlers php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly On Off session.cookie_lifetime 0 0 session.cookie_path /piwigo/ / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.force_path 1 1 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 0 0 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name pwg_id PHPSESSID session.referer_check no value no value session.save_handler user files session.save_path /tmp /tmp session.serialize_handler php php session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies On On session.use_only_cookies On On session.use_trans_sid 0 1 SimpleXML Simplexml support enabled Revision $Id: 16070fc92ad6f69cebb2d52ad3f02794f833ce39 $ Schema support enabled soap Soap Client enabled Soap Server enabled Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 sockets Sockets Support enabled SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException sqlite3 SQLite3 support enabled SQLite3 module version 0.7 SQLite Library 3.8.10.2 Directive Local Value Master Value sqlite3.extension_dir no value no value standard Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 from no value no value url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry user_agent no value no value sysvmsg sysvmsg support enabled Revision $Id: adf1d2d6be849c46eed3c3ee6f1cbebd1448d6e5 $ tokenizer Tokenizer Support enabled wddx WDDX Support enabled WDDX Session Serializer enabled xml XML Support active XML Namespace Support active libxml2 Version 2.7.8 xmlreader XMLReader enabled xmlrpc core library version xmlrpc-epi v. 0.51 php extension version 0.51 author Dan Libby homepage http://xmlrpc-epi.sourceforge.net open sourced by Epinions.com xmlwriter XMLWriter enabled xsl XSL enabled libxslt Version 1.1.26 libxslt compiled against libxml Version 2.7.8 EXSLT enabled libexslt Version 1.1.26 Zend OPcache Opcode Caching Up and Running Optimization Enabled Startup OK Shared memory model mmap Cache hits 5356215 Cache misses 17154 Used memory 785051676 Free memory 278704164 Wasted memory 9985984 Interned Strings Used memory 4194288 Interned Strings Free memory 16 Cached scripts 16402 Cached keys 18674 Max keys 32531 OOM restarts 0 Hash keys restarts 0 Manual restarts 0 Directive Local Value Master Value opcache.blacklist_filename no value no value opcache.consistency_checks 0 0 opcache.dups_fix Off Off opcache.enable On On opcache.enable_cli Off Off opcache.enable_file_override Off Off opcache.error_log no value no value opcache.fast_shutdown 0 0 opcache.file_update_protection 2 2 opcache.force_restart_timeout 180 180 opcache.inherited_hack On On opcache.interned_strings_buffer 4 4 opcache.load_comments 1 1 opcache.log_verbosity_level 1 1 opcache.max_accelerated_files 32000 32000 opcache.max_file_size 0 0 opcache.max_wasted_percentage 5 5 opcache.memory_consumption 1024 1024 opcache.optimization_level 0x7fffffef 0x7fffffef opcache.preferred_memory_model no value no value opcache.protect_memory 0 0 opcache.restrict_api /home/ovh/fpm5.4/opcache-status.php /home/ovh/fpm5.4/opcache-status.php opcache.revalidate_freq 2 2 opcache.revalidate_path Off Off opcache.save_comments 1 1 opcache.use_cwd On On opcache.validate_timestamps On On zip Zip enabled Extension Version $Id: 6c872ebfb022206b0cc2a183c7a388c7b6ad8685 $ Zip version 1.11.0 Libzip version 0.10.1 zlib ZLib Support enabled Stream Wrapper compress.zlib:// Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.3.4 Linked Version 1.2.3.4 Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value Additional Modules Module Name ionCube Loader sysvsem sysvshm PHP License This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE 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. If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.
Offline
Oops, the error disappeared from 2.8.4 gallery, after I made some configuration chages on it o_O ... Basically, I applied the same configuration than present on the other gallery, which was having this configuration for a long time...? (Configuration modifications: everything available with LocalFiles editor.)
I'll continue to look...
Offline
Hi again;
found the origin of the issue: it comes from parameter $conf['comments_page_nb_comments'] in local/config/config.inc.php. When set to value 'all', the issue raises:
// how many user comments to display by default on comments.php. Use 'all' // to display all user comments without pagination. Default available values // are array(5,10,20,50,'all') but you can set any other numeric value. $conf['comments_page_nb_comments'] = 'all';
When set to a numeric value, the issue doesn't raise.
Have a good night ;-) !
Offline