Pixelpost

LittleKing · #1 11-16-2005, 12:58 AM

I don't know if this is something specific for my install but I don't believe it is. If I try to an apostrophe (') in the title of my blog I get the following error:

Code:

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 's Photoblog' where admin='admin'' at line 1

I don't know a lot about programming, but I assume it has something to do with the way the string is parsed in to the SQL statement. Meaning when it sees my (') in the title it thinks it the end of the text, however since there is more after it, the command then errors.

LK

jeremycherfas · #2 11-16-2005, 04:52 AM

I had this too, some while ago. But I thought it had been fixed.

What version are you on?

#3 11-16-2005, 07:06 AM

so first, avoid using "'" in the title
second tell us which version you use, as Jeremy asked
because this should be fixed in 1.4.2, the actual version

mckendall · #4 11-20-2005, 05:32 AM

I have the same problem and I'm using version 1.4.2. I can avoid using the apostrophes, but it would be nice if it is possible.

Thanks

#5 11-20-2005, 08:16 AM

so if it is not fixed in 1.4.2, it is for sure fixed in 1.5 which will come soon

Pixelpost

Authentic Photoblog Flavour