WassUp Real Time Analytics
Error installing WassUp tables. (2 posts)

  1. mphacker
    Posted 4 years ago #

    I am running WordPress 3.2.1 on Windows Server 2008 R2 (IIS) with a SQL 2008 R2 backend.

    When trying to install this plug-in I receive the following error:
    Error installing WassUp tables.

    Do you have any plans to support WordPress running on SQL?



  2. mphacker
    Posted 4 years ago #

    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?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic