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

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 <[email protected]> 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/