Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Error on New Installation #813

Closed
anonymous-matomo-user opened this issue Jun 19, 2009 · 4 comments
Closed

SQL Error on New Installation #813

anonymous-matomo-user opened this issue Jun 19, 2009 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Milestone

Comments

@anonymous-matomo-user
Copy link

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

@anonymous-matomo-user
Copy link
Author

Looks similar to #809

@robocoder
Copy link
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-matomo-user
Copy link
Author

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
Copy link
Member

mattab commented Jun 22, 2009

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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. wontfix If you can reproduce this issue, please reopen the issue or create a new one describing it.
Projects
None yet
Development

No branches or pull requests

3 participants