NOTICE: We've Moved to a Ticket System for Support
As of August 31, 2017 (12am EST) our support forums will be retired (read-only), and we will be moving to a support ticket system. This will allow us to better organize and answer support requests, and provide a more personalized experience as we assist our customers.
For the time being, we will leave our forums open for reading and learning while we work on creating a more robust Knowledge Base for everyone to use.
If you are a WC Vendors Pro customer please open a support ticket here. If you are a WC Vendors user please open a support ticket on the Wordpress.org forums.
The information on this forum is outdated and in most instances no longer relevant. Please be sure to check our documentation for the most up to date information.
Thank you to all of our customers!
- This topic has 16 replies, 5 voices, and was last updated 6 years, 8 months ago by
.
-
Posts
-
Hello, some of my vendors are experiencing a completely white vendor dashboard. Nothing loads, no charts, no orders, nothing. It is driving me insane. Other vendors have had no trouble using the dashboard and creating new products or viewing orders. Please help!
Hello,
Are you using the latest versions of WC Vendors (1.9.12) and WC Vendors Pro (1.4.4)?
Is it only vendors with many orders?I am on WC Vendors Version 1.9.11
and Pro Version Version 1.4.3Little scared to update because I think I have custom coding. But if you think it would fix it then ill do it.
Just updated both, unfortunately, it did not fix the problem. Disabling all plugins did not work either. It is very odd that this problem is only for certain vendors.
I found this in my error log, it seems relevant.
[02-Aug-2017 02:15:51 UTC] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Invalid order.’ in /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/woocommerce/includes/data-stores/abstract-wc-order-data-store-cpt.php:86
Stack trace:
#0 /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(143): Abstract_WC_Order_Data_Store_CPT->read(Object(WC_Order))
#1 /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-order.php(109): WC_Data_Store->read(Object(WC_Order))
#2 /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/wc-vendors-pro/public/class-wcvendors-pro-vendor-controller.php(259): WC_Abstract_Order->__construct(‘8167’)
#3 /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/wc-vendors-pro/public/class-wcvendors-pro-reports-controller.php(67): WCVendors_Pro_Vendor_Controller::get_orders2(538)
#4 /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/p in /home/97249.cloudwaysapps.com/ckwswhnmwp/public_html/wp-content/plugins/woocommerce/includes/data-stores/abstract-wc-order-data-store-cpt.php on line 86@bantanaaudio
Hello,
thank you– I will need to work with our lead developer on this when he returns. I will update you asapHello,
Once our lead developer returns I will discuss this with him and update with any information.@bantanaaudio
Have you deleted any orders without first reversing commission for the order?
If the system is still trying to access orders that were deleted but may have been still “due” commission, this can cause errors.
If you have deleted orders without reversing the commissions, you can go to your phpmyadmin in the database, find the pv_commissions table, and drop any lines from deleted orders from that table in your database.So I have found that each of the vendors experiencing a white dashboard all have orders that seem to be corrupted. I have attached an image that shows examples of these orders from different vendors. All are missing commission values order numbers and various other things. I have no idea how to delete these through MyPHPAdmin because I can’t find them.
Hello,
This is because the system is trying to create orders that have been deleted/trashed/some other weird status. If the order id’s don’t exist in the wp_posts table but are in the commissions table that is where the system is choking. I added code a long time ago that is supposed to fix the deletion of orders from killing the system.
You will have to clean up your commissions table with some SQL.
Instructions:
1. READ THE COMMENTS IN THE FILE
2. ONLY RUN THE FIRST COMMAND, DO NOT RUN BOTH.
3. IF FIRST COMMAND DOESN’T WORK, THEN USE THE SECOND COMMAND.This is the code:
https://gist.github.com/digitalchild/6c6ac086e1a08fd4e3befd7cc2b7e16f
DO NOT RUN THIS ON YOUR LIVE SITE WITHOUT TESTING IT ON A STAGING SERVER. YOU HAVE BEEN WARNED!!!!!!!!!
cheers,
Jamie.
I tried this code (I have been experiencing the same problem now for months) and it didn’t work.
” 0 rows affected. (Query took 0.0789 seconds.)”
Anything else that might work? I have tried everything that you have said (in my separate thread).
Thanks
- The forum ‘WC Vendors Pro Support’ is closed to new topics and replies.