Can’t login after Auto WordPress update

Hi,

Sorry about the delay.

Some how one of the AIOS database tables appears to have been removed.

Are you able to confirm if this is the case via PHPMyAdmin or similar?

Best Wishes,

Ashley

I have acces to PHPMyAdmin what do i need to look for?

Hi @footstepsdesign

Can you please cross check if in phpMyAdmin the table s7gn_aiowps_logged_in_users is there or not if yes and it is not corrupted you should see the rows if any.

If table is not there please try create table using below query you can add table

CREATE TABLE s7gn_aiowps_logged_in_users (
			id bigint(20) NOT NULL AUTO_INCREMENT,
			user_id bigint(20) NOT NULL,
			username varchar(60) NOT NULL DEFAULT '',
			ip_address varchar(45) NOT NULL DEFAULT '',
			site_id bigint(20) NOT NULL,
			created integer UNSIGNED,
			expires integer UNSIGNED,
			PRIMARY KEY (id),
			UNIQUE KEY unique_user_id (user_id),
			INDEX created (created),
			INDEX expires (expires),
			INDEX user_id (user_id),
			INDEX site_id (site_id)
			) 

Regards

Solved! Thank you. Really excelling support.

Do you know what may have caused this table to be dropped?

I have not done this intentionally and to my knowledge noon has ben in phpMyAdmin for set time.

Hi @footstepsdesign

It might be some issue while updating the plugin some how this new table not created. It should not be the general case.

Do you have any php log enabled? It might be there is create table error logged.

Regards