Home Forums Theme Support Dokan Dokan Plugin – Orders not showing

This topic is: not resolved

This topic contains 8 replies, has 3 voices, and was last updated by  Sekander Badsha 4 years, 7 months ago.

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #28944

    Roberto
    Member
    Post count: 59

    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

    #28947

    Roberto
    Member
    Post count: 59

    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?

    #29108

    Sekander Badsha
    Member
    Post count: 2067

    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 ๐Ÿ™‚

    #29114

    Roberto
    Member
    Post count: 59

    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 ๐Ÿ™‚

    #29123

    Sk
    Moderator
    Post count: 371

    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 ๐Ÿ™‚

    #29135

    Roberto
    Member
    Post count: 59

    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

    #29147

    Sk
    Moderator
    Post count: 371

    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.

    #29157

    Roberto
    Member
    Post count: 59

    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 :/

    #29303

    Sekander Badsha
    Member
    Post count: 2067

    Hello Roberto,

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

Viewing 9 posts - 1 through 9 (of 9 total)

The topic ‘Dokan Plugin – Orders not showing’ is closed to new replies.