• Возможно ли подключить PostgreSQL к Wordpress?

    @petruncho Автор вопроса
    Refguser, где в вопросе написано, что нужно ваше мнение по вопросу?
    Не согласны — страницу закрыли
    Написано
  • Возможно ли подключить PostgreSQL к Wordpress?

    @petruncho Автор вопроса
    Zettabyte, 7 млн записей + мета поля. Можете смело на 2 умножать)
    Написано
  • Возможно ли подключить PostgreSQL к Wordpress?

    @petruncho Автор вопроса
    Отличается ли в производительности PostgreSQL и MySQL для WordPress?

    Задача: хранить и обрабатывать около 7 млн. записей в бд
    Написано
  • Как реализовать подсказки при наборе в поиске WordPress?

    @petruncho Автор вопроса
    ElasticPress работает с локальным ElasticSearch?
    Какую версию ElasticSearch ставить?
    Написано
  • Как правильно создать белый список доступа для определенного url в nginx?

    @petruncho Автор вопроса
    dodo512, выложу полный конфиг сервера

    server {
        root /var/www/html/wordpress;
        index  index.php index.html index.htm;
        server_name URL_САЙТА;
        
        client_max_body_size 500M;
    
        location / {
            try_files $uri $uri/ /index.php?$args;
        }
    	
        location = /favicon.ico {
            log_not_found off;
            access_log off;
        }
    
        location ~* .(jpg|jpeg|gif|png|css|zip|tgz|gz|rar|bz2|doc|docx|xls|xlsx|exe|pdf|ppt|tar|wav|bmp|rtf|js|svg|svgz)$ {
            expires max;
            log_not_found off;
        }	
    
        location = /robots.txt {
            allow all;
            log_not_found off;
            access_log off;
        }
    
    	location /phpmyadmin {
    		alias /usr/share/phpmyadmin/;
    
    		location ~ \.php$ {
    			fastcgi_pass unix:/run/php/php8.1-fpm.sock;
    			fastcgi_index index.php;
    			fastcgi_param SCRIPT_FILENAME $request_filename;
    			include fastcgi_params;
    			fastcgi_ignore_client_abort off;
    		}
    
    		location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
    			access_log    off;
    			log_not_found    off;
    			expires 1M;
    		}
    	}
    
        location ~ .php$ {
             include snippets/fastcgi-php.conf;
             fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;
             fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
             include fastcgi_params;
        }
    }
    Написано
  • Как правильно создать белый список доступа для определенного url в nginx?

    @petruncho Автор вопроса
    IvanU7n, на сервере стоит WordPress. GraphQL установлен как плагин ( WPGraphQL ).
    url — /graphql
    скрипты обрабатывает index.php в корне сайта, но это не конечный обработчик, т.к. используется MVC паттерн
    Написано
  • Как правильно создать белый список доступа для определенного url в nginx?

    @petruncho Автор вопроса
    dodo512, перенаправления нет.
    Планирую просто 403 выдавать, если IP не тот
    Написано
  • Как сделать сортировку по кастомному ACF полю в WPGraphQL?

    @petruncho Автор вопроса
    РЕШЕНО!

    Проблема была в плагине Post Types Order и включенной настройке Автосортировка — игнорировала значения meta полей и выдавала принудительный MENU ORDER.

    Добавления параметра сортировки в WP GraphQL
    add_filter( 'graphql_PostObjectsConnectionOrderbyEnum_values', function( $values ){
    
        // RELEASE_DATE — название параметра сортировки
        $values['RELEASE_DATE'] = [
    	'value' => 'release_date',   // название meta key
            'description' => __( 'Дата выпуска проекта', 'wp-graphql' ),  // описание для документации
        ];
    
        return $values;
    
    });
    
    
    add_filter( 'graphql_post_object_connection_query_args', function( $query_args, $source, $input ) {
    
        if ( isset( $input['where']['orderby'] ) && is_array( $input['where']['orderby'] ) ) {
    
            foreach( $input['where']['orderby'] as $orderby ) {
    
                if ( !isset( $orderby['field'] ) || $orderby['field'] !== 'release_date' ){
                    continue;
                }
    
                $query_args['meta_key']  = 'release_date';   // название meta key
                $query_args['orderby']   = 'meta_value';
                $query_args['order'] 	 = $orderby['order'];
    
            }
    
        }
    
        return $query_args;
    
    }, 10, 3);
    Написано
  • Как минифицировать HTML в WordPress?

    @petruncho Автор вопроса
    Refguser, без понятия, зачем ковыряться в минифицированном HTML, если есть:
    1. Веб инспектор, который форматирует код
    2. Есть исходники шаблона, где пишется неминифицированный код

    Под минификацией HTML подразумеваю только удаление пробелов и табов, без изменения значения атрибутов тэгов.
    При таком способе картинки и стили не могут поплыть (форматирование текста не берем)
    Написано
  • Как минифицировать HTML в WordPress?

    @petruncho Автор вопроса
    Алексей Уколов, при кешировании сайта разве страница не сохраняется как статичный файл?
    Написано
  • Как спрятать ключи авторизации при HTTP запросах в JS?

    @petruncho Автор вопроса
    Александр Лисин, пока остановился на варианте отправлять тело запроса с ключами через бэк,
    а через JS обращаться к своему бэку
    Написано
  • Как спрятать ключи авторизации при HTTP запросах в JS?

    @petruncho Автор вопроса
    http only cookie можно через консоль посмотреть?
    Написано
  • Как спрятать ключи авторизации при HTTP запросах в JS?

    @petruncho Автор вопроса
    Wispik, какое решение тогда?
    Делать защиту на стороне приема запроса?
    Написано
  • Как получить ссылку на запись со статусом черновик Wordpress?

    @petruncho Автор вопроса
    Дмитрий, подходит для решения. Спасибо!
    Написано
  • Как получить ссылку на запись со статусом черновик Wordpress?

    @petruncho Автор вопроса
    $my_post = clone $post;
    создает копию в бд?
    или в памяти сервера, а после выполнения удаляется?
    Написано
  • Как вернуть package control в Sublime Text 4?

    @petruncho Автор вопроса
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/Package Control.py", line 89, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/commands/__init__.py", line 3, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/commands/advanced_install_package_command.py", line 10, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/package_manager.py", line 34, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/downloaders/__init__.py", line 20, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/downloaders/oscrypto_downloader.py", line 44, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/tls.py", line 11, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_mac/tls.py", line 39, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_mac/util.py", line 208, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_openssl/_libcrypto.py", line 15, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_openssl/_libcrypto_ctypes.py", line 30, in
    File "./python3.3/ctypes/__init__.py", line 353, in __init__
    OSError: dlopen(/usr/local/lib/libcrypto.dylib, 0x0006): tried: '/usr/local/lib/libcrypto.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/lib/libcrypto.dylib' (no such file), '/usr/local/lib/libcrypto.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (no such file), '/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64'))
    plugins loaded
    Написано
  • Как вернуть package control в Sublime Text 4?

    @petruncho Автор вопроса
    Traceback (most recent call last):
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 308, in reload_plugin
    m = importlib.import_module(modulename)
    File "./python3.3/importlib/__init__.py", line 90, in import_module
    File "", line 1584, in _gcd_import
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/2_bootstrap.py", line 26, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/bootstrap.py", line 20, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/download_manager.py", line 24, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/downloaders/__init__.py", line 20, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/downloaders/oscrypto_downloader.py", line 44, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/tls.py", line 11, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_mac/tls.py", line 39, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_mac/util.py", line 208, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_openssl/_libcrypto.py", line 15, in
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    File "/Users/petrov/Library/Application Support/Sublime Text/Installed Packages/Package Control.sublime-package/package_control/deps/oscrypto/_openssl/_libcrypto_ctypes.py", line 30, in
    File "./python3.3/ctypes/__init__.py", line 353, in __init__
    OSError: dlopen(/usr/local/lib/libcrypto.dylib, 0x0006): tried: '/usr/local/lib/libcrypto.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/lib/libcrypto.dylib' (no such file), '/usr/local/lib/libcrypto.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (no such file), '/usr/local/Cellar/openssl@3/3.2.0_1/lib/libcrypto.3.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64'))
    reloading python 3.3 plugin Package Control.Package Control
    Traceback (most recent call last):
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 308, in reload_plugin
    m = importlib.import_module(modulename)
    File "./python3.3/importlib/__init__.py", line 90, in import_module
    File "", line 1584, in _gcd_import
    File "", line 1565, in _find_and_load
    File "", line 1532, in _find_and_load_unlocked
    File "/Applications/Sublime Text.app/Contents/MacOS/Lib/python33/sublime_plugin.py", line 1697, in load_module
    exec(compile(source, source_path, 'exec'), mod.__dict__)
    Написано