Hello Ismael,
If I understand correctly your explanations concerning these custom fields, I should have the same values on all my CPTs since the very same Custom Layout template is used.

I’ll compare a few posts in my database to confirm this hypothesis and, if that’s the case, I’ll be able to leverage the power of Enfold and its new features like never before.

I plan to do this tomorrow, and I’ll post my findings in this conversation to help anyone else who might be interested.

Best regards,

Thank you Ismael for your answer.
I’ll analyse the values of these fields and try to determine how to set them programmatically.

The meta fields I’m the less sure about are the following (the values displayed below are from a CPT where I activated ALB manually) :

• _avia_builder_shortcode_tree : a:1:{i:0;a:3:{s:3:”tag”;s:16:”av_custom_layout”;s:7:”content”;a:0:{}s:5:”index”;i:0;}}
• _av_alb_posts_elements_state : a:1:{s:16:”av_custom_layout”;b:1;}

Do you know if there is any Enfold documentation about the way their values are generated ?

Best regards,

• This reply was modified 1 year ago by agencelarsen.

Thank you Ismael for your answer.

Do you have some information about the expected values of each of these meta fields ?

As each entry will use the same CPT and “Custom Layout”, I guess that I can anticipate the values even if some “post ID” or other parameters are included.

It seems to me that being able to quickly mass publish CPTs (using ALB) is a fine demonstration of the power of Enfold and its great “Custom Layout” functionality!

Best regards,

Hello Ismael,
thank you for your quick answer !
Unfortunately I can’t use the import/export tools for this CPT because it’s an Excel database of hundreds of entries from my customer that I need to transform into this freshly created CPT.

So I’ve prepared my Custom Layout for this CPT (as well as all my custom fields, with ACF) and I’d like to be able to import the data and programmatically activate the Advanced Layout Editor.

Using only the custom field _aviaLayoutBuilder_active with the “active” value, the Advanced Layout Editor is well activated but not rendered in frontend. I have to open the edition page of each CPT manually and then click “Update” in order to generate the proper avia custom fields.

It’s quite frustrating to see that all my CPTs are ready, with the right content, but that because of this small detail there’s still a manual operation to perform on hundreds of posts.

Best regards,

Following on from this

I can 100% confirm this was the cause of our server issues.

Essentially ALL Enfold websites with WooCommerce installed will gradually use up the ram and see mysql memory usage rise until the server crashes.

The bots getting stuck crawling all of the ?avia_extended_shop_select=yes queries includes:
Even with the rel-nofollow:
Bing bot
Google bot
A majority of major search engines
AI crawlers – New aggressive bots that ignore all instructions

See screenshot of the before and after. Our Ram use fell from almost 90GB of ram used to 8GB used on average.
Physical Ram usage screenshot
https://www.dropbox.com/scl/fi/tw8p399gfdr9cclorc5j9/ramuse-screenshot.PNG?rlkey=d9ty4xvui4w3m2ycb9b9ez94s&st=28aameqn&dl=0
Mysql memory usage screenshot
https://www.dropbox.com/scl/fi/iixhdd5vpe7253tbavbxf/mysql-memory-usage.PNG?rlkey=15061shf0haiu3d36cdy0be3t&st=ep9fncx5&dl=0

SOLUTION
I propose that Enfold removes the custom sort by options and reinstates the default Woocommerce ones.
The defaults use form fields and JS so there are no a href links in the default woo sort by dropdown. Bots cannot follow these links because there are no urls in the HTML.

In your child theme functions.php add the following to remove the enfold filters and reinstate the woo ones.

// remove the enfold sort by filters
function avia_woocommerce_frontend_search_params()
{
   return;
}
// reinstate the woo default sort by filters
add_action( 'woocommerce_before_shop_loop', 'woocommerce_catalog_ordering', 20 );

Add the following CSS to quick CSS and tweak depending on your sidebar position:

.sort-param-count {
display:none;
}
.product-sorting {
padding-top:0px;
}
div .product-sorting ul, div .product-sorting li {
font-size: 16px;
}
div .product-sorting ul {
width: 200px;
}
.main_color .sort-param a {
    color: #000000;
}
.sort-param-sort a, ul.sort-param-order {
border: 1px;
border-color: #969696;
border-style: solid;
}
@media only screen and (max-width: 767px) {
    .responsive #top .woocommerce-ordering {
        position: relative;
        float: left;
        clear: both;
        margin: 0;
        padding-bottom: 25px;
        padding-top: 15px;
        top: 0px;
    }
}
@media only screen and (min-width: 768px) {
    .responsive #top .woocommerce-ordering {
        position: relative;
        float: left;
        clear: both;
        margin: 0;
        padding-bottom: 25px;
        padding-top: 15px;
        top: 0px;
    }
}
#top.woocommerce-page .woocommerce-ordering select {
width: 100%;
font-size:16px;
}

Install the Redirection Plugin:

Add the following RegEX expression to redirect the queries so that the URL redirects BEFORE the query runs on the DB

Source URL: ^/(.*?)/\?avia_extended_shop_select=.*
Enable: Ignore Case, Regex and Ignore Slash
Target URL: /$1/
Hit Save
This will redirect any attempt to crawl the enfold filters back to the current category

Assuming you refer to functions.php – then our site would not work! we have code in functions.php to enable the learning management system learndash to operate and to avoid conflicts between woocommerce shop and ENFOLD. We have not made any changess in this for some time. The problem of false SQL detection and helper-assets is very recent

This is the code in the functions.php – do you see anything that may cause problems?:
<?php

/*
* Add your own functions here. You can also copy some of the theme functions into this file.
* WordPress will use those functions instead of the original functions then.
*/

/*
* Remove fields from woocommerce checkout page
* /
/**
Remove all possible fields by removing the commented out areas
**/
function wc_remove_checkout_fields( $fields ) {

// Billing fields
//
/*
unset( $fields[‘billing’][‘billing_company’] );
unset( $fields[‘billing’][‘billing_email’] );
unset( $fields[‘billing’][‘billing_phone’] );
unset( $fields[‘billing’][‘billing_state’] );
unset( $fields[‘billing’][‘billing_first_name’] );
unset( $fields[‘billing’][‘billing_last_name’] );
unset( $fields[‘billing’][‘billing_address_1’] );
unset( $fields[‘billing’][‘billing_address_2’] );
unset( $fields[‘billing’][‘billing_city’] );
unset( $fields[‘billing’][‘billing_postcode’] );
*/

// Shipping fields
/*
unset( $fields[‘shipping’][‘shipping_company’] );
unset( $fields[‘shipping’][‘shipping_phone’] );
unset( $fields[‘shipping’][‘shipping_state’] );
unset( $fields[‘shipping’][‘shipping_first_name’] );
unset( $fields[‘shipping’][‘shipping_last_name’] );
unset( $fields[‘shipping’][‘shipping_address_1’] );
unset( $fields[‘shipping’][‘shipping_address_2’] );
unset( $fields[‘shipping’][‘shipping_city’] );
unset( $fields[‘shipping’][‘shipping_postcode’] );
*/
// Order fields
unset( $fields[‘order’][‘order_comments’] );

return $fields;
}
add_filter( ‘woocommerce_checkout_fields’, ‘wc_remove_checkout_fields’ );

/** Added 22 Feb 2021 by Alex to enable SMTP email usage
*
* This function will connect wp_mail to your authenticated
* SMTP server. This improves reliability of wp_mail, and
* avoids many potential problems.
*
* For instructions on the use of this script, see:
* https://butlerblog.com/easy-smtp-email-wordpress-wp_mail/
*
* Values for constants are set in wp-config.php
*/
add_action( ‘phpmailer_init’, ‘send_smtp_email’ );
function send_smtp_email( $phpmailer ) {
$phpmailer->isSMTP();
$phpmailer->Host = SMTP_HOST;
$phpmailer->SMTPAuth = SMTP_AUTH;
$phpmailer->Port = SMTP_PORT;
$phpmailer->Username = SMTP_USER;
$phpmailer->Password = SMTP_PASS;
$phpmailer->SMTPSecure = SMTP_SECURE;
$phpmailer->From = SMTP_FROM;
$phpmailer->FromName = SMTP_NAME;
}

/* Replace logo based on ‘promotion code’ – Jelmer*/
add_action( ‘wp_head’, ‘logo_css’, 0 );
function logo_css() {
$user = wp_get_current_user();
$user_info = get_userdata($user->ID);
$code = $user->promotion_code;
if( strcasecmp($code, ‘RightBrains’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/04/rsz_1rightbrains.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Polaris’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/04/rsz_polaris.jpg) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Nyenrode’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/03/Logo-Small.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘StrategyWorks’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/09/SWSA-LOGO-3-1-e1600615027209.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘EXIN’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/02/Screenshot-2021-02-25-at-16.18.48.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Beeckestijn’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/05/Beeckestijn.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘HQAI2021’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/05/Screenshot-2020-05-01-at-13.53.02.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Assurant2020’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2020/05/rsz_assurant-logo.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Computrain’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/02/CT-Small-Logo.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘NCOI’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/02/NCOI-Small-Logo.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘NCD’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/03/NCD-Kleiner.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘Randstad’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/04/Randstad.png) no-repeat;}</style></head>”;
}
if( strcasecmp($code, ‘GK2021’) == 0){
echo “<style>span.logo{display:none;}</style></head>”;
echo “<style>div.inner-container{background:url(https://axveco.com/wp-content/uploads/2021/04/GK-Logo-small-1.jpg) no-repeat;}</style></head>”;
}
}

/* ‘Edit profile’ redirects to profile page – Jelmer*/
add_action( ‘load-profile.php’, ‘Redirect_profile_axveco’);
function Redirect_profile_axveco (){
if( ! current_user_can( ‘manage_options’ ) )
exit( wp_safe_redirect( “https://axveco.com/en/profile/&#8221; ) );
}

/* Redirect wp-login to loginwp screen – Jelmer*/
add_filter( ‘login_url’, ‘my_login_page’, 10, 3 );
function my_login_page( $login_url, $redirect, $force_reauth ) {
$login_page = “https://axveco.com/en/loginwp/&#8221; ;
$login_url = add_query_arg( ‘redirect_to’, $redirect, $login_page );
return $login_url;
}

/* Shows headers promotion code in the admin user table – Jelmer*/
add_filter(‘manage_users_columns’, ‘add_promotion_code_column’);
function add_promotion_code_column($columns) {
$columns[‘promotion_code’] = ‘Promotion Code’;
return $columns;
}
/* Shows content promotion code in the admin user table – Jelmer */
add_action(‘manage_users_custom_column’, ‘show_user_promotion_code_column_content’, 10, 3);
function show_user_promotion_code_column_content($value, $column_name, $user_id) {
$user = get_userdata( $user_id );
if ( ‘promotion_code’ == $column_name )
return $user->promotion_code;
return $value;
}

/*Archive category page layout JP https://kriesi.at/support/topic/category-archive-page-change-layout-to-show-excerpt
add_filter(‘avf_blog_style’,’avia_change_category_blog_layout’, 10, 2);
function avia_change_category_blog_layout($layout, $context){
if($context == ‘archive’) $layout = ‘single-big’;
return $layout;
}*/

add_filter(‘avf_blog_style’,’avia_change_category_blog_layout’, 10, 2);
function avia_change_category_blog_layout($layout, $context){
if($context == ‘archive’) $layout = ‘blog-grid’;
return $layout;
}

add_action(‘wp_footer’, ‘add_custom_tooltip’);
function add_custom_tooltip(){
?>
<script>
jQuery(window).load(function(){
jQuery(‘a’).removeAttr(‘title’);
jQuery(‘img’).removeAttr(‘title’);
});
</script>
<?php
}

/*
* This function is required to display the location map on the contact us page
* if removed then the map does not display – API key is from Theme Google services
*/
add_action(‘wp_footer’, ‘gmaps_workaround’);
function gmaps_workaround(){
?>
<!–Google Maps JavaScript API –>
<script src=”https://maps.googleapis.com/maps/api/js?key=AIzaSyCWwtEsgQqGTvuqmzrZMapkbyzqyxCKZBw”
type=”text/javascript”></script>
<script type=”text/javascript”>
jQuery(document).ready(function($){
setTimeout(function(){
$(‘#s_pdf_frame’).attr( ‘src’, function ( i, val ) { return val; });
}, 100);
});
</script>
<?php
}

// add_action(‘avia_builder_mode’, “builder_set_debug”);
function builder_set_debug()
{
return “debug”;
}

/*
* this funciton has been updated – see above post in header
* the original code is: $meta[‘page’][] = ‘events’;
*
* Adds PageBuilder to LearnDash Post Typs
* this is to enable the Advanced Builder in LearnDash – Alex
* see post at https://kriesi.at/support/topic/learndash-plugin/
*
}*/
add_filter(‘avf_builder_boxes’, ‘add_builder_to_posttype’);
function add_builder_to_posttype($metabox)
{
foreach($metabox as &$meta)
{
if($meta[‘id’] == ‘avia_builder’ || $meta[‘id’] == ‘layout’)
{
/* original code: $meta[‘page’][] = ‘events’; instead add the name of the custom post type here*/
$meta[‘page’][] = ‘sfwd-courses’;
$meta[‘page’][] = ‘sfwd-lessons’;
$meta[‘page’][] = ‘sfwd-topic’;
$meta[‘page’][] = ‘sfwd-quiz’;
}
}
return $metabox;
}

/*
* After installing Woocommerce bookings, the events table function was no longer needed
* I cannot determine whether ‘Events’ post type here is related to events…
*/
add_action( ‘init’, ‘create_post_type’ );
function create_post_type() {
register_post_type( ‘Events’,
array(
‘labels’ => array(
‘name’ => __( ‘Events’ ),
‘singular_name’ => __( ‘Event’ )
),
‘public’ => true,
‘has_archive’ => false,
‘hierarchical’ => true,
‘supports’ => array( ‘title’, ‘editor’)
)
);

register_taxonomy(
‘event_categories’, //The name of the taxonomy. Name should be in slug form (must not contain capital letters or spaces).
‘events’, //post type name
array(
‘hierarchical’ => true,
‘label’ => ‘Categories’, //Display name
‘query_var’ => true
)
);
}
/*
* Goal here is to disable woocommerce from opening the default shop page which is incompatible with
* our ENFOLD Child theme and appears to be the cause of the Internal Server Error intermittent failure
* We log that the event has occurred, disbale woocommerce and then redirect to a safe page
*/
function custom_woocommerce_redirect_shop_page() {
if (is_shop()) {
// Send an email to log that this event has occured

// Get the current user info
$current_user = wp_get_current_user();
$username = $current_user->user_login;
//$is_logged_in = is_user_logged_in() ? ‘Yes’ : ‘No’;

// Send email notification if logged in (not logged in generates a hit every minute)
if (is_user_logged_in()) {
$to = (Email address hidden if logged out) ‘;
$subject = ‘WooCommerce Shop Page Disable invoked’;
$message = ‘The WooCommerce shop page open was attempted and has been disabled.’;
$message .= ‘<br>User: ‘ . $username;
//$message .= ‘<br>Logged in: ‘ . $is_logged_in;
$headers = array(‘Content-Type: text/html; charset=UTF-8’);

wp_mail($to, $subject, $message, $headers);
}
// Remove the default WooCommerce content for the shop page
remove_action(‘woocommerce_archive_description’, ‘woocommerce_taxonomy_archive_description’, 10);
remove_action(‘woocommerce_archive_description’, ‘woocommerce_product_archive_description’, 10);
remove_action(‘woocommerce_before_main_content’, ‘woocommerce_output_content_wrapper’, 10);
remove_action(‘woocommerce_after_main_content’, ‘woocommerce_output_content_wrapper_end’, 10);
remove_action(‘woocommerce_sidebar’, ‘woocommerce_get_sidebar’, 10);

// Set up a target page to redirect to
$alternative_shop_page = “https://axveco.com/en/your-next-step/&#8221; ;

// Redirect to our own next steps page
wp_redirect($alternative_shop_page);

exit;
}
}
add_action(‘template_redirect’, ‘custom_woocommerce_redirect_shop_page’);

/*
* End of functions.php
*/
?>

Hey Ismael,

wow, many thanks, it works, but I wasn’t exact enough. I meant only subcategories a certain product is assigned to. If a certain product category has subcategories A, B and C and a product is assigned to A and C then only A and C should be displayed. Possible?

By activating custom elements in Enfold settings it’s possible to insert WP Post Data or ACF fields. And there are also Dynamic WP Custom Fields like Theme Custom Field Shortcodes ({av_dynamic_el src=”wp_custom_field” key=”%metakey%” default=”” link=”” linktext=”” format=””}).And so I thought I can use this. But how?

Thanks again
Stefan

Thank you Mike.

I am trying this now.

But does this mean that I have to edit every “Journal” item individually? There are thousands. I thought they’d be a way to say, if post type = X then put out these custom fields. I didn’t think I’d have to do it page by page.

Thanks

Lucy

Hi Günter

Thanks for your reply.

The documentation is good, however is doesn’t explain why all the form fields are missing when i create a custom element from a contact form. IMAGE 1 is a form created in the normal way and IMAGE 2 is the same for saved as a Custom Element. As you can see all the form fields apart from the first one are missing and there isn’t a way to add them back in to the Custom Element.

Regards
Colin

Temporary fix for anyone experiencing the same issue (until the authors of Enfold fix this issue permanently):

Add this to your child theme’s functions.php:

// Enfold 6.0 slow query fix
add_filter('avf_before_query_wp_default_custom_fields', function($custom_fields) { return []; });

The dynamic custom fields don’t work anymore with this line, but at least your website is working again.