• From: South Korea
  • Registered: 2004-05-02
  • Posts: 96

Topic: SQLite bug

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.

jacobswell's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: SQLite bug

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.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: South Korea
  • Registered: 2004-05-02
  • Posts: 96

Re: SQLite bug

right. it's an punbb+ bug. smile

jacobswell's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: SQLite bug

[Topic moved]

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website