I have a client who just updated to PHP 7.2.
We're trying to increase the PHP limits for memory limit, upload size, etc using a php.ini file as that is what the host allows.
Working from a host help file and a Perch help file* we are trying to make all folders use the php.ini file in the public_html directory.
* https://docs.grabaperch.com/perch/building/hosts/a2hosting/ (A2 is not the host we are working with)
This is the relevant code to add to the .htaccess file (with MYHOME being replaced with the appropriate directory name):
- SuPHP_ConfigPath /home/MYHOME/public_html/
Unfortunately when we update the .htaccess file as directed we get this error when trying to load any page, front-end or admin:
- Fatal error: Uncaught Error: Call to undefined function mysqli_report() in /home/strateg9/public_html/admin/core/lib/PerchDB_MySQLi.class.php:17 Stack trace: #0 /home/strateg9/public_html/admin/core/lib/PerchDB.class.php(20): PerchDB_MySQLi->__construct(NULL) #1 /home/strateg9/public_html/admin/core/lib/PerchFactory.class.php(28): PerchDB::fetch() #2 /home/strateg9/public_html/admin/core/inc/auth.php(14): PerchFactory->__construct() #3 /home/strateg9/public_html/admin/core/settings/diagnostics/index.php(6): include('/home/strateg9/...') #4 {main} thrown in /home/strateg9/public_html/admin/core/lib/PerchDB_MySQLi.class.php on line 17
Diagnostics from Perch are below.
I'm not sure where to go next, so any pointers could be helpful.
Thanks!
- Perch: 3.1.5
- Production mode: Production (100)
- Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_blog (5.5.1), perch_forms (1.12), perch_gallery (2.8.9), perch_mailchimp (3.1)
- DB driver: PDO
- DB tables: perch2_blog_authors (2), perch2_blog_categories (6), perch2_blog_comments (0), perch2_blog_index (2626), perch2_blog_posts (93), perch2_blog_posts_to_categories (28), perch2_blog_posts_to_tags (0), perch2_blog_sections (1), perch2_blog_tags (2), perch2_blogs (1), perch2_categories (6), perch2_category_counts (3), perch2_category_sets (1), perch2_content_index (2744), perch2_content_items (396), perch2_content_regions (50), perch2_forms (3), perch2_forms_responses (861), perch2_gallery_albums (27), perch2_gallery_image_versions (384), perch2_gallery_images (70), perch2_mailchimp_campaigns (23), perch2_mailchimp_imports (2), perch2_mailchimp_lists (6), perch2_mailchimp_subscribers (186), perch2_mailchimp_subscriptions (186), perch2_mailchimp_webhooks (6), perch2_menu_items (12), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_templates (1), perch2_pages (21), perch2_resource_log (1136), perch2_resource_tags (188), perch2_resources (675), perch2_resources_to_tags (673), perch2_settings (39), perch2_user_passwords (2), perch2_user_privileges (50), perch2_user_role_privileges (32), perch2_user_roles (2), perch2_users (2)
- Users: 2
- App runtimes:
- <?php
-
- $apps_list = [
- 'perch_gallery',
- 'perch_blog',
- 'perch_forms',
- 'kirk_admin_links',
- 'perch_mailchimp'
- ];
- ?>
- Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
- Scheduled tasks for perch_mailchimp: import_data (1 mins)
- Editor plug-ins: ckeditor, ckeditor.css, ckeditor.less, config.js, redactor-plugins
- H1: 7b73897093d41436fef0db007f202825
- L1: d6293cb3087dd8379109a5e1a6099a30
- F1: 3b606135b33e6a102526838f4152a807
- headerColour: #666666
- content_singlePageEdit: 1
- helpURL: /admin/tips/
- siteURL: /
- hideBranding: 0
- content_collapseList: 1
- lang: en-gb
- latest_version:
- headerScheme: dark
- content_hideNonEditableRegions: 1
- perch_blog_post_url: /blog:post:{postSlug}
- perch_blog_slug_format: {postTitle}-%y%m%d
- perch_blog_akismet_key:
- dashboard: 1
- perch_blog_comment_notify: 0
- perch_gallery_basicUpload: 1
- logoPath:
- update_3.1.4: done
- update_2.7.9: done
- perch_blog_update: 5.0.1
- on_sale_version:
- perch_gallery_update: 2.8.5
- update_2.8.8: done
- update_3.0.8: done
- perch_gallery_bucket_mode: single
- perch_gallery_bucket: default
- perch_blog_site_name:
- perch_blog_max_spam_days: 0
- hide_pwd_reset: 0
- keyboardShortcuts: 0
- content_frontend_edit: 0
- content_skip_region_list: 1
- perch_mailchimp_api_key: 750c10641c46460323783174eeaf225e-us10
- perch_mailchimp_campaign_url: /mailchimp/campaign/{campaignSlug}
- perch_mailchimp_secret: 36de47c
- update_3.0.14: done
- sidebar_back_link: 0
- assets_restrict_buckets: 0
- update_3.1.5: done
- PERCH_DEVELOPMENT: 10
- PERCH_STAGING: 50
- PERCH_PRODUCTION: 100
- PERCH_DB_USERNAME: strateg9_perch
- PERCH_DB_SERVER: localhost
- PERCH_DB_DATABASE: strateg9_perch2
- PERCH_DB_PREFIX: perch2_
- PERCH_EMAIL_FROM: info@strategic.health
- PERCH_EMAIL_FROM_NAME: Strategic Health
- PERCH_LOGINPATH: /admin
- PERCH_PATH: /home/strateg9/public_html/admin
- PERCH_CORE: /home/strateg9/public_html/admin/core
- PERCH_RESFILEPATH: /home/strateg9/public_html/admin/resources
- PERCH_RESPATH: /admin/resources
- PERCH_HTML5: 1
- PERCH_EDITORIMAGE_MAXWIDTH: 626
- PERCH_EDITORIMAGE_MAXHEIGHT: 626
- PERCH_EDITORIMAGE_CROP:
- PERCH_SCHEDULE_SECRET: iCvVPZ67BJcq
- PERCH_DONT_DELETE_FILES: 1
- PERCH_RWD: 1
- PERCH_TZ: America/New_York
- PERCH_CUSTOM_EDITOR_CONFIGS: 1
- PERCH_SSL: 1
- PERCH_RUNWAY:
- PERCH_ERROR_MODE: DIE
- PERCH_DATE_LONG: %d %B %Y
- PERCH_DATE_SHORT: %d %b %Y
- PERCH_TIME_SHORT: %H:%M
- PERCH_TIME_LONG: %H:%M:%S
- PERCH_RUNWAY_ROUTED:
- PERCH_STRONG_PASSWORDS:
- PERCH_ASSET_VERSION: 6738d5d5f5664f7c5e34
- PERCH_DEBUG:
- PERCH_PREVIEW_ARG: preview
- PERCH_TEMPLATE_PATH: /home/strateg9/public_html/admin/templates
- PERCH_TEMPLATE_FILTERS:
- PERCH_DEFAULT_DOC: index.php
- PERCH_DEFAULT_EXT: .php
- PERCH_PRODUCTION_MODE: 100
- PERCH_XHTML_MARKUP:
- PERCH_HTML_ENTITIES:
- PERCH_STRIPSLASHES:
- PERCH_PROGRESSIVE_FLUSH: 1
- PERCH_PARANOID:
- PERCH_FORCE_SECURE_COOKIES:
- PERCH_DEFAULT_BUCKET: default
- PERCH_TRANSLATION_ASSIST:
- PERCH_PASSWORD_MIN_LENGTH: 6
- PERCH_MAX_FAILED_LOGINS: 10
- PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
- PERCH_VERIFY_UPLOADS:
- PERCH_PRIV_ASSIST:
- PERCH_ENABLE_EXIF: 1
- PERCH_AUTH_PLUGIN:
- PERCH_DB_CHARSET: utf8
- PERCH_DB_PORT:
- PERCH_DB_SOCKET:
- PERCH_APPS_EDITOR_PLUGIN: markitup
- PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
- Hosting settings
- PHP: 7.2.29
- Zend: 3.2.0
- OS: Linux
- SAPI: cgi-fcgi
- Safe mode: not detected
- MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
- MySQL server: 5.6.45
- Free disk space: 4.26 TB
- Extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dba, dom, enchant, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imap, intl, json, ldap, exif, mysqlnd, odbc, PDO, pgsql, Phar, posix, pspell, shmop, SimpleXML, snmp, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl, zip, mysqli, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, wddx, xmlreader, xmlrpc, Zend OPcache
- GD: Yes
- ImageMagick: No
- PHP max upload size: 2M
- PHP max form post size: 8M
- PHP memory limit: 32M
- Total max uploadable file size: 2M
- Resource folder writeable: Yes
- Session timeout: 24 minutes
- Native JSON: Yes
- Filter functions: Yes
- Transliteration functions: Yes
- CONTEXT_DOCUMENT_ROOT: /home/strateg9/public_html
- DOCUMENT_ROOT: /home/strateg9/public_html
- GATEWAY_INTERFACE: CGI/1.1
- HTTPS: on
- HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
- HTTP_ACCEPT_ENCODING: gzip, deflate, br
- HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.9,la;q=0.8
- HTTP_CONNECTION: keep-alive
- HTTP_COOKIE: _ga=GA1.2.531064022.1584723842; cmsa=1; timezone=America/New_York; strategichealthannouncement=true|1; _gid=GA1.2.1231861073.1585248544; cpsession=strateg9%3a0ejEsbppGwKLHZFI%2ce6ca11b1b7c1503467f8797b4c5f4961; PHPSESSID=2e415af18f6463b8abe4d9bbfd23dae5
- HTTP_HOST: strategic.health
- HTTP_REFERER: https://strategic.health/admin/core/settings/diagnostics/
- HTTP_SEC_FETCH_DEST: document
- HTTP_SEC_FETCH_MODE: navigate
- HTTP_SEC_FETCH_SITE: same-origin
- HTTP_SEC_FETCH_USER: ?1
- HTTP_UPGRADE_INSECURE_REQUESTS: 1
- HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36
- HTTP_X_HTTPS: 1
- PATH: /bin:/usr/bin
- PHP_INI_SCAN_DIR: /opt/cpanel/ea-php72/root/etc:/opt/cpanel/ea-php72/root/etc/php.d:.
- QUERY_STRING: extended
- REDIRECT_STATUS: 200
- REMOTE_ADDR: 73.190.140.221
- REMOTE_PORT: 52834
- REQUEST_METHOD: GET
- REQUEST_SCHEME: https
- REQUEST_URI: /admin/core/settings/diagnostics/?extended
- SCRIPT_FILENAME: /home/strateg9/public_html/admin/core/settings/diagnostics/index.php
- SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
- SCRIPT_URI: https://strategic.health/admin/core/settings/diagnostics/
- SCRIPT_URL: /admin/core/settings/diagnostics/
- SERVER_ADDR: 66.206.89.21
- SERVER_ADMIN: webmaster@strategicdesignstudio.com
- SERVER_NAME: strategic.health
- SERVER_PORT: 443
- SERVER_PROTOCOL: HTTP/1.1
- SERVER_SOFTWARE: Apache
- SSL_TLS_SNI: strategic.health
- TZ: America/Los_Angeles
- UNIQUE_ID: Xn0B3ykLQhzlEfZH-OhtQAAAAA4
- proto: https
- PHP_SELF: /admin/core/settings/diagnostics/index.php
- REQUEST_TIME_FLOAT: 1585250784.051
- REQUEST_TIME: 1585250784
- argc: 1
Display More