<![CDATA[PunBB Forums — SQLite bug]]> https://punbb.informer.com/forums/topic/3786/sqlite-bug/ Fri, 07 May 2004 15:58:55 +0000 PunBB <![CDATA[Re: SQLite bug]]> https://punbb.informer.com/forums/post/13425/#p13425 [Topic moved]

]]> Fri, 07 May 2004 15:58:55 +0000 https://punbb.informer.com/forums/post/13425/#p13425 <![CDATA[Re: SQLite bug]]> https://punbb.informer.com/forums/post/13417/#p13417 right. it's an punbb+ bug. smile

]]> Fri, 07 May 2004 15:48:16 +0000 https://punbb.informer.com/forums/post/13417/#p13417 <![CDATA[Re: SQLite bug]]> https://punbb.informer.com/forums/post/13416/#p13416 Yes, using addslashes() on query data with SQLite will screw things up. You should use sqlite_escape_string().

Then again, how can this be a bug report? PunBB doesn't even support SQLite in it's current version.

]]> Fri, 07 May 2004 15:43:32 +0000 https://punbb.informer.com/forums/post/13416/#p13416 <![CDATA[SQLite bug]]> https://punbb.informer.com/forums/post/13406/#p13406 Hello.

Using SQLite, we will have a bug.
Currently we use addslashes() before we qoute in database queries.
Most of database systems use backslashes for escaping single quotes, but SQLite uses a more single quote. so escaping this('), it should be double single quotes('').

When we use SQLite, and type a single quote in the message field and press submit button, it will show you an error message. I've tested in Win2000 / Apache.

]]> Fri, 07 May 2004 14:19:50 +0000 https://punbb.informer.com/forums/post/13406/#p13406