Support » Plugin: WooCommerce » upgrading to WP 3.6 breaks variables

  • I am trying to upgrade a site to WP 3.6, but as soon as I upgrade it breaks the variations of a product. However, sometimes it works perfectly!

    This is my test site: http://www.123club.co.uk/blog/shop/supreme-memory-1000-2/

    I have activated theme twenty thirteen and deactivated all unnecessary plugins and the problem still occurs.

    When the problem occurs “Clear selection”, below the option drop-downs, does not hide but remains visible even if no selections have been made. If you then choose options the price does not appear and clicking the clear selection does not clear them!

    I have an open ticket with WooCommerce, but they said they could not reproduce the problem.

    I have asked several people here in the UK to look, and they have all seen the problem, so it is not to do with my IP or connection.

    Hoping SOMEBODY can shed some light on this so I can upgrade 🙂

    http://wordpress.org/plugins/woocommerce/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Roy Ho

    (@splashingpixelscom)

    I don’t see any issue. I just went to your link and the product shows how it is supposed to. No “clear selection” until I selected a variation.

    Thread Starter babrees

    (@babrees)

    Hi SplashingPixels. Thanks for looking. I know it is a needle in a haystack, but this is causing a BIG problem for me as I am unable to update the live site.

    The problem is intermittent 🙁 I can view the site one day and it will be working. Next day it won’t. I have tried in all browsers and it has been intermittent in all except Opera, where by every time I view the page it does NOT work. However, Woocommerce support told me that it worked for them. A real nightmare!

    I don’t suppose you have any suggestions on what I can do?

    Roy Ho

    (@splashingpixelscom)

    This is issue is definitely specific to you because your site indeed is not working probably in Opera but when I pull up one of my own sites, it works fine.

    I suggest you build a new testing site with ONLY WP and WC plugin and nothing else and re-test.

    Thread Starter babrees

    (@babrees)

    Many thanks.

    The link above for the test site is on twenty thirteen and only the necessary plugins, ie WC and two of their extensions, product enquiry form and table rate shipping. I stripped it back after the problem started showing on my custom theme. I also stripped the database of “left-over” plugins.

    To redo the main site from scratch will probably take about three months of solid inputting 🙁

    Now, I am VERY embarrassed to admit that I have only just noticed an error log file on the domain. Does the following make sense to you?

    [11-Sep-2013 01:43:45] WordPress database error Table 'club123_blog.2012wp09_woocommerce_tax_rates' doesn't exist for query
    			SELECT * FROM (
    				SELECT tax_rates.* FROM
    					2012wp09_woocommerce_tax_rates as tax_rates
    				LEFT OUTER JOIN
    					2012wp09_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
    				LEFT OUTER JOIN
    					2012wp09_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
    				WHERE
    					tax_rate_country IN ( 'GB', '' )
    					AND tax_rate_state IN ( '', '' )
    					AND tax_rate_class = ''
    					AND
    					(
    						(
    							locations.location_type IS NULL
    						)
    						OR
    						(
    							locations.location_type = 'postcode'
    							AND locations.location_code IN ('*','')
    							AND locations2.location_type = 'city'
    							AND locations2.location_code = ''
    						)
    						OR
    						(
    							locations.location_type = 'postcode'
    							AND locations.location_code IN ('*','')
    							AND 0 = (
    								SELECT COUNT(*) FROM 2012wp09_woocommerce_tax_rate_locations as sublocations
    								WHERE sublocations.location_type = 'city'
    								AND sublocations.tax_rate_id = tax_rates.tax_rate_id
    							)
    						)
    						OR
    						(
    							locations.location_type = 'city'
    							AND locations.location_code = ''
    							AND 0 = (
    								SELECT COUNT(*) FROM 2012wp09_woocommerce_tax_rate_locations as sublocations
    								WHERE sublocations.location_type = 'postcode'
    								AND sublocations.tax_rate_id = tax_rates.tax_rate_id
    							)
    						)
    					)
    				GROUP BY
    					tax_rate_id
    				ORDER BY
    					tax_rate_priority, tax_rate_order
    			) as ordered_taxes
    			GROUP BY
    				tax_rate_priority
    			 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/twentythirteen/page.php'), the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, WC_Shortcodes->cart, Woocommerce->shortcode_wrapper, call_user_func, WC_Shortcode_Cart::output, woocommerce_get_template, include('/plugins/woocommerce/templates/cart/cart.php'), WC_Cart->get_product_subtotal, WC_Product->get_price_excluding_tax, WC_Tax->get_shop_base_rate, WC_Tax->find_rates
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘upgrading to WP 3.6 breaks variables’ is closed to new replies.