yeah just noticed that comment here removed the back ticks..
Glad that you could get it sorted.
Anybody else coming to this thread, please put back ticks around “key” and “type” in below query, then it should work.
CREATE TABLE wp_statistics_historical (
key bigint(20) NOT NULL,
type varchar(25) NOT NULL,
id bigint(20) NOT NULL,
uri varchar(255) NOT NULL,
value bigint(20) NOT NULL,
PRIMARY KEY (ID),
KEY type (type),
UNIQUE KEY id (id),
UNIQUE KEY uri (uri)
)
My WP Statistics stopped working after the update. Run following SQL and it’s all working now.
CREATE TABLE wp_statistics_historical (
key bigint(20) NOT NULL,
type varchar(25) NOT NULL,
id bigint(20) NOT NULL,
uri varchar(255) NOT NULL,
value bigint(20) NOT NULL,
PRIMARY KEY (ID),
KEY type (type),
UNIQUE KEY id (id),
UNIQUE KEY uri (uri)
)
