@anonymous-piwik-user opened this Issue on July 20th 2011

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 commented on July 20th 2011 Owner

Thanks for the report KKKas

@robocoder commented on July 31st 2011 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 &amp;<a href='/039'>#039</a>;)                   AND deleted = 0&amp;<a href='/039'>#039</a>; at line 3
@robocoder commented on September 5th 2011 Contributor

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

@mattab commented on September 6th 2011 Owner

Which changeset was it fixed? thx

@mattab commented on September 27th 2011 Owner

(In [5245]) Fixes #2576

This Issue was closed on October 14th 2011
Powered by GitHub Issue Mirror