travelavenger

It seems that the error is gone in a site with category, it might be better to check the existence of $faq_category_options and other place with similar situation before using it

if(!empty($faq_category_options)){

……

}

Thank you for the follow up!

Hi there,

thank you for the follow up, could you add the icon of “Xiaohongshu”

https://en.wikipedia.org/wiki/Xiaohongshu

which is very popular now in China

Thank you!

I solved the issue by running the following sql at phpmyadmin:

ALTER TABLE wp_actionscheduler_actions
ADD priority tinyint(10) unsigned NOT NULL;

which will create the missing column.

Hope this helps and hope the woocommerce team could make use of this and add a fix in the future version

Hi there,

Thank you for the solution, I have several wordpress site in the server, just want to confirm if I should run the command at the root folder of the wordpress haing the issue and it will not affect the other sites?

Thank you!

Hi there,

thank you for the advise. Understand that reinstall woocommerce will create any missing tables in the database, but in my case it is missing a “column” within a table, would that fix the issue as well?

Also, since the function WooCommerce > Status > Tools > Update Database doesn’t work in some cases, would it be fixed in the future version? Maybe add some more checking and included more condition in order to update the database.

Thank you!

Hi there,

Thank you for the advise, but the table schema remains the same after clicking the update tables. and at apache error log when I click the update table button:

PHP Warning: Undefined property: stdClass::$priority in …………/plugin/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 379

Wondering if there is any reference I could find out the tables’ schema of version 7.9 or a sql could add the column ‘priority’ in table ‘field list’ ?

Many thank for your help!

Thank you for your advise, but how come I have no issue with 7.82 and version prior but only has this fatal issue with 7.9?

Thank you again!

The problem occur when I click on the product tab at admin panel, ie to show all the products.

And the error is in the apache as shown in the previous message, sorry the company does not allow me to send out the system report, is it possible to fix from the information provided?

Thank you!

I down graded back to 7.8.2 and has no issue. 7.9 definitely has some issue

more information for there is another error:

WordPress database error Unknown column ‘priority’ in ‘order clause’ for query UPDATE wp_actionscheduler_actions SET claim_id=2596, last_attempt_gmt=’xxxxx’, last_attempt_local=’xxxxx’ WHERE claim_id = 0 AND scheduled_date_gmt <= ‘xxxxxx’ AND status=’pending’ ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT 25 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->claim_actions

Hey there,

Thank you for your reply. Wondering if it is possible to have an update which supports Chinese or other non Latin characters without changing the setting on the server in the future? Most of the hosting are shared and it is not possible to change the setting.

This plugin is useful but if it does not Chinese or other non Latin characters, it will lost a lot of users.

Thank you!!

Hi there,

Its a great plugin, hope you could include order by title for free in the future as order by date only is very restricted.

thank you!

Thank you for the solution, but the order by setting only available for pro user, would you consider to make the order by setting for free?

Hi there,

not working, but it says disabled on the server, should I enable it first? If so, how to do so?

Thank you!

Hi there,

Thank you for the follow up. I tested again and it works. the problem is that the search result ranks post title begins with “A Mx” very low and ranks post title with “%%%A Mx%%%” at the very beginning. Therefore the expected search result is not showing at the first page.

Logically speaking, the search result should order results with search keyword at the beginning within the post title first than at the back, is it possible to fix that?

Thank you for your help!