php - Symfony2 store docx file into database -


i'm trying store .docx file mysql database. know .docx files .zip file. however, i'm trying store them blob field, there should difference.

if try store file not .docx, .png, .jpeg, .pdf. works fine, when try store .docx file, 500 response, no error message.

this code:

public function saveresumee($slug, $file)   {     $em = $this->getentitymanager();      $resumee = new file(file_get_contents($file), $file->getmimetype(), $file->guessextension(), $file->getclientsize());     $em->persist($resumee);     $em->flush(); // blows here!     ...      return true;   }

here file entity

<?php  namespace dnd\rahapibundle\entity;  use doctrine\orm\mapping orm;  /**  * file  *  * @orm\table()  * @orm\entity  */ class file {    public function __construct($data, $type, $extension, $length)   {      $this->data = $data;     $this->type = $type;     $this->extension = $extension;      if ($length) $this->length = $length;   }    /**    * @var integer    *    * @orm\column(name="id", type="integer")    * @orm\id    * @orm\generatedvalue(strategy="auto")    */   private $id;    /**    * @var string    *    * @orm\column(name="data", type="blob")    */   private $data;    /**    * @var string    *    * @orm\column(name="extension", type="string", length=255)    */   private $extension;    /**    * @var integer    *    * @orm\column(name="length", type="integer")    */   private $length;    /**    * @var string    *    * @orm\column(name="type", type="string", length=16)    */   private $type;     /**    * id    *    * @return integer    */   public function getid()   {     return $this->id;   }    /**    * set data    *    * @param string $data    * @return file    */   public function setdata($data)   {     $this->data = $data;      return $this;   }    /**    * data    *    * @return string    */   public function getdata()   {     return $this->data;   }    /**    * set length    *    * @param integer $length    * @return file    */   public function setlength($length)   {     $this->length = $length;      return $this;   }    /**    * length    *    * @return integer    */   public function getlength()   {     return $this->length;   }    /**    * set type    *    * @param string $type    * @return file    */   public function settype($type)   {     $this->type = $type;      return $this;   }    /**    * type    *    * @return string    */   public function gettype()   {     return $this->type;   }    /**    * @return string    */   public function getextension()   {     return $this->extension;   }    /**    * @param string $extension    */   public function setextension($extension)   {     $this->extension = $extension;   } }

what wrong this?

ok, got work.

as @sdespont mentioned above, length problem, mime type of .docx file extremely large, updated field this:

  /**    * @var string    *    * @orm\column(name="type", type="string", length=16)    */   private $type;

to this:

  /**    * @var string    *    * @orm\column(name="type", type="string", length=255)    */   private $type;

Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more