Thread tagged as: Problem, Error, Blog

Blog Problem - have an error, no idea how to fix it!

Hi guys,

My blog will not show up on the homepage but after a DEBUG I get this:

Debug Message
SELECT * FROM perch2_pages WHERE pagePath='/index.php' LIMIT 1
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/index.php' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000')
Using template: /templates/navigation/item.html
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/index.php' LIMIT 1
SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-001', '000')
Using template: /templates/navigation/item.html
SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2015-10-16 11:16:00' ) GROUP BY itemID ORDER BY sortval DESC LIMIT 0, 2
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbphysio.perch2_blog_index' doesn't exist
SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: /templates/blog/post_in_list_home.html
SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC

I'm not sure how to fix the invalid query?

Any ideas guys?

Chris McGuicken

Chris McGuicken 1 points

  • 6 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

Can we see your Diagnostics Report and get some info as to what you did before this happened? Did you upgrade, is it a new install?

I upgraded from 2.6.2 (I think) and am on the latest version of both Perch and the App.


Perch: 2.8.13 Production mode: Production (100) Installed apps: content (2.8.13), assets (2.8.13), categories (2.8.13), perch_blog (4.6), perch_forms (1.7), perch_gallery (2.8.2), 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_tags, perch2_categories, perch2_category_counts, perch2_category_sets, perch2_content_index, perch2_content_items, perch2_content_regions, perch2_forms, perch2_forms_responses, 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: 2 App runtimes: <?php include(PERCH_PATH.'/core/apps/content/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_forms/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_members/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_blog/runtime.php'); ?> Scheduled tasks for perch_blog: delete_spam_comments (1440 mins) Editor plug-ins: ckeditor, markitup H1: 55324a14d64520b1451a9365a132d287 L1: b9d955667d594ced5e88e154fd0c38a8 headerColour: #ffffff content_singlePageEdit: 1 helpURL: siteURL: / hideBranding: 1 content_collapseList: 1 lang: en-gb update_2.3.2: done latest_version: 2.8.8 headerScheme: light perch_blog_post_url: /blog/post.php?s={postSlug} perch_blog_slug_format: %Y-%m-%d-{postTitle} perch_blog_akismet_key: perch_blog_max_spam_days: 0 perch_gallery_bucket_mode: single perch_gallery_bucket: default dashboard: 0 content_hideNonEditableRegions: 1 perch_blog_comment_notify: 0 perch_gallery_basicUpload: 0 logoPath: /ucontrol/resources/1418137843_ucontrol.png perch_members_login_page: /login/login.php?r={returnURL} perch_blog_update: 5.0 update_2.5.1: done on_sale_version: 2.8.13 update_2.7.4: done hide_pwd_reset: 0 content_frontend_edit: 0 update_2.7.10: done update_2.8.13: done PERCH_DEVELOPMENT: 10 PERCH_STAGING: 50 PERCH_PRODUCTION: 100 PERCH_DB_USERNAME: usrphysio PERCH_DB_SERVER: PERCH_DB_DATABASE: dbphysio PERCH_DB_PREFIX: perch2_ PERCH_TZ: Europe/London PERCH_EMAIL_FROM: PERCH_EMAIL_FROM_NAME: Steven Legge PERCH_LOGINPATH: /ucontrol PERCH_PATH: /home/ftp_conet_customer_sites/ PERCH_CORE: /home/ftp_conet_customer_sites/ PERCH_RESFILEPATH: /home/ftp_conet_customer_sites/ 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/ftp_conet_customer_sites/ 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: PERCH_SESSION_TIMEOUT_MINS: 20 HOSTING SETTINGS PHP: 5.6.10 Zend: 2.6.0 OS: Linux SAPI: cgi-fcgi Safe mode: not detected MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ MySQL server: 5.1.56-log Extensions: Core, date, ereg, libxml, pcre, sqlite3, filter, mbstring, SPL, PDO, Reflection, pdo_sqlite, hash, session, cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dom, standard, ftp, gd, gettext, exif, iconv, imap, json, mcrypt, mysqlnd, mysqli, openssl, pcntl, pdo_mysql, posix, pspell, mysql, SimpleXML, soap, sockets, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib, imagick, mhash GD: Yes ImageMagick: Yes PHP max upload size: 64M PHP max form post size: 65M PHP memory limit: 90M Total max uploadable file size: 64M Resource folder writeable: Yes Session timeout: 24 minutes Native JSON: Yes Filter functions: Yes Transliteration functions: No PATH: /bin:/usr/bin:/sbin:/usr/sbin RAILS_ENV: production SCRIPT_NAME: /ucontrol/core/settings/diagnostics/index.php REQUEST_URI: /ucontrol/core/settings/diagnostics/?extended QUERY_STRING: extended REQUEST_METHOD: GET SERVER_PROTOCOL: HTTP/1.1 GATEWAY_INTERFACE: CGI/1.1 REMOTE_PORT: 65168 SCRIPT_FILENAME: /home/ftp_conet_customer_sites/ SERVER_ADMIN: DOCUMENT_ROOT: /home/ftp_conet_customer_sites/ REMOTE_ADDR: SERVER_PORT: 80 SERVER_ADDR: SERVER_NAME: SERVER_SOFTWARE: Apache HTTP_COOKIE: cmsa=1; _gat=1; _ga=GA1.3.1119187105.1443455152; PHPSESSID=%2CgoPZFYTiP6Cy5MM%2C5xE52 HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8 HTTP_ACCEPT_ENCODING: gzip, deflate, sdch HTTP_REFERER: HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36 HTTP_UPGRADE_INSECURE_REQUESTS: 1 HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 HTTP_CONNECTION: close HTTP_HOST: DH_USER: ftp_conet_customer_sites dsid: 25622732 SCRIPT_URI: SCRIPT_URL: /ucontrol/core/settings/diagnostics/ UNIQUE_ID: ViDfH0BaOdAAABlms14AAAAK FCGI_ROLE: RESPONDER PHP_SELF: /ucontrol/core/settings/diagnostics/index.php REQUEST_TIME_FLOAT: 1444994847.7777 REQUEST_TIME: 1444994847

Hi guys, I know I am being cheeky here but could someone reply soon as I have a client pestering me... sorry!

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you try forcing a blog update?



That's it Drew, thanks!