Dokan Plugin – Orders not showing

This topic contains 8 reply and 3 voices, and was last updated by Sekander Badsha 10 years ago
Viewing 8 Posts - 1 through 8 (of 8 total)
Author Posts
October 23, 2014 at 3:24 pm 28944
Sekander Badsha Hello. Just bought the Plugin. Running WP 4.0, Woo 2.2.7, Dokan 1.1, Theme is Vantage (Woo support declared). Bug: When I buy a product, via Paypal (no sandbox) or simulate it with Direct Bank Transfer, I can see the order in the Administration Area / Dashboard / Woocommerce / Orders tab. From there, as an admin, I can do whatever i want: process, delete, complete, etc etc. But when I log in as the vendor who is selling the product, I don't see any order in the dashboard!!!!!! I tried multiple times, and it doesn't work. What should I do? EDIT: website is running on microsoft Azure, and wordpress is running on SQL SERVER, not MYSQL. I wonder if the query in order-functions.php line 18 
SELECT do.order_id, p.post_date
                FROM {$wpdb->prefix}dokan_orders AS do
                LEFT JOIN $wpdb->posts p ON do.order_id = p.ID
                WHERE
                    do.seller_id = %d AND
                    p.post_status != 'trash'
                    $status_where
                GROUP BY do.order_id
                ORDER BY p.post_date DESC
                LIMIT $offset, $limit"
is the problem
October 23, 2014 at 4:07 pm 28947
Roberto Roberto

Update: I entered the SQL php admin (or alike) of windows Azure. And I can’t see the dokan_* tables.

This is probably due to the fact that they get created in a syntax that SQL doesn’t recognize.
Can you please help me out with this?

October 26, 2014 at 11:18 pm 29108
Sekander Badsha Sekander Badsha

Hello Roberto,

I will discuss this issue with the developer team. If we can reproduce the issue, I will get back to you with a solution.

In the mean time, you can try on Apache or Nginx with MySQL. I believe everything should work fine.

Thank you for having patience 🙂

October 27, 2014 at 3:45 am 29114
Roberto Roberto

Hello.

I created another topic about this cause i figured it out.
Basically the SQL query syntax used for the queries all over the plugin is not compatible with SQL Server.
I am pretty sure to “abstract” the queries in order for WP to be run on several database engine, the queries have to be written in a particular way.

That said, of all the plugins I am using right now, Dokan is the only one which does not work on SQL Server database.
This prevents a wordpress database to be run on an Azure service. Which is a big deal for me 🙂

October 27, 2014 at 12:01 pm 29123
Sk Sk

Hello Roberto,

Please provide your login details by using this form -http://wedevs.com/provide-login-details/. I will have a look what is going wrong.

Thank you 🙂

October 27, 2014 at 2:11 pm 29135
Roberto Roberto

I sent the login details.

As you can see, there are orders in woocommerce (1 made just a few minutes ago) but the vendor who’s selling that item is not seeing anything on his dashboard.

I activated the debug mode of wordpress but if you want i can deactivate it.

Cheers

October 27, 2014 at 3:12 pm 29147
Sk Sk

hi,

I am getting an error in your site.
[php]WordPress database error: [23000 : [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint ‘wp_options_option_name’. Cannot insert duplicate key in object ‘dbo.wp_options’. The duplicate key value is (rewrite_rules).][/php]

please check your site by deactivate all plugins include “dokan” and “woocommerce”. See if the problem still there.
we think this problem causes by either your theme or hosting server.

thank you.

October 27, 2014 at 5:01 pm 29157
Roberto Roberto

The problem arises when i activate Woocommerce.
Seems like it is their problem with the queries (onduplicate key maybe is not supported by sql server??)

Seemss to be a problem given by the permalink structure
I am confused :/

October 29, 2014 at 12:00 pm 29303
Sekander Badsha Sekander Badsha

Hello Roberto,

We are suspecting your server. Please change your hosting server and check.

Viewing 8 Posts - 1 through 8 (of 8 total)
Coupon
Coupons