Menu

#3832 (ok 4.0) Unable to upload blob data while insering row into a table

Latest_Git
fixed
None
1
2013-06-11
2013-02-19
No

Table structure:-

CREATE TABLE IF NOT EXISTS testblob (
id int(11) NOT NULL,
name varchar(56) NOT NULL,
image blob NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

  1. Click on the table, go to "Insert" page.
  2. Try inserting a row, select some image for the BLOB field.
  3. Click "Go" and just non-blob fields are inserted.

Found it working fine in 3.5.4. Also, MIME transformations work fine in latest_git too but not upload.

Discussion

  • Supun Nakandala

    Supun Nakandala - 2013-02-19

    Javascript cannot read local files for security reasons, so we can't send the data using AJAX. So I think we have to disable ajax for insert forms which has 'blob' fields.

     
  • Supun Nakandala

    Supun Nakandala - 2013-02-19

    I have created a bug fix for this error
    https://github.com/phpmyadmin/phpmyadmin/pull/174

     
  • Atul Pratap Singh

    • summary: Unable to upload blob data while insering row into a table --> (ok 4.0) Unable to upload blob data while insering row into a table
    • status: open --> open-fixed
    • assigned_to: Atul Pratap Singh
    • priority: 5 --> 1
     
  • Atul Pratap Singh

    Fixed in master with pull request 174.

     
  • Marc Delisle

    Marc Delisle - 2013-05-03
    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.