Opened 4 years ago

Closed 4 years ago

#1220 closed Bug (fixed)

Last visits graph -SQLSTATE[42000]: Syntax error

Reported by: blacklion1 Owned by:
Priority: major Milestone: Piwik 0.6
Component: Core Keywords:
Cc: Sensitive: no



Once in a while I receive this error in the
"Last visits graph"

"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 name IN ( 'nb_visits' )' at line 3" (without the quotes)

and a error with this Feed burner thing. (I'm No Web master, Happy enough to have just been able to install it. :)

I mark it as "major" because this single component is one of seven most import and needs to function with out error. (for a accurate annalist)

On the other hand you guys have done an excellent job with this.
You have quite a superior project here.


Change History (3)

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

  • Keywords SQLSTATE[42000]: Syntax error removed
  • Milestone set to 1 - Piwik 0.6
  • Resolution set to fixed
  • Status changed from new to closed

Already fixed in svn.

In [1959], refs #56 - handle timezone mismatch more gracefully

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

  • Resolution fixed deleted
  • Status changed from closed to reopened

Sorry, I see there was a part 2: What's the Feedburner error?

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

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

Got it.

[1962] - fixes Feedburner issue where sendHttpRequest() throws an exception because the server disabled curl/sockets/etc

Note: See TracTickets for help on using tickets.