@anonymous-piwik-user opened this Issue on June 19th 2009


I have installed PiWik on a Xampp on Port 81
I have the DNN Site on Port 80 running on IIS and MS-SQL

First I got the Error for the
'option'= "Create table"....

This was resolved after 4-5 hours of efforts and googling

I am now getting error


SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')<br />
AND name IN ( 'nb_visits' )' at line 3

Appreciate if some one can provide a fix for this

@anonymous-piwik-user commented on June 19th 2009

Looks similar to #809

@robocoder commented on June 19th 2009 Contributor

How did you fix your first error?

What version of Xampp do you have? I installed Piwik using Xampp 1.7.1 (Apache 2.2.11, PHP 5.2.9, and MySQL 5.1.33) without any problems on a Vista laptop.

@anonymous-piwik-user commented on June 22nd 2009

I got this rectified by Removing the creation of the Options table from the core\piwik.php

But, I am still not seeing the new reports reflected in the dashboard even though I have the visits logged in the database

@mattab commented on June 22nd 2009 Owner

well if you remove one of the core table in piwik, most likely it won't work.. piwik doesn't support MS SQL at this stage, if you want you can provide a patch but we can't support it ourselves. Thanks

see for more info: http://piwik.org/faq/installation/#faq_55

This Issue was closed on March 19th 2010
Powered by GitHub Issue Mirror