Stories
Slash Boxes
Comments

Slash Open Source Project

This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

New Features! 18 Comments More | Login /

 Full
 Abbreviated
 Hidden
More | Login
Loading... please wait.
  • 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) on Monday March 10 2003, @03:54AM (#5847) Homepage Journal
      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.
      • 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.
      • Oh, wait, it seems to work ok on smaller files. However, when you view the story I don't see the links or whatever to the files......
        --

        --
        It's either on the beat or off the beat, it's that easy.
        • Oh, and in my slashd log, I'm getting this message again, which maybe might be something that has cropped up again.

          Mon Mar 10 11:25:11 2003 [freshenup.pl] updated software:03/01/21/078239 (Plugin For Finale)
          Filehandle $cchp_fh opened only for output at /usr/local/slash/site/www.jazz-sax.com/tasks/fresh enup.pl line 217.

          Mon Mar 10 11:25:11 2003 [freshenup.pl] Commentcount/hitparade data was not retrieved, reason unknown (cchp: '')

          If memory serves me, we dealt with that months ago, it was some sort of

          --

          --
          It's either on the beat or off the beat, it's that easy.
        • Once you attached a file you have to decide where it goes. If you look up in the right hand corner of the story editor there should be a list of files (and the tag you need to use for the file.
          --

          --
          You can't grep a dead tree.
          • Hmm, in the story editor I see a box that has this in it:

            Paul Contos II/V/I Patterns
            <SLASH-IMAGE id="a18eca1c6688d2752537bb6330b03b01" TITLE="Paul Contos II/V/I Patterns">

            Paul Contos Misc Patterns<BR>
            <SLASH-IMAGE id="5677a6090aef75f3aa5e3735e988ee4e" TITLE="Paul Contos Misc Patterns">

            But there is nothing else. Nothing that I can select or do.
            --

            --
            It's either on the beat or off the beat, it's that easy.
            • Copy and paste those into your stories where you want your images to appear. At some point I will modify so that you can set up templates where images will automagically appear in but for now our requirement was that they wanted images to be able to go anywhere in the document.
              --

              --
              You can't grep a dead tree.
              • Oh. Ok, it works. Needed to change it from IMAGE to FILE and everything was good. Works great. Now how does one prevent Anonymous Cowards from getting images/files? There is a select level, but does Slash check it? Does it check who is logged in before fetching the file?

                Ok, now, just need to figure out why it wouldn't take a big file....

                Oh, and what about that Slashd log message that is happening? Where stories aren't getting updated?

                Thanks! Great work!

                --

                --
                It's either on the beat or off the beat, it's that easy.
                • Hmm, digging some more it seems that Blob.pl does redirect to a 404.pl.

                  On my site, most all the users have a 1 seclev. Would moving Anonymous Coward to 0 mess things up on a slash site? Or maybe I should move all the users to seclev 2?

                  Ideas?

                  --

                  --
                  It's either on the beat or off the beat, it's that easy.
                  • Are files being saved with a seclev above zero?
                    If so that is a bug.
                    --

                    --
                    You can't grep a dead tree.
                    • No no. They are saved with a seclev of 1. I was saying what would it take to get Anonymous Cowards NOT to have access to things. I moved my AC user to seclev 0, and everything is good.

                      Two problems I see with the Blob thing right now. One, it's not keeping track of how many times it has been "hit" or viewed. Or atleast I don't see it anywhere. And two, I can't get any big files to get loaded in via the fileadmin.pl interface, nor through the blobLoader interface. The latter spews out junk about about 3 seconds, and the web interface fails and gives errors like I said in previous posts. I'm not sure exactly the size it dies it, but it's around 1 meg.

                      --

                      --
                      It's either on the beat or off the beat, it's that easy.
                    • you get output from your /fileadmin.pl?

                      I don't. I just get a blank screen.

                      Does it only give output if there's been a file loaded into the blob?

                      --
                      lottadot [lottadot.com]
                    • Right now it just has support that is needed to add stories.
                      --

                      --
                      You can't grep a dead tree.

                    • so I should be seeing *something* there?
                      --
                      lottadot [lottadot.com]
                    • Yeah, fileadmin.pl give you output. But you have to give it some params. Like:

                      www.site.com/fileadmin.pl?op=addFileForStory&sid =11/11/11/12345

                      And when it stores something successfully, it will list the file as part of the story. Problem is that there seems to be issues with anything around about 1 meg or more....

                      --

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