nikitabaliov

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 19 total)
  • Thread Starter nikitabaliov

    (@nikitabaliov)

    Hello Paulo,

    I have own cloud server and I did many VPS backups. The problem is happened after that, the update of Woocommerce version 6.3.1 is performed. I checked it two time. I returned to last backup and it is worked. When I update again Woccommerce – the same result. Next days, I will test gradually everything. I thing to remove all attributes and products too, but it is slow process.
    I will inform you.
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi again,
    In my case, when “Use the product attributes lookup table for catalog filtering.” is checked, not all attributes are presented for every category page. When I tray to Regenerate (click on button), it is processing to end of product count. All attributes are shown between processing, but when it is finished, the reported problem is happening! The button “Clear” product lookup table is disappeared – may be it is new in last update.

    Best regards,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Thank you for your respond,

    Here is the system status:

    
### WordPress Environment ###

WordPress address (URL): https://yntech.bg
Site address (URL): https://yntech.bg
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: bg_BG
External object cache: –

### Server Environment ###

Server Info: nginx/1.14.0
PHP Version: 7.4.28
PHP Post Max Size: 256 MB
PHP Time Limit: 360
PHP Max Input Vars: 6000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 8.0.28
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: wp_
Общ размер на базата данни: 500.02MB
Размер на базата данни: 392.91MB
Размер на индекса на базата данни: 107.11MB
wp_woocommerce_sessions: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_woocommerce_api_keys: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_woocommerce_attribute_taxonomies: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_woocommerce_downloadable_product_permissions: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_woocommerce_order_items: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_woocommerce_order_itemmeta: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_woocommerce_tax_rates: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_woocommerce_tax_rate_locations: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_woocommerce_shipping_zones: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_woocommerce_shipping_zone_locations: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_woocommerce_shipping_zone_methods: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_woocommerce_payment_tokens: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_woocommerce_payment_tokenmeta: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_woocommerce_log: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_actionscheduler_actions: Данни: 0.02MB + Индекси: 0.13MB + подсистема InnoDB
wp_actionscheduler_claims: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_actionscheduler_groups: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_actionscheduler_logs: Данни: 86.61MB + Индекси: 47.11MB + подсистема InnoDB
wp_aioseo_notifications: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_aioseo_posts: Данни: 3.52MB + Индекси: 0.30MB + подсистема InnoDB
wp_commentmeta: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_comments: Данни: 0.02MB + Индекси: 0.09MB + подсистема InnoDB
wp_links: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_mailchimp_carts: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_mailchimp_jobs: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_options: Данни: 21.52MB + Индекси: 0.48MB + подсистема InnoDB
wp_pmxi_files: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_hash: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_history: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_images: Данни: 3.52MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_imports: Данни: 1.50MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_posts: Данни: 0.39MB + Индекси: 0.00MB + подсистема InnoDB
wp_pmxi_templates: Данни: 1.50MB + Индекси: 0.00MB + подсистема InnoDB
wp_postmeta: Данни: 81.61MB + Индекси: 21.88MB + подсистема InnoDB
wp_posts: Данни: 32.55MB + Индекси: 6.53MB + подсистема InnoDB
wp_rank_math_analytics_gsc: Данни: 0.41MB + Индекси: 0.66MB + подсистема InnoDB
wp_rank_math_analytics_inspections: Данни: 0.52MB + Индекси: 0.41MB + подсистема InnoDB
wp_rank_math_analytics_objects: Данни: 53.58MB + Индекси: 19.66MB + подсистема InnoDB
wp_rank_math_internal_links: Данни: 0.11MB + Индекси: 0.05MB + подсистема InnoDB
wp_rank_math_internal_meta: Данни: 1.52MB + Индекси: 0.00MB + подсистема InnoDB
wp_rank_math_redirections: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_rank_math_redirections_cache: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_revslider_css: Данни: 0.27MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_css_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_layer_animations: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_layer_animations_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_navigations: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_navigations_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_sliders: Данни: 0.06MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_sliders_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_slides: Данни: 0.11MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_slides_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_static_slides: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_revslider_static_slides_bkp: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_term_relationships: Данни: 2.52MB + Индекси: 2.33MB + подсистема InnoDB
wp_term_taxonomy: Данни: 0.19MB + Индекси: 0.20MB + подсистема InnoDB
wp_termmeta: Данни: 0.25MB + Индекси: 0.27MB + подсистема InnoDB
wp_terms: Данни: 0.17MB + Индекси: 0.17MB + подсистема InnoDB
wp_tm_taskmeta: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_tm_tasks: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_usermeta: Данни: 0.06MB + Индекси: 0.03MB + подсистема InnoDB
wp_users: Данни: 0.02MB + Индекси: 0.05MB + подсистема InnoDB
wp_wc_admin_note_actions: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wc_admin_notes: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wc_category_lookup: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wc_customer_lookup: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_wc_download_log: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_wc_order_coupon_lookup: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_wc_order_product_lookup: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_wc_order_stats: Данни: 0.02MB + Индекси: 0.05MB + подсистема InnoDB
wp_wc_order_tax_lookup: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_wc_product_attributes_lookup: Данни: 3.52MB + Индекси: 4.03MB + подсистема InnoDB
wp_wc_product_meta_lookup: Данни: 1.52MB + Индекси: 0.97MB + подсистема InnoDB
wp_wc_rate_limits: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wc_reserved_stock: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wc_tax_rate_classes: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wc_webhooks: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wfblockediplog: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfblocks7: Данни: 0.02MB + Индекси: 0.05MB + подсистема InnoDB
wp_wfconfig: Данни: 2.52MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfcrawlers: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wffilechanges: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wffilemods: Данни: 67.64MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfhits: Данни: 0.47MB + Индекси: 0.16MB + подсистема InnoDB
wp_wfhoover: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wfissues: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_wfknownfilelist: Данни: 21.55MB + Индекси: 0.00MB + подсистема InnoDB
wp_wflivetraffichuman: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wflocs: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wflogins: Данни: 0.38MB + Индекси: 0.13MB + подсистема InnoDB
wp_wfls_2fa_secrets: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_wfls_settings: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfnotifications: Данни: 0.08MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfpendingissues: Данни: 0.02MB + Индекси: 0.06MB + подсистема InnoDB
wp_wfreversecache: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wfsnipcache: Данни: 0.02MB + Индекси: 0.05MB + подсистема InnoDB
wp_wfstatus: Данни: 1.03MB + Индекси: 0.09MB + подсистема InnoDB
wp_wftrafficrates: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpforms_tasks_meta: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza_circles: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza_maps: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza_polygon: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza_polylines: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpgmza_rectangles: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpmailsmtp_debug_events: Данни: 0.02MB + Индекси: 0.00MB + подсистема InnoDB
wp_wpmailsmtp_tasks_meta: Данни: 0.05MB + Индекси: 0.00MB + подсистема InnoDB
wp_yith_wcwl: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_yith_wcwl_lists: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB
wp_yoast_indexable: Данни: 0.06MB + Индекси: 0.03MB + подсистема InnoDB
wp_yoast_indexable_hierarchy: Данни: 0.02MB + Индекси: 0.05MB + подсистема InnoDB
wp_yoast_migrations: Данни: 0.02MB + Индекси: 0.02MB + подсистема InnoDB
wp_yoast_primary_term: Данни: 0.02MB + Индекси: 0.03MB + подсистема InnoDB

### Post Type Counts ###

attachment: 20350
custom_css: 2
mas_static_content: 19
mc4wp-form: 1
nav_menu_item: 173
oembed_cache: 372
page: 47
post: 25
product: 5298
revision: 8
shop_order: 4
wp_block: 1
wp_global_styles: 1
wpforms: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (21) ###

Template Library and Redux Framework: от Extendify – 4.3.12
Akismet Anti-Spam: от Automattic – 4.2.2
Cookie Notice & Compliance for GDPR / CCPA: от Hu-manity.co – 2.2.3
Electro Extensions: от MadrasThemes – 3.1.3
Envato Market: от Envato – 2.0.7
Loco Translate: от Tim Whitlock – 2.6.1
MC4WP: Mailchimp for WordPress: от ibericode – 4.8.7
Really Simple SSL: от Really Simple Plugins – 5.3.0
Rank Math SEO: от Rank Math – 1.0.84
Simple Google reCAPTCHA: от Michal Novák – 3.9
Super Socializer: от Team Heateor – 7.13.29
WP All Import - WooCommerce Add-On: от Soflyy – 1.5.1
WooCommerce: от Automattic – 6.3.1
Wordfence Security: от Wordfence – 7.5.8
WP All Import: от Soflyy – 3.6.6
WP Google Maps: от WP Google Maps – 8.1.21
WP Mail SMTP: от WPForms – 3.3.0
WP-Optimize - Clean, Compress, Cache: от David Anderson
Ruhani Rabin
Team Updraft – 3.2.3

WPForms Lite: от WPForms – 1.7.3
YITH WooCommerce Compare Premium: от YITH – 2.12.0
YITH WooCommerce Wishlist: от YITH – 3.7.0

### Inactive Plugins (9) ###

Facebook for WooCommerce: от Facebook – 2.6.12
Hello Dolly: от Matt Mullenweg – 1.7.2
MAS Brands for WooCommerce: от MadrasThemes – 1.0.4
MAS Static Content: от MadrasThemes – 1.0.4
Regenerate Thumbnails: от Alex Mills (Viper007Bond) – 3.1.5
Slider Revolution: от ThemePunch – 6.5.9
WordPress Importer: от wordpressdotorg – 0.7
WPBakery Page Builder: от Michael M - WPBakery.com – 6.7.0
YITH WooCommerce Compare: от YITH – 2.12.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: BGN (лв.)
Currency Position: right_space
Thousand Separator: 
Decimal Separator: .
Number of Decimals: 0
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Основна страница на магазина: #3163 - /shop/
Количка: #9455 - /kolichka/
Поръчка: #6 - /porachka-2/
Моят профил: #7 - /moyat-profil/
Общи условия: #223616 - /%d0%be%d0%b1%d1%89%d0%b8-%d1%83%d1%81%d0%bb%d0%be%d0%b2%d0%b8%d1%8f/

### Theme ###

Name: Electro Child
Version: 2.5.5
Author URL: https://madrasthemes.com/
Child Theme: ?
Parent Theme Name: Electro
Parent Theme Version: 3.2.4
Parent Theme Author URL: https://madrasthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: electro/woocommerce/archive-product.php
electro/woocommerce/global/quantity-input.php

### Action Scheduler ###

Complete: 14
Oldest: 2022-03-16 09:49:51 +0200
Newest: 2022-03-18 09:51:30 +0200

Pending: 3
Oldest: 2022-03-21 07:29:48 +0200
Newest: 2022-03-21 07:29:48 +0200

### Status report information ###

Generated at: 2022-03-19 08:52:42 +02:00
    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi,
    I solve it by updating every comment with some review. It shows correctly!
    But it is work till next product updating. I will have difficulties when there are huge amount of reviews.

    Thank you,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi Harshad,
    I’ve never minified javascrips! I minify HTML and CSS, also Page caching. When I update all products, I clear Minify and Page cache, after that, I clear Woocommerce all cache options. If I clear nothing, it is presented correctly! Sorry to disturb you if you can not find solution, I will use it as it is. For other example you can see if it possible: https://yntech.bg/produkt-kategoriya/лаптоп/?rating_filter=5

    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Exactly, at this page, bottom of screenshot, see tab “Отзиви” (“Reviews”) and click over it. It will be presented Review section. See left graduated stars. There is 1 review/rating with 5 stars, but “Based on 0 reviews” and “0.0 overall”. If you give a rating for this product, it will be accepted and will be averaged (without previous result) to next product updating! I.e. it is related with caching. If I stop cashing it will work correct. How to exclude product rating from cashing?

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Sorry,
    I copied/pasted link with Cyrillic symbols, but there is a problem! Please search SKU: N005L342014EMEA

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi Harshad,

    Sorry, my English is not so fluent. I tray to explain situation. When the product rating is performed, then everything looks fine until product updating and after that, cache cleaning. Next, rating stars are grey in a product category page, but if you click on given product page with review, rated with stars, the rating is not marked and averaged (if there are more than 1 values), but still showing reviews by stars, bottom the average grade! See an example: https://yntech.bg/produkt/лаптоп-dell-latitude-3420-intel-core-i3-1115g4-6m-cache-up-to-4-1-ghz-14-0-fhd-1920×1080-ag-8gb-ddr4-256gb-ssd-pcie-m-2-uhd-graphics-cam-and-mic-wifi-blueto/ *you can translate with google

    Thank you,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Thank you,

    It is work perfectly.
    As I said, we use (https://yntech.bg) WordPress ONLY because WP All Import is created – it is most useful plugin application. Our shop depend on this! We import about 6000 products with many attributes and it is not true that WordPress/Woocommerce cannot deal with huge amount of products and attributes. Everything correlated with web server/PHP and MYSQL settings. Only problem is the stable of the platform or plugins.

    Best regard Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    I isolated the problem/s – they are in the last updates of WP All Import or WP All Import – Woocommerce Add-On. I updated step by step every new update of the other plugins, the effect is related only (in that case) with WP All Import plugins!
    Our company use WordPress ONLY just because WP All Import exists – we import about 6000 products. WordPress is very unstable platform!!!! In time to time it is crashed! I renew our configuration every year, first it is worked with Apache, then NGINX, optimising MYSQL to deal with many attributes (product filters). After that it fine, but when updated new version of some plugin, again bad!
    Now it is interfered another problem with WP All In One SEO – I removed it, because the CPU increase very high and permalinks of the our site showed 404 errors.
    I recommend developers to be more conservative and to release only stable products. It is awful to update sites every minute!!!

    Thread Starter nikitabaliov

    (@nikitabaliov)

    I restored 3 old backups of the VM and after I finished all updates of the WordPress plugins to now and all Ubuntu 18.04 updates of MYSQL8 and PHP7.4 for NGINX, the problem is happened.

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi,
    It is seems OK with woocommerce 4.5.2!

    Thank you,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Thank you grigaswp,
    I’ve already checked version 4.5.1 and the same! I will wait!

    Best regards,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi grigaswp,
    In my case, Woocommerce is tried to update to v. 4.5 not 4.5.1. I returned it to 4.3.1 (old backup, but the others plugins updated). Now is OK, and I will wait new release! I do not use variations!!! I cleared every products and start with very simple test – problem with v. 4.5.
    My site is https://yntech.bg

    Thank you for response,
    Nikolay

    Thread Starter nikitabaliov

    (@nikitabaliov)

    Hi,
    I solved it by:

    wp db query ‘DELETE FROM wp_actionscheduler_actions WHERE status = “complete”‘ –path to wordpress

    Thanks,
    Nikolay

Viewing 15 replies - 1 through 15 (of 19 total)