Slashcode

• Issues.... (Score:2)

  by ericdano (1000)

  Ok, so, I installed the plugin. The tables are all there, etc. I get a message in my Apache server:
  

  DBD::mysql::db do failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/ Slash/DB/Utility.pm line 595.
  [Mon Mar 10 07:03:31 2003] [error] /fileadmin.pl:Slash::DB::Utility:/usr/local/lib/pe rl5/site_perl/5.6.1/i386-freebsd/Slash/DB/Utility. pm:585'
  
  

  And

  
  [Mon Mar 10 07:03:31 2003] [error] Which was called by:Slash::Blob:/usr/local/lib/perl5/site_perl/5.6. 1/Slash/Blob.pm:87:INSERT INTO blobs (data,id,content_type,seclev) VALUES('
  
  

  Basically, I was trying to add a PDF to a story. The PDF is 1.3 megs. I changed my Apache Server to allow for this, and the Fileadmin.pl adds a record for story_files, but errors out on inserting into the blob table....

  --
  
  --
  It's either on the beat or off the beat, it's that easy.
  • Re:Issues.... (Score:3, Informative)

    by Krow (986)

    Try the blobLoader, but my guess is one of the following:
    
    1) You have your packet size set too small
    2) Somehow Apache isn't set to take objects that large
    3) Combination of the two above.
    
    I can try on my local copy tomorrow morning and see what I get.

    --
    
    --
    You can't grep a dead tree.
    • Re:Issues.... (Score:2)

      by ericdano (1000) on Monday March 10 2003, @04:17AM (#5850) Homepage Journal

      Hmm, it looks like a DBD:mysql::db error to me.
      

      The PDF is about 1.2 Megs. I removed the LimitRequestBody command in slash.conf. I was getting errors about the size before, but that got rid of it. I don't see anything else in the apache conf that would seem to limit anything.
      

      --
      
      --
      It's either on the beat or off the beat, it's that easy.

      Parent

      • Re:Issues.... (Score:1)

        by chicks (3690)

        As Krow indicated, your packet size is probably too small. Check out the relevant MySQL FAQ entry [mysql.com]. Setting max_allowed_packet high enough has solved this problem every time I've run into it.
        • Re:Issues.... (Score:2)

          by ericdano (1000)

          Wow, thanks! That fixed the problem. Thinks are working great now!

          --
          
          --
          It's either on the beat or off the beat, it's that easy.