| Newsgroups |
gmane.network.ubh |
| Message-ID |
<[email protected]> |
--- In [email protected], "foosink1 <foosink@h...>" <foosink@h...>
wrote:
> 2003/01/12 20:42:42 ubh.save_file INFO> Done saving file.
> DBD::mysql::db do failed: Duplicate entry '7623' for key 1 at
> lib/Ubh/Metadata.pm line 23.
> DBD::mysql::db do failed: Duplicate entry '7623' for key 1 at
> lib/Ubh/Metadata.pm line 23.
> /data/news/ubh/runubh.sh: line 8: [: 255: unary operator expected
>
> if I have some time, I will dig into this, probably caused by bad
> header (duplicate file), cure could be a check before or a catch
> during.
>
> --->Suggestion
>
> Maybe a filter program to run the headers through to look for
certain
> characteristics:
> --member of a series (regex here? mysql loves 'em)
> --favorite posters
> --etc.
>
> & apply a weight based on rules applied
>
> UBH then does the select with an ORDER BY based on these weights,
> download in that order. Across news groups.
>
> That would be not only the coolest in the realm, but would allow us
> to suck down what we want, toss the rest.
>
> (Maybe I even build some kind of interactive interface (TK?) to
allow
> selection of those that fall out of the rules for later download.)
>
> Maybe an idea is to add a "weight" column to the headers table,
> update the select in UBH with an:
>
> $stmt .= "GROUP by h.header_id ORDER BY h.weight,h.subject";
>
> The potential for this is awesome. Good work.
The dup key was a MYSQL bug--weird, dropped and rebuilt table, works
fine--suggestion still good.
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Turn flat surfaces into speakers with the Soundbug.
http://us.click.yahoo.com/QWAVSC/onCFAA/xGHJAA/IHFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
[email protected]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/