troglobyte

I´ll love to work in a SQL Server version but I barely have available time to make a stable version and give the support it deserves to keep the current quality standard.

Anyway I´ll try to make a SQL version and I´ll keep you informed about the progress and work required.

Thanks again for you support and the great plugin, of course 🙂

Looks like all the problems creating the tables are SQL Server syntax related. Here is the official SQL SErver distro:
http://wordpress.visitmix.com/download

We created the 3 missing tables with minimun changes (just one line each) in the SQL but we´re not sure it´ll work

[line 5] There is a problem with the KEY syntax, maybe this syntax will work with any database

CREATE TABLE msn43_slim_countries (
				ip_from INT DEFAULT 0,
				ip_to INT DEFAULT 0,
				country_code CHAR(2) DEFAULT '',
				CONSTRAINT ip_from_idx KEY (ip_from, ip_to)			);

[line 5] In Sql Server there is no boolean, the bit field is the most similar

CREATE TABLE msn43_slim_screenres (
				screenres_id SMALLINT NOT NULL IDENTITY(1,1),
				resolution NVARCHAR(12) COLLATE Latin1_General_BIN DEFAULT '',
				colordepth NVARCHAR(5) COLLATE Latin1_General_BIN DEFAULT '',
				antialias bit DEFAULT 0,
				CONSTRAINT [msn43_slim_screenres_screenres_id] PRIMARY KEY CLUSTERED (screenres_id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY];

[line 4] “user” is a SQL Server internal use registered word, you can use it with quotes but will be great to change it

CREATE TABLE msn43_slim_stats (
				id INT NOT NULL IDENTITY(1,1),
				ip INT DEFAULT 0,
				"user" NVARCHAR(255) COLLATE Latin1_General_BIN DEFAULT '',
				language NVARCHAR(5) COLLATE Latin1_General_BIN DEFAULT '',
				country NVARCHAR(2) COLLATE Latin1_General_BIN DEFAULT '',
				domain NVARCHAR(255) COLLATE Latin1_General_BIN DEFAULT '',
				referer NVARCHAR(2048) COLLATE Latin1_General_BIN DEFAULT '',
				searchterms NVARCHAR(2048) COLLATE Latin1_General_BIN DEFAULT '',
				resource NVARCHAR(2048) COLLATE Latin1_General_BIN DEFAULT '',
				browser_id SMALLINT NOT NULL DEFAULT 0,
				screenres_id SMALLINT NOT NULL DEFAULT 0,
				plugins NVARCHAR(255) COLLATE Latin1_General_BIN DEFAULT '',
				visit_id INT NOT NULL DEFAULT 0,
				dt int DEFAULT 0,
				CONSTRAINT [msn43_slim_stats_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY];

We keep testing…

I tried deactivate/reactivate and today installed new version (2.4.1) over (2.4.0) but no new tables were created, so 3 tables arew missing yet.

And yes, it´s a multisite enviroment, currently with only one site but multisite anyway.