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: 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
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.
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
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