"Mysqli prepare error" on idSite=0 #2576

Closed
anonymous-piwik-user opened this Issue Jul 20, 2011 · 5 comments

3 participants

@anonymous-piwik-user

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
Piwik Open Source Analytics member

Thanks for the report KKKas

@robocoder

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

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

@mattab
Piwik Open Source Analytics member

Which changeset was it fixed? thx

@mattab
Piwik Open Source Analytics member

(In [5245]) Fixes #2576

@anonymous-piwik-user anonymous-piwik-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