Forum
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 FOUND_ROWS() AS `count`
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?
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.
Diagnostics:
Hi guys, I know I am being cheeky here but could someone reply soon as I have a client pestering me... sorry!
Can you try forcing a blog update?
BOOM!
That's it Drew, thanks!