Our Perch system became unavailable overnight

    No pages shows up on our site that were created in Perch. Thousands of pages were editable yesterday but none show up in the Pages tab. The data is seen in the database tables. I can also see the Navigation Groups and Assets but no pages.


    PERCH INFORMATION

    • Perch: 2.8.34
    • Production mode: Production (100)
    • Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_gallery (2.8.4), perch_comments (1.0.1)
    • DB driver: PDO
    • DB tables: AcesAndAviatorsWW1 (2230), AircrewDeaths3947 (124583), AircrewDeaths3947BU28Mar18 (124581), AlameinRAFMemorial (3167), AlliedAirForces (236703), AlliedLossesIncidents (82899), AlliedLossesIncidentsNew (84808), AlliedLossesIncidentsNewBU28Aug18 (84904), AlliedLossesIncidentsNewBU7Feb19 (84787), AlliedNonBritishAirForceGravesEuropeCWGC (19427), BattleofBritainRoll (2927), BomberCommand (74231), ConsolidateNames (429541), ConsolidateNamesNonAlpha (429541), DeutschesKreuzGoldDatabase (6395), FighterCommandLosses (15206), FighterCommandLossesbu (7603), GermanWW2Aces (2885), GliderCasualties (651), KrackerArchive (31054), KrackerArchiveBU5Aug18 (30853), KrackerArchiveBU7Feb18 (30767), LuftwaffeGravesCWGC (1945), LuftwaffePilotData (7303), LuftwaffeVictoriesByName (67017), LuftwaffeVictoriesByNameBU7Feb19 (67017), MaltaMemorial (2297), MurderedByAxis2 (448), OriginalSourceMaterial (19), OttawaMemorial (798), ParadieArchive (54773), ParadieArchiveBU10Aug18 (54814), ParadieArchiveBU7Feb19 (54777), PoWAlliedMaster (53), PolishAirForceFrance1940 (40), PolishHonourRoll_West (2287), RAAFLosses (11205), RAAFLossesB U29Jan18 (0), RCAFNotes (5550), RNFleetAirArm (4575), RNFleetAirArmBU20May18 (4569), RNFleetAirArmBU3Sep17 (4567), RunnymedeMemorialMay2017 (20383), SOELosses (12), SovietAcesDatabase (3172), TopScorers (9575), USAcesAndAviatorsWW2 (221), USAirVictoriesWW1 (1455), USMCSquadronsWW2 (167), hesk_attachments (1844), hesk_banned_emails (1), hesk_banned_ips (1), hesk_categories (1), hesk_kb_articles (141), hesk_kb_attachments (14), hesk_kb_categories (4), hesk_logins (30), hesk_mail (7), hesk_notes (304), hesk_online (0), hesk_pipe_loops (0), hesk_replies (7573), hesk_reply_drafts (0), hesk_reset_password (0), hesk_service_messages (0), hesk_std_replies (11), hesk_ticket_templates (0), hesk_tickets (3394), hesk_users (4), maritimequest (38177), perch2_categories (0), perch2_category_counts (0), perch2_category_sets (0), perch2_content_index (102256), perch2_content_items (47406), perch2_content_regions (23490), perch2_gallery_albums (0), perch2_gallery_image_versions (0), perch2_gallery_images (0), perch2_menu_items (10), perch2_navigation (173), perch2_navigation_pages (16628), perch2_page_templates (26), perch2_pages (3894), perch2_resource_log (10009), perch2_resource_tags (94), perch2_resources (40566), perch2_resources_to_tags (498), perch2_settings (43), perch2_user_passwords (3), perch2_user_privileges (33), perch2_user_role_privileges (11), perch2_user_roles (4), perch2_users (10), smp_ad (1), smp_answer (3), smp_cust (1), smp_quiz (1), smp_result (1)
    • Users: 10
    • PHPMailer: 5.2.21
    • App runtimes:
      PHP
      1. <?php include(PERCH_PATH.'/core/apps/content/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_comments/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_gallery/runtime.php');
      2. ?>
    • Editor plug-ins: tinymce, redactor, ckeditor, redactorORIG
    • H1: 6d2e5c503f10ab8cdb8d8d5cfe9da389
    • L1: 30e62d05c451dbc35ba141aa8669341b
    • F1: 6a33f95eca3667f9e0c39bf5ca2980fe
    • headerColour: #ffffff
    • content_singlePageEdit: 1
    • helpURL:
    • siteURL: /
    • hideBranding: 1
    • content_collapseList: 1
    • lang: en-gb
    • latest_version: 2.8.15
    • headerScheme: light
    • dashboard: 0
    • content_hideNonEditableRegions: 0
    • logoPath: /editorial/resources/1356354991_arbanner235Perch.png
    • on_sale_version:
    • update_2.4.2: done
    • content_frontend_edit: 1
    • update_2.4.3: done
    • update_2.4.4: done
    • update_2.4.5: done
    • update_2.4.9: done
    • perch_gallery_update: 2.8.4
    • update_2.5.1: done
    • update_2.5.2: done
    • update_2.5.3: done
    • update_2.5.4: done
    • update_2.6: done
    • update_2.6.3: done
    • update_2.6.5: done
    • update_2.6.6: done
    • update_2.7.2: done
    • update_2.7.10: done
    • update_2.8.2: done
    • update_2.8.6: done
    • update_2.8.17: done
    • update_2.8.18: done
    • update_2.8.23: done
    • update_2.8.25: done
    • update_2.8.29: done
    • update_2.8.30: done
    • update_2.8.31: done
    • update_2.8.34: done
    • update_3.1.3: done
    • PERCH_DEVELOPMENT: 10
    • PERCH_STAGING: 50
    • PERCH_PRODUCTION: 100
    • PERCH_DB_USERNAME: kelstef_arem
    • PERCH_DB_SERVER: localhost
    • PERCH_DB_DATABASE: kelstef_arem
    • PERCH_DB_PREFIX: perch2_
    • PERCH_EMAIL_FROM: oriorda@me.com
    • PERCH_EMAIL_FROM_NAME: Stefan Youngs
    • PERCH_LOGINPATH: /editorial
    • PERCH_PATH: /home4/kelstef/public_html/editorial
    • PERCH_CORE: /home4/kelstef/public_html/editorial/core
    • PERCH_RESFILEPATH: /home4/kelstef/public_html/editorial/resources
    • PERCH_RESPATH: /editorial/resources
    • PERCH_HTML5: 1
    • PERCH_CLEAN_RESOURCES:
    • 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_DEBUG:
    • PERCH_PREVIEW_ARG: preview
    • PERCH_TEMPLATE_PATH: /home4/kelstef/public_html/editorial/templates
    • PERCH_DEFAULT_DOC: index.php
    • PERCH_DEFAULT_EXT: .php
    • PERCH_PRODUCTION_MODE: 100
    • PERCH_RWD:
    • PERCH_HTML_ENTITIES:
    • PERCH_SSL:
    • PERCH_STRIPSLASHES:
    • PERCH_PROGRESSIVE_FLUSH: 1
    • PERCH_PARANOID:
    • PERCH_FORCE_SECURE_COOKIES:
    • PERCH_PASSWORD_MIN_LENGTH: 6
    • PERCH_MAX_FAILED_LOGINS: 10
    • PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
    • PERCH_VERIFY_UPLOADS:
    • PERCH_AUTH_PLUGIN:
    • PERCH_DB_CHARSET: utf8
    • PERCH_DB_PORT:
    • PERCH_DB_SOCKET:
    • PERCH_SESSION_TIMEOUT_MINS: 20


    HOSTING SETTINGS

    • PHP: 5.4.45
    • Zend: 2.4.0
    • OS: Linux
    • SAPI: cgi-fcgi
    • Safe mode: not detected
    • MySQL client: 5.6.41-84.1
    • MySQL server: 5.6.41-84.1
    • Free disk space: 187.47 GB
    • Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, gmp, SPL, iconv, session, intl, json, mbstring, mcrypt, mssql, mysql, mysqli, odbc, standard, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, Reflection, imap, SimpleXML, soap, sockets, exif, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, imagick, SourceGuardian, mhash, ionCube Loader, Zend Guard Loader
    • GD: Yes
    • ImageMagick: Yes
    • PHP max upload size: 64M
    • 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
    • CONTEXT_DOCUMENT_ROOT: /home4/kelstef/public_html
    • DOCUMENT_ROOT: /home4/kelstef/public_html
    • GATEWAY_INTERFACE: CGI/1.1
    • HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    • HTTP_ACCEPT_ENCODING: gzip, deflate
    • HTTP_ACCEPT_LANGUAGE: en-gb
    • HTTP_COOKIE: __utma=109100309.29636910.1548606824.1550717641.1550739648.3; __utmb=109100309.30.10.1550739648; __utmc=109100309; __utmz=109100309.1550739648.3.2.utmcsr=aircrewremembered.com|utmccn=(referral)|utmcmd=referral|utmcct=/current-site-status.html; PHPSESSID=f08d6165e10d0679ae5128a66133d98f; cmsa=1; __atuvc=22%7C8; __atuvs=5c6e79ebdcfa7fd0001; sc_is_visitor_unique=rx8374633.1550744782.839F334E9CBA4FEADF3A5E7CCB0F8731.4.3.3.3.3.2.2.2.2; __utmt=1; HESK445c9d98985d45f1d921d44eb81a38517496cf6e=b949e3e8828eb9642506d023bb1db8fc; __unam=911f0f0-1690d981afb-746b7f61-34; _ga=GA1.2.29636910.1548606824; __atssc=google%3B2%2Ctwitter%3B2
    • HTTP_DNT: 1
    • HTTP_HOST: aircrewremembered.com
    • HTTP_REFERER: http://aircrewremembered.com/e…ore/settings/diagnostics/
    • HTTP_UPGRADE_INSECURE_REQUESTS: 1
    • HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0.3 Safari/605.1.15
    • HTTP_X_FORWARDED_FOR: 86.153.63.86
    • HTTP_X_HTTP_PROTO: HTTP/1.1
    • PATH: /bin:/usr/bin
    • PHPRC: /opt/php54/lib
    • PHP_INI_SCAN_DIR: /opt/php54/bin/php-cgi/etc:/opt/php54/bin/php-cgi/etc/php.d:.
    • QUERY_STRING: extended
    • REDIRECT_STATUS: 200
    • REMOTE_ADDR: 86.153.63.86
    • REMOTE_PORT: 14732
    • REQUEST_METHOD: GET
    • REQUEST_SCHEME: http
    • REQUEST_URI: /editorial/core/settings/diagnostics/?extended
    • SCRIPT_FILENAME: /home4/kelstef/public_html/editorial/core/settings/diagnostics/index.php
    • SCRIPT_NAME: /editorial/core/settings/diagnostics/index.php
    • SERVER_ADDR: 192.254.224.43
    • SERVER_ADMIN: webmaster@aircrewremembered.com
    • SERVER_NAME: aircrewremembered.com
    • SERVER_PORT: 80
    • SERVER_PROTOCOL: HTTP/1.1
    • SERVER_SIGNATURE: <address>Apache Server at aircrewremembered.com Port 80</address>
    • SERVER_SOFTWARE: Apache
    • UNIQUE_ID: XG585pgYy7Oo@xJwhte6UwAAAC0
    • PHP_SELF: /editorial/core/settings/diagnostics/index.php
    • REQUEST_TIME_FLOAT: 1550744806.43
    • REQUEST_TIME: 1550744806
    • argc: 1

  • drewm

    Approved the thread.

    Drew... I think the problem is that our hosting service changed our rewrite instruction on our htaccess... which says to rewrite html as php. All our Perch pages are suffixed html as are our the templates. I am onto the hosting service right now... hopefully this fixes things. If not I'm off to make several prayers

    The hosting service says this is a Perch issue. I think this is a rewrite issue. Can you please tell me your recommended rewrite instructions to be added to htaccess so that pages created in Perch with the html suffix (with the php headers etc) will be handled correctly by Perch

    I really need your help here. Our entire Editorial System is offline. If I dupe a html file that no longer works and suffix the dupe with .php then it works except for the content (because the template generating the content is in html and I can't easily change the template to php). But no html pages produce anything at all. Everything worked yesterday and has done so for 4 years, and we made no changes. check our site http://aircrewremembered.com and select Obituaries from the menu... white screen. Show PAGE Source showes greyed out <?php include(str_replace('/', DIRECTORY_SEPARATOR, 'editorial/templates/pages/ListsPagesTemplateObituaries.html')); ?>

    Quote from stefanyoungs

    Show PAGE Source showes greyed out <?php include(str_replace('/', DIRECTORY_SEPARATOR, 'editorial/templates/pages/ListsPagesTemplateObituaries.html')); ?>

    If the page source is showing PHP tags, then the server is not correctly configured to parse that type of file as PHP.


    You should show that problem to your host and ask them what you need to do to get the file to be parsed as PHP

    I apologize for continuing with this. I need help.


    The page that produces the Page Source php <?php include(str_replace('/', DIRECTORY_SEPARATOR, 'editorial/templates/pages/ListsPagesTemplateObituaries.html')); ?> which you correctly say should not be shown is suffixed .html


    http://aircrewremembered.com/all-about-us.html


    I made a duplicate of this page and suffixed this with .php (the code is identical to that on the .html page <?php include(str_replace('/', DIRECTORY_SEPARATOR, 'editorial/templates/pages/AboutUsTemplate.html')); ?>


    http://aircrewremembered.com/all-about-us.php


    THIS page outputs correctly (except for the content which the AboutUsTemplate.html is not delivering, I imagine for the same reason)


    The point being HostGator's server IS correctly parsing the identical coding on the .php suffix page, Page Source shows no php commands as expected for the .php suffix page.


    Any further insights will be MUCH appreciated. If there are fees to get this resolved, we will provide, as our site is dead in the water.

    I got nowhere with HostGator.


    If we undertake the large manual task of converting all our Perch files to .php, and we convert our Master Pages and Content to .php will everything return to normal without any further work?


    Is it permissible to change the file extensions from .html to .php in the Contents and Pages folders direct on the server using my FTP program or must I create new versions inside Perch? I ask because we've had an unresolved problem for the past few years of not being able to create new Master Pages... they show up on the server but do not appear in the Master Pages listing. I think I might have created this problem by deleting a few Master Pages directly via FTP during a general server clean-up rather than by doing so through the Perch mechanism, before I realized what I was doing. We would really liked to correct that situation and get back to being able to create new Master Pages and I hoped periodic updates would accomplish this, but they didn't.

    Never a truer word. I'll contact another hosting service ASAP. THANKYOU for digging around... I appreciate it. I know dealing with a non-programmer can be a pain, but I've built a huge and impressive site using Perch which we're very proud of. We couldn't have done it without you.


    Thanks for finding that link... 5 hours on Chat with their support people today and nobody mentioned that page! I tried it and it didn't work. I read somewhere there's something they have to do in the config file for their server to allow this to work. My thinking is they did something to the config file overnight which nobody in support knows about.


    But if I did go the renaming route, can I change the .html extensions in the 'pages' and 'contents' folders using renaming in my FTP program?


    We originally went the .html route as we have thousands of users with zero computer knowledge and we thought it would be simpler for them if our files kept the .html names they had in our original non-Perch site, and I think I picked up the idea from the Perch forum. It worked perfectly for 4 years... until today

    Hopefully we can get a quick site transfer to a more competent hosting service. They will suck the site over to their servers and let us try things out before we commit. Usually this is via a private link as we will not have performed a Nameserver change at this time. Do I have to do anything in the Perch config file to make this all work during our testing phase?


    THANKS

    Drew... we are in serious trouble. The new hosting service shows we have exactly the same problem: php files are being parsed as flat html and hence nothing in Perch is being seen by users.


    Do you know of a competent consultant/developer familiar with php files using .html suffix with the appropriate .htaccess instruction. I need help urgently and we expect to pay.


    We made no changes before our CMS material vanished - material that has been working fine for 5 years - but we have the same problem on 2 different hosts.

  • What an amazing man! Ryan found and fixed the issue in 15 minutes that I had been struggling with for 6 days with our hosting 'service' staff and getting nowhere very slowly.


    Incredible stuff and testament to the quality of people using our favourite CMS Perch