Posts by aulda

aulda · Aug 26th 2022

Hi,

My site is still running Perch, upgraded to 3.2. I use the events addon which is currently at version 1.9.5. From the Perch addons page I can't download events 1.9.6. Is there a way of updating the addon as it is being flagged in diagnostics as being out of date.

My login to your site doesn't give me access to the Perch Runway addons page as I don't currently have any Perch Runway subs.

Thanks

Andrew

aulda · May 1st 2022

Quote from Clive Walker

Yes, what a shame.

Does this mean that Perch is on its way out?

aulda · May 1st 2022

Hi George,

I have one Perch site and need to decide what to do with it now that you are no longer going to be supporting Perch. I haven't quite understood your pricing model. Currently if I click on the upgrade link it quotes £129 + vat to upgrade from perch to perch runway. It doesn't say anything about a subscription model. Is the subscription model not yet in your online shop?

Also, what are the risks of me continuing to run Perch. How long before it becomes a security issue or is incompatible with php or something like that? And how long will the Perch to Perch runway upgrade path and tools be supported.

Thanks

Andrew

aulda · Jan 28th 2021

This is exciting news. I am a very basic Perch user with just three sites under my belt. However, I have always been so supported by drewm and this community. Good luck, Drew and rachelandrew and thank you for Perch!

Really looking forward to seeing what comes with George G and the new team.

aulda · Oct 26th 2019

Quote from drewm

Yes, pretty soon. We're working on getting that ready.

Hi Drew,

I have read this thread with interest and fully understand the need for a new pricing model. Any update on what the pricing might look like or how soon we should expect Perch 4?

Thanks

Andrew

aulda · Feb 6th 2019

Quote from JonathanHazelwood

Read more about "allowed content" the CKEditor Docs at

https://ckeditor.com/docs/cked…tent_rules.html#debugging

Thanks. i have messed around with your code suggestion with no joy but I will take your and drew's advice and delve into CHEditor Docs and forum to get this one sorted.

aulda · Feb 5th 2019

Quote from drewm

That might be a good question to ask in the CKEditor forums.

True, but I just thought someone here might have had a similar experience and worked out a way around it. I have previously found folk in this forum very helpful.

I tried using the tinymce editor but couldn't actually get it to work...I noticed it was a Perch 2 addon so assumed it doesn't work in Perch 3...is that correct?

aulda · Feb 5th 2019

That would be accurate, though as we are loading content very actively for the next week, could you leave this thread open for a couple of days just in case the glitch re-occurs and I can capture some definitive error message?

Thanks

aulda · Feb 5th 2019

I currently have the ckeditor installed and working well for the most part on my 'textarea' regions.

As an editor, it gives you the ability to put a table in to the text area...in a similar way to the text editor used by this forum.

I can then go into the source within the textarea and add a class to the table to style it.

Saving it from this source view results in the table appearing on the page styled correctly. However, if I go back into the page to edit it, the text editor overrides the previous styling, removing the class from the <table> and if I save again the styling disappears from the page.

Is there a way of getting the ckeditor to retain classes that you add in the source

or

is there a better editor to use that would do this?

Thanks

aulda · Feb 5th 2019

No errors in the browser console.

I deleted the blank assets and reloaded them. Then re-added them to the pages. Obviously that all worked fine.

The problem hasn't re-occurred today.

aulda · Feb 2nd 2019

Here is the debug from the page itself.

Code

Debug Message - Perch 3.1.2
[40] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT * FROM perch3_pages WHERE pagePath='/accommodation/index.php' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[9] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/accommodation/index.php' OR regionPage='*' ORDER BY regionPage DESC
[6] 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='/accommodation/index.php' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/item.html
[6] 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='/accommodation/index.php' LIMIT 1
[2] SELECT pageID FROM perch3_pages WHERE pageTreePosition IN ('000-006-002', '000-006', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/dropdownnav.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='adverts' LIMIT 1
[78] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=4 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[1] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=4 AND p.pagePath='/accommodation/index.php' LIMIT 1
[1] SELECT pageID FROM perch3_navigation_pages WHERE groupID=4 AND pageTreePosition IN ('000-001', '000') ORDER BY pageTreePosition DESC
[15] Using template: /templates/navigation/item.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='footer-navigation' LIMIT 1
[5] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 AND np.pageDepth >=0 AND np.pageDepth<=1 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/accommodation/index.php' LIMIT 1
[5] Using template: /templates/navigation/footernav.html
[2] 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-02-02 17:28:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 2
[1] SELECT FOUND_ROWS() AS `count`
[2] Using template: /templates/blog/post_exerpt_in_list.html
[1] SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1] SELECT * FROM perch3_blogs ORDER BY blogTitle ASC

Display More

aulda · Feb 2nd 2019

We have just started adding the main content to a new website I build using perch and I have just got some users going adding some image files and sub pages to a directory part of the site. Things were going fine yesterday but then I notice today that some of the images uploaded into the assets and used on the site have now disappeared. They are still listed in the assets but not visible as images on the pages where they are used. You can still download the original files so the assets still exist. Any clues why this might have happened?

Here is a screenshot of the assets page on the CMS.

The CMS debug below seems free of errors:

Code

Debug Message - Perch 3.1.2
[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='c2a30879c13207f5e7093204850aba89' LIMIT 1
UPDATE perch3_users SET userHash='8a9eea7877b381d8a066444bb3eaa16e' WHERE userID='1'
[40] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[12] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[3] SELECT DISTINCT resourceBucket FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !=""
[30] SELECT SQL_CALC_FOUND_ROWS DISTINCT r1.* FROM perch3_resources r1 WHERE r1.resourceKey='orig' AND r1.resourceAWOL=0 AND r1.resourceBucket IN ('Adverts', 'Main-Images', 'admin', 'default') ORDER BY r1.resourceUpdated DESC, r1.resourceID DESC LIMIT 0, 30
[71] SELECT FOUND_ROWS() AS `count`
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=380 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=376 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=371 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=368 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=364 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=360 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=354 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=350 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=347 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=346 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=343 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=335 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=334 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=333 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=329 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=327 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=319 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=311 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=303 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=295 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=287 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=279 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=271 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=263 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=255 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=247 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=239 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=231 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=223 AND resourceKey='thumb' AND resourceAWOL!=1 LIMIT 1
[1] SELECT resourceFile AS thumb, resourceWidth AS thumbWidth, resourceHeight AS thumbHeight, resourceDensity AS thumbDensity FROM perch3_resources WHERE resourceParentID=215 AND resourceKey='thumb' AND resourceAWOL!=1 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 0, 1
[7] 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='assets' 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: /core/apps/assets/modes/list.post.php
[5] SELECT DISTINCT resourceType FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !="" ORDER BY resourceType ASC
[3] SELECT DISTINCT resourceBucket FROM perch3_resources WHERE resourceAWOL=0 AND resourceType !=""
[nil] SELECT t.tagTitle, t.tagSlug, t.tagCount FROM perch3_resource_tags t WHERE tagCount > 0 GROUP BY t.tagID ORDER BY t.tagCount DESC LIMIT 40
Queries: 46
Memory: 2.5961

Display More

And so does the debug on a page where the asset should be appearing.

aulda · Feb 2nd 2019

Quote from granttransition

Are you referring to the Events app or an Events collection?

The events app.

aulda · Feb 2nd 2019

Quote from peteperch4

Recently I've been getting messages from clients asking about being able to create recurring events so that they don't have to enter events which happen each week twice or sometimes 4 times having multiple instances of the same event with just a different date. Would this be something that might be looked at in future?

I have the same requirement from my users. Hopefully someone might help develop this!

Posts by aulda

New sign on Addons Page for New Version release!

Perch has a new home!

Pricing Notification. We hope you love Perch as much as we do..

Perch has a new home!

Is support still a thing?

Styling a table using an editor

Styling a table using an editor

Disappearing assets

Styling a table using an editor

Disappearing assets

Disappearing assets

Disappearing assets

Repeating events

Repeating events