Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#2576 closed Bug (fixed)

"Mysqli prepare error" on idSite=0

Reported by: KKKas Owned by: matt
Priority: normal Milestone: 1.6 Piwik 1.6
Component: Core Keywords:
Cc: Sensitive: no

Description

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

Change History (10)

comment:1 Changed 3 years ago by matt (mattab)

  • Priority changed from normal to major

comment:2 Changed 3 years ago by matt (mattab)

  • Milestone changed from 1.x - Piwik 1.x to 1.6 Piwik 1.6

Thanks for the report KKKas

comment:3 Changed 3 years ago by vipsoft (robocoder)

  • Owner set to matt

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

comment:4 Changed 3 years ago by vipsoft (robocoder)

  • Resolution set to fixed
  • Status changed from new to closed

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

comment:5 Changed 3 years ago by matt (mattab)

Which changeset was it fixed? thx

comment:6 Changed 3 years ago by vipsoft (robocoder)

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:7 Changed 3 years ago by matt (mattab)

  • Priority changed from major to critical

comment:8 Changed 3 years ago by matt (mattab)

  • Milestone changed from 1.7 Piwik 1.7 to 1.6 Piwik 1.6

comment:9 Changed 3 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from reopened to closed

(In [5245]) Fixes #2576

comment:10 Changed 3 years ago by matt (mattab)

  • Priority changed from critical to normal
Note: See TracTickets for help on using tickets.