unrecognized token @

[Former user]

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

[Dane Iracleous]

``` 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

[Christopher Kramer]

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

[Christopher Kramer]

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

[Christopher Kramer]

Reported by crazy4chrissi on 2013-03-09 17:14:02