Re: DBD::mysql::st execute failed: You have an error in your SQL syntax near ')

Here's the output:

SQL> SELECT h.msgid, h.subject, h.category FROM headers h,
xref_headers x WHERE
h.header_id = x.header_id AND x.newsgroup_id = 2 AND x.server_id IN )
AND h.category = 'SINGLE' AND h.status = 'UNREAD' GROUP by h.header_id
ORDER BY h.subject

Thanks,
Tony

--- In [email protected], Gerard Lanois <gerardlanois@y...> wrote:
> go into sub process_group
> 
> right *before* where it says 
> 
>              my $sth = $dbh->prepare($stmt);
>              $sth->execute;
> 
> insert a print statment, so that it looks like this:
> 
>              print "SQL> $stmt\n";
>              my $sth = $dbh->prepare($stmt);
>              $sth->execute;
> 
> and tell me what it says
> 
> this dumps out the complete SQL statement text prior to 
> executing it - it should help us understand how/why it
> did not get put together correctly
> 
> 
> 
> --- Tony Bierman <biermana@h...> wrote:
> > Help??
> > 
> > [biermana@localhost stable3]$ ./ubh -g
> >
>
------------------------------------------------------------------------------
> > ubh 3.0b1, (C) 2000-2003 Gerard Lanois
> > This software comes with ABSOLUTELY NO WARRANTY; for details use -w.
> > This is free software, and you are welcome to redistribute
> > it under certain conditions; see the file LICENSE for details.
> >
>
------------------------------------------------------------------------------
> > 2003/04/16 16:04:08 ubh.process_servers INFO> Constructing list of
groups
> > to 
> > process.
> > 2003/04/16 16:04:08 ubh.process_servers INFO> Begin processing groups.
> > 2003/04/16 16:04:08 ubh.process_group INFO> Begin processing group 
> > alt.binaries.movies
> > 2003/04/16 16:04:08 ubh.process_group INFO> Begin processing
single part 
> > articles.
> > DBD::mysql::st execute failed: You have an error in your SQL
syntax near ')
> > 
> > AND
> > h.category IN ('UNKNOWN','SINGLE') AND h.status = 'UNREAD' GROUP
by h.head'
> > 
> > at line 1 at ./ubh line 1752.
> > DBD::mysql::st execute failed: You have an error in your SQL
syntax near ')
> > 
> > AND
> > h.category IN ('UNKNOWN','SINGLE') AND h.status = 'UNREAD' GROUP
by h.head'
> > 
> > at line 1 at ./ubh line 1752.
> > 
> > 
> > 
> > 
> > 
> > 
> > _________________________________________________________________
> > The new MSN 8: advanced junk mail protection and 2 months FREE*  
> > http://join.msn.com/?page=features/junkmail
> > 
> >


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/W7NydA/hdqFAA/VygGAA/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/