Forum Replies Created

Viewing 15 replies - 1 through 15 (of 80 total)
  • Thread Starter DiscountDukan

    (@techjockey)

    please close this ticket, i am able to solve the issue by changing the ‘numberposts’ value https://prnt.sc/20g47b5

    Thank you for your support.

    Thread Starter DiscountDukan

    (@techjockey)

    deleted v1.3, installed fresh : Does not work https://prnt.sc/20bgn3g
    installed v1.2 : works just fine
    tried updating again from v1.2 to v1.3 : Same error https://prnt.sc/20bgn3g

    Thread Starter DiscountDukan

    (@techjockey)

    I am still getting the error after deactivating other plugins – https://prnt.sc/20bgn3g

    Thread Starter DiscountDukan

    (@techjockey)

    any help is appreciated…

    yes please add a cron job which can be scheduled to run at specific inerval.

    Thread Starter DiscountDukan

    (@techjockey)

    Ok, for now i have mitigated the issue by limiting the number of posts…

    //* Get all the posts
    $posts = get_posts( array( ‘numberposts’ => 20, ‘post_status’ => ‘any’,’post_type’=>$cr_type )

    Thread Starter DiscountDukan

    (@techjockey)

    awesome, looking forward to it. Thanks

    Thread Starter DiscountDukan

    (@techjockey)

    Thank you for responding team. I do not wish to randomize all products at once rather no would like to do so.

    I think randomize products per category or choosing between two dates will be more relevant strategy.

    please see this plugin for reference – https://ww.wp.xz.cn/plugins/wp-random-post-dater/

    I know for a free plugin this is much of an effort, just want to contribute to the development of it wherever possible.

    Thank you again for creating wonderful plugin.

    Thread Starter DiscountDukan

    (@techjockey)

    it just lost the connection when executing that SQL query… there should be some limit
    or an filter set to control how many items can be changed at once.

    Thread Starter DiscountDukan

    (@techjockey)

    i think we should be able to set the limit on the number of posts to randomize, that should solve the problem.

    no solution yet… tried almost everything available online 🙁

    If i run the following query on the SQL DB manually, it looses the connection.

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%samsung%’)
    OR ( posts.post_excerpt LIKE ‘%samsung%’)
    OR ( posts.post_content LIKE ‘%samsung%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%samsung%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    If i just run it on post.title it works, looks like all those joins are making it fail….

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id FROM wp_posts posts LEFT JOIN wp_postmeta postmeta ON posts.ID = postmeta.post_id WHERE posts.post_type IN (‘product’,’product_variation’) AND ( posts.post_title LIKE ‘%samsung%’) ORDER BY posts.post_parent ASC, posts.post_title ASC

    • This reply was modified 7 years, 9 months ago by DiscountDukan.

    Since the upgrade i am also facing the same search issues, i am on PHP 7.2, even the latest update did not help, please help.

    SELECT DISTINCT posts.ID as product_id, posts.post_parent as parent_id
    FROM wp_posts posts
    LEFT JOIN wp_postmeta postmeta
    ON posts.ID = postmeta.post_id
    WHERE posts.post_type IN (‘product’,’product_variation’)
    AND ( ( ( posts.post_title LIKE ‘%samsung%’)
    OR ( posts.post_excerpt LIKE ‘%samsung%’)
    OR ( posts.post_content LIKE ‘%samsung%’ )
    OR ( postmeta.meta_key = ‘_sku’
    AND postmeta.meta_value LIKE ‘%samsung%’ ) ))
    ORDER BY posts.post_parent ASC, posts.post_title ASC

    
    ### WordPress Environment ###
    
    Home URL: http://domain.com
    Site URL: http://domain.com
    WC Version: 3.4.4
    Log Directory Writable: ✔
    WP Version: 4.9.7
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.2.6
    PHP Post Max Size: 1 GB
    PHP Time Limit: 180
    PHP Max Input Vars: 1000
    cURL Version: 7.54.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.39-cll-lve
    Max Upload Size: 1,000 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.4.4
    WC Database Prefix: wp4c_
    Total Database Size: 477.80MB
    Database Data Size: 411.07MB
    Database Index Size: 66.73MB
    wp4c_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
    wp4c_woocommerce_attribute_taxonomies: Data: 0.03MB + Index: 0.03MB
    wp4c_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp4c_abj404_redirects: Data: 0.00MB + Index: 0.02MB
    wp4c_amz_assets: Data: 0.55MB + Index: 0.21MB
    wp4c_amz_cross_sell: Data: 0.15MB + Index: 0.01MB
    wp4c_amz_products: Data: 0.15MB + Index: 0.16MB
    wp4c_amz_queue: Data: 0.00MB + Index: 0.00MB
    wp4c_amz_search: Data: 0.00MB + Index: 0.00MB
    wp4c_cegg_autoblog: Data: 0.01MB + Index: 0.00MB
    wp4c_cegg_price_alert: Data: 0.00MB + Index: 0.01MB
    wp4c_cegg_price_history: Data: 0.71MB + Index: 0.99MB
    wp4c_commentmeta: Data: 0.42MB + Index: 0.02MB
    wp4c_comments: Data: 0.40MB + Index: 0.03MB
    wp4c_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wp4c_lgp_posts: Data: 0.15MB + Index: 0.00MB
    wp4c_links: Data: 0.03MB + Index: 0.02MB
    wp4c_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wp4c_mclean_refs: Data: 12.08MB + Index: 5.45MB
    wp4c_mclean_scan: Data: 0.00MB + Index: 0.00MB
    wp4c_mts_locker_stats: Data: 0.00MB + Index: 0.00MB
    wp4c_options: Data: 15.48MB + Index: 1.03MB
    wp4c_pmxi_files: Data: 0.00MB + Index: 0.00MB
    wp4c_pmxi_history: Data: 0.00MB + Index: 0.00MB
    wp4c_pmxi_imports: Data: 0.23MB + Index: 0.00MB
    wp4c_pmxi_posts: Data: 0.10MB + Index: 0.02MB
    wp4c_pmxi_templates: Data: 0.42MB + Index: 0.00MB
    wp4c_postmeta: Data: 314.38MB + Index: 23.82MB
    wp4c_posts: Data: 61.51MB + Index: 28.63MB
    wp4c_price_alert: Data: 0.00MB + Index: 0.00MB
    wp4c_price_evolution: Data: 0.17MB + Index: 0.12MB
    wp4c_queue: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi_log: Data: 0.00MB + Index: 0.00MB
    wp4c_relevanssi_stopwords: Data: 0.00MB + Index: 0.00MB
    wp4c_tdrd_redirection: Data: 0.12MB + Index: 0.01MB
    wp4c_termmeta: Data: 0.15MB + Index: 0.10MB
    wp4c_terms: Data: 0.18MB + Index: 0.32MB
    wp4c_term_relationships: Data: 2.88MB + Index: 5.18MB
    wp4c_term_taxonomy: Data: 0.21MB + Index: 0.18MB
    wp4c_usermeta: Data: 0.11MB + Index: 0.06MB
    wp4c_users: Data: 0.02MB + Index: 0.05MB
    wp4c_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp4c_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp4c_woocommerce_termmeta: Data: 0.00MB + Index: 0.00MB
    wp4c_yoast_seo_links: Data: 0.25MB + Index: 0.08MB
    wp4c_yoast_seo_meta: Data: 0.18MB + Index: 0.17MB
    
    ### Post Type Counts ###
    
    aal_auto_insert: 2
    aal_button: 1
    amazon_auto_links: 2
    attachment: 22044
    content-locker: 2
    coupons: 1217
    custom_css: 1
    easy_affiliate_link: 5
    fetch_tweets: 3
    inc_popup: 1
    jp_img_sitemap: 13
    jp_img_sitemap_index: 1
    jp_sitemap: 4
    jp_sitemap_index: 1
    jp_sitemap_master: 1
    mts_notification_bar: 1
    nav_menu_item: 119
    oembed_cache: 84
    opanda-item: 4
    page: 23
    polylang_mo: 1
    post: 7949
    product: 12994
    pt_view: 1
    revision: 66
    safecss: 1
    schema: 2
    tablepress_table: 22
    thirstylink: 1
    wc_product_retailer: 20
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (16) ###
    
    Query Monitor: by John Blackbourn & contributors – 3.1.0
    Accelerated Mobile Pages: by Ahmed Kaludi
    Mohammed Kaludi – 0.9.97.8
    
    Akismet Anti-Spam: by Automattic – 4.0.8
    Bulk Move: by Sudar – 1.3.0
    Content Egg Pro: by keywordrush.com – 4.6.1
    Cuelinks - Affiliate Marketing Tool: by Cuelinks – 1.0.0
    Delete Expired Transients: by LittleBizzy – 1.0.2
    Jetpack by WordPress.com: by Automattic – 6.3.2
    MyThemeShop Connect: by MyThemeShop – 2.0
    SSL Insecure Content Fixer: by WebAware – 2.7.0
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.14.12
    
    W3 Total Cache: by Frederick Townes – 0.9.7
    WC Speed Drain Repair: by WP Fix It – 1.2 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.4.4
    Yoast SEO: by Team Yoast – 7.9
    WP External Links: by Victor Villaverde Laan – 2.2.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: INR (₹)
    Currency Position: left
    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)
    
    ### WC Pages ###
    
    Shop base: #3798 - /shop/
    Cart: #64935 - /cart/
    Checkout: #64936 - /checkout/
    My account: #3801 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: incognito
    Version: 1.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Coupon by MyThemeShop
    Parent Theme Version: 2.0.7
    Parent Theme Author URL: http://mythemeshop.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: mts_coupon/woocommerce/archive-product.php
    mts_coupon/woocommerce/single-product.php
    
    
    Thread Starter DiscountDukan

    (@techjockey)

    @narinder-singh Thank you for resolving the issue. One more issue i would like to bring to your notice.

    if you keep the ticker at the “bottom” it does not display well…

    http://ovo.li/WEy8av

    same here… http://ovo.li/HB7NqP

    Thread Starter DiscountDukan

    (@techjockey)

    Thank you @sudar

    I will test and get back to you.

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