Posts by jstahr99

jstahr99 · May 31st 2019

SQL

SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='143c8be045d2e9ebd04a2de2ebcd485d' LIMIT 1
UPDATE perch2_users SET userHash='d711e9fdc7ebed433bd201c5fa3d2f58' WHERE userID='1'
[26] SELECT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[10] SELECT itemValue FROM perch2_menu_items WHERE itemType='app'
[nil] SELECT *, REPLACE(pagePath, '/index.php', '') as sortPath FROM perch2_pages WHERE pageNew=1 ORDER BY LENGTH(sortPath)-LENGTH(REPLACE(sortPath, '/', '')) ASC
[32] SELECT p.*, (SELECT COUNT(*) FROM perch2_pages WHERE pageParentID=p.pageID) AS subpages FROM perch2_pages p WHERE p.pageParentID IN (0) ORDER BY p.pageTreePosition ASC
[72] SELECT * FROM perch2_content_regions ORDER BY regionOrder ASC
[8] SELECT * FROM perch2_content_regions WHERE regionPage='*' ORDER BY regionKey ASC
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[5] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch2_menu_items WHERE itemType='app' AND itemValue='content' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /core/apps/content/modes/list.post.php
[8] SELECT DISTINCT regionTemplate FROM perch2_content_regions ORDER BY regionTemplate ASC
[nil] SELECT * FROM perch2_content_regions WHERE pageID=28 AND regionPage!='*' ORDER BY regionOrder ASC
Queries: 16
Memory: 5.8853

Display More

I guess I'm not sure what I'm even looking for in the debug.

jstahr99 · May 31st 2019

I am getting a 500 error when I click to a region on my site. This has been happening since yesterday late morning. I am able to get to all other areas with no problem except for this one.

This is the diagnostics:

PHP

Perch information
Perch: 3.1.5
Production mode: Production (100)
Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_events (1.9.3), perch_comments (1.2), perch_mailchimp (3.0.1)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_categories (12), perch2_category_counts (0), perch2_category_sets (1), perch2_collection_index (84307), perch2_collection_items (4197), perch2_collection_revisions (4196), perch2_collections (1), perch2_comments (3599), perch2_comments_votes (0), perch2_content_index (413765), perch2_content_items (27873), perch2_content_locks (0), perch2_content_regions (72), perch2_events (9), perch2_events_categories (0), perch2_events_to_categories (0), perch2_mailchimp_campaigns (136), perch2_mailchimp_imports (1), perch2_mailchimp_lists (1), perch2_mailchimp_subscribers (356), perch2_mailchimp_subscriptions (356), perch2_mailchimp_webhooks (1), perch2_menu_items (12), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (6), perch2_page_templates (5), perch2_pages (63), perch2_resource_log (267309), perch2_resource_tags (4), perch2_resources (24455), perch2_resources_to_tags (8), perch2_settings (26), perch2_user_passwords (0), perch2_user_privileges (38), perch2_user_role_buckets (0), perch2_user_role_privileges (16), perch2_user_roles (2), perch2_users (3)
Users: 3
App runtimes:
<?php
$apps_list = array(
'perch_comments',
'perch_events',
'perch_mailchimp',
);
Scheduled tasks for perch_comments: delete_spam_comments (1440 mins)
Scheduled tasks for perch_events: update_category_counts (60 mins)
Scheduled tasks for perch_mailchimp: import_data (1 mins)
Editor plug-ins: ckeditor, markitup
H1: b433d7d8409f6a7ce2a7231b299a1d26
L1: ba2cd861f638cc6dccdd6741e3ef1e2c
F1: 3b606135b33e6a102526838f4152a807
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 0
content_collapseList: 1
lang: en-gb
update_2.8.32: done
latest_version:
perch_events_update: 1.8
headerScheme: light
perch_events_detail_url: /events/event.php?s={eventSlug}
perch_comments_akismet_key:
perch_comments_max_spam_days: 0
perch_mailchimp_api_key: 8cbf2fc9cd7a65c4d4ac05df18c843ca-us15
perch_mailchimp_campaign_url: /mailchimp/campaign/{campaignSlug}
dashboard: 0
hide_pwd_reset: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
perch_mailchimp_secret: e746e2b
update_runway_3.0.4: done
update_runway_2.8.34: done
on_sale_version:
update_runway_3.0.10: done
update_3.1.5: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: deyrich
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: AroundPtown2016
PERCH_DB_PREFIX: perch2_
PERCH_TZ: America/Chicago
PERCH_EMAIL_FROM: aroundprophetstown@gmail.com
PERCH_EMAIL_FROM_NAME: Dan Eyrich
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/jstahr99/public_html/aroundptown2016/perch
PERCH_CORE: /home/jstahr99/public_html/aroundptown2016/perch/core
PERCH_RESFILEPATH: /home/jstahr99/public_html/aroundptown2016/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_UNDO_BUFFER: 5
PERCH_DEBUG:
PERCH_YOUTUBE_API_KEY: AIzaSyDDumsF5lcbCluAcvlvro88TvEAaUh5Qb8
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_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/jstahr99/public_html/aroundptown2016/perch/templates
PERCH_TEMPLATE_FILTERS:
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_XHTML_MARKUP:
PERCH_RWD: 1
PERCH_HTML_ENTITIES:
PERCH_SSL:
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_CUSTOM_EDITOR_CONFIGS:
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: 5.4.45
Zend: 2.4.0
OS: Linux
SAPI: litespeed
Safe mode: not detected
MySQL client: 5.6.39
MySQL server: 5.6.39-cll-lve
Free disk space: 33.74 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, imagick, imap, inotify, intl, json, exif, mcrypt, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, soap, xmlreader, xmlrpc, xmlwriter, mhash, ionCube Loader, Zend Guard Loader
GD: Yes
ImageMagick: Yes
PHP max upload size: 128M
PHP max form post size: 64M
PHP memory limit: 256M
Total max uploadable file size: 64M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
LSPHP_ENABLE_USER_INI: on
PATH: /usr/local/bin:/usr/bin:/bin
TEMP: /tmp
TMP: /tmp
TMPDIR: /tmp
PWD: /
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3
HTTP_ACCEPT_ENCODING: gzip, deflate, br
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.9,es-US;q=0.8,es;q=0.7
HTTP_COOKIE: cmsa=1; _ga=GA1.2.1836965467.1559307621; _gid=GA1.2.48638314.1559307621; PHPSESSID=ukvusk9dcgkibtkhth2cgbq6c3
HTTP_HOST: aroundptown.com
HTTP_REFERER: https://aroundptown.com/perch/core/settings/diagnostics/
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_X_HTTPS: 1
UNIQUE_ID: XPE261AzF6S2VkhjZQJwJQAAAAE
SCRIPT_URL: /perch/core/settings/diagnostics/
SCRIPT_URI: https://aroundptown.com/perch/core/settings/diagnostics/
HTTPS: on
SSL_TLS_SNI: aroundptown.com
HTTP2: on
H2PUSH: on
H2_PUSH: on
H2_STREAM_ID: 1
H2_STREAM_TAG: 215-1
SERVER_SOFTWARE: Apache
SERVER_NAME: aroundptown.com
SERVER_ADDR: 107.180.97.208
SERVER_PORT: 443
REMOTE_ADDR: 73.168.136.5
DOCUMENT_ROOT: /home/jstahr99/public_html/aroundptown2016
REQUEST_SCHEME: https
CONTEXT_DOCUMENT_ROOT: /home/jstahr99/public_html/aroundptown2016
SERVER_ADMIN: webmaster@aroundptown.move.stahrfamilydesign.com
SCRIPT_FILENAME: /home/jstahr99/public_html/aroundptown2016/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 49799
SERVER_PROTOCOL: HTTP/2.0
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1559312107.6439
REQUEST_TIME: 1559312107

Display More

Any help would be greatly appreciated.

Posts by jstahr99

HTTP 500 error on one region

HTTP 500 error on one region