SQL Error with version 1.7.1

[ampix]

HI!

I hope someone can help: Here is the problem: When going on my main page, I get this 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 'ile+ronde&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:fr:official&' at line 1

I've search the forum and found there might be a problem with apostrophe... is it still the case with version 1.7.1?

I'm even more lost as when I left in the morning everything was fine and when I return later the same day...it would not load the page... you can go see for yourself on the link in my signature.

Thank you for your help!

[Dkozikowski]

It looks as if a character was not escaped. From what I can tell, it looks like your referrer / visitor table. Am I correct?

Unless you can manually pinpoint the problem entry and delete just that record, you'll have to empty this table to restore your photoblog. The only down side will be the loss of visitor data.

[ampix]

Belive it or not... Today, it is working fine! Without me doing anything!

I'm happy it is back but I wonder what the problem was and if it's going to come back...

Thanks anyways for looking into it!

Have a great weekend! And if you get an explanation for all this, let me know.

[austriaka]

visitors table is emptied each month begin, so maybe the weird entry just has gone now