Forum
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:
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
Can you try running an blog update?
Just tried that and I end up on the perch/addons/apps/perch_blog/ page with no update message.
Are you the primary admin?
Yes, primary admin.
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.
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