aiosep DB error

Resolved icetechy
(@icetechy)

3 years, 5 months ago

Hi,

I am getting the error below each time I download a fresh a copy of aioseo plugin and activate. The error is also displaying at header of my front and backend even though wp-congig debug is not set to true.

Below is the error:

WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
SELECT key, value FROM wp_aioseo_cache WHERE 1 = 1 AND ( expiration IS NULL OR expiration > ‘2022-12-05 13:37:16’ ) AND key = ‘attachment_url_to_post_id_d99ed2ddbeefba28910cca4100f73b401b38bc49’ /* 1 = 1 */
WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
INSERT INTO trgpd4_aioseo_cache SET key = ‘attachment_url_to_post_id_d99ed2ddbeefba28910cca4100f73b401b38bc49’, value = ‘s:4:\”none\”;’, expiration = ‘2022-12-06 13:37:16’, created = ‘2022-12-05 13:37:16’, updated = ‘2022-12-05 13:37:16’ ON DUPLICATE KEY UPDATE value = ‘s:4:\”none\”;’, expiration = ‘2022-12-06 13:37:16’, updated = ‘2022-12-05 13:37:16’ /* 1 = 1 */
WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
SELECT key, value FROM wp_aioseo_cache WHERE 1 = 1 AND ( expiration IS NULL OR expiration > ‘2022-12-05 13:37:16’ ) AND key = ‘addons’ /* 1 = 1 */
WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_aioseo_cache
WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_aioseo_cache

WordPress database error: [Table ‘wp_aioseo_cache’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_aioseo_cache

Viewing 5 replies - 1 through 5 (of 5 total)

Thread Starter icetechy
(@icetechy)

3 years, 5 months ago
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 */
```
Plugin Support MM Aurangajeb
(@aurangajeb)

3 years, 5 months ago
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 3 years, 5 months ago by MM Aurangajeb.
Plugin Support Steve M
(@wpsmort)

3 years, 5 months ago

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!

Thread Starter icetechy
(@icetechy)

3 years, 5 months ago

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.

Thread Starter icetechy
(@icetechy)

3 years, 5 months ago

Hi thank you it worked like a charm! 🙂