Development

#5052 (sfDoctrineQueryLogger broken with large blob field)

You must first sign up to be able to contribute.

Ticket #5052 (closed defect: fixed)

Opened 4 years ago

Last modified 4 years ago

sfDoctrineQueryLogger broken with large blob field

Reported by: rande Assigned to: fabien
Priority: major Milestone: 1.2.0
Component: sfDoctrinePlugin Version:
Keywords: Cc:
Qualification: Unreviewed

Description

The sfDoctrineQueryLogger send binary content from blob field to registererd loggers.

I get a 505 error from lightty with large file (>200Kb), I suppose other registered logger cannot handle properly binary field.

So the sfDoctrineQueryLogger should change the param value of blob field : display [BLOB XXKb] instead of the binary

This is what I get in the console with a 1pixel gif file.

UPDATE general_media_file SET object_id = ?, weight = ?, filename = ?, type = ?, size = ?, binary_content = ?, updated_at = ? WHERE id = ? - (1, 0, Empty.gif, image/gif, 807, GIF89a?		








  !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????!?
??;, 2008-11-24, 1 )


This output will be better :

UPDATE general_media_file SET object_id = ?, weight = ?, filename = ?, type = ?, size = ?, binary_content = ?, updated_at = ? WHERE id = ? - (1, 0, Empty.gif, image/gif, 807, [BLOB 1Kb] , 2008-11-24, 1 ) 

Change History

11/27/08 10:17:26 changed by Jonathan.Wage

  • status changed from new to closed.
  • resolution set to fixed.

(In [13393]) [1.2] sfDoctrinePlugin: fixes issue with query params with binary data causing problems in the logs (closes #5052)

11/27/08 10:17:39 changed by Jonathan.Wage

  • status changed from closed to reopened.
  • resolution deleted.

11/27/08 10:17:52 changed by Jonathan.Wage

  • owner changed from Jonathan.Wage to fabien.
  • status changed from reopened to new.

11/27/08 10:52:24 changed by Jonathan.Wage

  • milestone set to 1.2.0.

11/27/08 13:21:45 changed by fabien

  • status changed from new to closed.
  • resolution set to fixed.