Forum

Thread tagged as: Problem, Error, Blog

Unable to create blog post - Perch Blog Sorry, that post could not be updated

I receive the above error when trying to add a blog post. I've updated both Perch and the Blog app to the latest versions and have followed Drew's instructions in the following forum post:

https://forum.grabaperch.com/forum/08-12-2014-perch-blog-create-post-issue-sorry-that-post-could-not-be-updated

According to my debug info there is a table missing:

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='0c16216208f1be986ba2c9f949b4f866' LIMIT 1
UPDATE perch2_users SET userHash='8f22db7169e55aa6107ed0f70afcac6c' WHERE userID=1
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
SELECT * FROM perch2_blog_sections ORDER BY sectionTitle ASC
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'hispeed.perch2_blog_sections' doesn't exist
SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_blog_posts ORDER BY postDateTime DESC LIMIT 0, 15
SELECT FOUND_ROWS() AS `count`
Attempting app installation: perch_blog
SHOW TABLES LIKE "perch2_blog_posts"
SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
Setting alert: There are no posts yet. (notice)
Queries: 10
Memory: 4.1248

Diagnostics:

Perch: 2.8.7
Production mode: Production (100)
Installed apps: content (2.8.7), assets (2.8.7), categories (2.8.7), perch_blog (4.6), perch_forms (1.8.2)
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_tags, perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_forms, perch2_forms_responses, 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

    $apps_list = array(
        'perch_forms',
        'perch_blog',
    );

?>
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup
H1: 45fd627668d8daddd640aba30dc019f5
L1: 7122ce4c4abda59af06b562f1ea6022c
headerColour: #ffffff
content_singlePageEdit: 1
hideBranding: 1
content_collapseList: 1
lang: en-gb
latest_version: 2.8
headerScheme: light
siteURL: hispeed.co.uk
content_hideNonEditableRegions: 1
dashboard: 0
logoPath: /ace/resources/1346947860_ace.png
helpURL: ace-high.co.uk
perch_blog_post_url: /blog/post.php?s={postSlug}
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key:
update_2.7.5: done
on_sale_version: 2.8.7
update_2.8.6: done
perch_blog_update: 5.0
perch_blog_max_spam_days: 0
hide_pwd_reset: 0
content_frontend_edit: 0
perch_blog_comment_notify: 0
update_2.8.7: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: hispeed
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: hispeed
PERCH_DB_PREFIX: perch2_
PERCH_EMAIL_FROM: support@pixelpen.co.uk
PERCH_EMAIL_FROM_NAME: PixelPen Support
PERCH_LOGINPATH: /ace
PERCH_PATH: /Users/Toby/Sites/hispeed/ace
PERCH_CORE: /Users/Toby/Sites/hispeed/ace/core
PERCH_RESFILEPATH: /Users/Toby/Sites/hispeed/ace/resources
PERCH_RESPATH: /ace/resources
PERCH_HTML5: 1
PERCH_DEBUG: 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_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /Users/Toby/Sites/hispeed/ace/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_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
HOSTING SETTINGS

PHP: 5.3.29
Zend: 2.3.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: 5.5.42
MySQL server: 5.5.42
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, SPL, iconv, intl, json, ldap, mbstring, mysql, mysqli, session, PDO, pdo_sqlite, standard, posix, Reflection, Phar, SimpleXML, soap, sockets, SQLite, exif, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, apache2handler, imap, gettext, mcrypt, yaz, pgsql, pdo_pgsql, pdo_mysql
GD: Yes
ImageMagick: No
PHP max upload size: 32M
PHP max form post size: 32M
PHP memory limit: 128M
Total max uploadable file size: 32M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
HTTP_HOST: loc.hispeed:8888
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36
HTTP_REFERER: https://loc.hispeed:8888/ace/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8
HTTP_COOKIE: __utma=21147174.1625374710.1432635941.1432635941.1432635941.1; __utmc=21147174; __utmz=21147174.1432635941.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); wroteIt=wroteIt; PHPSESSID=4238e2d629638edecb3f439ab244e0b4; cmsa=1
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SOFTWARE: Apache
SERVER_NAME: loc.hispeed
SERVER_ADDR: ::1
SERVER_PORT: 8888
REMOTE_ADDR: ::1
DOCUMENT_ROOT: /Users/Toby/Sites/hispeed
SERVER_ADMIN: you@example.com
SCRIPT_FILENAME: /Users/Toby/Sites/hispeed/ace/core/settings/diagnostics/index.php
REMOTE_PORT: 52196
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /ace/core/settings/diagnostics/?extended
SCRIPT_NAME: /ace/core/settings/diagnostics/index.php
PHP_SELF: /ace/core/settings/diagnostics/index.php
REQUEST_TIME: 1432638130
argc: 1
Creative Monster

Creative Monster 0 points

  • 6 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you try running an blog update?

/perch/addons/apps/perch_blog/update/

Just tried that and I end up on the perch/addons/apps/perch_blog/ page with no update message.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you the primary admin?

Yes, primary admin.

Drew McLellan

Drew McLellan 2638 points
Perch Support

How many posts do you have?

There aren't any posts.

The client is having a redesign and now wants a blog but I noticed there was already the blog app installed, so before I started work I wanted to get everything updated.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok. Do you know which version of Blog it was previously?

The simplest thing may be to delete any perch2_blog tables from the DB and then it'll install fresh.

I think it was very old. Maybe 2.2.

I'll try deleting the tables now and doing a fresh install.

That seems to of worked.

I just checked the live site and it was version 3.0.1