Posts by Hoops78

Hoops78 · Monday, 10:36 am

I'd be interested if you find something that helps. I've found creating a variant or saving a product takes a couple of minutes and tried adding no-index, but didn't help.

Hoops78 · Oct 21st 2019

Hi andocobo

This sounds a little like the problem I had and was because I had removed postDateTime field from the template. Here's the thread incase its the same issue

Thread

Hoops78 · Sep 30th 2019

We've just launched our new site fullfatdesigns.co.uk and is the first time I've used Collections in Runway for the Portfolio section.

Hoops78 · Sep 19th 2019

Thanks Jordin

I will check this out!

Hoops78 · Sep 18th 2019

Hi Jordin

Thank you for the reply.

I'm not that clever to write a php script for this... plus there's only 6 entries, so doesn't warrant me doing additional work. I was just fishing for either a no or a quick solution

Hoops78 · Sep 18th 2019

Hi

I think I know the answer to this, but thought I would check.

A client is using Perch forms I have done for a questionnaire with around 30 questions (requiring long answers). Last week their email stopped working, so they've had to use the csv option. As there is so many columns and long answers the csv download, they've asked if the content can be re-submitted to send as an email, so they can print it.

I've got a feeling no... but said I would ask the question.

Regards

Wayne

Hoops78 · Sep 12th 2019

Good call Byron

This was the issue and fixed!

Thank you!

Hoops78 · Sep 12th 2019

Hi Byron

Thank you. I'm using this for post_feed.html

Code

<div class="col-sm-4 news-feed text-center">
<div class="news-feed-image">
<img src="<perch:blog id="image" type="image" width="500" height="350" crop="true" />" class="img-responsive" alt="<perch:blog id="postTitle" />" />
</div>
<h3><a href="<perch:blog id="postURL" />" rel="bookmark" class="entry-title"><perch:blog id="postTitle" /></a></h3>
<div class="hidden-xs hidden-sm">
<perch:blog id="excerpt" type="textarea" textile="true" chars="120" append="..."/>
<a href="<perch:blog id="postURL" />">Read more</a>
</div>
<div class="hidden-md hidden-lg">
<perch:blog id="excerpt" type="textarea" textile="true" chars="50" append="..."/>
<a href="<perch:blog id="postURL" />">Read more</a>
</div>
</div>

Display More

And this for post.html

Code

<article class="h-entry">
<h1><perch:blog id="postTitle" type="text" label="Title" required="true" size="xl autowidth" order="1" /></h1>
<perch:if exists="video">
<div class="embed-responsive embed-responsive-16by9">
<iframe class="embed-responsive-item" src="<perch:blog id="video" type="textarea" order="4" label="Youtube vid" size="xs" />" frameborder="0" allowfullscreen></iframe>
</div>
<perch:else />
<div class="blog-pic-wrapper">
<div class="blog-pic">
<img src="<perch:blog id="image" type="image" width="800" height="600" crop="true" label="Image" order="5" />" class="img-responsive" alt="<perch:blog id="postTitle" />" />
</div>
</div>
</perch:if>
<div class="description e-content" id="blog" >
<perch:blog id="postDescHTML" type="textarea" label="Post" order="2" editor="simplemde" markdown="true" size="xxl autowidth" imagewidth="500" imageclasses="img-responsive" required="true" />
<h2>Share article</h2>
<a href="<perch:sharing id="twitter" />" target="_blank"><i class="fab fa-twitter-square"></i></a>
<a href="<perch:sharing id="facebook" />" target="_blank"><i class="fab fa-facebook-square"></i></a>
<a href="<perch:sharing id="linkedin" />" target="_blank"><i class="fab fa-linkedin"></i></a>
</div>
</article>
<perch:blog id="excerpt" type="textarea" label="Excerpt" markdown="true" order="3" suppress="true" size="s" />
<perch:blog id="image" type="image" width="500" height="350" crop="true" suppress="true" />

Display More

This is the debug of the page when the posts show;

Code

Debug Message - Perch 3.1.5
[30] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
Using template: /templates/pages/attributes/seo.html
[5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item-bootstrap.html
[5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item-bootstrap.html
[8] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC
[3] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_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, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2019-09-12 10:25:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 3
[1] SELECT FOUND_ROWS() AS `count`
[3] Using template: /templates/blog/post_feed.html
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC

Display More

And I've re-saved the posts, so their not showing and here is the debug from the same page

Code

Debug Message - Perch 3.1.5
[30] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
Using template: /templates/pages/attributes/seo.html
[5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item-bootstrap.html
[5] SELECT * FROM perch3_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[5] Using template: /templates/navigation/item-bootstrap.html
[8] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/index.php' OR regionPage='*' ORDER BY regionPage DESC
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_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, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2019-09-12 10:26:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 3
[1] SELECT FOUND_ROWS() AS `count`
Using template: /templates/blog/post_feed.html

Display More

Hoops78 · Sep 12th 2019

Am I the only one experiencing this issue? Not sure how to debug... if anyones got any ideas it would be appreciated.

Hoops78 · Sep 11th 2019

Here is the debug message;

Code

Debug Message - Perch 3.1.5
[1]SELECT u.*, r.* FROM perch3_users u, perch3_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='b0b4cfcd87ad7d395fa622221b78c204' LIMIT 1
UPDATE perch3_users SET userHash='021b9b2c0a9240d0408b661bed7185d7' WHERE userID='1'
[30]SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
Adding: Pipit Sharing
[8]SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[0]SELECT COUNT(*) FROM perch3_blog_comments WHERE commentStatus='PENDING'
[1]SELECT * FROM perch3_blog_authors WHERE authorEmail='wayne@fullfatdesigns.co.uk' LIMIT 1
[1]SELECT * FROM perch3_blog_posts WHERE postID=1
[1]SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1]SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
[1]SELECT * FROM perch3_blogs WHERE blogID=1 LIMIT 1
[1]SELECT * FROM perch3_blog_sections WHERE blogID='1' ORDER BY sectionTitle ASC
Using template: /templates/blog/post.html
[1]SELECT * FROM perch3_resources WHERE resourceID='63' LIMIT 1
[1]SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='63' AND resourceKey='thumb'
[1]SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='63' AND resourceTargetWidth=800 AND resourceTargetHeight=600 AND resourceCrop=1 AND resourceDensity=1
[1]SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='63' AND resourceTargetWidth=500 AND resourceTargetHeight=350 AND resourceCrop=1 AND resourceDensity=1
Logging resources for perch_blog
DELETE FROM perch3_resource_log WHERE appID='perch_blog' AND itemFK='postID' AND itemRowID=1
INSERT IGNORE INTO perch3_resource_log(`appID`, `itemFK`, `itemRowID`, `resourceID`) VALUES('perch_blog','postID',1,63),('perch_blog','postID',1,64),('perch_blog','postID',1,69),('perch_blog','postID',1,70)
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Shortened...</p>', postTitle='Top 6 benefits ofExecutive Coaching', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Shortened....<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"63\",\"title\":\"AdobeStock 246829191 Preview\",\"_default\":\"\\/perch\\/resources\\/adobestock246829191preview.jpeg\",\"bucket\":\"default\",\"path\":\"adobestock246829191preview.jpeg\",\"size\":158158,\"w\":1000,\"h\":667,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"adobestock246829191preview-thumb@2x.jpeg\",\"size\":16547,\"mime\":\"image\\/jpeg\",\"assetID\":\"64\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"adobestock246829191preview-w800h600.jpeg\",\"size\":75698,\"mime\":\"\",\"assetID\":\"69\"},\"w500h350c1\":{\"w\":\"500\",\"h\":\"350\",\"target_w\":\"500\",\"target_h\":\"350\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"adobestock246829191preview-w500h350.jpeg\",\"size\":36550,\"mime\":\"\",\"assetID\":\"70\"}}}}' WHERE postID='1'
No ids to log.
UPDATE perch3_blog_posts SET postStatus='Published', postTemplate='post.html', postDescRaw='Shortened to allow posting to this forum under the 10,0000 limit.</p>\n<p>Shortened to allow posting to this forum under the 10,0000 limit.</p>', postTitle='Top 6 benefits ofExecutive Coaching', postDynamicFields='{\"excerpt\":{\"_flang\":\"markdown\",\"raw\":\"Shortened....<\\/p>\"},\"video\":{\"_flang\":\"plain\",\"raw\":\"\",\"processed\":\"\"},\"image\":{\"assetID\":\"63\",\"title\":\"AdobeStock 246829191 Preview\",\"_default\":\"\\/perch\\/resources\\/adobestock246829191preview.jpeg\",\"bucket\":\"default\",\"path\":\"adobestock246829191preview.jpeg\",\"size\":158158,\"w\":1000,\"h\":667,\"mime\":\"image\\/jpeg\",\"sizes\":{\"thumb\":{\"w\":\"150\",\"h\":\"100\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"adobestock246829191preview-thumb@2x.jpeg\",\"size\":16547,\"mime\":\"image\\/jpeg\",\"assetID\":\"64\"},\"w800h600c1\":{\"w\":\"800\",\"h\":\"600\",\"target_w\":\"800\",\"target_h\":\"600\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"adobestock246829191preview-w800h600.jpeg\",\"size\":75698,\"mime\":\"\",\"assetID\":\"69\"},\"w500h350c1\":{\"w\":\"500\",\"h\":\"350\",\"target_w\":\"500\",\"target_h\":\"350\",\"crop\":\"true\",\"density\":\"1\",\"path\":\"adobestock246829191preview-w500h350.jpeg\",\"size\":36550,\"mime\":\"\",\"assetID\":\"70\"}}}}', postDateTime='2019-09-11 08:46:55', postSlug='top-6-benefits-ofexecutive-coaching' WHERE postID='1'
No ids to log.
DELETE FROM perch3_blog_index WHERE itemKey='postID' AND itemID='1'
INSERT INTO perch3_blog_index (itemKey, itemID, indexKey, indexValue) VALUES ('postID',1,'excerpt','Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Curabitur blandit tempus port'),('postID',1,'video',''),('postID',1,'image','/perch/resources/adobestock246829191preview.jpeg'),('postID',1,'postID','1'),('postID',1,'blogID','1'),('postID',1,'postTitle','Top 6 benefits ofExecutive Coaching'),('postID',1,'postSlug','top-6-benefits-ofexecutive-coaching'),('postID',1,'postDateTime','2019-09-11 08:46:55'),('postID',1,'postDescRaw','Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Curabitur blandit tempus port'),('postID',1,'postDescHTML','<p>Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Curabitur blandit tempus p'),('postID',1,'postTags',''),('postID',1,'postStatus','Published'),('postID',1,'authorID','1'),('postID',1,'sectionID','1'),('postID',1,'postCommentCount','0'),('postID',1,'postImportID',''),('postID',1,'postLegacyURL',''),('postID',1,'postAllowComments','1'),('postID',1,'postTemplate','post.html'),('postID',1,'postMetaTemplate','post_meta.html'),('postID',1,'postIsPublished','0'),('postID',1,'itemID',''),('postID',1,'itemRowID',''),('postID',1,'postURL','/latest-news/top-6-benefits-ofexecutive-coaching'),('postID',1,'postURLFull','http://kwa/latest-news/top-6-benefits-ofexecutive-coaching'),('postID',1,'_id',1)
[1]OPTIMIZE TABLE perch3_blog_index
[nil]SELECT COUNT(*) AS qty, c.catID FROM perch3_blog_index i, perch3_categories c, perch3_blog_posts p WHERE i.indexValue=c.catPath AND i.indexKey='_category' AND i.itemKey='postID' AND i.itemID=p.postID AND p.postStatus='Published' AND p.postDateTime<='2019-09-11 08:46:00' GROUP BY i.indexValue, c.catID
DELETE FROM perch3_category_counts WHERE countType='blog.post'
[1]SELECT authorID, COUNT(*) AS qty FROM perch3_blog_posts WHERE postStatus='Published' AND postDateTime<='2019-09-11 08:46:00' GROUP BY authorID
UPDATE perch3_blog_authors SET authorPostCount=0
UPDATE perch3_blog_authors SET authorPostCount='2' WHERE authorID=1 LIMIT 1
[1]SELECT c.sectionID, COUNT(p.postID) AS qty FROM perch3_blog_sections c, perch3_blog_posts p WHERE c.sectionID=p.sectionID AND p.postStatus='Published' AND p.postDateTime<='2019-09-11 08:46:00' GROUP BY c.sectionID ORDER BY c.sectionTitle ASC
UPDATE perch3_blog_sections SET sectionPostCount=0
UPDATE perch3_blog_sections SET sectionPostCount='2' WHERE sectionID='1' LIMIT 1
Edit mode: edit
[1]SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[2]SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1]SELECT itemTitle FROM perch3_menu_items WHERE itemType='app' AND itemValue='perch_blog' LIMIT 1
[1]SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2]SELECT mi.*, p.privKey FROM perch3_menu_items mi LEFT JOIN perch3_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /addons/apps/perch_blog/modes/edit.post.php
[1]SELECT * FROM perch3_resources WHERE resourceID='63' LIMIT 1
Queries: 46
Memory: 4.6633

Display More

Hoops78 · Sep 11th 2019

Hi

I've had this happen before on another site, but they don't add posts regularly so the problem doesn't show.

I have posts feeding into the home page with this;

PHP

<?php
perch_blog_custom(array(
'count' => 3,
'template' => 'post_feed.html',
'sort' => 'postDateTime',
'sort-order' => 'DESC'
));
?>

And I've added 3 posts to start the site off but only the first one shows. I then tried re-saving them all and none showed, re-saved them again and one shows. I've checked they are all set to published, but I can't seem to get all three to show. Plus I know from the previous site, when you get them all showing, if you edit a post all three can disappear. So I'm not sure whats happening?

I have a debug when saving, but couldn't add it due to the 10,000 character limit. I'll add it in the reply when the post is approved.

and my diagnostics are;

PHP

Summary information
Perch: 3.1.5, PHP: 7.2.21, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $, with PDO
Server OS: Darwin, cgi-fcgi
Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_blog (5.6.1), pipit_sharing (2.0.2)
App runtimes: <?php $apps_list = [ 'perch_blog', 'pipit_sharing', ];
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/hoops78/Documents/KWA/root/perch
PERCH_CORE: /Users/hoops78/Documents/KWA/root/perch/core
PERCH_RESFILEPATH: /Users/hoops78/Documents/KWA/root/perch/resources
Image manipulation: GD
PHP limits: Max upload 32M, Max POST 8M, Memory: 128M, Total max file upload: 8M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
REQUEST_URI: /perch/core/settings/diagnostics/
DOCUMENT_ROOT: /Users/hoops78/Documents/KWA/root
HTTP_HOST: kwa

Display More

Weirdly, re-saving this time to get a debug on save has made all three show, but I know re-saving one will make them all disappear. I can't really tell the client to keep re-saving all the posts until they all appear, so any help would be appreciated.

Kind Regards

Wayne

Hoops78 · May 13th 2019

Found how to do the blog updater

Code

perch/addons/apps/perch_blog/update/

fixed it

Hoops78 · May 12th 2019

Is there anything else I can try? Or something I've missed? I could do with fixing this for tomorrow if possible.

Regards

Wayne

Hoops78 · May 9th 2019

Is that part of the blog update? I saw the message about posts being updated. Or is it something else?

Hoops78 · May 9th 2019

it says;

Code

Debug Message - Perch 3.1.5
[1] 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='a1a134dcc517e7bbcaccbed8d1da4333' LIMIT 1
UPDATE perch2_users SET userHash='e4b9e8bdba8bacc3f8fc075bab29869f' WHERE userID='1'
[35] SELECT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[11] SELECT itemValue FROM perch2_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch2_blog_comments WHERE commentStatus='PENDING'
[1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC
[1] SELECT * FROM perch2_blogs ORDER BY blogTitle ASC LIMIT 1
[2] SELECT * FROM perch2_categories c, perch2_category_sets s WHERE c.setID=s.setID AND s.setSlug='blog' ORDER BY catTreePosition ASC
[1] SELECT * FROM perch2_blog_sections WHERE blogID=1 ORDER BY sectionTitle ASC
SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_blog_posts WHERE blogID=1 ORDER BY postDateTime DESC LIMIT 0, 15
Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blogID' in 'where clause'
[1] SELECT FOUND_ROWS() AS count
Attempting app installation: perch_blog
[1] SHOW TABLES LIKE "perch2_blog_posts"
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 0, 1
[6] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=1 ORDER BY mi.itemOrder ASC
[1] SELECT itemTitle FROM perch2_menu_items WHERE itemType='app' AND itemValue='perch_blog' LIMIT 1
[1] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=0 ORDER BY itemOrder ASC LIMIT 1, 10
[2] SELECT mi.*, p.privKey FROM perch2_menu_items mi LEFT JOIN perch2_user_privileges p ON mi.privID=p.privID WHERE mi.itemActive=1 AND mi.parentID=2 ORDER BY mi.itemOrder ASC
File: /addons/apps/perch_blog/modes/list.post.php
Queries: 17
Memory: 2.7873

Display More

I'm guessing this is the problem...

Code

Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'blogID' in 'where clause'

What should I do to fix this?

Hoops78 · May 9th 2019

Hi

Any suggestions about this? as I'm hoping to push this live tomorrow.

Regards

Wayne

Hoops78 · May 7th 2019

Hi

I've updated a site (v2.8.34 with blog 4.6 (I think)) to the latest (diagnostics below).

I updated the core first, then blog and the updating posts message ran and completed. I've just realised when going to the blog app and listing posts, its empty. The posts are on the site so I hadn't noticed earlier. I can't be 100% which version of blog I updated from, but it was higher than 4.5 as I don't need to do any extra work to update.

Would a force update help?

Regards

Wayne

PHP

Perch: 3.1.5, PHP: 7.2.17, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $, with PDO
Server OS: Linux, cgi-fcgi
Installed apps: content (3.1.5), assets (3.1.5), categories (3.1.5), perch_blog (5.6.1)
App runtimes: <?php $apps_list = array( 'perch_blog', );
PERCH_LOGINPATH: /perch
PERCH_PATH: /home/fullfatwebsite/public_html/beautyroom/perch
PERCH_CORE: /home/fullfatwebsite/public_html/beautyroom/perch/core
PERCH_RESFILEPATH: /home/fullfatwebsite/public_html/beautyroom/perch/resources
Image manipulation: GD
PHP limits: Max upload 25M, Max POST 128M, Memory: 256M, Total max file upload: 25M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
DOCUMENT_ROOT: /home/fullfatwebsite/public_html/beautyroom
HTTP_HOST: beautyroom.fullfatwebsitedesign.co.uk
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

Display More

Hoops78 · Apr 15th 2019

The template looks OK and as I'm working on a Perch site at the moment I quickly used your template as a test and the phone number link worked for me.

Can you post your source code from a browser of the area to see what's happening?

Hoops78 · Apr 14th 2019

Hi Kim

Does the region for TollFreeNumber in Perch have any spaces in the phone number?

I do a similar thing to you, but have 2 regions (one for the <a> tag and one for the number that shows on the site), as I like to have spaces in the phone number on display, but need it without for the link.

Hoops78 · Mar 4th 2019

Thanks. I'd missed the notifications settings and now turned on the email notifications

Posts by Hoops78

Shop - Processing time for creating or updating products

Blog posts not showing up after being created or edited

New website for our company

Info from form csv back to email

Info from form csv back to email

Info from form csv back to email

Not all blog posts are showing

Not all blog posts are showing

Not all blog posts are showing

Not all blog posts are showing

Not all blog posts are showing

Blog post list empty after update

Blog post list empty after update

Blog post list empty after update

Blog post list empty after update

Blog post list empty after update

Blog post list empty after update

clickable phone number

clickable phone number

Updating mySQL from5.5 to 5.7