Ticket #1220 (closed Bug: fixed)

Opened 6 months ago

Last modified 6 months ago

Last visits graph -SQLSTATE[42000]: Syntax error

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

Description

High,

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.

Thanks

Change History

Changed 6 months ago by vipsoft

  • keywords SQLSTATE[42000]: Syntax error removed
  • status changed from new to closed
  • resolution set to fixed
  • milestone set to 1 - Piwik 0.6

Already fixed in svn. In [1959], refs #56 - handle timezone mismatch more gracefully

Changed 6 months ago by vipsoft

  • status changed from closed to reopened
  • resolution fixed deleted

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

Changed 6 months ago by vipsoft

  • status changed from reopened to closed
  • resolution set to fixed

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.