DodoDog
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Database errorsHello, I just checked the server log files and I have a somewhat similar WordPress database error. I use WordPress 4.8.1 and WooCommerce version 3.1.0 (will update to latest version of WC today). I use a theme based on Underscores.
[Sun Aug 06 06:34:07 2017] [error] [client 68.180.228.216] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 1′ at line 1 for query SELECT wp_comments.* FROM wp_comments AND comment_type != ‘webhook_delivery’ ORDER BY comment_date_gmt DESC LIMIT 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
Is this a theme problem that causes the database error? I’m new to these things, any help is very much appreciated, thank you!
Hello Oscar,
thank you so much for the update, I just installed and tested WooCommerce Price Based on Country Version 1.6.13 and it’s working great! The prices are showing up like they should again.
Can’t thank you enough for your help 😉
Have a great day, EvaHi Oscar,
correct, EU 31,092437 is the regular price for EU countries and the VAT/Tax (19%) is added in the front end. This adds up to EU 37,00 in total.
Thank you for your time, much appreciated!
EvaHello Oscar,
thank you so much for your swift reply!I hope to answer your questions correctly, here’s the info:
1. Exchange rate:
doesn’t apply, this order is in Euro’s and the base currency of the shop is euro’s2. Product price:
Regular price € 31,092437 (price excluding tax 19%)
Price including VAT € 37,003. Shipping costs:
Shipping € 6.302521 (price excluding tax 19%)
Shipping including VAT: € 7.50Also handy to know, these options are selected:
Enable taxes and tax calculations
Set prices manuallyPlease let me know if you need more info. Thanks a million!
EvaForum: Plugins
In reply to: [WooCommerce] WC 3.0 and orders’ Custom fieldsHello Lyonbeton, going back to Woocommerce 3.0.1 is not really an option. Especially WC should be last updated version, security reasons plus all the template adjustments that had to be made,… Still hope to find a better solution for the WC plus custom field problems. Will let you know if I find one ofcourse!
Cheers, EvaForum: Plugins
In reply to: [WooCommerce] WC 3.0 and orders’ Custom fieldsHello,
looking for an answer for the same problem,… Once the ACF field is filled in on the WooCOmmerce order page and you want to change the value, the changes are not saved. In short, it’s impossible to change the ACF fields on the WooCommerce order page. This is very unhandy!I use:
WordPress 4.7.5
WooCommerce Version 3.0.5
ACF Version 4.4.11I hope someone has found a solution for this problem, your help is really appreciated. Thank you for your time!
Thank you so much purbeckpixels, your answer totally solved the problem! The featured products list exactly how they should, marking products as featured in the admin as well. I’m so gratefull you took the time to help out, a HUGE thank you to you!
EvaAnd topic resolved ofcourse
Hello Oscar,
it works! Updated WooCommerce to version 2.4.8 and updated Product Price Based on Countries to version 1.4.2.
All prices show correctly.Thank you so much Oscar for your excellend support! You made my day.
Cheers DodoDogHello Oscar,
yes I did clear the WC Transients but that didn’t solve the problem.
I also checked if the prices displayed correctly when using another template after upgrading WooCommerce to 2.4.7. That didn’t work either.
The only thing taht worked so far was going back to WooCommerce version 2.4.6.I wonder what causes the price display problem for variable products after upgrading WooCommerce. Getting pretty desperate, your help is very much appreciated, thank you!