ntrivilino@alice.it

found the problem: with PHP 8.1 i have many processes in the server Cpanel, and web site offline with PHP 8.0 all works perfectly 😲 my php 8.0 config

processes list can you see anything strange?

my web site www.drivingitalia.net is offline because i have too many processes active in the server, look from Cpanel an example of the processes list i125w7do 128480 0.0 0.0 303284 14216 ? Ss giu07 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 292990 0.0 0.0 303284 15852 ? Ss giu09 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 354086 0.0 0.4 422676 133088 ? Ss giu09 0:14 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 356423 0.0 0.0 450748 15856 ? Ssl giu09 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 499115 0.0 0.0 450748 15856 ? Ssl giu09 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 705045 0.0 0.5 457496 166788 ? Ss giu07 0:20 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 844211 0.0 0.0 303284 15848 ? Ss giu09 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 848134 0.0 0.0 303284 15844 ? Ss giu09 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1452045 0.0 0.7 523520 235508 ? Ss giu10 0:33 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1486124 0.0 0.0 307512 19216 ? Ss giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1505418 0.0 0.0 307512 20196 ? Ss giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1690880 0.0 0.3 549428 112508 ? Ssl giu10 0:08 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1702026 0.0 0.0 454980 20200 ? Ssl giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 1853612 0.0 0.0 307512 18576 ? Ss giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2019226 0.0 0.4 422932 134172 ? Ss giu10 0:12 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2218381 0.0 0.0 305464 18104 ? Ss giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2257406 0.0 0.0 454976 20212 ? Ssl giu10 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2778053 0.0 0.3 410376 120548 ? Ss 02:32 0:10 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2981465 0.0 0.0 452796 18060 ? Ssl 06:29 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 2988766 0.0 0.0 307512 20176 ? Ss 06:38 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 3273000 0.0 0.0 307512 18568 ? Ss giu08 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c i125w7do 3658205 0.0 0.0 307512 18496 ? Ss giu08 0:00 /opt/alt/php81/usr/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/i125w7do/public_html/applications/core/interface/task/task.php 8fcc8ff5e18cddb41ce882ef95340d0c what's the problem? thanks

here is some database expert who could help me and do the job (he gets paid of course)... You Randy?

not working 😞 or to be precise, a new error now appears my host proposes this: could a solution be to dump and restore the database on the same node? could someone from the Invision staff carry out the operation for a fee? The MySQL server reported an error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1) in response to this request: INSERT INTO 'ibf_core_spam_service_log' ('id', 'log_date', 'log_code', 'log_msg', 'email_address', 'ip_address') VALUES ... i can empty the table ibf_core_spam_service_log ?

ok i'm testing this solution today, tks

in the phpmyadmin of my site i have the "to empty" command, it's correct? thanks

i can delete the table named ibf_core_sitemap without problem?

OK I have requested the full error report

I want to upgrade MySQL version 5.7.34-cll-lve to version 8.0.13 and using the InnoDB storage engine, but when i try to upgrade the update and migration procedure on a new server crashes due to a database error: The MySQL server reported an error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<urlset xmlns=\"http://www.sitemaps' at line 1) in response to this request: INSERT INTO 'ibf_core_sitemap' ('data', 'updated', 'sitemap', 'last_id') VALUES (... How can I solve the problem to make the update work? Is there anyone who can help me with the database and the error?

is it possible to rename the index file (so that it is no longer found by attacks), for example index2.php, but still make the site work? what should I change?

the problem is not on third party applications/plugins or theme: problem is in the high number access to the index.php file! If i rename index.php to another file name, all return to the normality.

note: spam filter are active

on my IPB on www.drivingitalia.net i have many error in the system log and many spammers traffic, in the last 3 days example: The log entry was triggered by a guest (Guests) 20 minutes ago The URL of page the error occurred on was http://www.drivingitalia.net/index.php?s=5aaf2b8029884e28f832d7fc35addee6&act=idx Error: Cannot use a scalar value as an array (0) #0 /home/i125w7do/public_html/system/Output/Javascript/Javascript.php(786): IPS\Output\_Javascript::_writeJavascriptFromResultset() #1 /home/i125w7do/public_html/system/Output/Output.php(585): IPS\Output\_Javascript::compile() #2 /home/i125w7do/public_html/system/Output/Output.php(338): IPS\_Output::_getJavascriptFileObject() #3 /home/i125w7do/public_html/system/Dispatcher/Standard.php(79): IPS\_Output->js() #4 /home/i125w7do/public_html/system/Dispatcher/Front.php(717): IPS\Dispatcher\_Standard::baseJs() #5 /home/i125w7do/public_html/system/Dispatcher/Front.php(79): IPS\Dispatcher\_Front::baseJs() #6 /home/i125w7do/public_html/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #7 /home/i125w7do/public_html/index.php(13): IPS\_Dispatcher::i() #8 {main} #0 /home/i125w7do/public_html/init.php(1036): IPS\_Log::log() #1 [internal function]: IPS\IPS::exceptionHandler() #2 {main} the stats of the server hosting in real time, absolutely abnormal and many errors like this on www.drivingitalia.net Resource Limit Is Reached The website is temporarily unable to service your request as it exceeded resource limit. Please try again later.

In my IPB site i have installed the PHP Version 8.1.22. But in the Get Support page i have this error: Find a solution You are running MySQL version 5.7.34-cll-lve. While this version is compatible, future releases of our software will require version 8.0.13 or above. Any help? thanks