Vendor registration not working

Hi,

Do you have enabled “Vendor Application Approval” option?

If so, then vendor will become a vendor user only after application approve by Admin.

You may enable vendor approval at global level from WCFM Admin Setting -> Vendor Registration

And at individual membership level as well.

Thank You

Hi,

vendor approval is enabled, no application shows up in “pending vendors”.

I also added a free basic membership and added a thank you page, still After registration I am NOT redirected to the “Thank you” page either.

Another thing, the “Become a Vendor” link on the registration page and dashboard redirects to “My account” but it does not submit the application.

• This reply was modified 5 years, 10 months ago by mezzatesta.
• This reply was modified 5 years, 10 months ago by mezzatesta.
• This reply was modified 5 years, 10 months ago by mezzatesta.

HI,

Another thing, the “Become a Vendor” link on the registration page and dashboard redirects to “My account” but it does not submit the application.

– Ahh .. main problem is here. please be sure “Registration” and “Membership” pages are set at WCFM Admin Setting -> Dashboard Pages

Thank You

Hi,
thanks for your reply.

I’ve set up the “Registration” and “Membership” pages and I am able to go through the whole registration process and land to the “thank you” page. Also receiving the email notification of the new application.

However, the pending application does not show up anywhere in the WCFM vendor list or the WP user list. Also, in “Notification” in WCFM vendors application does not show up.

I’m looking forward to your reply.

Thanks,
G

• This reply was modified 5 years, 9 months ago by mezzatesta.

could it be related to the followi error?

DataTables warning: table id=wcfm-messages – Invalid JSON response. For more information about this error, please see https://datatables.net/tn/1

Please check at wp-admin -> WooCommerce -> Status -> Logs -> fatal_erros log -> is any error generated?

there are several fatal errors for WCFM

what should I be looking for exactly?

Hi,

Kindly show me screenshot for those?

Between, are you using latest version of WCFM and WooCommerce ?

Thank You

hey,

Yes, both WC and WCFM are latest versions.

I think I’m getting closer. Find below the php error log, it refers to wcfm_messages – where I think the issue lies.

29-May-2019 06:12:38 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:13:40 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:13:40 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:14:39 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:14:39 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:15:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:15:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:16:40 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:16:40 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:17:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:17:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:18:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:18:41 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:19:42 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:19:42 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:20:56 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:20:56 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:21:44 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:21:44 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:22:46 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:22:46 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:24:02 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:24:02 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:24:55 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:24:55 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:26:10 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:26:10 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:26:46 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT COUNT(wcfm_messages.ID) FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing
[29-May-2019 06:26:46 UTC] WordPress database error Unknown column ‘message_type’ in ‘where clause’ for query SELECT wcfm_messages.* FROM wpnu_wcfm_messages AS wcfm_messages WHERE 1=1 AND is_direct_message = 1 AND message_type = ‘vendor_approval’ AND author_id != -1 AND NOT EXISTS (SELECT * FROM wpnu_wcfm_messages_modifier as wcfm_messages_modifier_2 WHERE wcfm_messages.ID = wcfm_messages_modifier_2.message AND wcfm_messages_modifier_2.read_by=1) ORDER BY wcfm_messages.ID DESC LIMIT 25 OFFSET 0 made by do_action(‘wp_ajax_wcfm_ajax_controller’), WP_Hook->do_action, WP_Hook->apply_filters, WCFM_Ajax->wcfm_ajax_controller, WCFM_Messages_Controller->__construct, WCFM_Messages_Controller->processing

Also, here’s the XHR response from the browser console

Path: admin-ajax.php

*******
{
“draw”: 5,
“recordsTotal”: ,
“recordsFiltered”: ,
“data”: []
}
****

Where “recordsTotal”: , and “recordsFiltered”: , Shows error with JSON validator, missing some value IMO

Please let’s get this sorted, it’s driving me crazy and need to restart the business.

Thanks

• This reply was modified 5 years, 9 months ago by mezzatesta.

Opps! how this? DO you have modified database tables manually?