Forum

Thread tagged as: Problem, Error, Blog

Blog Posts Disappearing

Hi guys,

I have a client whos blog posts are dissapearing at random. They seem to appear for a while, then remove themselves altogether. I am concerned this is a SQL issue or Perch talking to my database?

My Perch is quite out of date - should I try updating it first?

Diagnostics below

Perch: 2.6.3
Production mode: Production (100)
Installed apps: content (2.6.3), assets (2.6.3), categories (2.6.3), perch_blog (4.1), perch_forms (1.5.1), perch_gallery (2.8), perch_members (1.0.3)
DB driver: PDO
DB tables: perch2_blog_authors, perch2_blog_categories, perch2_blog_comments, perch2_blog_posts, perch2_blog_posts_to_categories, perch2_blog_posts_to_tags, perch2_blog_sections, perch2_blog_tags, perch2_categories, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_forms, perch2_forms_responses, perch2_gallery_albums, perch2_gallery_image_versions, perch2_gallery_images, perch2_members, perch2_members_forms, perch2_members_member_tags, perch2_members_sessions, perch2_members_tags, perch2_navigation, perch2_navigation_pages, perch2_page_templates, perch2_pages, perch2_resource_log, perch2_resource_tags, perch2_resources, perch2_resources_to_tags, perch2_settings, perch2_user_privileges, perch2_user_role_privileges, perch2_user_roles, perch2_users
Users: 3
App runtimes:
<?php
    include(PERCH_PATH.'/core/apps/content/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_blog/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_gallery/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_forms/runtime.php');
    include(PERCH_PATH.'/addons/apps/perch_members/runtime.php');
?>
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup, ckeditor
H1: 338f71cf6b5569a28f5a95d8d41dc3c7
L1: 6be008c8adab3e53c865aad517c96dde
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.2.9: done
latest_version: 2.8.15
headerScheme: light
dashboard: 0
content_hideNonEditableRegions: 0
perch_blog_post_url: /blog/post.php?s={postSlug}
perch_blog_update: 4.0
perch_gallery_update: 2.7
update_2.3: done
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
perch_gallery_bucket_mode: single
perch_gallery_bucket: default
perch_members_login_page: /members/index.php?r={returnURL}
perch_blog_comment_notify: 0
perch_gallery_basicUpload: 0
logoPath: /ucontrol/resources/bp-logo.png
update_2.3.2: done
on_sale_version: 3.0.2
update_2.4.2: done
content_frontend_edit: 0
update_2.6.3: done
perch_blog_max_spam_days: 0
hide_pwd_reset: 0
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: forever_usr
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: forever_website
PERCH_DB_PREFIX: perch2_
PERCH_TZ: Europe/London
PERCH_EMAIL_FROM: steven@designbyconet.com
PERCH_EMAIL_FROM_NAME: Steven Legge
PERCH_LOGINPATH: /ucontrol
PERCH_PATH: /home/forever/public_html/ucontrol
PERCH_CORE: /home/forever/public_html/ucontrol/core
PERCH_RESFILEPATH: /home/forever/public_html/ucontrol/resources
PERCH_RESPATH: /ucontrol/resources
PERCH_HTML5: 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_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/forever/public_html/ucontrol/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
HOSTING SETTINGS

PHP: 5.6.30
Zend: 2.6.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.6.35
Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, imap, json, exif, mcrypt, mysqlnd, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, SimpleXML, soap, sockets, sqlite3, tidy, tokenizer, xml, wddx, xmlreader, xmlwriter, xsl, zip, mhash, ionCube Loader, Zend Guard Loader, Zend OPcache
GD: Yes
ImageMagick: No
PHP max upload size: 200M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 8M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
TZ: Europe/London
REDIRECT_UNIQUE_ID: WP4MEwvE0RmXED5082d79gAAABM
REDIRECT_HANDLER: application/x-httpd-ea-php56
REDIRECT_STATUS: 200
UNIQUE_ID: WP4MEwvE0RmXED5082d79gAAABM
HTTP_HOST: 4everphotos.net
HTTP_CONNECTION: keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER: https://4everphotos.net/ucontrol/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8
HTTP_COOKIE: _ga=GA1.2.1718515611.1489681937; __utma=63478890.1718515611.1489681937.1490349918.1491810767.4; __utmz=63478890.1489681937.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); PHPSESSID=imcd7r2p4rjhk47qtcniutcq20; cmsa=1
PATH: /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
SERVER_SOFTWARE: Apache
SERVER_NAME: 4everphotos.net
SERVER_ADDR: 87.117.225.86
SERVER_PORT: 80
REMOTE_ADDR: 86.188.215.34
DOCUMENT_ROOT: /home/forever/public_html
REQUEST_SCHEME: http
CONTEXT_PREFIX: /cgi-sys
CONTEXT_DOCUMENT_ROOT: /usr/local/cpanel/cgi-sys/
SERVER_ADMIN: webmaster@4everphotos.net
SCRIPT_FILENAME: /home/forever/public_html/ucontrol/core/settings/diagnostics/index.php
REMOTE_PORT: 57590
REDIRECT_URL: /ucontrol/core/settings/diagnostics/index.php
REDIRECT_QUERY_STRING: extended
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /ucontrol/core/settings/diagnostics/?extended
SCRIPT_NAME: /ucontrol/core/settings/diagnostics/index.php
ORIG_SCRIPT_FILENAME: /usr/local/cpanel/cgi-sys/ea-php56
ORIG_PATH_INFO: /ucontrol/core/settings/diagnostics/index.php
ORIG_PATH_TRANSLATED: /home/forever/public_html/ucontrol/core/settings/diagnostics/index.php
ORIG_SCRIPT_NAME: /cgi-sys/ea-php56
PHP_SELF: /ucontrol/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1493044243.59
REQUEST_TIME: 1493044243
Chris McGuicken

Chris McGuicken 1 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

I'd recommend updating, yes.

I will obviously make a backup of the site and database but is there anything else I should be wary of upgrading so many versions?

I would update the site on local dev version first.