Hello, I tried second time this upgrade, but the result is the same: the forum is working, but cannot install any modification (I've tried Simple Audio-Video Embedder and Stop Forum Spam, but earlier TinyPortal as well).
During installation this appears:
array(14) { [0]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(301) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6030) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(184) ["function"]=> string(9) "AdminMain" } } Error loop.
Our server's error log is empty.
Is it worth to remain at 2.1.4, and hope that will work properly in 2-3 days? The forum is working now, if I have to reinstall the old engine with the saved DB, every day is a loss, that is why I ask this.
Thanks!
Which php and mysql versions?
It looks like we have another situation where the system is breaking before the actual error can be reported and what you are seeing is the broken error log, not the error itself.
@Sesquipedalian @shawnb61
Quote from: Sir Osis of Liver on July 21, 2023, 12:43:25 PMWhich php and mysql versions?
Hello, earlier I colud install a modification, which told me the php version. If you can tell me, where can I find it, i will tell you :)
And the same story with mysql....
thanks!
Quote from: Kindred on July 21, 2023, 12:52:39 PMIt looks like we have another situation where the system is breaking before the actual error can be reported and what you are seeing is the broken error log, not the error itself.
@Sesquipedalian @shawnb61
And what do you recommend then?
Hopefully one of the developers that I tagged will have some input
So far, these cases seems to be due to some irregularities in the database
Hello,
finally I could (almost) solve the problem, and the idea came from an earlier topic of this forum:
- I restored the old DB from backup
- a new home directory from the full install pack was installed (2.0.19)
- I checked if any mod can be installed on this forum, seemed to be ok
- then upgraded this pure forum...
The result is better, than earlier: tinyportal and some mods are already installed. But f.e. Simple audio and video embedder causes error again:
""smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(301) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6030) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(184) ["function"]=> string(9) "AdminMain" } } Error loop."
Any idea about the solution?
Thanks!
Quote from: Sir Osis of Liver on July 21, 2023, 12:43:25 PMWhich php and mysql versions?
My php info:
System Linux cpl84.hosting24.com 4.18.0-305.10.2.2.lve.el7h.x86_64 #1 SMP Wed Jul 28 13:09:44 UTC 2021 x86_64
Build Date Feb 1 2023 18:36:33
Configure Command './configure' '--disable-dependency-tracking' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/opt/alt/php74' '--exec-prefix=/opt/alt/php74' '--bindir=/opt/alt/php74/usr/bin' '--sbindir=/opt/alt/php74/usr/sbin' '--sysconfdir=/opt/alt/php74/etc' '--datadir=/opt/alt/php74/usr/share' '--includedir=/opt/alt/php74/usr/include' '--libdir=/opt/alt/php74/usr/lib64' '--libexecdir=/opt/alt/php74/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/opt/alt/php74/usr/share/man' '--infodir=/opt/alt/php74/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/opt/alt/php74/etc' '--with-config-file-scan-dir=/opt/alt/php74/link/conf' '--disable-debug' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-huge-code-pages' '--enable-jit' '--enable-opcache' '--enable-shmop' '--enable-xml' '--with-bz2' '--with-freetype=/usr' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg=/usr' '--with-layout=GNU' '--with-mhash' '--with-password-argon2=/usr' '--with-pcre-jit' '--with-pic' '--with-readline' '--with-webp=/opt/alt/libwebp' '--with-xpm=/usr' '--with-zlib' '--with-zlib-dir=/usr' '--without-gdbm' '--without-pear' '--with-curl=/opt/alt/curlssl11/usr' '--with-openssl-dir=/opt/alt/openssl11' '--with-openssl=/opt/alt/openssl11' '--with-pcre-dir=/opt/alt/pcre2' '--with-kerberos' '--enable-litespeed' '--enable-pcntl' '--without-mysqli' '--disable-mbstring' '--disable-bcmath' '--disable-dba' '--disable-dom' '--disable-fileinfo' '--disable-json' '--disable-intl' '--disable-pdo' '--disable-phar' '--disable-posix' '--disable-soap' '--disable-sockets' '--disable-sysvsem' '--disable-sysvshm' '--disable-sysvmsg' '--disable-xmlreader' '--disable-xmlwriter' '--without-zip' '--disable-gd' '--without-imap' '--without-xmlrpc' '--without-xsl' '--without-ldap' '--without-pgsql' '--without-snmp' '--without-sodium' '--without-tidy' '--without-enchant' '--without-pspell' '--without-unixODBC' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'target_alias=x86_64-redhat-linux-gnu' 'PKG_CONFIG_PATH=/opt/alt/nghttp2/lib64/pkgconfig:/opt/alt/curlssl11/usr/lib64/pkgconfig:/opt/alt/openssl11/lib64/pkgconfig:/opt/alt/sqlite/usr/lib64/pkgconfig:/opt/alt/pcre2/usr/lib64/pkgconfig:/opt/alt/libzip/usr/lib64/pkgconfig:/opt/alt/libxml2/usr/lib64/pkgconfig:/opt/alt/libicu/usr/lib64/pkgconfig:/opt/alt/libgd/lib64/pkgconfig::/usr/lib64/pkgconfig:/usr/share/pkgconfig' 'CFLAGS=-O2 -g -pipe -Wall -Wp, -D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -fno-strict-aliasing -Wno-pointer-sign' 'KERBEROS_CFLAGS=-I/usr/include' 'KERBEROS_LIBS=-L/usr/lib64' 'WEBP_LIBS=-L/opt/alt/libwebp/lib64 -Wl, -rpath=/opt/alt/libwebp/lib64' 'CXXFLAGS=-O2 -g -pipe -Wall -Wp, -D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic' 'SASL_CFLAGS=-I/usr/include' 'SASL_LIBS=-L/usr/lib64'
Server API LiteSpeed V8.0.1 Cloudlinux 1.3
Virtual Directory Support disabled
Configuration File (php.ini) Path /opt/alt/php74/etc
Loaded Configuration File /opt/alt/php74/etc/php.ini
Scan this dir for additional .ini files /opt/alt/php74/link/conf
PHP API 20190902
PHP Extension 20190902
Zend Extension 320190902
Zend Extension Build API320190902, NTS
PHP Extension Build API20190902, NTS
Debug Build no
Thread Safety disabled
Zend Signal Handling enabled
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, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3
Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk
bcmath
BCMath support enabled
Beállítások Local Settings Alapértelmezett beállítások
bcmath.scale 0 0
bz2
BZip2 Support Enabled
Stream Wrapper support compress.bzip2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.6, 6-Sept-2010
calendar
Calendar support enabled
clos_ssa
SSA Support Enabled
Beállítások Local Settings Alapértelmezett beállítások
clos_ssa.debug Off Off
clos_ssa.debug_file no value no value
clos_ssa.enabled On On
clos_ssa.to_file Off Off
Core
PHP Version 7.4.33
Beállítások Local Settings Alapértelmezett beállítások
allow_url_fopen On On
allow_url_include On On
arg_separator.input & &
arg_separator.output & &
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 UTF-8 UTF-8
default_mimetype text/html text/html
disable_classes no value no value
disable_functions symlink,shell_exec,exec,popen,system,dl,passthru,escapeshellarg,escapeshellcmd,show_source,pcntl_exec symlink,shell_exec,exec,popen,system,dl,passthru,escapeshellarg,escapeshellcmd,show_source,pcntl_exec
display_errors Off 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 Off Off
enable_post_data_reading On On
error_append_string no value no value
error_log error_log error_log
error_prepend_string no value no value
error_reporting 24575 32767
expose_php On On
extension_dir /opt/alt/php74/usr/lib64/php/modules /opt/alt/php74/usr/lib64/php/modules
file_uploads On On
hard_timeout 2 2
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors On On
ignore_repeated_source On On
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/opt/alt/php74/usr/share/pear .:/opt/alt/php74/usr/share/pear
input_encoding no value no value
internal_encoding no value no value
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 90 90
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 512M 512M
open_basedir no value no value
output_buffering 1 1
output_encoding no value no value
output_handler no value no value
post_max_size 128M 128M
precision 14 14
realpath_cache_size 4096K 4096K
realpath_cache_ttl 120 120
register_argc_argv Off Off
report_memleaks On On
report_zend_debug On On
request_order no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision -1 -1
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sys_temp_dir no value no value
syslog.facility LOG_USER LOG_USER
syslog.filter no-ctrl no-ctrl
syslog.ident php php
track_errors On Off
unserialize_callback_func no value no value
upload_max_filesize 128M 128M
upload_tmp_dir /tmp /tmp
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.assertions 1 1
zend.detect_unicode On On
zend.enable_gc On On
zend.exception_ignore_args Off Off
zend.multibyte Off Off
zend.script_encoding no value no value
zend.signal_check Off Off
ctype
ctype functions enabled
curl
cURL support enabled
cURL Information 7.87.0
Age 10
AsynchDNS Yes
CharConv No
Debug No
GSS-Negotiate No
IDN Yes
IPv6 Yes
krb4 No
Largefile Yes
libz Yes
NTLM Yes
NTLMWB Yes
SPNEGO Yes
SSL Yes
SSPI No
TLS-SRP Yes
HTTP2 Yes
GSSAPI Yes
KERBEROS5 Yes
UNIX_SOCKETS Yes
PSL No
HTTPS_PROXY Yes
MULTI_SSL No
BROTLI No
Protocols dict, file, ftp, ftps, gopher, gophers, http, https, imap, imaps, ldap, ldaps, mqtt, pop3, pop3s, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
Host x86_64-redhat-linux-gnu
SSL Version OpenSSL/1.1.1p
ZLib Version 1.2.7
libSSH Version libssh2/1.10.0
Beállítások Local Settings Alapértelmezett beállítások
curl.cainfo no value no value
date
date/time support enabled
timelib version 2018.04
"Olson" Timezone Database Version 2022.1
Timezone Database internal
Default timezone Europe/Berlin
Beállítások Local Settings Alapértelmezett beállítások
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 UTC UTC
dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.10.2
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled
exif
EXIF Support enabled
Supported EXIF Version 0220
Supported filetypes JPEG, TIFF
Multibyte decoding support using mbstring enabled
Extended EXIF tag formats Canon, Casio, Fujifilm, Nikon, Olympus, Samsung, Panasonic, DJI, Sony, Pentax, Minolta, Sigma, Foveon, Kyocera, Ricoh, AGFA, Epson
Beállítások Local Settings Alapértelmezett beállítások
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
libmagic 537
filter
Input Validation and Filtering enabled
Beállítások Local Settings Alapértelmezett beállítások
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value
ftp
FTP support enabled
FTPS support enabled
gd
GD Support enabled
GD headers Version 2.3.3
GD library Version 2.3.3
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
PNG Support enabled
WBMP Support enabled
XPM Support enabled
XBM Support enabled
WebP Support enabled
BMP Support enabled
TGA Read Support enabled
Beállítások Local Settings Alapértelmezett beállítások
gd.jpeg_ignore_warning 1 1
gettext
GetText Support enabled
gmp
gmp support enabled
GMP version 6.0.0
hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128, 3 tiger160, 3 tiger192, 3 tiger128, 4 tiger160, 4 tiger192, 4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b crc32c fnv132 fnv1a32 fnv164 fnv1a64 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
MHASH support Enabled
MHASH API Version Emulated Support
i360
i360 state activated
i360 mode kill
i360 blamer true
i360 path to log data sock:/opt/imunify360/lib/proactive.sock
i360 log type 2
i360 send on shtdwn 0
i360 report on kill 0
i360 build for 7.4.33
i360 signs 230710
i360 signs path /usr/share/i360-php-opts/sigs/7.6/.rules.v2
i360 pkg ver 7.6.1
i360 hdb ver 1689980346
i360 hdb entries 2579
iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.17
Beállítások Local Settings Alapértelmezett beállítások
iconv.input_encoding no value no value
iconv.internal_encoding no value no value
iconv.output_encoding no value no value
imap
IMAP c-Client Version 2007f
SSL Support enabled
Kerberos Support enabled
Beállítások Local Settings Alapértelmezett beállítások
imap.enable_insecure_rsh Off Off
json
json support enabled
libxml
libXML support active
libXML Compiled Version 2.10.2
libXML Loaded Version 21002
libXML streams enabled
mbstring
Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled
libmbfl version 1.3.2
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 6.8.2
Beállítások Local Settings Alapértelmezett beállítások
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input no value no value
mbstring.http_output no value no value
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.regex_retry_limit 1000000 1000000
mbstring.regex_stack_limit 100000 100000
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value
mysqli
Client API library version mysqlnd 7.4.33
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 1
Beállítások Local Settings Alapértelmezett beállítások
mysqli.allow_local_infile Off Off
mysqli.allow_persistent On On
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
mysqli.rollback_on_cached_plink Off Off
mysqlnd
Version mysqlnd 7.4.33
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 86400
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins mysqlnd, debug_trace, auth_plugin_mysql_native_password, auth_plugin_mysql_clear_password, auth_plugin_caching_sha2_password, auth_plugin_sha256_password
API Extensions mysqli, pdo_mysql
openssl
OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.1.1p 21 Jun 2022
OpenSSL Header Version OpenSSL 1.1.1p 21 Jun 2022
Openssl default config /opt/alt/openssl11/etc/pki/tls/openssl.cnf
Beállítások Local Settings Alapértelmezett beállítások
openssl.cafile no value no value
openssl.capath no value no value
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 10.35 2020-05-09
PCRE Unicode Version 13.0.0
PCRE JIT Support enabled
PCRE JIT Target x86 64bit (little endian + unaligned)
Beállítások Local Settings Alapértelmezett beállítások
pcre.backtrack_limit 1000000 1000000
pcre.jit 1 1
pcre.recursion_limit 100000 100000
PDO
PDO drivers mysql, sqlite
pdo_mysql
Client API version mysqlnd 7.4.33
Beállítások Local Settings Alapértelmezett beállítások
pdo_mysql.default_socket /tmp/mysql.sock /tmp/mysql.sock
pdo_sqlite
SQLite Library 3.39.4
Phar
Phar API version 1.1.1
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
OpenSSL support enabled
Beállítások Local Settings Alapértelmezett beállítások
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On
posix
POSIX support enabled
pspell
PSpell Support enabled
readline
Readline library 6.2
Beállítások Local Settings Alapértelmezett beállítások
cli.pager no value no value
cli.prompt \b \> \b \>
Reflection
Reflection enabled
session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php_serialize php php_binary
Beállítások Local Settings Alapértelmezett beállítások
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 no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_samesite no value no value
session.cookie_secure 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.lazy_write On On
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler user files
session.save_path /opt/alt/php74/var/lib/php/session /opt/alt/php74/var/lib/php/session
session.serialize_handler php_serialize php
session.sid_bits_per_character 4 4
session.sid_length 32 32
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 1 1
session.use_only_cookies no value 1
session.use_strict_mode 0 0
session.use_trans_sid no value 0
shmop
shmop support enabled
SimpleXML
SimpleXML support enabled
Schema support enabled
soap
Soap Client enabled
Soap Server enabled
Beállítások Local Settings Alapértelmezett beállítások
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
Interfaces 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
SQLite Library 3.39.4
Beállítások Local Settings Alapértelmezett beállítások
sqlite3.defensive 1 1
sqlite3.extension_dir no value no value
standard
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i
Beállítások Local Settings Alapértelmezett beállítások
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.exception 0 0
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
session.trans_sid_hosts no value no value
session.trans_sid_tags a=href,area=href,frame=src,form= a=href,area=href,frame=src,form=
unserialize_max_depth 4096 4096
url_rewriter.hosts no value no value
url_rewriter.tags no value a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value
tidy
Tidy support enabled
libTidy Version 5.4.0
libTidy Release 2017/03/01
Beállítások Local Settings Alapértelmezett beállítások
tidy.clean_output no value no value
tidy.default_config no value no value
timezonedb
Alternative Timezone Database enabled
Timezone Database Version 2020.4
tokenizer
Tokenizer Support enabled
xml
XML Support active
XML Namespace Support active
libxml2 Version 2.10.2
xmlreader
XMLReader enabled
xmlrpc
core library version xmlrpc-epi v. 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.28
libxslt compiled against libxml Version 2.9.1
EXSLT enabled
libexslt Version 1.1.28
zip
Zip enabled
Zip version 1.15.6
Libzip headers version 1.3.2
Libzip library version 1.3.2
zlib
Stream Wrapper compress.zlib://
Stream Filter zlib.inflate, zlib.deflate
Compiled Version 1.2.7
Linked Version 1.2.7
Beállítások Local Settings Alapértelmezett beállítások
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
Environment
PATH /usr/local/bin:/bin:/usr/bin
At what point in the package manager install do you see that?
The test of the package is still ok:
(https://images2.imgbox.com/4a/dd/h4FjJtk1_o.jpg) (https://imgbox.com/h4FjJtk1)
Then 20-25 seconds wating:
(https://images2.imgbox.com/6a/34/8jOpTQP9_o.jpg) (https://imgbox.com/8jOpTQP9)
And the the error msg:
(https://images2.imgbox.com/11/68/VyhWnypq_o.jpg) (https://imgbox.com/VyhWnypq)
But forum is working (more or less):
(https://images2.imgbox.com/c4/3e/gVl7yGGM_o.jpg) (https://imgbox.com/gVl7yGGM)
Only Tinyportal and Antispam could be installed succesful, and several themes...nothing else
During unsuccesful installation the error log is the following:
(https://images2.imgbox.com/b9/94/M3e88YBo_o.jpg) (https://imgbox.com/M3e88YBo)
Backtrace info:
Error
Type of error
Undefined_vars
Error message
8: Undefined index: label
File
/home/strea334/public_html/Themes/default/GenericMenu.template.php
Line
282
URL of page causing the error
https://www.streamloadforum.com/index.php?action=admin;area=logs;e866e20c3237=f5605a06695729a3dd347eb180943605
Backtrace information
#0: smf_error_handler()
Called from /home/strea334/public_html/Themes/default/GenericMenu.template.php on line 282
#1: template_generic_menu_tabs()
Called from /home/strea334/public_html/Themes/default/GenericMenu.template.php on line 58
#2: template_generic_menu_dropdown_above()
Called from /home/strea334/public_html/Sources/Load.php on line 2778
#3: loadSubTemplate()
Called from /home/strea334/public_html/Sources/Subs.php on line 4550
#4: template_header()
Called from /home/strea334/public_html/Sources/Subs.php on line 4157
#5: obExit()
Called from /home/strea334/public_html/index.php on line 187
Yeah that errorvis not related to your problem at all
Wonder what would happen if you replaced log_errors table. Attached is empty table from clean 2.1.4 core install. If you're comfortable using phmyadmin, rename your log_errors table and import the attached. Make sure table prefix matches yours.
Hello, I'm not really comfortable using phpmyadmin, but have copied earlier already some tables with it. Anyway I cannot see any atachment in your post.... And please write me what to do after that.
One more thing: in forum maintenance "Find and repair any errors" doesn't work, after one-two minutes spinning wheel "503 Service Unavailable The server is temporarily busy, try again later!" is appearing
I believe these two issues are dupes, which is interesting.
https://www.simplemachines.org/community/index.php?topic=586522.0
https://www.simplemachines.org/community/index.php?topic=586471.0
How many rows are in your smf_packages table?
What mod were you trying to install?
What theme were you using at the time?
If you use the default theme, does it still fail?
The first one is mine :) Ok, try them, and come back, thanks
::) Oops, here's the table.
Quote from: shawnb61 on July 22, 2023, 05:02:22 PMHow many rows are in your smf_log_packages table?
What mod were you trying to install?
What theme were you using at the time?
If you use the default theme, does it still fail?
So in smf packages table there are 25 rows
I copuld install Stop Forum Spam & TinyPortal, and could not Simple Audio Video Embedder, Users Online Today, Alternate User Posting & de Images From Guests
I tried with the default theme as well, with the same result, still fail.
Thanks for the info. I'll keep trying to reproduce.
With the empty error log table the result is the same
In your Settings table, what is the value for the variable 'knownThemes'?
SELECT * FROM `smf_settings` WHERE variable = 'knownThemes';
Already 5 new line in error log, all of the with the same text:
a15924186f3455b3ccaa95178be0fab5
https://www.streamloadforum.com/index.php?action=admin;area=logs;sa=settings;f80568b93f2=a15924186f3455b3ccaa95178be0fab5
/home/strea334/public_html/Themes/default/GenericMenu.template.php (Sor 282)
Quote from: shawnb61 on July 22, 2023, 05:30:23 PMIn your Settings table, what is the value for the variable 'knownThemes'?
SELECT * FROM `smf_settings` WHERE variable = 'knownThemes';
1,2,3,4
OK, for the next two queries, I just want to know if they complete successfully. No need to share the results, just an OK or Not OK...
SELECT version, themes_installed, db_changes
FROM smf_log_packages
WHERE install_state != 0
ORDER BY time_installed DESC
SELECT id_theme, variable, value
FROM smf_themes
WHERE id_theme IN (1,2,3,4)
AND variable IN ('name', 'theme_dir')
If the upper green line means OK, then Ok :)
Don't think it's at all relevant to this problem, but there are a couple of odd things about your forum. The theme you're currently running is broken, it's not displayed correctly. Other three themes look ok. But in all themes the forum logo throws 404 when accessed directly with browser or inspector.
Ok, last request for now...
Could you upload Subs.php & Packages.php?
Thanks for your patience.
Quote from: Sir Osis of Liver on July 22, 2023, 06:17:21 PMDon't think it's at all relevant to this problem, but there are a couple of odd things about your forum. The theme you're currently running is broken, it's not displayed correctly. Other three themes look ok. But in all themes the forum logo throws 404 when accessed directly with browser or inspector.
The forum logo seems to be ok:
(https://images2.imgbox.com/f9/3d/jlLBY865_o.jpg) (https://imgbox.com/jlLBY865)
Current theme NameX_1.2.3 is the only one, which appears correctly together with Tinyportal...it is a user side opinion only
Here you are :)
So, out of left field... what do you have for an htaccess file?
Quote from: hustreamload on July 22, 2023, 06:49:17 PMThe forum logo seems to be ok:
Your current default theme seems to use this url to a non existing image as the logo (https://www.streamloadforum.com/Themes/logo.png), which indeed leaves the front page broken for guests.
Not on my computer, but I believe all four themes, including Curve2, have the same 404 logo.
Is it better, when I insert here a logo with link of imgbox or any other image hosting? If yes, how to do that?
The front page appears for guests as well, but the image is "hidden" (the forum is hidden for guest, only members can see it), is it affecting the installation process?
No, it's not hidden. A 404 means it doesn't exist. It's an error. And generally, it's a bad idea to cause errors on purpose.
This particular error shouldn't really be related to the original issue though, just a side note.
ok, "https://www.streamloadforum.com/Themes/logo.png" is already on the server, but nothing has beeen changed with the original problem
Is there any chance to export only the useful data of the db (users, messages, etc.), import to an empty db, and build a new forum from zero? It is an almost 20 years old forum, and we may bring with old mistakes to every newversion...however till today we ran without any bigger mistake
One last question: What mods did you have installed before the 2.1.4 update?
At this point, I don't think we need to rebuild the db. We may want to reload a fresh set of files, though. Doing so you'd need to reload mods.
https://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files
Would be interesting to get hands on the original 2.0.19 database and see if problem can be replicated on different server. If it had only been reported once good bet it's a broken install, but it's now been reported twice and may be an obscure glitch in the upgrader.
Quote from: Sir Osis of Liver on July 23, 2023, 01:26:48 PMWould be interesting to get hands on the original 2.0.19 database and see if problem can be replicated on different server. If it had only been reported once good bet it's a broken install, but it's now been reported twice and may be an obscure glitch in the upgrader.
The other one was a 2.1.3 => 2.1.4 patch, though. No upgrader involved.
I'm still curious to see what mods were installed before the upgrade.
Hooks? Maybe upload clean files and remove hooks before reinstalling mods.
These mods were installed on 2.0.19
Tinyportal
(Eralier: SimplePortal)
Simple Audio Video Embedder
nCode Image Resizer
Hide Images From Guests
Hide the content of code tags from guests
Hide Signatures from Guests
Disable 'last edit by....' for Administrators
Login Security
Stop Forum Spam
CleanTalk
Custom buttons
Search Focus Dropdown
Users Online Today
Board Viewers
Language Dropdown
Alternate User Posting
Copy Topics
Facebook Video BBC
Soundcloud BBcode
maybe 2-3 more :)
Quote from: Sir Osis of Liver on July 23, 2023, 01:26:48 PMWould be interesting to get hands on the original 2.0.19 database and see if problem can be replicated on different server. If it had only been reported once good bet it's a broken install, but it's now been reported twice and may be an obscure glitch in the upgrader.
It was already done: in reuploaded 2.0.19 clean version everything ran properly
Quote from: shawnb61 on July 23, 2023, 10:07:04 AM...
At this point, I don't think we need to rebuild the db. We may want to reload a fresh set of files, though. Doing so you'd need to reload mods.
As earlier I wrote, I have reupped the old db with a clean 2.0.19, tested the mods availability (see my post before), and then I made on the "clean" 2.0.19 an upgrade...but the bug remained.
Thanks
Quote from: Sir Osis of Liver on July 23, 2023, 02:35:01 PMHooks? Maybe upload clean files and remove hooks before reinstalling mods.
Sorry, what does it mean practically? Pls step by step (see my last 2 post before).
Thanks
It would be easier, if I shouldn't close the forum during this repair process...but I dont know, how to upload the old DB with the old home directory parallel with the living db. I have made already a clean upload with a clean DB earlier (www.myforum/pilot), but not with the same DB
Quote from: Illori on July 23, 2023, 11:29:11 AMhttps://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files
Anyway I tried again with a fresh set of files, deleted Themes and Sources. The result is interesting: the first
two mods run still OK, but from the third no more...but that was the result in the previous version as well (there also the Tinyportal was the first, but now another mod, Simple Audio Video Embedder is running properly). Magic....
The error:
array(14) { [0]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(301) ["function"]=> string(9) "log_error" } [4]=> array(1) { ["function"]=> string(17) "smf_error_handler" } [5]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" } [6]=> array(3) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" } [7]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" } [8]=> array(3) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" } [9]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" } [10]=> array(3) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6030) ["function"]=> string(14) "PackageInstall" } [11]=> array(3) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" } [12]=> array(3) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(499) ["function"]=> string(8) "Packages" } [13]=> array(3) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(184) ["function"]=> string(9) "AdminMain" } } Error loop.
Quote from: hustreamload on July 24, 2023, 01:30:28 AM... but now another mod, Simple Audio Video Embedder is running properly). Magic....
One more plus info: Simple Audio Video Embedder seemed running properly, but it doesn't really work. And it cannot be unistalled:
(https://images2.imgbox.com/68/3f/QhISN2Ay_o.png) (http://"https://imgbox.com/QhISN2Ay")
Is it interesting that above Simplemachines Download Site is "Unknown or Not Found"?
Did you not uninstall it before replacing the files?
You can use fix_packages.php (https://download.simplemachines.org/index.php?tools) tool, but it doesn't work on PHP 8+
Quote from: hustreamload on July 24, 2023, 12:33:51 AMQuote from: Sir Osis of Liver on July 23, 2023, 02:35:01 PMHooks? Maybe upload clean files and remove hooks before reinstalling mods.
Sorry, what does it mean practically? Pls step by step (see my last 2 post before).
Uploading clean files does not fix it, and the result seems to be erratic. As mentioned early on in this topic, the problem may be in the database. 2.1 upgrade is supposed to remove integration hooks, which are added to the db by hooked mods. It's possible one or more hooks weren't removed successfully, and that could cause grief for package manager. When you upload clean files it removes all mods from the files, but does not affect the database. There can be stray hooks, mod settings, mod tables. The latter two are ignored, but it might be possible that a damaged hook is affecting mod installs (shawn?). Hooks are in the settings table, they can be removed using repair_settings, or you can delete them manually.
You can also disable or remove hooks from Forum Maintenance > Integration Hooks section.
Quote from: Sir Osis of Liver on July 24, 2023, 01:42:06 PMUploading clean files does not fix it, and the result seems to be erratic. As mentioned early on in this topic, the problem may be in the database. 2.1 upgrade is supposed to remove integration hooks, which are added to the db by hooked mods. It's possible one or more hooks weren't removed successfully, and that could cause grief for package manager. When you upload clean files it removes all mods from the files, but does not affect the database. There can be stray hooks, mod settings, mod tables. The latter two are ignored, but it might be possible that a damaged hook is affecting mod installs (shawn?). Hooks are in the settings table, they can be removed using repair_settings, or you can delete them manually.
Ok, I ve deleted all hooks, then made a clean upgrade by https://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files...Now only
one mod ia working, that is the Tinyportal, nothing else. PLUS I've uploaded native language, I push the change button, green light, succesful...and remains English. Terrible....
(https://images2.imgbox.com/86/4f/DlcUzfzx_o.jpg) (https://imgbox.com/DlcUzfzx)
Your forum is not displaying english to guests. Do you have english selected as your language in profile?
Quote from: Sir Osis of Liver on July 24, 2023, 10:17:24 PMYour forum is not displaying english to guests. Do you have english selected as your language in profile?
Of course, see pic above, and this:
(https://images2.imgbox.com/ce/d7/mrGPa2px_o.jpg) (http://\"https//imgbox.com/mrGPa2px%5C")
As guest the login box is hungarian, after login changes to english.
***this one is solved, it was my fault: after disabling the user selectable language support the main language have changed correctly****
Ok, then remains "only" the main error
Quote from: hustreamload on July 24, 2023, 06:26:26 PMOk, I ve deleted all hooks, then made a clean upgrade by https://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files...Now only one mod ia working, that is the Tinyportal, nothing else. PLUS I've uploaded native language, I push the change button, green light, succesful...and remains English. Terrible....
With a fresh set of files, you are trying to make your forum look like a new install, no mods.
You will need to deinstall all the mods first. You shouldn't see any mods listed as installed under Admin | Package Manager when this is complete. Double-check & confirm the hooks are gone under Admin | Maintenance.
If you followed the optional step of deleting the /Sources and /Themes folders, you are going to also need to re-upload all the language packs & themes & revisit those settings to make sure they make sense. If you did not delete those folders, this should not be necessary.
One thing I would do, if I were in your shoes, after refreshing the full set of files, is to empty the smf_log_packages table. Especially since the problems you are having appear to be around queries related to this table.
After refreshing your code, you are aiming for (1) all new files, (2) no installed packages, (3) no hooks at all.
After ensuring the 3 conditions above are met, the next thing I would do is some routine maintenance:
- Run the Optimize all tables function under Forum Maintenance. If there is a DB issue with one or more tables, this will error out. This would be good to know...
- Run the Find & Repair Any Errors under Forum Maintenance. Shouldn't hurt...
Another thing I would do if I were in your place is confirm the DB matches desired DB. I have a utility that will help with this:
https://raw.githubusercontent.com/sbulen/sjrbTools/master/smf_db_compare.php
Right-click & download that utility. Copy it to your forum root, then run it from your browser.
If there is anything missing from your DB, it will be highlighted in RED. Let us know about those.
If there are columns/tables added (via mods or manually), they will be highlighted in GREEN. You want to make sure these make sense & you know why they were added.
Ignore anything highlighted in yellow for now.
But raise any items in red here for us to look at.
When we are done reviewing this, it will be time to reinstall mods, one at a time.
Hope this helps,
Thanks shawnb61, I try it. As earlier wrote here, Find & Repair Any Errors under Forum Maintenance doesn't work, it runs on 503 error Service unavailable. I come back soon.
Quote from: shawnb61 on July 25, 2023, 12:34:24 AMAnother thing I would do if I were in your place is confirm the DB matches desired DB. I have a utility that will help with this:
https://raw.githubusercontent.com/sbulen/sjrbTools/master/smf_db_compare.php
....
If there is anything missing from your DB, it will be highlighted in RED. Let us know about those.
If there are columns/tables added (via mods or manually), they will be highlighted in GREEN. You want to make sure these make sense & you know why they were added.
Ignore anything highlighted in yellow for now.
But raise any items in red here for us to look at.
These are the red rows, on the left side they are empty, on the right side the following:
smf_boards 1 idx_member_groups 1 member_groups 48
smf_topics 0 idx_first_message 1 id_first_msg null
smf_topics 0 idx_first_message 2 id_board null
smf_topics 0 idx_last_message 1 id_last_msg null
smf_topics 0 idx_last_message 2 id_board null
Can you show the structure for the smf_boards & smf_topics records?
Include the indexes. Screen shot from phpmyadmin Structure tab is OK.
If we confirm those indexes are missing, that might explain the 503. That can be easily fixed.
(https://images2.imgbox.com/09/63/hzX5fsSY_o.png) (https://imgbox.com/hzX5fsSY)
(https://images2.imgbox.com/59/ef/pKeKrBuy_o.png) (https://imgbox.com/pKeKrBuy)
(https://images2.imgbox.com/73/91/ud9tvxg2_o.png) (https://imgbox.com/ud9tvxg2)
(https://images2.imgbox.com/46/36/nJTZl0aF_o.png) (https://imgbox.com/nJTZl0aF)
Thanks
Quote from: shawnb61 on July 25, 2023, 01:45:47 AMCan you show the structure for the smf_boards & smf_topics records?
Include the indexes. Screen shot from phpmyadmin Structure tab is OK.
If we confirm those indexes are missing, that might explain the 503. That can be easily fixed.
Sorry because of the previous post, it was misunderstanding. So the smf_boards contains cca. 500 rows, but smf topics 87000! I send smf_boards attached, but smf_topics is 7 MB, , therefore I send download link instead:
(Edit by Kindred: link and attachment removed)
Not the contents. The Structure.
Select the table, then select the Structure tab in phpmyadmin.
For both boards & topics.
Shouldn't be very big.
Boards
(https://images2.imgbox.com/ef/fe/nuSwKfRf_o.png) (http://"https://imgbox.com/nuSwKfRf")
Topics:
(https://images2.imgbox.com/1b/2e/OFVhBtTS_o.png) (http://"https://imgbox.com/OFVhBtTS")
The good news, that after the 57th clean upgarde I tried another portal (EzPortal) with succes, and then almost every mod could be installed...already 5 or 6. The bad news, that the two corrupted tables are still red, maybe this info helps.
Thanks!
Also bad news, that after the first 5 every mod failed
We need to add those missing indexes.
I believe that will fix the 503 error. Possibly more. We'll see.
I'll be able to help in a couple hours. (At work now...)
OK, there are 3 indexes that need to be built. You can run this sql in phpmyadmin, in the SQL tab:
ALTER TABLE smf_boards ADD INDEX idx_member_groups (member_groups(48));ALTER TABLE smf_topics ADD UNIQUE idx_last_message (id_last_msg, id_board);ALTER TABLE smf_topics ADD UNIQUE idx_first_message (id_first_msg, id_board);
After doing this, please attempt the "Find and repair errors" task.
Also, did you try the "Optimize all tables" as suggested above?
Also please rerun the DB compare utility to confirm no more RED missing items.
Let us know how these tasks go...
Oh, thanks a lot shawnb61!
After running sql scripts in phpmyadmin a full repair check was made, then db optimalization, after that I tried to run Find and repair errors task, but 503 error remained. More tragical, that mod unavailability as well. The good news, that DB compare is already OK, no red missing items.
Something is causing your database to run away, and we still don't know the root cause. There are two things I'd like to look at next:
(1) Do you have the mysql log entries? Normally the only entries in the mysql log are startup/shutdown, but in the event of something deeper, errors may be logged here.
(2) Let's turn on SMF's mysql debug mode... Place the following in your Settings.php file, near the other $db settings:
$db_show_debug = true;
After turning debug mode, attempt one of the actions that is failing. Then, let's look at the queries that were executing.
Thanks again shawnb61!
To the first point: I dont know, from where/what sholud I send. Do you mean the log_error table from the DB? Attached. Or sholuld send the backtraces?
To the second point: After activating debug mode the first test was running "Find and repair any errors". Earlier this ended with 503 error, now only a blank screen came out after 60 seconds (and error log remained empty). The second was activating mod !Forum with settings". After 60 seconds this query came out:
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home/strea334/public_html/Sources/Subs-Db-mysql.php on line 1027
array(14) { [0]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(42) "Database Error: MySQL server has gone away" [1]=> string(8) "database" [2]=> string(45) "/home/strea334/public_html/Sources/Errors.php" [3]=> int(138) } } [1]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" ["args"]=> array(2) { [0]=> string(44) " SELECT COUNT(*) FROM smf_log_errors" [1]=> object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1762952) ["warning_count"]=> int(0) } } } [2]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" ["args"]=> array(3) { [0]=> string(0) "" [1]=> string(44) " SELECT COUNT(*) FROM smf_log_errors" [2]=> array(0) { } } } [3]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(301) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(77) "2: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given" [1]=> string(7) "general" [2]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" [3]=> int(1027) } } [4]=> array(2) { ["function"]=> string(17) "smf_error_handler" ["args"]=> array(5) { [0]=> int(2) [1]=> string(74) "mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given" [2]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" [3]=> int(1027) [4]=> array(4) { ["error_array"]=> array(10) { [0]=> &int(3) [1]=> &int(1690433413) [2]=> &string(8) "0526f8d0" [3]=> &string(80) "?action=admin;area=packages;sa=install2;package=smf-forum-width_1.2.tar.gz;pid=0" [4]=> &string(42) "Database Error: MySQL server has gone away" [5]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [6]=> &string(8) "database" [7]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [8]=> &int(928) [9]=> &string(1482) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"SychO:forum_width_setting"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } ["db_prefix"]=> &string(4) "smf_" ["db_connection"]=> &object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1762952) ["warning_count"]=> int(0) } ["mysql_error_data_prep"]=> &bool(false) } } } [5]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" ["args"]=> array(12) { [0]=> bool(false) [1]=> string(10) "iissssssis" [2]=> &int(3) [3]=> &int(1690433413) [4]=> &string(8) "0526f8d0" [5]=> &string(80) "?action=admin;area=packages;sa=install2;package=smf-forum-width_1.2.tar.gz;pid=0" [6]=> &string(42) "Database Error: MySQL server has gone away" [7]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [8]=> &string(8) "database" [9]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [10]=> &int(928) [11]=> &string(1482) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"SychO:forum_width_setting"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } } [6]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" ["args"]=> array(1) { [0]=> array(10) { [0]=> &int(3) [1]=> &int(1690433413) [2]=> &string(8) "0526f8d0" [3]=> &string(80) "?action=admin;area=packages;sa=install2;package=smf-forum-width_1.2.tar.gz;pid=0" [4]=> &string(42) "Database Error: MySQL server has gone away" [5]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [6]=> &string(8) "database" [7]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [8]=> &int(928) [9]=> &string(1482) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'SychO:forum_width_setting'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"SychO:forum_width_setting"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } } } [7]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(42) "Database Error: MySQL server has gone away" [1]=> &string(8) "database" [2]=> string(47) "/home/strea334/public_html/Sources/Packages.php" [3]=> int(928) } } [8]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" ["args"]=> array(2) { [0]=> string(187) " SELECT version, themes_installed, db_changes FROM smf_log_packages WHERE package_id = 'SychO:forum_width_setting' AND install_state != 0 ORDER BY time_installed DESC LIMIT 1" [1]=> object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1762952) ["warning_count"]=> int(0) } } } [9]=> array(4) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" ["args"]=> array(3) { [0]=> string(0) "" [1]=> string(187) " SELECT version, themes_installed, db_changes FROM smf_log_packages WHERE package_id = 'SychO:forum_width_setting' AND install_state != 0 ORDER BY time_installed DESC LIMIT 1" [2]=> array(2) { ["not_installed"]=> int(0) ["current_package"]=> string(25) "SychO:forum_width_setting" } } } [10]=> array(4) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6042) ["function"]=> string(14) "PackageInstall" ["args"]=> array(0) { } } [11]=> array(4) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" ["args"]=> array(1) { [0]=> string(14) "PackageInstall" } } [12]=> array(4) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(501) ["function"]=> string(8) "Packages" ["args"]=> array(0) { } } [13]=> array(4) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(184) ["function"]=> string(9) "AdminMain" ["args"]=> array(0) { } } } Error loop.Then I tried another mod "SoundCloud Embed Widget", and the result:
Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given in /home/strea334/public_html/Sources/Subs-Db-mysql.php on line 1027
array(14) { [0]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(42) "Database Error: MySQL server has gone away" [1]=> string(8) "database" [2]=> string(45) "/home/strea334/public_html/Sources/Errors.php" [3]=> int(138) } } [1]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" ["args"]=> array(2) { [0]=> string(44) " SELECT COUNT(*) FROM smf_log_errors" [1]=> object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1765933) ["warning_count"]=> int(0) } } } [2]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" ["args"]=> array(3) { [0]=> string(0) "" [1]=> string(44) " SELECT COUNT(*) FROM smf_log_errors" [2]=> array(0) { } } } [3]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(301) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(77) "2: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given" [1]=> string(7) "general" [2]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" [3]=> int(1027) } } [4]=> array(2) { ["function"]=> string(17) "smf_error_handler" ["args"]=> array(5) { [0]=> int(2) [1]=> string(74) "mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, bool given" [2]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" [3]=> int(1027) [4]=> array(4) { ["error_array"]=> array(10) { [0]=> &int(3) [1]=> &int(1690433606) [2]=> &string(8) "0526f8d0" [3]=> &string(77) "?action=admin;area=packages;sa=install2;package=SoundCloudEmbed-v13.zip;pid=0" [4]=> &string(42) "Database Error: MySQL server has gone away" [5]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [6]=> &string(8) "database" [7]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [8]=> &int(928) [9]=> &string(1479) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"shawnb61:SoundCloudEmbed"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } ["db_prefix"]=> &string(4) "smf_" ["db_connection"]=> &object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1765933) ["warning_count"]=> int(0) } ["mysql_error_data_prep"]=> &bool(false) } } } [5]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(1027) ["function"]=> string(22) "mysqli_stmt_bind_param" ["args"]=> array(12) { [0]=> bool(false) [1]=> string(10) "iissssssis" [2]=> &int(3) [3]=> &int(1690433606) [4]=> &string(8) "0526f8d0" [5]=> &string(77) "?action=admin;area=packages;sa=install2;package=SoundCloudEmbed-v13.zip;pid=0" [6]=> &string(42) "Database Error: MySQL server has gone away" [7]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [8]=> &string(8) "database" [9]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [10]=> &int(928) [11]=> &string(1479) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"shawnb61:SoundCloudEmbed"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } } [6]=> array(4) { ["file"]=> string(45) "/home/strea334/public_html/Sources/Errors.php" ["line"]=> int(129) ["function"]=> string(19) "smf_db_error_insert" ["args"]=> array(1) { [0]=> array(10) { [0]=> &int(3) [1]=> &int(1690433606) [2]=> &string(8) "0526f8d0" [3]=> &string(77) "?action=admin;area=packages;sa=install2;package=SoundCloudEmbed-v13.zip;pid=0" [4]=> &string(42) "Database Error: MySQL server has gone away" [5]=> &string(32) "a0afdff95d5bdcde424b9b0294ac5e13" [6]=> &string(8) "database" [7]=> &string(47) "/home/strea334/public_html/Sources/Packages.php" [8]=> &int(928) [9]=> &string(1479) "[{"file":"\/home\/strea334\/public_html\/Sources\/Subs-Db-mysql.php","line":494,"function":"smf_db_error","args":["\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"affected_rows":null,"client_info":null,"client_version":null,"connect_errno":null,"connect_error":null,"errno":null,"error":null,"error_list":null,"field_count":null,"host_info":null,"info":null,"insert_id":null,"server_info":null,"server_version":null,"sqlstate":null,"protocol_version":null,"thread_id":null,"warning_count":null}]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":928,"function":"smf_db_query","args":["","\n\t\tSELECT version, themes_installed, db_changes\n\t\tFROM smf_log_packages\n\t\tWHERE package_id = 'shawnb61:SoundCloudEmbed'\n\t\t\tAND install_state != 0\n\t\tORDER BY time_installed DESC\n\t\tLIMIT 1",{"not_installed":0,"current_package":"shawnb61:SoundCloudEmbed"}]},{"file":"\/home\/strea334\/public_html\/Sources\/Subs.php","line":6042,"function":"PackageInstall","args":[]},{"file":"\/home\/strea334\/public_html\/Sources\/Packages.php","line":91,"function":"call_helper","args":["PackageInstall"]},{"file":"\/home\/strea334\/public_html\/Sources\/Admin.php","line":501,"function":"Packages","args":[]},{"file":"\/home\/strea334\/public_html\/index.php","line":184,"function":"AdminMain","args":[]}]" } } } [7]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(590) ["function"]=> string(9) "log_error" ["args"]=> array(4) { [0]=> string(42) "Database Error: MySQL server has gone away" [1]=> &string(8) "database" [2]=> string(47) "/home/strea334/public_html/Sources/Packages.php" [3]=> int(928) } } [8]=> array(4) { ["file"]=> string(52) "/home/strea334/public_html/Sources/Subs-Db-mysql.php" ["line"]=> int(494) ["function"]=> string(12) "smf_db_error" ["args"]=> array(2) { [0]=> string(186) " SELECT version, themes_installed, db_changes FROM smf_log_packages WHERE package_id = 'shawnb61:SoundCloudEmbed' AND install_state != 0 ORDER BY time_installed DESC LIMIT 1" [1]=> object(mysqli)#1 (18) { ["affected_rows"]=> int(-1) ["client_info"]=> string(14) "mysqlnd 7.4.33" ["client_version"]=> int(70433) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone away" ["error_list"]=> array(2) { [0]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } [1]=> array(3) { ["errno"]=> int(2006) ["sqlstate"]=> string(5) "HY000" ["error"]=> string(26) "MySQL server has gone away" } } ["field_count"]=> int(1) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(29) "5.5.5-10.6.14-MariaDB-cll-lve" ["server_version"]=> int(100614) ["sqlstate"]=> string(5) "HY000" ["protocol_version"]=> int(10) ["thread_id"]=> int(1765933) ["warning_count"]=> int(0) } } } [9]=> array(4) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(928) ["function"]=> string(12) "smf_db_query" ["args"]=> array(3) { [0]=> string(0) "" [1]=> string(186) " SELECT version, themes_installed, db_changes FROM smf_log_packages WHERE package_id = 'shawnb61:SoundCloudEmbed' AND install_state != 0 ORDER BY time_installed DESC LIMIT 1" [2]=> array(2) { ["not_installed"]=> int(0) ["current_package"]=> string(24) "shawnb61:SoundCloudEmbed" } } } [10]=> array(4) { ["file"]=> string(43) "/home/strea334/public_html/Sources/Subs.php" ["line"]=> int(6042) ["function"]=> string(14) "PackageInstall" ["args"]=> array(0) { } } [11]=> array(4) { ["file"]=> string(47) "/home/strea334/public_html/Sources/Packages.php" ["line"]=> int(91) ["function"]=> string(11) "call_helper" ["args"]=> array(1) { [0]=> string(14) "PackageInstall" } } [12]=> array(4) { ["file"]=> string(44) "/home/strea334/public_html/Sources/Admin.php" ["line"]=> int(501) ["function"]=> string(8) "Packages" ["args"]=> array(0) { } } [13]=> array(4) { ["file"]=> string(36) "/home/strea334/public_html/index.php" ["line"]=> int(184) ["function"]=> string(9) "AdminMain" ["args"]=> array(0) { } } } Error loop.
aaah...another bug: search is not working....
The DB error shown in forum:
Table 'strea334_wp618.smf_log_floodcontrol' doesn't exist
Fájl: /home/strea334/public_html/Sources/Security.php
Sor: 1199
DELETE FROM smf_log_floodcontrol
WHERE log_time < 1690435602
AND log_type = 'search'
Log error:
a0afdff95d5bdcde424b9b0294ac5e13
https://www.streamloadforum.com/index.php?action=search2
/home/strea334/public_html/Sources/Security.php (Line 1199)
Backtrace information:
Error
Type of error
Database
Error message
Adatbázis hiba: Table 'strea334_wp618.smf_log_floodcontrol' doesn't exist
File
/home/strea334/public_html/Sources/Security.php
Line
1199
URL of page causing the error
https://www.streamloadforum.com/index.php?action=search2
Backtrace information
#0: smf_db_error()
Called from /home/strea334/public_html/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home/strea334/public_html/Sources/Security.php on line 1199
#2: spamProtection()
Called from /home/strea334/public_html/Sources/Search.php on line 1041
#3: PlushSearch2()
Called from /home/strea334/public_html/index.php on line 184
Browser ID: chrome (is_chrome, is_webkit)
Templates: 4: index (default), Admin (default), GenericMenu (default), Errors (default).
Sub templates: 2: init, show_backtrace.
Language files: 5: EzPortal.english (default), index+Modifications.english (default), Admin.english (default), ManageMaintenance.english (default), HIFG/.english (default).
Style sheets: 4: index.css, jquery.custom-scrollbar.css, admin.css, responsive.css.
Hooks called: 318 (show)
Files included: 41 - 1588KB. (show)
Memory used: 6963KB.
Tokens: post-admin-login, post-admin-maint, post-admin-el, post-profile-ac3.
Queries used: 15.
[Show Queries]
And does the log_floodcontrol table exist in your database?
No, it doesn't. How to create it? Or may I rename backup file, because this one exists?
Ok, after 7 days I gave it up, and restored the 2.0.19 version. New db problems appeared:
- the original was the mod install unavailability
- after that came the search problem
- today many members called me, that they cannot login because of a db problem
I would be glad if you explain me, how to make a second forum with the same data content on www.myaccount/pilot, and i reproduce this upgrade again, with less bug (I think I've "upgraded" the db 10 times minimum in these days, the data loss and plus problems appeared after that)
Thanks guys for your help!
You have something very wrong with your system....
your database tables are missing columns and now it appears that you are missing entire tables.
I have run and upgraded more than a dozen systems now and I have never seen a system do what yours is doing. :o
If you are willing to PM me full access to your server (cpanel login info and forum login info) I will try to take a look this weekend.
Yes, entire tables just flat out disappearing is a problem with your DB &/or your host. Possibly a corrupted backup that you restored from.
Regarding the initial error where you cannot install mods, this old thread might help:
Quote from: -Rock Lee- on July 27, 2023, 11:03:37 AM@shawnb61 Look https://www.simplemachines.org/community/index.php?msg=4121949 some mods produce that error, I don't know why... I think it doesn't manage to analyze it well.
Based on Rock Lee's note above, the next thing I'd suggest is disabling *both* of the backup options under Package Manger | Options.
Then try installing the mod again.
I wanted to followup on this, to share what I have found, in case we see this again.
Based on
@-Rock Lee- 's input above, I was able to reproduce the issue. Steps:
- Select both backup options under Package Manager | Options
- Put a bunch of huge files under /Sources & /Themes - I put a few GB of backups there. (Not too much or it will blow up on memory allocation... Just enough to slow it down...)
- Set the MySQL wait_timeout to a low value, e.g., 60 sec
Similar stack trace & errors.
So what I think is happening is that it takes so long to do the backup, MySQL goes away. When the process resumes, it tries to make DB updates, which fail, since the DB is gone. Then it tries to log the error, which also fails, since the DB is gone. Rinse & repeat.
Note these issues will repeat until /Sources & /Themes are cleaned up, or, the backup option is disabled.
I.e., you can refresh files, uninstall mods, revert package updates, etc., all you want, and the behavior won't change, as seen above...
If we see this again, I'd like to know:
- Which backup options were selected?
- Does disabling backups fix the issue?
- How big are the latest backups under /Packages/backups?
- Are there large files in /Sources & /Themes? What & why?
- What is the value of MySQL's wait_timeout?
shawwnb61, Kindred, thanks again for your help!
As I wrote before, I have to make a pilot for this upgrade, where all the bugs can be reproduced. Can you help me in this first step as well?
So how can I make a second forum with the same data content on the same server?
Quote from: hustreamload on August 06, 2023, 11:53:52 PMSo how can I make a second forum with the same data content on the same server?
Do you mean to make a duplication of your main forum in a test folder/other subdomain? If that is the case, upload the forum folder to your pc and then reupload it to the folder where you want the test forum to be at, then create a new database and restore there a backup of your main forum 's database and as last but certainly not least, run the repair_settings (https://wiki.simplemachines.org/smf/Repair_settings.php) tool to straighten all paths and urs of the test forum and you should be all set.
Quote from: Kindred on July 28, 2023, 10:19:56 AMYou have something very wrong with your system....
your database tables are missing columns and now it appears that you are missing entire tables.
I have run and upgraded more than a dozen systems now and I have never seen a system do what yours is doing. :o
If you are willing to PM me full access to your server (cpanel login info and forum login info) I will try to take a look this weekend.
Thanks Kindred, I sent a pm
Quote from: shawnb61 on August 06, 2023, 08:21:56 PMI wanted to followup on this, to share what I have found, in case we see this again.
Based on @-Rock Lee- 's input above, I was able to reproduce the issue. Steps:
- Select both backup options under Package Manager | Options
- Put a bunch of huge files under /Sources & /Themes - I put a few GB of backups there. (Not too much or it will blow up on memory allocation... Just enough to slow it down...)
- Set the MySQL wait_timeout to a low value, e.g., 60 sec
Similar stack trace & errors.
So what I think is happening is that it takes so long to do the backup, MySQL goes away. When the process resumes, it tries to make DB updates, which fail, since the DB is gone. Then it tries to log the error, which also fails, since the DB is gone. Rinse & repeat.
Note these issues will repeat until /Sources & /Themes are cleaned up, or, the backup option is disabled.
I.e., you can refresh files, uninstall mods, revert package updates, etc., all you want, and the behavior won't change, as seen above...
If we see this again, I'd like to know:
- Which backup options were selected?
- Does disabling backups fix the issue?
- How big are the latest backups under /Packages/backups?
- Are there large files in /Sources & /Themes? What & why?
- What is the value of MySQL's wait_timeout?
I made a pilot forum, where I could reproduce the main error:
http://streamloadforum.com/pilot
In few words the situation:
- I deleted all the mods from the 2.0.19 forum's db, and deleted the hooks as well
- I deleted the Sources and Themes dir as well
- after that I upgraded on 2.1.4
- Tinyportal installation sucseeded
- any other mod failed
- find and repair any errors failed as well
- with smf_db_compare.php and your scripts the missing tables are made up
Questions:
1. Where can I Set the MySQL wait_timeout "to a low value"?
Answers/questions on your questions:
- Which backup options were selected? Where should I select this option?
- Does disabling backups fix the issue? Where should I select this option?
- How big are the latest backups under /Packages/backups? cca 40 MB
- Are there large files in /Sources & /Themes? What & why? It was deeted before upgrade so only the normal files are in it
- What is the value of MySQL's wait_timeout? se my question above
Thanks!
Quote from: hustreamload on August 13, 2023, 08:51:47 AMAnswers/questions on your questions:
- Which backup options were selected? Where should I select this option?
- Does disabling backups fix the issue? Where should I select this option?
- What is the value of MySQL's wait_timeout? se my question above
Thanks!
The backup options are in the admin panel, under Admin | Package Manager | Options. There are two 'Create a backup of...' options at the bottom of the form. What are they set to? Does it work if you disable both?
The wait_timeout is set by your host. To view it, in the myphpadmin SQL tab, run this query:
SHOW VARIABLES LIKE 'wait_timeout';40MB (compressed) backups are actually pretty big, for just a copy of /Sources & /Themes... Mine are all in the 4-7MB (compressed) range. (The entire SMF install is only ~3.5MB...) It is possible that something in there is much bigger than expected. I would search both /Sources & /Themes for the biggest subfolders for clues.
shawnb61, disabling the backup option, THAT was the solution!
Thanks a lot, I could install every mod in seconds!
MAGIC!!!!
Thank you very much!
What was the value of wait_timeout?
wait_timeout is 20
but without any change in it the mods are already available
thanks!
That wait_timeout is extremely low...
The mysql default for wait_timeout is 28800.
So what is happening here is that the backup, which is unusually large, is taking longer than 20 seconds to create, causing mysql to timeout, in part due to an unusually low timeout setting.
That explains why a 'hooks only' mod does install fine: no files needed in the backup
Ok, maybe that explains the unavailability of "Find and repair any errors" as well, it runs still on 503 timeout. How to set it, and what is the offered value?
Quote from: hustreamload on August 15, 2023, 11:51:37 AMOk, maybe that explains the unavailability of "Find and repair any errors" as well, it runs still on 503 timeout. How to set it, and what is the offered value?
Your host should increase this. 20 prohibits a lot of maintenance activity. SMF does chunk up big maintenance tasks, but as you have learned, it is pretty easy to pass 20.
If they're not OK with restoring the default of 28800, see if you can at least get them to go to a few hundred. As big as they're willing to go. Enough so you can run the Find and Repair any Errors.
We are on a shared server (Hosting24), I cannot reach them to rise this level. "That can happen if you use heavy or very long MySQL queries. To solve it, try adding the mysql_reconnect command before each query. " (FAQ)
Its not clear for me, if that 20 for wait_timeot in 2.0.19 was enough, why is not enough in 2.1.4....si any idea how to solve it?
Quote from: hustreamload on August 21, 2023, 03:25:37 AMIts not clear for me, if that 20 for wait_timeot in 2.0.19 was enough, why is not enough in 2.1.4....si any idea how to solve it?
The logic behaves pretty much the same in 2.1 as in 2.0. 20 seconds would cause issues in 2.0, depending on the request. You can search the forum for wait_timeout or "Mysql server has gone away" and see prior similar issues.
Regarding your thread here - the backup option to make a backup of /Sources & /Themes didn't exist in 2.0. That's why it didn't bother you in 2.0. Also, we never found out why your backups are so big.
Regarding Find & Repair Errors - unfortunately, we cannot know WHY F&RE is failing for you in this instance, because F&RE is the very tool that runs such checks...
SMF needs some mechanism to run long-running tasks, e.g., Scheduled Tasks & F&RE.
If you stay with that host, the best advice I can provide is to download a copy of your DB & run F&RE locally. Another option is to follow their recommendation to issue a reconnect before every query in F&RE. I am not sure how extensive those changes would be. Or you could attempt to issue a "SET session wait_timeout=1000;" somewhere in F&RE. That would only work if they allow such an update (& probably not...). For those last two recommendations, you're on your own & coding around an unreasonable setting.