‘date_modified’ column error

Hey @hugemagic,

Thank you for reaching out! It looks like one of the columns from the visits database tables is missing, thus the error.

Why this column is missing however, I can’t say, as we have not modified the structure of the visits database table these past few years.

Nevertheless, I believe that this following code will help:

function slicewp_custom_update_database_table_visits() {
	
	if ( ! function_exists( 'slicewp' ) ) {
		return;
	}
	
	if ( empty( $_GET['page'] ) || strpos( $_GET['page'], 'slicewp' ) !== 0 ) {
		return;
	}
	
	if ( empty( slicewp()->db['visits'] ) ) {
		return;
	}

	slicewp()->db['visits']->create_table();
	
}
add_action( 'admin_init', 'slicewp_custom_update_database_table_visits' );

Please copy the code and add it to your website. If you’re not sure how to add code snippets to your site, you can use the Code Snippets plugin (https://ww.wp.xz.cn/plugins/code-snippets/).

Once you add the code snippet to your website, please visit one of SliceWP’s admin page to trigger the code. The code will run automatically when you visit a SliceWP admin page. It will attempt to rebuild the visits database table.

Once you’ve visited a SliceWP admin page, you can go ahead and remove this code snippet, as it will not be required anymore. The database table should be rebuilt and it should contain the date_modified column.

Please try it out and let me know how it goes.

Thank you and best wishes,

Mihai