SQL Error on New Installation

[sameer.shah]

H

I have installed PiWik on a Xampp on Port 81 and 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

for

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

[Blizzz]

Looks similar to #809

[vipsoft]

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.

[sameer.shah]

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

[matt]

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