unrecognized token @
Issue #102
resolved
Originally reported on Google Code with ID 102
What steps will reproduce the problem?
1. Add a new field with type=integer
2. All my data has been deleted, instead it show This table is empty.
3. Click Insert here to insert a new row
4. Click Insert Button
What is the expected output? What do you see instead?
Warning: SQLiteDatabase::query() [sqlitedatabase.query]: unrecognized token: "@" 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 12:34:37
<hr> * Attachment: reg_w.wmv
Comments (4)
-
-
I can understand what you mean. So in fact these are two issues here: 1. all your data gets deleted when adding a column 2. You are not able to insert data containing @. Problem 2 is another example of issue #75 and should be fixed in 1.9.2. Problem 1 is related to issue #12, although not exactly reported there. A lot of work has already gone into fixing issue #12, although not completely finished yet. Along with this work, this issue should also be fixed by now in current SVN versions. You can get the latest SVN (development) version here: http://phpliteadmin.googlecode.com/svn/source/1.9.3/phpliteadmin.php Your problems should both not be in there anymore. Please have a try with the current version.
Reported by
crazy4chrissi
on 2012-10-23 10:41:48 - Status changed:Started
-
I mark this issue fixed as it should be fixed in the current development version in SVN.
Reported by
crazy4chrissi
on 2012-10-25 20:30:09 - Status changed:Fixed
-
Reported by
crazy4chrissi
on 2013-03-09 17:14:02 - Log in to comment
``` I can't reproduce your issue. Your steps don't make sense, and I couldn't make out what you did from your video. Could you please write out the steps more clearly starting with a blank database? ```
Reported by `diracleo` on 2012-06-02 07:49:44