Skip to content

Error while activating plugin wp-statistics #115

@0xFEEDC0DE64

Description

@0xFEEDC0DE64

WP Version: 6.5
PG4WP Version: latest master

---------------------
[1712768022.327] Error running :

					CREATE TABLE wp_statistics_useronline (
						ID bigint(20) NOT NULL AUTO_INCREMENT,
	  					ip varchar(60) NOT NULL,
						created int(11),
						timestamp int(10) NOT NULL,
						date datetime NOT NULL,
						referred text CHARACTER SET utf8 NOT NULL,
						agent varchar(255) NOT NULL,
						platform varchar(255),
						version varchar(255),
						location varchar(10),
						`user_id` BIGINT(48) NOT NULL,
						`page_id` BIGINT(48) NOT NULL,
						`type` VARCHAR(100) NOT NULL,
						PRIMARY KEY  (ID)
					) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
---- converted to ----
CREATE TABLE IF NOT EXISTS wp_statistics_useronline (
					 "ID" bigserial,
	  					ip varchar(60) NOT NULL,
						created int,
						"timestamp" int NOT NULL,
						"date" timestamp NOT NULL,
						referred text NOT NULL,
						agent varchar(255) NOT NULL,
						platform varchar(255),
						version varchar(255),
						location varchar(10),
						user_id BIGINT(48) NOT NULL,
						page_id BIGINT(48) NOT NULL,
						type VARCHAR(100) NOT NULL,
						PRIMARY KEY  ( "ID" )
					);
----> FEHLER:  Syntaxfehler bei »(«
LINE 12:       user_id BIGINT(48) NOT NULL,
                             ^
---------------------

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions