[Plugin: wassup] Error installing WassUp tables.

Viewing 1 replies (of 1 total)
  • Thread Starter mphacker

    (@mphacker)

    I found out that if I create the database tables using SQL Server format before I activate the plug-in then it sort-of works.

    The main table I created:

    CREATE TABLE wp_wassup (
    id int NOT NULL identity,
    wassup_id varchar(60) NOT NULL,
    [timestamp] varchar(20) NOT NULL,
    ip varchar(50) default NULL,
    hostname varchar(150) default NULL,
    urlrequested text,
    agent varchar(255) default NULL,
    referrer text default NULL,
    search varchar(255) default NULL,
    searchpage int default 0,
    os varchar(15) default NULL,
    browser varchar(50) default NULL,
    "language" varchar(5) default NULL,
    screen_res varchar(15) default NULL,
    searchengine varchar(25) default NULL,
    spider varchar(50) default NULL,
    feed varchar(50) default NULL,
    username VARCHAR(50) default NULL,
    comment_author VARCHAR(50) default NULL,
    spam VARCHAR(5) default 0,
    url_wpid varchar(50) default NULL,
    CONSTRAINT pkid primary key(id),
    CONSTRAINT idx_wassup unique (wassup_id,[timestamp])
    );

    The spy visitors page seems to work but the visitor details and the current visitors online pages do not. If I get some time I may look into those issues. Anyone else with workarounds or fixes?

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: wassup] Error installing WassUp tables.’ is closed to new replies.