Error during update record

Issue #87 resolved
Former user created an issue

Originally reported on Google Code with ID 87 ``` What steps will reproduce the problem? I get error in newest version of phpliteadmin when i try to update field in some entry

What is the expected output? What do you see instead? Warning: SQLiteDatabase::query(): near "B": syntax error in ...phpliteadmin.php on line 670 Error: not an error.

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

Reported by `dunarispace` on 2012-02-04 17:07:10

Comments (3)

  1. Former user Account Deleted

    ``` I have a the same or at least a similar issue if I want to edit a field. (v1.9.1, on php 5.3.9, sqlite3 backend) So I printed out the actual query and tried in in the SQL view where it failed as well. But adding some " around key, which is a string in my case, solved it, at least in the SQL view. So I think phpliteadmin should add the " if the type of a key is text/string

    ```

    Reported by `m.gysel` on 2012-03-05 09:46:02

  2. Former user Account Deleted

    ``` I had the same problem (I think a string escape problem of a vcard) installing pdo module of php solved. ```

    Reported by `f05533n` on 2012-04-09 10:45:22

  3. Dane Iracleous

    ``` I don't see instructions on how to reproduce this issue, but in the latest version, there is a fix for string escaping, so I am assuming that was the issue. ```

    Reported by `diracleo` on 2012-06-02 08:40:18 - Status changed: `Fixed`

  4. Log in to comment