Menu

#2404 (ok 2.10.0.3) Blobs being cleared on Edit of row

2.10.0.2
fixed
1
2013-06-11
2007-03-29
No

Apache/2.0.52 (CentOS)
PHP Version 5.2.1
MySQL 5.0.22

When editing a row which contains longblob fields, they are cleared. Rather than being left as they were.

This behaviour is difference to phpmyadmin version 2.9.0.1

We have a table containing 3 fields (id INT(10) unsigned auto-inc, title VARCHAR(64), image LONGBLOB)
This has been populated from a php script on our website.

If we edit a title using phpmyadmin 2.10.0.2, then the blob gets cleared to 0b. The SQL appears to be UPDATE tbl SET title='newtitle', image='' WHERE id=1. When in 2.9.0.1 it would have not included the image='' in the query.

Discussion

  • Sebastian Mendel

    • priority: 5 --> 8
     
  • Marc Delisle

    Marc Delisle - 2007-03-29

    Logged In: YES
    user_id=210714
    Originator: NO

    Was OK in 2.9.2.

     
  • Sebastian Mendel

    • assigned_to: nobody --> cybot_tm
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    and was not ok in 2.10 beta ... working on this

     
  • Sebastian Mendel

    • summary: Blobs being cleared on Edit of row --> (ok 2.10.0.3) Blobs being cleared on Edit of row
    • status: open --> open-fixed
     
  • Sebastian Mendel

    • priority: 8 --> 1
     
  • Marc Delisle

    Marc Delisle - 2007-04-24
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed