YetiForceCompany / YetiForceCRM

Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
Other
1.73k stars 749 forks source link

Errore tabelle inesistenti dopo migrazione Yeti[bug] #17297

Closed aleterracciano closed 1 year ago

aleterracciano commented 1 year ago

Buongiorno, ho provato a migrare Yetiforce su un sottodominio per realizzare un ambiente di test. Ho però riscontrato un errore importante, non posso visualizzare le impostagioni generali perchè dopo aver migrato DB e Hosting sul nuovo dominio, il sistema yetiforce mi mostra un messaggio di errore: Errore: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testcmcrv3_yesttest22.i_yf_wapro' doesn't exist Failed to prepare SQL: SELECT COUNT(*) FROM i_yf_wapro

Di seguito uno screenshot dell'errore: image

Ho provato a creare la tabella con delle colonne generiche ma il messaggio di errore non scompare, cambia solo la tabella che non esiste. Per il sistema alcune tabelle non esistono nel database ma la cosa interessante è che la tabella "yesttest22.i_yf_wapro" non esiste nemmeno nel database del sito principale. NON ESISTE sul sito in produzione, perchè dovrebbe essere richiesta da yetiforce sulla copia destinata al sito di test?

Di seguito il log error generato dal dominio di test:

2023-10-06 11:08:02.203369 [NOTICE] [4143289] [T0] [149.62.185.242:42022:HTTP2-1#APVH_www.test-miosito.it:443] [STDERR] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testcmcrv3_yesttest22.i_yf_wapro' doesn't exist in /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Command.php:267\nStack trace:\n#0 /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Command.php(267): PDO->prepare('SELECT COUNT()...')\n#1 /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Command.php(1163): yii\db\Command->prepare(true)\n#2 /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Command.php(436): yii\db\Command->queryInternal('fetchColumn', 0)\n#3 /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Query.php(497): yii\db\Command->queryScalar()\n#4 /home/testcmcrv3/domains/test-miosito.itv/public_html/app/Db/Query.php(136): yii\db\Query->queryScalar('COUNT()', NULL)\n#5 /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/y in /home/testcmcrv3/domains/test-miosito.it/public_html/vendor/yetiforce/yii2/db/Command.php on line 272\n

Come posso risolvere?

Non potendo condividervi la configurazione del server tramite yetiforce, vi invio la configurazione del php server. Di seguito le configurazioni del php-info:

System | Linux v3001.priv.to.host.it 4.18.0-477.21.1.lve.1.el8.x86_64 #1 SMP Tue Sep 5 23:08:35 UTC 2023 x86_64 -- | -- Build Date | Aug 9 2023 11:14:05 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=/opt/alt/krb5/usr' '--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/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/krb5/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' 'KERBEROS_CFLAGS=-I/opt/alt/krb5/usr/include' 'KERBEROS_LIBS=-L/opt/alt/krb5/usr/lib64' 'WEBP_LIBS=-L/opt/alt/libwebp/lib64 -Wl,-rpath=/opt/alt/libwebp/lib64' 'SASL_CFLAGS=-I/opt/alt/cyrus-sasl/include' 'SASL_LIBS=-L/opt/alt/cyrus-sasl/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 Additional .ini files parsed | /opt/alt/php74/link/conf/alt_php.ini 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

🐞 bug report

⁉️ Describe the bug

🔥 How to trigger the error

Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

👎 Actual Behavior

👍 Expected Behavior

👷 Testing

📷 Screenshot of configuration

📝 PHP/Apache/Nginx/Browser/CRM Logs

🌍 Your Environment

Environment Version / Name
YetiForce
Web server (name and version)
PHP
Browser (name and version)
Operating System (name and version)
Database (name and version)
Service Pack version

❓ Additional context

Add any other context about the problem here.

❗️ Inform the community if you solve the problem

System Linux v3001.priv.to.host.it 4.18.0-477.21.1.lve.1.el8.x86_64 #1 SMP Tue Sep 5 23:08:35 UTC 2023 x86_64 Build Date Aug 9 2023 11:14:05 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=/opt/alt/krb5/usr' '--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/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/krb5/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' 'KERBEROS_CFLAGS=-I/opt/alt/krb5/usr/include' 'KERBEROS_LIBS=-L/opt/alt/krb5/usr/lib64' 'WEBP_LIBS=-L/opt/alt/libwebp/lib64 -Wl,-rpath=/opt/alt/libwebp/lib64' 'SASL_CFLAGS=-I/opt/alt/cyrus-sasl/include' 'SASL_LIBS=-L/opt/alt/cyrus-sasl/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 Additional .ini files parsed /opt/alt/php74/link/conf/alt_php.ini 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 Zend logoThis program makes use of the Zend Scripting Language Engine: Zend Engine v3.4.0, Copyright (c) Zend Technologies with the ionCube PHP Loader + ionCube24 v12.0.5, Copyright (c) 2002-2022, by ionCube Ltd. with Zend OPcache v7.4.33, Copyright (c), by Zend Technologies Configuration apcu APCu Support Enabled Version 5.1.21 APCu Debugging Disabled MMAP Support Enabled MMAP File Mask no value Serialization Support php Build Date Mar 15 2023 19:00:38 Directive Local Value Master Value apc.coredump_unmap Off Off apc.enable_cli Off Off apc.enabled On On apc.entries_hint 4096 4096 apc.gc_ttl 3600 3600 apc.mmap_file_mask no value no value apc.preload_path no value no value apc.serializer php php apc.shm_segments 1 1 apc.shm_size 32M 32M apc.slam_defense Off Off apc.smart 0 0 apc.ttl 0 0 apc.use_request_time Off Off 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.6, 6-Sept-2010 calendar Calendar support enabled Core PHP Version 7.4.33 Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off 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 virtual, popen, pclose, dl, proc_open, proc_terminate, proc_get_status, proc_close, pfsockopen, pcntl_exec, apache_child_terminate, posix_kill, posix_mkfifo, posix_setpgid, posix_setsid, posix_setuid, ini_alter, show_source shell_exec,exec,system,passthru,popen 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 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 32759 32759 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 Off Off ignore_repeated_source Off Off 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 On On log_errors_max_len 1024 1024 mail.add_x_header Off Off mail.force_extra_parameters no value no value mail.log /home/testcmcrv3/.php/php-mail.log no value max_execution_time 600 600 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 600 600 max_input_vars 100000 1000 max_multipart_body_parts -1 -1 memory_limit 1G 1G open_basedir /home/testcmcrv3/:/tmp:/var/tmp:/opt/alt/php74/usr/share/pear/:/dev/urandom:/usr/local/lib/php/:/usr/local/php74/lib/php/ no value output_buffering 4096 4096 output_encoding no value no value output_handler no value no value post_max_size 128M 64M 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 -f testcmcrv3@test-miosito.it /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 Off Off unserialize_callback_func no value no value upload_max_filesize 512M 512M 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.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 Features 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.11 libSSH Version libssh2/1.10.0 Directive Local Value Master Value 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/Rome 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/Rome Europe/Rome 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 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 libmagic 537 filter Input Validation and Filtering enabled Directive Local Value Master Value 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 Directive Local Value Master Value gd.jpeg_ignore_warning 1 1 gettext GetText Support enabled gmp gmp support enabled GMP version 6.1.2 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 iconv iconv support enabled iconv implementation glibc iconv library version 2.28 Directive Local Value Master Value iconv.input_encoding no value no value iconv.internal_encoding no value no value iconv.output_encoding no value no value imagick imagick module enabled imagick module version 3.7.0 imagick classes Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator, ImagickKernel Imagick compiled with ImageMagick version ImageMagick 7.1.0-20 Q16-HDRI x86_64 2022-01-22 https://imagemagick.org Imagick using ImageMagick library version ImageMagick 7.1.0-62 Q16-HDRI x86_64 20885 https://imagemagick.org ImageMagick copyright (C) 1999 ImageMagick Studio LLC ImageMagick release date 2023-02-12 ImageMagick number of supported formats: 259 ImageMagick supported formats 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, ASHLAR, AVI, AVIF, AVS, BAYER, BAYERA, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUBE, CUR, CUT, DATA, DCM, DCR, DCRAW, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FARBFELD, FAX, FF, FITS, FL32, FLV, FRACTAL, FTS, FTXT, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, HALD, HDR, HEIC, HEIF, HISTOGRAM, HRZ, HTM, HTML, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, KERNEL, LABEL, M2V, M4V, MAC, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORA, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PHM, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PS, PS2, PS3, PSB, PSD, PTIF, PWP, QOI, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGB565, RGBA, RGBO, RGF, RLA, RLE, RMF, RSVG, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, STRIMG, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TM2, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YAML, YCbCr, YCbCrA, YUV Directive Local Value Master Value imagick.allow_zero_dimension_images 0 0 imagick.locale_fix 0 0 imagick.progress_monitor 0 0 imagick.set_single_thread 1 1 imagick.shutdown_sleep_count 10 10 imagick.skip_version_check 0 0 imap IMAP c-Client Version 2007f SSL Support enabled Kerberos Support enabled Directive Local Value Master Value imap.enable_insecure_rsh Off Off intl Internationalization support enabled ICU version 64.2 ICU Data version 64.2 ICU TZData version 2019a ICU Unicode version 12.1 Directive Local Value Master Value intl.default_locale no value no value intl.error_level 0 0 intl.use_exceptions 0 0 ionCube Loader ionCube logoionCube24 logo ionCube Loader developed by ionCube Ltd. Visit ioncube.com for latest Loaders and support. This Loader also includes features for real-time error reporting and malware protection. Visit ioncube24.com for more details. Loader version 12.0.5 ionCube24 features unconfigured Directive Local Value Master Value ic24.api.log_msg_errors 0 0 ic24.api.max_timeout 7 7 ic24.api_access_key **** **** ic24.api_check_ip 1 1 ic24.enable 0 0 ic24.home_dir no value no value ic24.phperr.enable auto auto ic24.phperr.ignore 0 0 ic24.sec.block_stdin 1 1 ic24.sec.block_uploaded_files 1 1 ic24.sec.enable auto auto ic24.sec.exclusion_key **** **** ic24.sec.initial_action block block ic24.sec.initial_cache_all 1 1 ic24.sec.initial_notify always always ic24.sec.initial_state 1 1 ic24.sec.stop_on_error 1 1 ic24.sec.trusted_include_paths **** **** ic24.slt 7 7 ic24.update_domains_retry_interval 30 30 ioncube.loader.encoded_paths no value no value json json support enabled libxml libXML support active libXML Compiled Version 2.10.2 libXML Loaded Version 21002 libXML streams enabled mailparse mailparse support enabled Extension Version 3.1.4 Directive Local Value Master Value mailparse.def_charset us-ascii us-ascii 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) version 6.8.2 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 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 MysqlI Support enabled Client API library version mysqlnd 7.4.33 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value 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 mysqlnd enabled 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 Directive Local Value Master Value openssl.cafile no value no value openssl.capath no value no value pcntl pcntl support enabled 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) Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.jit 1 1 pcre.recursion_limit 100000 100000 PDO PDO support enabled PDO drivers mysql, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 7.4.33 Directive Local Value Master Value pdo_mysql.default_socket /tmp/mysql.sock /tmp/mysql.sock pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.39.4 Phar Phar: PHP Archive support enabled 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 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 POSIX support enabled readline Readline Support enabled Readline library 7.0 Directive Local Value Master Value 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 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 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 files files session.save_path /opt/alt/php74/var/lib/php/session /opt/alt/php74/var/lib/php/session session.serialize_handler php 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 uploadprogress uploadprogress session.use_cookies 1 1 session.use_only_cookies 1 1 session.use_strict_mode 0 0 session.use_trans_sid 0 0 shmop shmop support enabled SimpleXML SimpleXML support enabled 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 sodium sodium support enabled libsodium headers version 1.0.18 libsodium library version 1.0.18 SPL SPL support enabled 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 SQLite3 support enabled SQLite Library 3.39.4 Directive Local Value Master Value sqlite3.defensive 1 1 sqlite3.extension_dir no value no value standard Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i -f testcmcrv3@miosito.it Directive Local Value Master Value 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 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 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.32 libxslt compiled against libxml Version 2.9.7 EXSLT enabled libexslt Version 1.1.32 Zend OPcache Opcode Caching Up and Running Optimization Enabled SHM Cache Enabled File Cache Disabled Startup OK Shared memory model mmap Cache hits 318188 Cache misses 913 Used memory 27057880 Free memory 104951032 Wasted memory 2208816 Interned Strings Used memory 2967544 Interned Strings Free memory 3323464 Cached scripts 845 Cached keys 1457 Max keys 16229 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 On On opcache.enable_file_override Off Off opcache.error_log no value no value opcache.file_cache no value no value opcache.file_cache_consistency_checks On On opcache.file_cache_only Off Off opcache.file_update_protection 2 2 opcache.force_restart_timeout 180 180 opcache.huge_code_pages Off Off opcache.interned_strings_buffer 8 8 opcache.lockfile_path /tmp /tmp opcache.log_verbosity_level 1 1 opcache.max_accelerated_files 10000 10000 opcache.max_file_size 0 0 opcache.max_wasted_percentage 5 5 opcache.memory_consumption 128 128 opcache.opt_debug_level 0 0 opcache.optimization_level 0x7FFEBFFF 0x7FFEBFFF opcache.preferred_memory_model no value no value opcache.preload no value no value opcache.preload_user no value no value opcache.protect_memory Off Off opcache.restrict_api no value no value opcache.revalidate_freq 2 2 opcache.revalidate_path Off Off opcache.save_comments On On opcache.use_cwd On On opcache.validate_permission Off Off opcache.validate_root Off Off opcache.validate_timestamps On On zip Zip enabled Zip version 1.15.6 Libzip headers version 1.3.2 Libzip library version 1.3.2 zlib ZLib Support enabled Stream Wrapper compress.zlib:// Stream Filter zlib.inflate, zlib.deflate Compiled Version 1.2.11 Linked Version 1.2.11 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 litespeed Environment Variable Value PATH /usr/local/bin:/bin:/usr/bin PHP Variables Variable Value $_REQUEST['YTSID'] 60d705bd198a7154eb6afd41f225b23c $_REQUEST['session'] LILIYHYUSLSIHITVG5YEZ5ZET3THOB7VR3BRJVQ $_COOKIE['YTSID'] 60d705bd198a7154eb6afd41f225b23c $_COOKIE['session'] LILIYHYUSLSIHITVG5YEZ5ZET3THOB7VR3BRJVQ $_SERVER['PATH'] /usr/local/bin:/bin:/usr/bin $_SERVER['HTTP_ACCEPT'] text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.7 $_SERVER['HTTP_ACCEPT_ENCODING'] gzip, deflate, br $_SERVER['HTTP_ACCEPT_LANGUAGE'] it-IT,it;q=0.9 $_SERVER['HTTP_COOKIE'] YTSID=60d705bd198a7154eb6afd41f225b23c; session=LILIYHYUSLSIHITVG5YEZ5ZET3THOB7VR3BRJVQ $_SERVER['HTTP_HOST'] test-miosito.it $_SERVER['HTTP_USER_AGENT'] Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 $_SERVER['HTTP_SEC_CH_UA'] "Google Chrome";v="117", "Not;A=Brand";v="8", "Chromium";v="117" $_SERVER['HTTP_SEC_CH_UA_MOBILE'] ?0 $_SERVER['HTTP_SEC_CH_UA_PLATFORM'] "Windows" $_SERVER['HTTP_UPGRADE_INSECURE_REQUESTS'] 1 $_SERVER['HTTP_SEC_FETCH_SITE'] none $_SERVER['HTTP_SEC_FETCH_MODE'] navigate $_SERVER['HTTP_SEC_FETCH_USER'] ?1 $_SERVER['HTTP_SEC_FETCH_DEST'] document $_SERVER['DOCUMENT_ROOT'] /home/testcmcrv3/domains/test-cmiosito.it/private_html $_SERVER['REMOTE_ADDR'] 94.138.187.67 $_SERVER['REMOTE_PORT'] 53701 $_SERVER['SERVER_ADDR'] 149.62.185.242 $_SERVER['SERVER_NAME'] test-miosito.it $_SERVER['SERVER_ADMIN'] webmaster@test-miosito.it $_SERVER['SERVER_PORT'] 443 $_SERVER['REQUEST_SCHEME'] https $_SERVER['REQUEST_URI'] /php-info.php $_SERVER['HTTPS'] on $_SERVER['HTACCESS_TEST'] on $_SERVER['modHeadersAvailable'] true $_SERVER['HTTP_AUTHORIZATION'] no value $_SERVER['X_SPDY'] HTTP3 $_SERVER['SSL_PROTOCOL'] QUIC $_SERVER['SSL_CIPHER'] TLS_AES_128_GCM_SHA256 $_SERVER['SSL_CIPHER_USEKEYSIZE'] 128 $_SERVER['SSL_CIPHER_ALGKEYSIZE'] 128 $_SERVER['SCRIPT_FILENAME'] /home/testcmcrv3/domains/test-miosito.itt/private_html/php-info.php $_SERVER['QUERY_STRING'] no value $_SERVER['SCRIPT_URI'] https://test-miosito.it/php-info.php $_SERVER['SCRIPT_URL'] /php-info.php $_SERVER['SCRIPT_NAME'] /php-info.php $_SERVER['SERVER_PROTOCOL'] HTTP/1.1 $_SERVER['SERVER_SOFTWARE'] LiteSpeed $_SERVER['REQUEST_METHOD'] GET $_SERVER['X-LSCACHE'] on,crawler,esi,combine $_SERVER['PHP_SELF'] /php-info.php $_SERVER['REQUEST_TIME_FLOAT'] 1696580833.9625 $_SERVER['REQUEST_TIME'] 1696580833 $_ENV['PATH'] /usr/local/bin:/bin:/usr/bin PHP Credits PHP Group Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski Language Design & Concept Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger PHP Authors Contribution Authors Zend Scripting Language Engine Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov Extension Module API Andi Gutmans, Zeev Suraski, Andrei Zmievski UNIX Build and Modularization Stig Bakken, Sascha Schumann, Jani Taskinen, Peter Kokot Windows Support Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski, Kalle Sommer Nielsen Server API (SAPI) Abstraction Layer Andi Gutmans, Shane Caraveo, Zeev Suraski Streams Abstraction Layer Wez Furlong, Sara Golemon PHP Data Objects Layer Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky Output Handler Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner Consistent 64 bit support Anthony Ferrara, Anatol Belski SAPI Modules Contribution Authors Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code) CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui Embed Edin Kadribasic FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet litespeed George Wang phpdbg Felipe Pena, Joe Watkins, Bob Weinand Module Authors Module Authors BC Math Andi Gutmans Bzip2 Sterling Hughes Calendar Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong COM and .Net Wez Furlong ctype Hartmut Holzgraefe cURL Sterling Hughes Date/Time Support Derick Rethans DB-LIB (MS SQL, Sybase) Wez Furlong, Frank M. Kromann, Adam Baratz DBA Sascha Schumann, Marcus Boerger DOM Christian Stocker, Rob Richards, Marcus Boerger enchant Pierre-Alain Joye, Ilia Alshanetsky EXIF Rasmus Lerdorf, Marcus Boerger FFI Dmitry Stogov fileinfo Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans, Anatol Belski Firebird driver for PDO Ard Biesheuvel FTP Stefan Esser, Andrew Skalski GD imaging Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger GetText Alex Plotnick GNU GMP support Stanislav Malyshev Iconv Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi IMAP Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky Input Filter Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky Internationalization Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar JSON Jakub Zelenka, Omar Kilani, Scott MacVicar LDAP Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas LIBXML Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo Multibyte String Functions Tsukada Takuya, Rui Hirokawa MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter OCI8 Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation ODBC driver for PDO Wez Furlong ODBC Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky Opcache Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Dmitry Stogov, Xinchen Hui OpenSSL Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar Oracle (OCI) driver for PDO Wez Furlong pcntl Jason Greene, Arnaud Le Blanc Perl Compatible Regexps Andrei Zmievski PHP Archive Gregory Beaver, Marcus Boerger PHP Data Objects Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky PHP hash Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar Posix Kristian Koehntopp PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky PostgreSQL Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne Pspell Vlad Krupin Readline Thies C. Arntzen Reflection Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter Sessions Sascha Schumann, Andrei Zmievski Shared Memory Operations Slava Poliakov, Ilia Alshanetsky SimpleXML Sterling Hughes, Marcus Boerger, Rob Richards SNMP Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin SOAP Brad Lafountain, Shane Caraveo, Dmitry Stogov Sockets Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene Sodium Frank Denis SPL Marcus Boerger, Etienne Kneuss SQLite 3.x driver for PDO Wez Furlong SQLite3 Scott MacVicar, Ilia Alshanetsky, Brad Dewar System V Message based IPC Wez Furlong System V Semaphores Tom May System V Shared Memory Christian Cartus tidy John Coggeshall, Ilia Alshanetsky tokenizer Andrei Zmievski, Johannes Schlueter XML Stig Bakken, Thies C. Arntzen, Sterling Hughes XMLReader Rob Richards xmlrpc Dan Libby XMLWriter Rob Richards, Pierre-Alain Joye XSL Christian Stocker, Rob Richards Zip Pierre-Alain Joye, Remi Collet Zlib Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner PHP Documentation Authors Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Philip Olson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey Editor Peter Cowburn User Note Maintainers Daniel P. Brown, Thiago Henrique Pojda Other Contributors Previously active authors, editors and other contributors are listed in the manual. PHP Quality Assurance Team Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs Websites and Infrastructure team PHP Websites Team Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison Event Maintainers Damien Seguy, Daniel P. Brown Network Infrastructure Daniel P. Brown Windows Infrastructure Alex Schoenmaker 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.

rskrzypczak commented 1 year ago

First of all... you put too much information about unformatted code in your post. Secondly... the most important information is missing here, namely the version of the YetiForce system. Thirdly... this is not a system error, but an incorrectly performed migration process.(https://github.com/YetiForceCompany/YetiForceCRM/discussions).

You have a file incompatibility with the database. You probably migrated the files after the update, and you have the database from before the update. https://doc.yetiforce.com/introduction/system-migration-or-recovery/

aleterracciano commented 1 year ago

Ciao, la versione è: 6.0.3. Riguardo l'incompatibilità, il database è aggiornato. Sto provando da tre giorni a scaricare e caricare hosting e database sempre nuovi. Non posso effettuare per errore un aggiornamento al giorno. Perciò il db è quello allineato all'hosting attuale. Anche perchè il sito in produzione, funziona correttamente. Riguardo la migrazione andata male, potrebbe essere anche se alla fine ho modificato correttamente sia il file main.php sia il DB.php, infatti riesco ad accedere al portale e ad utilizzarlo, mi manca solo il back end.

aleterracciano commented 1 year ago

Ho notato che il https://miosito.it/cron.php non fa partire il cron. Mi da l'errore: Errore: La pagina non funzionatest-company.crcema.it al momento non è in grado di gestire la richiesta. HTTP ERROR 500

aleterracciano commented 1 year ago

Buongiorno, ho capito che la schermata di errore mi viene proposta da yeti solo nella pagina negozio. Sono riuscito a visualizzare la sezione dedicata all'aggiornamento del sistema ed ho tentato l'aggiornamento. Da 6.0.3 a 6.0.4. Ma a questo punto mi da un'altro errore: SQLSTATE[HY000]: General error: 1005 Can't create table testcmcrv3_yesttest22.roundcube_responses (errno: 150 "Foreign key constraint is incorrectly formed") The SQL being executed was: CREATE TABLE roundcube_responses ( response_id int(10) unsigned NOT NULL AUTO_INCREMENT, user_id int(10) unsigned NOT NULL, name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, data longtext COLLATE utf8mb4_unicode_ci NOT NULL, is_html tinyint(1) NOT NULL DEFAULT 0, changed datetime NOT NULL DEFAULT '1000-01-01 00:00:00', del tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (response_id), KEY user_responses_index (user_id,del), CONSTRAINT user_id_fk_responses FOREIGN KEY (user_id) REFERENCES roundcube_users (user_id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; L'aggiornamento non è avvenuto.