Сергей Карпович

Error 42S22 executing statement:
INSERT INTO `modx_ef_fields` (`class_name`, `field_name`, `field_type`, `field_null`, `field_index`, `field_default`, `menuindex`, `active`) VALUES ('modUserProfile', 'agreed', 'xcheckbox', 0, 0, '0', 0, 1)
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'field_index' in 'field list'
)

Error translate text:'[{"MIGX_id":"1","title":"BROKER","text":"+5% Бонус ко всем вашим депозитам"},{"MIGX_id":"2","title":"CSGOBROKER","text":"1.50$ Бесплатно"},{"MIGX_id":"3","title":"BROKER","text":"+5% Бонус ко всем вашим депозитам"},{"MIGX_id":"4","title":"CSGOBROKER","text":"1.50$ Бесплатно"}]' from ru to de

[pdoTools] Error 42S22: Unknown column 'ecThread.resource' in 'on clause'

{set $show_more = $_modx->lexicon('show_more')}
    {$_modx->runSnippet('!mFilter2', [
        'parents' => '22',
        'minQuery' => 2,
        'element' => 'msProducts',
        'class' => 'msProduct',
        'limit' => '20',
        'setMeta' => 0,
        'suggestions' => '0',
        'depth' => '',
        'includeTVs' => '
            project_logo,
            project_promocode,
            project_offer,
        ',
        'tvPrefix' => '',
        'filters' => '',
        'aliases' => '',
        'tplOuter' => 'tpl_mFilter2.outer',
        'tpl' => 'tpl_project_item',
    	'ajaxMode' => 'button',
        'ajaxElemWrapper' => '.catalog-content',
        'ajaxElemRows' => '.all-items',
        'ajaxElemPagination' => '.catalog-content .mse2_pagination',
        'ajaxElemMore' => '.catalog-content .pagination-more',
        'ajaxTplMore' => '@INLINE: <div class="pagination-more center"><button class="btn">' ~ $show_more ~ '</button></div>',
        'filterOptions' => '{"more": ".catalog-content .pagination-more", "more_tpl": "<div class=\"pagination-more center\"><button class=\"btn\">' ~ $show_more ~ '</button></div>"}'
    ])}

{set $show_more = $_modx->lexicon('show_more')}
    {$_modx->runSnippet('!mFilter2', [
        'parents' => '22',
        'minQuery' => 2,
        'element' => 'msProducts',
        'class' => 'msProduct',
        'loadModels'=>'easycomm',
        'leftJoin' => '{
            "ecThread" : {
                "class" : "ecThread",
                "on" : "msProduct.id = ecThread.resource"
            }
        }',
        'select' => '{
            "msProduct" : "*",
            "ecThread" : "ecThread.rating_simple AS rating"
        }',
        'limit' => '20',
        'setMeta' => 0,
        'suggestions' => '0',
        'depth' => '',
        'includeTVs' => '
            project_logo,
            project_promocode,
            project_offer,
        ',
        'tvPrefix' => '',
        'filters' => '',
        'aliases' => '',
        'tplOuter' => 'tpl_mFilter2.outer',
        'tpl' => 'tpl_project_item',
    	'ajaxMode' => 'button',
        'ajaxElemWrapper' => '.catalog-content',
        'ajaxElemRows' => '.all-items',
        'ajaxElemPagination' => '.catalog-content .mse2_pagination',
        'ajaxElemMore' => '.catalog-content .pagination-more',
        'ajaxTplMore' => '@INLINE: <div class="pagination-more center"><button class="btn">' ~ $show_more ~ '</button></div>',
        'filterOptions' => '{"more": ".catalog-content .pagination-more", "more_tpl": "<div class=\"pagination-more center\"><button class=\"btn\">' ~ $show_more ~ '</button></div>"}'
    ])}

document.addEventListener('si:send:success', (e) => {
    const { action, target, result, headers, Sending } = e.detail;
    Sending.success = (result, target) => {
        Fancybox.close([{ src: "#popup" }]);
        Fancybox.show([{ src: "#success-message", type: "inline" }]);
    }
})

Polylang не умеет переводить значения опций, а переводы названий фильтров можно сделать через управление словарями.

document.addEventListener('afl_complete', e => {
    if (e.detail.response.success) {
        тут что надо делать 
    }
});