#29 Data loss while editing text fields

closed
nobody
None
5
2006-05-12
2006-05-10
No

This bug is at least present in v1.1.3 and v1.2.0 but
is not in the online v1.1.2 demo
(http://freddy78.dyndns.org/sqlitemanager/)

Double quotes in text fields are not encoded while
editing a row. Validating row "as is" result in data
loss. Field value gets cut at the first double quote.

How to reproduce this bug:

1. Import this db:
CREATE TABLE TAB1 ( MaCle INTEGER PRIMARY KEY, MaValeur
TINYTEXT );

INSERT INTO TAB1 (MaCle, MaValeur) VALUES ('1', 'Toto');
INSERT INTO TAB1 (MaCle, MaValeur) VALUES ('2',
'test''apos<inf>sup');
INSERT INTO TAB1 (MaCle, MaValeur) VALUES ('3',
'retest''apos"guillemet');

2. Browse table TAB1

3. Edit row 3

I guess an htmlspecialchars would do the trick but I
don't know where to put it.

Discussion

  • HENNINOT frederic

    Logged In: YES
    user_id=142485

    Replace 'include/common.lib.php' with this file!
    Thanks for your help

     
  • HENNINOT frederic

    • status: open --> closed
     

Log in to post a comment.