Slash Boxes

Slash Open Source Project

This discussion has been archived. No new comments can be posted.
Display Options Threshold:
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • by ericdano (1000) on Monday March 10 2003, @12:52AM (#5843) Homepage Journal
    You forgot to include the table structure of story_files in the upgrades file ;-)

    It's either on the beat or off the beat, it's that easy.
  • by ericdano (1000) on Monday March 10 2003, @02:16AM (#5846) Homepage Journal
    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/ line 595.
    [Mon Mar 10 07:03:31 2003] [error] / rl5/site_perl/5.6.1/i386-freebsd/Slash/DB/Utility. pm:585'


    [Mon Mar 10 07:03:31 2003] [error] Which was called by:Slash::Blob:/usr/local/lib/perl5/site_perl/5.6. 1/Slash/ 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 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.
  • by tf23 (175) <> on Monday March 10 2003, @07:20AM (#5853) Homepage Journal
    direct from the source:


    I'm going through the changes in CVS in the hopes to upgrade my sites in about 5 minutes... so we'll see how this goes.

    These changes sound excellent Krow!

    lottadot []
  • I've not had a chance to look at the code yet, but from this story it looks like very useful features.

    Some questions about the image support, is it possible to specify additional information in the title attribute instead of just the same as the alt attribute?

    Are the width, height, longdesc attributes supported?

  • by james (1612) on Tuesday March 11 2003, @03:02PM (#5872) Homepage Journal
    Question about image blobs. (Not having yet looked at the code, sorry.)

    I have programmed a ridiculously complicated plugin for internal (my wife and I) use that manages family pics (8,000 and climbing), generating a static webisite of selected images for external consumption. Anyway, one problem I've had is detecting duplicate images. I've tried to resolve this by using dates to subdir the images in the image file system, but if there is a name collision (same datestamp + same filename), I just ignore the new image.

    The usual case is when I forget to purge all uploaded images from my memorystick. But there are situations where the same date and the same imagenumber/filename can be generated by my camera, but for different images---say if I clear out the memorystick and then shoot some more pics the same day.

    Now my question. Since I think it was said that this new image capability was programmed with blobs, can one compare two blobs to confirm that an incoming image and a stored image that resolve to the same "name" are indeed the same, thus necessitating an incremental bump in the image name rather than just ignoring it? I haven't used blobs. I understood that blobs are pretty inefficient to search on in MySQL, as are text values. But this isn't a search so much as a "fetch with key, compare blob" operation. I was thinking about doing some sort of MD5 comparison, but if blob compares work and are fast, I can perhaps go that route.