Plugin updates fail

Trying to update child plugins from the dashboard, they all fail - showing a red cross, but no error shows up.
Resynced, didn’t help.
Went to the status/error logs, the only line i saw that could be related is this:

PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /home/customer/www/theweather.dev/public_html/wp-content/plugins/mainwp-maintenance-extension/class/maintenance-extension-db.class.php on line 273

@amaau looking at your system reports from your other ticket your MainWP system looks to be ok.

The Child Site is not returning the correct response and is returning False.

Can you post your Child Sites system report ( you may redact site URLs if you feel it important )

Thanks for the reply Keith
Forgive the dumb question, but where do I find a child site’s system report?

@amaau

Child Site > Settings > MainWP Child > System Information > Blue Button

Redact any personal URLS before uploading please. If we need more info I will have you open an Official MainWP support ticket instead.

Thanks, here -


### Server configuration           Required value                                         Value                                        Status   ###

MAINWP CHILD                       
                                   MainWP Child Version                                   4.1.8                                        4.1.8       Pass        
WordPress                          
                                   WordPress Version                                      >=3.4                                        5.8.1       Pass        
                                   WordPress Memory Limit                                 >=64M                                        40M         Warning     
                                   MultiSite Disabled                                     =true                                        true        Pass        
                                   FileSystem Method                                      = direct                                     direct      Pass        
PHP SETTINGS                       
                                   PHP Version                                            >=5.6                                        7.4.25      Pass        
                                   PHP Safe Mode Disabled                                 OFF                                          
                                   PHP Max Execution Time                                 >=30 seconds                                 120         Pass        
                                   PHP Max Input Time                                     >=30 seconds                                 120         Pass        
                                   PHP Memory Limit                                       >=128M (256M+ best for big backups)          768M        Pass        
                                   PCRE Backtracking Limit                                >=10000                                      1000000     Pass        
                                   PHP Upload Max Filesize                                >=2M (2MB+ best for upload of big plugins)   256M        Pass        
                                   PHP Post Max Size                                      >=2M (2MB+ best for upload of big plugins)   256M        Pass        
                                   SSL Extension Enabled                                  =true                                        true        Pass        
                                   SSL Warnings                                           = empty                                                  Pass        
                                   cURL Extension Enabled                                 =true                                        true        Pass        
                                   cURL Timeout                                           >=300 seconds                                40          Warning     
                                   cURL Version                                           >=7.18.1                                     7.66.0      Pass        
                                   cURL SSL Version                                       >=OpenSSL/1.1.0                              OpenSSL/1.1.1l-fipsWarning     
Your host needs to update OpenSSL to at least version 1.1.0 which is already over 4 years old and contains patches for over 60 vulnerabilities.These range from Denial of Service to Remote Code Execution. Click here for more information.
MySQL SETTINGS                     
                                   MySQL Version                                          >=5.0                                        5.7.32-35-logPass        
BACKUP ARCHIVE INFORMATION         
                                   ZipArchive enabled in PHP                              =true                                        true        Pass        
                                   Tar GZip supported                                     =true                                        true        Pass        
                                   Tar BZip2 supported                                    =true                                        true        Pass        
SERVER INFORMATION                 
                                   WordPress Root Directory                               /home/customer/www/*****/public_html/
                                   Server Name                                            www.*****      
                                   Server Software                                        Apache                                       
                                   Operating System                                       Linux                                        
                                   Architecture                                           64 bit                                       
                                   Server IP                                              35.214.24.216                                
                                   Server Protocol                                        HTTP/1.0                                     
                                   HTTP Host                                              www.*****      
                                   HTTPS                                                  ON - on                                      
                                   Server self connect                                    Response Test O.K.                           
                                   User Agent                                             Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36
                                   Server Port                                            443                                          
                                   Gateway Interface                                      CGI/1.1                                      
                                   Memory Usage                                           126.95 MB                                    
                                   Complete URL                                           https://www.*****/wp-admin/options-general.php
                                   Request Time                                           1636228601                                   
                                   Accept Content                                         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.9
                                   Accept-Charset Content                                 N/A                                          
                                   Currently Executing Script Pathname                    /home/u1440-3swkdd0kn4gv/www/*****/public_html/wp-admin/options-general.php
                                   Current Page URI                                       /wp-admin/options-general.php?page=mainwp_child_tab
                                   Remote Address                                         89.176.24.79                                 
                                   Remote Host                                            N/A                                          
                                   Remote Port                                            55970                                        
PHP INFORMATION                    
                                   PHP Allow URL fopen                                    ON                                           
                                   PHP Exif Support                                       YES ( V7.4.)                                 
                                   PHP IPTC Support                                       YES                                          
                                   PHP XML Support                                        YES                                          
                                   PHP Disabled Functions                                 No functions disabled                        
                                   PHP Loaded Extensions                                  Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, memcached, mysqli, mysqlnd, openssl, pcntl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, pspell, readline, session, shmop, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib
MySQL INFORMATION                  
                                   MySQL Mode                                             NO_ENGINE_SUBSTITUTION                       
                                   MySQL Client Encoding                                  utf8                                         
WordPress PLUGINS                  
                                   Advanced Database Cleaner                              3.0.3                                        Active                  
                                   Advanced Post Queries                                  1.0.15                                       Active                  
                                   Ajax Search Pro                                        4.20.8                                       Active                  
                                   AJAX Thumbnail Rebuild                                 1.13                                         Active                  
                                   Better Search Replace                                  1.3.4                                        Active                  
                                   Classic Editor                                         1.6                                          Active                  
                                   Complianz Privacy Suite (GDPR/CCPA) premium            5.3.0.1                                      Active                  
                                   Crop Thumbnails                                        1.3.1                                        Active                  
                                   Custom Post Type Permalinks                            3.4.4                                        Active                  
                                   Disable Comments                                       2.1.1                                        Active                  
                                   Duplicate Page and Post                                2.6.5                                        Active                  
                                   Duplicator                                             1.4.0                                        Active                  
                                   Dynamic Content for Elementor                          1.14.5                                       Active                  
                                   Easy Updates Manager                                   9.0.8                                        Active                  
                                   Ele Custom Skin                                        3.1.0                                        Active                  
                                   Ele Custom Skin Pro                                    3.1.0                                        Active                  
                                   Elementor                                              3.2.3                                        Active                  
                                   Elementor Inline SVG                                   1.2.0                                        Active                  
                                   Elementor Pro                                          3.2.2                                        Active                  
                                   Enable Media Replace                                   3.5.0                                        Active                  
                                   Favorites                                              2.3.2                                        Inactive                
                                   Featured Image Admin Thumb                             1.6                                          Active                  
                                   FileBird Lite                                          4.9.3                                        Inactive                
                                   Folders                                                2.7.1                                        Active                  
                                   Google Pagespeed Insights                              4.0.3                                        Active                  
                                   Hotjar                                                 1.0.11                                       Active                  
                                   iThemes Sync                                           2.1.9                                        Active                  
                                   JetElements For Elementor                              2.5.7                                        Active                  
                                   JetEngine                                              2.8.0                                        Active                  
                                   JetEngine - Get attachment file link by ID             1.1.1                                        Active                  
                                   Jet Hide Empty Items                                   1.0.0                                        Active                  
                                   JetPopup                                               1.5.2                                        Active                  
                                   JetSmartFilters                                        2.2.3                                        Active                  
                                   JetTabs For Elementor                                  2.1.13                                       Active                  
                                   jQuery Pin It Button for Images                        3.0.6                                        Active                  
                                   MailOptin - Lite                                       1.2.36.1                                     Active                  
                                   MainWP Child                                           4.1.8                                        Active                  
                                   MainWP Child reports                                   2.0.8                                        Active                  
                                   Make Column Clickable Elementor                        1.3.1                                        Active                  
                                   Media Cleaner (Pro)                                    6.2.5                                        Active                  
                                   Plugins Garbage Collector (Database Cleanup)           0.12                                         Active                  
                                   Pre* Party Resource Hints                              1.7.7.1                                      Active                  
                                   Real Media Library (Free)                              4.16.2                                       Inactive                
                                   Redirection                                            5.1.1                                        Active                  
                                   SiteGround Optimizer                                   5.9.4                                        Active                  
                                   Sucuri Security - Auditing, Malware Scanner and Hardening1.8.30                                       Active                  
                                   Term Management Tools                                  2.0.1                                        Active                  
                                   The SEO Framework                                      4.1.3                                        Active                  
                                   Velvet Blues Update URLs                               3.2.10                                       Active                  
                                   When Last Login                                        1.2                                          Active                  
                                   Wordfence Security                                     7.5.6                                        Active                  
                                   WP Client Reports                                      1.0.12                                       Active                  
                                   WP Mail SMTP                                           2.9.0                                        Active                  
                                   WP Sheet Editor - JetEngine                            1.0.0                                        Active                  
                                   WP Sheet Editor - Media Library                        1.9.8                                        Active                  
                                   WP Sheet Editor - Post Types (Premium)                 2.24.4                                       Active                  
                                   YIKES Simple Taxonomy Ordering                         2.3.3                                        Active                  

### Next due                       Schedule                                               Hook                                      ###

November 6, 2021 7:57 pm           Every minute                                           action_scheduler_run_queue                   
November 6, 2021 8:04 pm           Twice Daily                                            wp_mainwp_stream_auto_purge                  
November 6, 2021 8:09 pm           Once Hourly                                            mo_hourly_recurring_job                      
November 6, 2021 8:27 pm           Once Hourly                                            wp_privacy_delete_old_export_files           
November 6, 2021 8:46 pm           Once Hourly                                            wordfence_ls_ntp_cron                        
November 6, 2021 8:46 pm           Once Hourly                                            wordfence_hourly_cron                        
November 6, 2021 10:04 pm          Twice Daily                                            wp_https_detection                           
November 7, 2021 12:00 am          Once Daily                                             wp_client_reports_check_for_updates_daily    
November 7, 2021 2:00 am           Once Daily                                             ithemes_sync_daily_schedule                  
November 7, 2021 2:35 am           Once Daily                                             fs_data_sync_wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages
November 7, 2021 5:38 am           Twice Daily                                            puc_cron_check_updates-dynamic-content-for-elementor
November 7, 2021 7:07 am           Once every day                                         cmplz_every_day_hook                         
November 7, 2021 10:44 am          Once Daily                                             sucuriscan_scheduled_scan                    
November 7, 2021 10:46 am          Once Daily                                             wordfence_daily_cron                         
November 7, 2021 11:19 am          Once Daily                                             gpi_prune_logs                               
November 7, 2021 11:19 am          Once Daily                                             mainwp_child_pagespeed_cron_check            
November 7, 2021 11:33 am          Once Daily                                             recovery_mode_clean_expired_keys             
November 7, 2021 11:41 am          Once Daily                                             wp_scheduled_delete                          
November 7, 2021 11:41 am          Once Daily                                             delete_expired_transients                    
November 7, 2021 12:01 pm          Once Daily                                             elementor/tracker/send_event                 
November 7, 2021 12:28 pm          Once Daily                                             mo_daily_recurring_job                       
November 7, 2021 12:48 pm          Once Daily                                             wp_scheduled_auto_draft_delete               
November 7, 2021 2:13 pm           Once Daily                                             wpseo-reindex                                
November 7, 2021 2:21 pm           Once Daily                                             analytify_email_cron_function                
November 7, 2021 2:33 pm           Once Daily                                             optml_daily_sync                             
November 7, 2021 2:35 pm           Once Daily                                             siteground_delete_assets                     
November 7, 2021 2:43 pm           Once Daily                                             siteground_optimizer_check_assets_dir        
November 7, 2021 4:27 pm           Once Daily                                             wpse_delete_old_csvs                         
November 7, 2021 7:04 pm           Once Daily                                             fs_data_sync_wp-sheet-editor-media-library   
November 8, 2021 4:00 pm                                                                  wordfence_email_activity_report              
November 9, 2021 5:50 am                                                                  wordfence_start_scheduled_scan               
November 9, 2021 7:07 am           Once every week                                        cmplz_every_week_hook                        
November 10, 2021 5:33 pm          Interval set in GPI options                            googlepagespeedinsightsworker                
November 11, 2021 11:57 am         Once Weekly                                            wp_site_health_scheduled_check               
November 11, 2021 2:35 pm          Once Weekly                                            monsterinsights_usage_tracking_cron          
November 12, 2021 5:50 am                                                                 wordfence_start_scheduled_scan               
November 24, 2021 7:07 am          Once every month                                       cmplz_every_month_hook                       

### Time                           Error                                               ###

06-Nov-2021 05:55:37 UTC           PHP Notice:  Undefined index: package-url in /home/customer/www/*****/public_html/wp-content/plugins/ithemes-sync/lib/updater/information.php on line 51
06-Nov-2021 05:55:37 UTC           PHP Notice:  Undefined index: available in /home/customer/www/*****/public_html/wp-content/plugins/ithemes-sync/lib/updater/information.php on line 49
03-Nov-2021 05:55:40 UTC           PHP Notice:  Undefined index: package-url in /home/customer/www/*****/public_html/wp-content/plugins/ithemes-sync/lib/updater/information.php on line 51
03-Nov-2021 05:55:40 UTC           PHP Notice:  Undefined index: available in /home/customer/www/*****/public_html/wp-content/plugins/ithemes-sync/lib/updater/information.php on line 49
19-Oct-2021 18:31:47 UTC           PHP Warning:  unlink(/tmp/zip6raB0g): No such file or directory in /home/customer/www/*****/public_html/wp-content/themes/oceanwp-child/functions.php on line 391
19-Oct-2021 18:31:47 UTC           PHP Warning:  readfile(/tmp/zip6raB0g): failed to open stream: No such file or directory in /home/customer/www/*****/public_html/wp-content/themes/oceanwp-child/functions.php on line 390
19-Oct-2021 18:31:47 UTC           PHP Warning:  filesize(): stat failed for /tmp/zip6raB0g in /home/customer/www/*****/public_html/wp-content/themes/oceanwp-child/functions.php on line 388
19-Oct-2021 16:50:01 UTC           PHP Warning:  unlink(/tmp/zipbfx72R): No such file or directory in /home/customer/www/*****/public_html/wp-content/themes/oceanwp-child/functions.php on line 391
19-Oct-2021 16:50:01 UTC           PHP Warning:  readfile(/tmp/zipbfx72R): failed to open stream: No such file or directory in /home/customer/www/*****/public_html/wp-content/themes/oceanwp-child/functions.php on line 390

@amaau Yeah I am not seeing anything jump out in these logs that would cause this.

You might want to turn on WP-Debug on the Child site to see if there is anything generated during updates.

You are connected too… Only thing we can do now is tried and true Process of Elimination.
Start with disabling your Security Plugins.
Then the theme.

Would you mind opening a private Help Desk ticket as well so we can collect some additional information & investigate further?

I have to solve something else first,
will get back to you on that if it’s still an issue
Thank you