wp_footer() doesn´t include any wp-slimstat js code

Thanks for the fast reply.

We´re not using any cache-plugin.
There is only 3 tables created and the 3 are empty:
-msn43_slim_browsers
-msn43_slim_visits
-msn43_slim_outbound
And maybe this is important, we are using the IIS version of WordPress with an SQL Server 2008

But I don´t understand why there is no js code created in the wp_footer() call

Thanks again

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.

Thanks Camu,

there is a few SQL Server syntax related errors in the log, I´ll try to create the tables manually.

Do you want the errors and updated SQL querys if we get it running?

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…

Maybe INT could be used for compatibility instead of BIT. And “user” could be used with quotes.

Unfortunately there is a few more SQL Server syntax problems:
– Incorrect syntax near ‘LIMIT’.
– ‘TIMEDIFF’ is not a recognized built-in function name.
– Incorrect syntax near ‘count’
Maybe some more in the administration panel.

Vote is done, of course. And if I get it running and working, donation too.

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 🙂