Digital experiences for all disciplines
New Landing › How can we help? › Themeforest Theme Support › Dante › Database error with galleries and WooCommerce
New Landing › How can we help? › Themeforest Theme Support › Dante › Database error with galleries and WooCommerce
- This topic has 23 replies, 4 voices, and was last updated 10 years by Rui Guerreiro – SUPPORT.
-
Posted in: Dante
-
July 29, 2014 at 2:20 pm #95733
Hello,
i see this error on all woocommerce pages:WordPress database error: [Unknown column ‘wp_postmeta.meta_value’ in ‘order clause’]
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘galleries’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_author = 1 AND wp_posts.post_status = ‘private’) AND wp_posts.post_password = ” ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESCI’m not using galleries and i do not want them on WooCommerce.
I tried to disable the post type not including it. It appears both with child and parent theme.I found that if i remove the gallery shortcode declaration it disappear.
Please check.
Thank you!July 30, 2014 at 12:12 pm #96074Hi,
I am not able to see this error at any page. How can i see this error?
Thanks ๐
With Best Regards
Swift IdeasJuly 30, 2014 at 1:42 pm #96113Hello,
you can see it here: http://dev.ecomstore.net/baccoeperbacco/categoria-prodotto/spumanti-champagne/ or in any other WooCommerce page.Also, check the footer, it’s hude. I think its related to this error but i’m not really sure. I tried to add this code in wp-config.php
define('WP_DEBUG', true); ini_set('log_errors',TRUE); ini_set('error_reporting', E_ALL); ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
But it does not report any particular error related to this footer error.
I’m using a child theme but it appear also with plain Dante. Also i saw that more products are in the page, more the footer is big, in fact if i have only 2 products added in WooCommerce, i do not see this problem, it appears above 50 products in WooCommerce.
July 31, 2014 at 8:48 am #96314Hi,
Please provide me your login detail so i can check your setup.
Thanks ๐
With Best Regards
Swift IdeasJuly 31, 2014 at 9:52 am #96360This reply has been marked as private.July 31, 2014 at 10:58 am #96383Hi,
The developer of theme will assist you.
Thanks ๐
With Best Regards
Swift IdeasJuly 31, 2014 at 5:34 pm #96595Not seeing that error? All I see is:
Strict Standards: Redefining already defined constructor for class wpide in D:\xampp\htdocs\baccoeperbacco\wp-content\plugins\wpide\WPide.php on line 31
– Ed
August 1, 2014 at 9:22 am #96736Yes it’s because i disabled the gallery at all.
However there are 2 other problems now.Somebody f your support team installed WPIde on my website and now that Strict Standard error appear, also if i completely removed the plugin from the server.
The products slider do not work at all. If i click on the arrow the default link event is triggered instead.
August 1, 2014 at 11:08 am #96810Hi,
Can you show us the link of the product slider? Can’t find it.
Regarding the Wpide error, do you have any cache system in your server?
– Rui
August 1, 2014 at 1:33 pm #96858HI Rui,
you can find it here http://dev.ecomstore.net/baccoeperbacco/ and here http://dev.ecomstore.net/baccoeperbacco/landing/No i do not have any cache on the server
August 1, 2014 at 5:37 pm #96928Hi,
The Product slider issue is related to the child theme modifications. If you activate the parent Dante theme you will see that works fine.
Try to comment parts of the code and test the product slider until you find what modification is causing it.
-Rui
August 4, 2014 at 7:01 am #97245Hi Rui,
sure i never tought about this test. I’ll do it!What about the WPIde error? Did you find anything?
August 4, 2014 at 7:06 am #97248Hi,
Please uninstall WPIDE plugin to remove this error.
Thanks ๐
With Best Regards
Swift IdeasAugust 4, 2014 at 7:27 am #97253That’s the problem ๐
I did it and i also deleted the plugin, but the error is still thereAugust 4, 2014 at 7:50 am #97262Hi,
Please remove this directory wpide at D:\xampp\htdocs\baccoeperbacco\wp-content\plugins\.Thanks ๐
With Best Regards
Swift Ideas -
Posted in: Dante
You must be logged in and have valid license to reply to this topic.