database error on install

  • Resolved infernoprime

    (@infernoprime)


    3 years, 3 months ago

    I switched back to All in One Seo and I get this:

    WordPress database error: [Unknown column 'new' in 'where clause']
SELECT * FROM cms_aioseo_notifications WHERE 1 = 1 AND <code>dismissed</code> = 0 AND <code>new</code> = 1 AND (start <= '2021-12-15 21:33:44' OR start IS NULL) AND (end >= '2021-12-15 21:33:44' OR end IS NULL) ORDER BY start DESC, created DESC /* 1 = 1 */

WordPress database error: [Unknown column 'new' in 'where clause']
UPDATE cms_aioseo_notifications SET <code>new</code> = 0 WHERE 1 = 1 AND <code>new</code> = 1 /* 1 = 1 */
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Steve M

    (@wpsmort)

    Hi @infernoprime, Can you please add the below code on your website using the Code Snippet plugin? After adding the code, refresh your WordPress Dashboard and it will fix the problem for you.

    
<pre><code>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();
	}
}

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

    • This reply was modified 3 years, 3 months ago by Steve M.
    Thread Starter infernoprime

    (@infernoprime)

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database error on install’ is closed to new replies.