Posts by Shane Lenzen

Shane Lenzen · Nov 23rd 2021

I tried to send a client today to grabaperch.com so they could purchase their own license when I noticed the expired cert. Not a good look. Expired since Thurs at least? Wtf.

Shane Lenzen · Sep 11th 2019

Bump? If anyone knows how to accomplish this I would greatly appreciate it! Also, sorry if I put this under the wrong topic...probably should have gone in Site Building Questions.

Shane Lenzen · Sep 4th 2019

I'm trying to filter a collection using multiple values that do NOT equal an item ID. First I tried this:

Code

perch_collection('Cocktails',[
'template'=>'cocktails/_list_item.html',
'sort' => '_order',
'sort-order' => 'asc',
'filter' => [
[
'filter' => '_id',
'match' => 'neq',
'value' => $featured_cocktails[0]['feat_cocktail'][0],
],
[
'filter' => '_id',
'match' => 'neq',
'value' => $featured_cocktails[0]['visitor_ctr_cocktail'][0],
]
],
'match'=>'and',
'count'=>4,
'paginate'=>true,
]);

Display More

I then realized that I'm supposed to use match type "in" with comma separated values. The problem is I need the reverse of that output. Basically, I need the reverse of this:

Code

perch_collection('Cocktails',[
'template'=>'cocktails/_list_item.html',
'sort' => '_order',
'sort-order' => 'asc',
'filter' => [
[
'filter' => '_id',
'match' => 'in',
'value' => $featured_cocktails[0]['feat_cocktail'][0].','.$featured_cocktails[0]['visitor_ctr_cocktail'][0],
],
],
'match'=>'and',
'count'=>4,
'paginate'=>true,
]);

Display More

Do I need to use a callback function? If so, will it work with paging, and how can I bring the IDs into the function?

Shane Lenzen · Apr 17th 2019

After scouring the forums, I've come to realize that this has been an issue with the Members app for years. Basically the image is uploaded and saved, but will not show in the admin area. You can still call it in the frontend using <?php echo perch_member_get('logo')['_default']; ?>

http://forum.grabaperch.com/fo…mage-not-showing-in-admin

http://forum.grabaperch.com/fo…bers-app-upload-fileimage

http://forum.grabaperch.com/fo…images-in-the-members-app

Shane Lenzen · Apr 4th 2019

Quote from ryan

Have you tried turning on debug, and checking the logs for any errors?

Do you mean other than what I showed in my first post?

Shane Lenzen · Apr 2nd 2019

Any ideas? I promised this functionality to my client knowing that I'd done it before with Perch...

Shane Lenzen · Mar 29th 2019

Drew, just to be sure I installed another fresh copy of Runway w/ Members app, loaded that member.html file, tried to save an image and got the same thing. Do you think this could be some kind of incompatibility between Runway and Members? What do you need from me to get this resolved?

Shane Lenzen · Mar 29th 2019

Nothing other than Runway/Member app versions. It's been a couple of years.

Shane Lenzen · Mar 28th 2019

FYI I also tried adding closing slashes in member.html. No dice. This was a fresh install, I set up Runway, added the Members app and this was the first thing I tried to do. I was attempting to whip together a quick demo for a client but now I've been waiting on this for 3 days. I've added images to members before and never had problems, so I wonder if this may be an incompatibility between the members app and latest version of Runway? A resolution would be very much appreciated!

Shane Lenzen · Mar 28th 2019

No, I've tried adding and saving multiple times, different images, logging out and back in, reloading cache.

Shane Lenzen · Mar 28th 2019

I add the image, click save, the edit page reloads and I get the "saved successfully" green banner, but the image field is reset as if I hadn't added and saved the image.

Shane Lenzen · Mar 27th 2019

Still banging my head against the wall on this one. The image path looks right in the debug log. Any ideas?

Edit: I would also like to protest my "Beginner" badge on this forum. 😂

Shane Lenzen · Mar 26th 2019

I have a fresh install of Runway 3.1.4 with Members 1.6.4. Here's my member.html:

Code

<perch:members order="1" type="image" id="logo" label="Logo" width="800" bucket="members">
<perch:members order="2" type="text" id="name" label="Name" listing="true" />

When I upload the image, everything works like it should (asset is uploaded and shows on edit page) until I save, then the image disappears.

Here's debug when I try to save the image:

Code

Debug Message - Perch Runway 3.1.4
[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='87894b21e54efd303ad2a9edb6232220' LIMIT 1
UPDATE perch3_users SET userHash='f09ff731c40a04eea9bc84309c72b43d' WHERE userID='1'
[14] SELECT settingID, settingValue, userID FROM perch3_settings WHERE userID=1 OR userID=0 ORDER BY userID ASC
[7] SELECT itemValue FROM perch3_menu_items WHERE itemType='app'
[0] SELECT COUNT(*) FROM perch3_members WHERE memberStatus='pending'
[1] SELECT * FROM perch3_members WHERE memberID=1 LIMIT 1
Using template: /templates/members/member.html
[1] SELECT * FROM perch3_resources WHERE resourceID='3' LIMIT 1
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='3' AND resourceKey='thumb'
[1] SELECT * FROM perch3_resources WHERE resourceAWOL=0 AND resourceParentID='3' AND resourceTargetWidth=800 AND resourceTargetHeight=0 AND resourceCrop=0 AND resourceDensity=1
Logging resources for perch_members
DELETE FROM perch3_resource_log WHERE appID='perch_members' AND itemFK='memberID' AND itemRowID=1
INSERT IGNORE INTO perch3_resource_log(`appID`, `itemFK`, `itemRowID`, `resourceID`) VALUES('perch_members','memberID',1,3),('perch_members','memberID',1,4),('perch_members','memberID',1,5)
UPDATE perch3_members SET memberEmail='school1@test.test', memberStatus='active', memberCreated='2019-03-26', memberProperties='{\"logo\":{\"assetID\":\"3\",\"title\":\"School demo 1\",\"_default\":\"\\/bp-admin\\/resources\\/members\\/schooldemo1.png\",\"bucket\":\"members\",\"path\":\"schooldemo1.png\",\"size\":356558,\"w\":900,\"h\":916,\"mime\":\"image\\/png\",\"sizes\":{\"thumb\":{\"w\":\"147\",\"h\":\"150\",\"target_w\":150,\"target_h\":150,\"density\":2,\"path\":\"schooldemo1-thumb@2x.png\",\"size\":93264,\"mime\":\"image\\/png\",\"assetID\":\"4\"},\"w800hc0\":{\"w\":\"800\",\"h\":\"814\",\"target_w\":\"800\",\"target_h\":false,\"crop\":false,\"density\":\"1\",\"path\":\"schooldemo1-w800.png\",\"size\":353704,\"mime\":\"\",\"assetID\":\"5\"}}},\"name\":\"Demo School 1\"}' WHERE memberID='1'
No ids to log.
DELETE FROM perch3_members_member_tags WHERE memberID='1' AND tagID NOT IN ('1')
[1] SELECT t.*, mt.tagExpires FROM perch3_members_member_tags mt, perch3_members_tags t WHERE mt.tagID=t.tagID AND mt.memberID=1 ORDER BY t.tag ASC
[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_members' 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_members/modes/members.edit.post.php
Queries: 23
Memory: 4.9362

Display More

Diagnostics:

PHP

Health check
Perch Runway is up to date
PHP 5.6.14-1+deb.sury.org~trusty+1 is up to date
MySQL 5.5.46-0ubuntu0.14.04.2 is up to date
Image processing available
Summary information
Perch Runway: 3.1.4, PHP: 5.6.14-1+deb.sury.org~trusty+1, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (3.1.4), assets (3.1.4), categories (3.1.4), perch_members (1.6.4)
App runtimes: <?php $apps_list = [ 'perch_members', ];
PERCH_LOGINPATH: /bp-admin
PERCH_PATH: /var/www/public/bedrockpartners.localdev/bp-admin
PERCH_CORE: /var/www/public/bedrockpartners.localdev/bp-admin/core
PERCH_RESFILEPATH: /var/www/public/bedrockpartners.localdev/bp-admin/resources
Image manipulation: GD Imagick
PHP limits: Max upload 100M, Max POST 100M, Memory: 128M, Total max file upload: 100M
F1: 3b606135b33e6a102526838f4152a807
Resource folder writeable: Yes
HTTP_HOST: bedrockpartners.localdev
DOCUMENT_ROOT: /var/www/public/bedrockpartners.localdev
REQUEST_URI: /bp-admin/core/settings/diagnostics/
SCRIPT_NAME: /bp-admin/core/settings/diagnostics/index.php

Display More

Shane Lenzen · Mar 21st 2019

Works great! Thanks so much Drew.

Shane Lenzen · Mar 20th 2019

Is there something I can do to prevent that? This site is in production and my client needs this to work.

Shane Lenzen · Mar 20th 2019

Hey Drew,

Looking at the debug messages, it looks like the leading 0 on the second query is somehow getting trimmed off when Runway creates the REGEXP for SQL. This only happens if the query is all numbers, it doesn't get trimmed off when there's a letter or dash in the query.

This works (keyword "01884373C"):

Code

Debug Message - Perch Runway 3.0.8
[24] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /search, so not using routes.
Using master page: /templates/pages/search.php
[1] SELECT * FROM perch3_pages WHERE pagePath='/search' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[5] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE (collectionKey='Ring & Pinion' OR collectionKey='Bearing Kit' OR collectionKey='Installation Kit' OR collectionKey='Portal Wheel End' OR collectionKey='Rockwell Wheel End')
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='title' WHERE (idx.collectionID=11 OR idx.collectionID=8 OR idx.collectionID=9 OR idx.collectionID=10 OR idx.collectionID=21) AND ((idx.indexKey='title' AND idx.indexValue REGEXP '[[:<:]]01884373C[[:>:]]') OR (idx.indexKey='part_number' AND idx.indexValue REGEXP '[[:<:]]01884373C[[:>:]]') OR (idx.indexKey='description' AND idx.indexValue REGEXP '[[:<:]]01884373C[[:>:]]') OR (idx.indexKey='keywords' AND idx.indexValue REGEXP '[[:<:]]01884373C[[:>:]]')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 18
[1] SELECT FOUND_ROWS() AS `count`
Using template: /templates/content/products/ring_and_pinion-product.html
Using sub-template: /templates/content/products/_paging.html
[2] Using sub-template: /templates/content/products/_paging.html
[1] SELECT * FROM perch3_collections WHERE collectionKey='Ring & Pinion' LIMIT 1
[1] SELECT * FROM perch3_collection_items ci, perch3_collection_revisions r WHERE r.itemID=ci.itemID AND ci.collectionID=11 AND ci.itemRev=r.itemRev AND ci.itemID=259
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Info' AND (regionPage='/search' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=4 AND idx.itemRev=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/shared/contact_info.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Footer' AND (regionPage='/search' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=8 AND idx.itemRev=19)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/shared/footer.html
...
Request time: 0.3314
Process time: 0.3098
Memory: 3.9875

Display More

This doesn't (keyword "01988614"):

Code

Debug Message - Perch Runway 3.0.8
[24] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /search, so not using routes.
Using master page: /templates/pages/search.php
[1] SELECT * FROM perch3_pages WHERE pagePath='/search' LIMIT 1
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[5] SELECT collectionID, collectionTemplate FROM perch3_collections WHERE (collectionKey='Ring & Pinion' OR collectionKey='Bearing Kit' OR collectionKey='Installation Kit' OR collectionKey='Portal Wheel End' OR collectionKey='Rockwell Wheel End')
[nil] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM perch3_collection_index idx JOIN perch3_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN perch3_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='title' WHERE (idx.collectionID=11 OR idx.collectionID=8 OR idx.collectionID=9 OR idx.collectionID=10 OR idx.collectionID=21) AND ((idx.indexKey='title' AND idx.indexValue REGEXP '[[:<:]]1988614[[:>:]]') OR (idx.indexKey='part_number' AND idx.indexValue REGEXP '[[:<:]]1988614[[:>:]]') OR (idx.indexKey='description' AND idx.indexValue REGEXP '[[:<:]]1988614[[:>:]]') OR (idx.indexKey='keywords' AND idx.indexValue REGEXP '[[:<:]]1988614[[:>:]]')) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY sortval ASC LIMIT 0, 18
[1] SELECT FOUND_ROWS() AS `count`
Using template: /templates/content/products/ring_and_pinion-product.html
Using sub-template: /templates/content/products/_paging.html
Using sub-template: /templates/content/products/_paging.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Contact Info' AND (regionPage='/search' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=4 AND idx.itemRev=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[1] Using template: /templates/content/shared/contact_info.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='Footer' AND (regionPage='/search' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=8 AND idx.itemRev=19)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[6] Using template: /templates/content/shared/footer.html
...
Request time: 0.3146
Process time: 0.3009
Memory: 3.9308

Display More

Shane Lenzen · Mar 14th 2019

I have a search results page that works like this:

Code

$search_query = addslashes(trim(perch_get('q'),'"'));
perch_collection(['Ring & Pinion','Bearing Kit', 'Installation Kit', 'Portal Wheel End', 'Rockwell Wheel End'],[
'sort'=>'title',
'sort-order' => 'ASC',
'paginate'=>true,
'count'=>18,
'page-links'=>true,
'filter'=>[
[
'filter'=>'title',
'match'=>'contains',
'value'=>$search_query
],[
'filter'=>'part_number',
'match'=>'contains',
'value'=>$search_query
],[
'filter'=>'description',
'match'=>'contains',
'value'=>$search_query
],
[
'filter'=>'keywords',
'match'=>'contains',
'value'=>$search_query
],
],
'match'=>'or',
]);

Display More

That last 'keywords' region is a simple textarea where the client can add keywords separated by spaces to return the item in a search. This is working great, except when the keyword is all numbers with no letters (client is mainly using this functionality for variations on part numbers). So for example, "01884433CX" works, "01-888456" works because it has a dash, but "01888456" doesn't.

What can I do to make the filter also look for number-only matches?

Thanks,

Shane

Shane Lenzen · Feb 12th 2019

Stephen Meehan empty should work. https://www.virendrachandak.co…sset-vs-empty-vs-is_null/

Shane Lenzen · Feb 10th 2019

Please see original thread in old forum for reference. Essentially, I need to create a new fieldtype that extends the default textarea fieldtype (/perch/core/lib/PerchForm.class.php line ~910) to run htmlspecialchars() on the $value before CKEditor is loaded on an edit page in Perch. In the original thread, I feel that Drew is hinting that this shouldn't be too difficult, however I don't know enough about PHP to even know where to begin.

I have so many use cases and requests from clients that could easily be solved with CKE plugins. If anyone can point me in the right direction, I would greatly appreciate it and would be willing to compensate your time. I imagine I'm not the only developer who would benefit from the ability to add CKE plugins to Perch.

Posts by Shane Lenzen

Grabaperch.com SSL Cert Expired

Reverse filter match "in"

Reverse filter match "in"

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Member Image Not Saving

Collection filtering not working when query is numbers only

Collection filtering not working when query is numbers only

Collection filtering not working when query is numbers only

Collection filtering not working when query is numbers only

Empty textarea versus empty text

Need help extending textarea fieldtype