Warning: SQLiteDatabase::query() [sqlitedatabase.query]: near

[Former user]

Originally reported on Google Code with ID 103

What steps will reproduce the problem?
1. Insert a new Row
2. id = 8D345
3. Click Insert Button

What is the expected output? What do you see instead?

Warning: SQLiteDatabase::query() [sqlitedatabase.query]: near "D345": syntax error
in D:\UwAmp\phpapps\WEB_PROJECT\lotto\admin\sqliteadmin.php on line 670

What version of the product are you using? On what operating system?

v1.9.1 on Windows 7 x64

Please provide any additional information below.

BRowser: Firefox 6.0.2
SQLite version: 2.8.17
SQLite extension [?]: SQLiteDatabase
PHP version: 5.2.17

Reported by nic2302 on 2012-05-03 20:13:26

<hr> * Attachment: reg_3.wmv * Attachment: db_call.sqlite

[Christopher Kramer]

``` SQLite extension "SQLiteDatabase" does not escape input data properly. See issue #75 and duplicates. I consider this issue caused by this problem. Please try version 1.9.2 which should fix this issue. If it does not, please comment again. ```

Reported by `crazy4chrissi` on 2012-05-30 16:47:38 - Status changed: `Fixed`

[Christopher Kramer]

Reported by crazy4chrissi on 2013-03-09 17:15:03 - Status changed: Duplicate - Merged into: #75