aiosep DB error

I managed to fix the wp_aioseo_cache error but I am still left with the error below.

nown column 'new' in 'where clause']
SELECT * FROM trgpd4_aioseo_notifications WHERE 1 = 1 AND <code>dismissed</code> = 0 AND <code>new</code> = 1 AND (start <= '2022-12-06 05:45:25' OR start IS NULL) AND (end >= '2022-12-06 05:45:25' OR end IS NULL) ORDER BY start DESC, created DESC /* 1 = 1 */

WordPress database error: [Unknown column 'new' in 'where clause']
UPDATE trgpd4_aioseo_notifications SET <code>new</code> = 0 WHERE 1 = 1 AND <code>new</code> = 1 /* 1 = 1 */

Hi @icetechy,

Thanks for reaching out, and I’m really sorry for the inconvenience caused!

Regarding the WordPress database error:

Could you please add the below code to your website using the WP Code plugin? After adding the code, refresh your WordPress Dashboard, and it should fix the problem for you.

add_action( 'admin_init', 'aioseo_add_notification_new_column' );
function aioseo_add_notification_new_column() {
	if ( ! method_exists( 'AIOSEO\Plugin\Common\Main\Updates', 'addNotificationsNewColumn' ) || ! method_exists( 'AIOSEO\Plugin\Common\Utils\Database', 'columnExists' ) ) {
		return;
	}
	if ( ! aioseo()->db->columnExists( 'aioseo_notifications', 'new' ) ) {
		aioseo()->updates->addNotificationsNewColumn();
	}
}

Here’s how you can add the code using the “WP Code” plugin: https://aioseo.com/docs/how-do-i-use-your-api-code-examples/

Please note you don’t need to keep this code on your site, so after refreshing your dashboard, please remove it.

Let me know how it goes or if you may need further assistance, and I will be happy to help!

Thanks!

• This reply was modified 2 years, 3 months ago by MM Aurangajeb.

Hi @icetechy,

We haven’t heard back from you in a couple of days. I’m going to go ahead and close this thread for now. But if you’d like us to assist, please feel welcome to continue the conversation.

Thanks!

Sorry I didn’t know that you have responded to my query. I will apply your solution and get back to you in a few.

Hi thank you it worked like a charm! ??