The variations are hidden after update 3.0.1

  • Resolved stanconstantin

    (@stanconstantin)


    7 years, 7 months ago

    I have woocommerce 3.0.1 and Flatsome 3.3.2
    I have a problem also with my variations. After the update, I have lost all my variations. They were working but couldn’t see them. So I deleted them all and re-built them. But then, the same problem, they were working, but couldn’t see them and couldn’t modify them, so if I wanted to change the stock, that was impossible.
    So I have applied the code that “Mike Jolley” gaved, in the SQL, (wordpress base) to recover the variations from trash, that worked once, so I could change some stock, but when I was back to change another time some variations, the same problem, the variations are there, they are working, but couldn’t see them or change them. So I wanted to apply another time that code, but now, this time, it’s not working anymore.
    I don’t know what to do???
    Could anyone help? I don’t have the time and the will to create each time the variations, and beside that it’s impossible, I have to re-do my stock each time.

Viewing 15 replies - 1 through 15 (of 34 total)
  • Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    https://www.ads-software.com/support/topic/before-posting-gather-the-following-details/

    It’s probably not the SQL issue and more a display issue with the theme.

    Thread Starter stanconstantin

    (@stanconstantin)

    
### WordPress Environment ###

Home URL: https://lidiacrochettricot.com
Site URL: https://lidiacrochettricot.com
WC Version: 3.0.1
Log Directory Writable: ?
WP Version: 4.7.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: fr_FR

### Server Environment ###

Server Info: Apache
PHP Version: 7.0.16
PHP Post Max Size: 64 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.19.7
NSS/3.27.1

SUHOSIN Installed: –
MySQL Version: ? 5.5.51 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.0.1
WC Database Prefix: wp_
woocommerce_sessions: ?
woocommerce_api_keys: ?
woocommerce_attribute_taxonomies: ?
woocommerce_downloadable_product_permissions: ?
woocommerce_order_items: ?
woocommerce_order_itemmeta: ?
woocommerce_tax_rates: ?
woocommerce_tax_rate_locations: ?
woocommerce_shipping_zones: ?
woocommerce_shipping_zone_locations: ?
woocommerce_shipping_zone_methods: ?
woocommerce_payment_tokens: ?
woocommerce_payment_tokenmeta: ?
MaxMind GeoIP Database: ?

### Security ###

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

### Active Plugins (28) ###

Advanced Custom Fields Multilingual: by OnTheGo Systems – 0.4
Contact Form 7: by Takayuki Miyoshi – 4.7
Iupay WooCommerce: by Redsys – 2.8.3
MOJO Marketplace: by Mike Hansen – 1.1.3
Newsletter: by Stefano Lissa & The Newsletter Team – 4.8.9
Nextend Facebook Connect: by Nextendweb – 2.0.2
Nextend Google Connect: by Roland Soos
Jamie Bainbridge – 1.6.1

Ninja Forms: by The WP Ninjas – 3.0.31
Redsys WooCommerce: by Redsys – 2.8.4
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6
WPML Multilingual CMS: by OnTheGoSystems – 3.6.3
SSL Insecure Content Fixer: by WebAware – 2.2.3
Booster for WooCommerce: by Algoritmika Ltd – 2.6.0
WooCommerce Multilingual: by OnTheGoSystems – 4.1.2
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 1.6.2
WooCommerce: by Automattic – 3.0.1
WooSidebars: by WooThemes – 1.4.3
Yoast SEO: by Team Yoast – 4.6
WP Speed of Light: by JoomUnited – 1.3.0
WP Super Cache: by Automattic – 1.4.9
WPML All Import: by OnTheGoSystems – 2.0.3
WPML CMS Nav: by OnTheGoSystems – 1.4.19
WPML Media: by OnTheGoSystems – 2.1.24
WPML Page Builders: by OnTheGoSystems – 1.0.0
WPML Sticky Links: by OnTheGoSystems – 1.4.0
WPML String Translation: by OnTheGoSystems – 2.5.2
WPML Translation Management: by OnTheGoSystems – 2.2.7
YITH WooCommerce Wishlist: by YITHEMES – 2.1.0

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: EUR (€)
Currency Position: right
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

### WC Pages ###

Shop base: #10 - /magasin/
Cart: #11 - /panier/
Checkout: #12 - /checkout/
My account: #13 - /mon-compte/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.3.2
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-product_cat.php
flatsome/woocommerce/content-single-product.php
flatsome-child/woocommerce/emails/admin-cancelled-order.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/orderby.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
    Thread Starter stanconstantin

    (@stanconstantin)

    And my link is https://lidiacrochettricot.com

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Which product is broken?

    Thread Starter stanconstantin

    (@stanconstantin)

    I give you an example : Batik (Yarn, Fantasy yarn), but not only this one, the Perlé Cotton also (in Shop/Cotton/Perlé). And some others.

    Thread Starter stanconstantin

    (@stanconstantin)

    Clients can order, and choose the variation, and buy it, but I can’t modify it.

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    So it’s the edit screen? Can you screenshot what you see there?

    Thread Starter stanconstantin

    (@stanconstantin)

    https://www.dropbox.com/s/6trvxqzrikbonxx/Sans%20titre.jpg?dl=0

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    In chrome, look at View > Developer > Javascript console. Any errors shown?

    Thread Starter stanconstantin

    (@stanconstantin)

    https://www.dropbox.com/s/jzqxaqvh5c8g8tw/3.jpg?dl=0
    https://www.dropbox.com/s/xywgguyzmda8sn8/4.jpg?dl=0

    Maybe this? I don’t know what to look.

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Open that console up when editing the product.

    Thread Starter stanconstantin

    (@stanconstantin)

    https://www.dropbox.com/s/sl2rar7mvoakzbj/6.jpg?dl=0
    https://www.dropbox.com/s/21jliihzf2jdug9/5.jpg?dl=0

    No error there.

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Ok, they are trashed I can see in the source. Run that SQL again. Then save the product and see if they remain? 3.0.0 had the bug which trashed them.

    Thread Starter stanconstantin

    (@stanconstantin)

    I’ve executed the SQL code that I Have UPDATE wp_posts SET post_status = ‘publish’ WHERE post_type = ‘product_variation’ AND post_status = ‘trash’;
    Deleted the cache, updated the product, and still can’t see the variations. They are there but cannot edit them.

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Did you confirm the SQL actually ran and your table is called wp_posts? Prefix may differ.

Viewing 15 replies - 1 through 15 (of 34 total)
  • The topic ‘The variations are hidden after update 3.0.1’ is closed to new replies.