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

Jump to bottom

"Mysqli prepare error" on idSite=0 #2576

Closed
anonymous-matomo-user opened this issue Jul 20, 2011 · 5 comments
Closed

"Mysqli prepare error" on idSite=0 #2576

anonymous-matomo-user opened this issue Jul 20, 2011 · 5 comments
Assignees
@mattab
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
1.6

Comments

@anonymous-matomo-user
Copy link

Hi,
on i.e:

index.php?module=Goals&action=addNewGoal&idSite=0&period=year&date=2011

(with idSite=0)

there is:

Mysqli prepare error: 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 ') AND deleted = 0' at line 3

Piwik version: 1.5.1

Cheers,
Kacper
@mattab
Copy link
Member

mattab commented Jul 20, 2011

Thanks for the report KKKas

@robocoder
Copy link
Contributor

Similar problem with PDO_MYSQL.

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 ')                   AND deleted = 0' at line 3

@robocoder
Copy link
Contributor

Fixed in trunk. (Sorry, my last few commits have been messy.)

@mattab
Copy link
Member

mattab commented Sep 6, 2011

Which changeset was it fixed? thx

@mattab
Copy link
Member

mattab commented Sep 27, 2011

(In [5245]) Fixes #2576

@anonymous-matomo-user anonymous-matomo-user added this to the 1.6 Piwik 1.6 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mattab mattab

Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
1.6
Development

No branches or pull requests
3 participants
@mattab @robocoder @anonymous-matomo-user