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

Did you run ubhdb first?

Did you then run ubhasm?

You need to do both those - ubhdb downloads headers, ubhasm
assembles the multiparts.

-Gerard


--- tony_bierman <[email protected]> wrote:
> Gerald,
> 
> Well, you put me on the right track.  The 'active' column for my
> 'servers' entry was not set to TRUE.  However, after making that
> adjustment, I only get this output:
> 
> [biermana@localhost stable3]$ ./ubh
>
------------------------------------------------------------------------------
> 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/17 17:27:24 Ubh.NNTP INFO> Connecting to news.machlink.com:119
> 2003/04/17 17:27:24 Ubh.NNTP INFO> Successfully connected.
> 2003/04/17 17:27:24 Ubh.NNTP INFO> Authenticating as
> 2003/04/17 17:27:24 Ubh.NNTP INFO> Successfully authenticated.
> 2003/04/17 17:27:24 ubh.process_servers INFO> Constructing list of
> groups to process.
> 2003/04/17 17:27:24 ubh.process_servers INFO> Begin processing groups.
> 2003/04/17 17:27:24 ubh.process_group INFO> Begin processing group
> alt.binaries.movies
> 2003/04/17 17:27:25 ubh.process_group INFO> Begin processing single
> part articles.
> 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 (6) AND h.category = 'SINGLE' AND h.status =
> 'UNREAD' GROUP by h.header_id ORDER BY h.subject
> 2003/04/17 17:27:25 ubh.process_group INFO> Begin processing multipart
> articles.
> 2003/04/17 17:27:25 ubh.process_group INFO> STATS: news.machlink.com 
> total bytes = 0  secs = 0  rate = 0.000 KB/sec
> 2003/04/17 17:27:25 ubh.process_group INFO> Finished processing group
> alt.binaries.movies
> 2003/04/17 17:27:25 ubh.process_servers INFO> Finished processing groups.
> 2003/04/17 17:27:25 Ubh.NNTP INFO> Disconnecting from
> news.machlink.com:119
> 
> By the way here's my .ubhrc file.
> 
> NNTPSERVER = news.machlink.com
> NEWSRCNAME = .newsrc
> DATADIR = data
> MULTI_EXT = (?i)asf|avi|gif|jpg|mov|mpg|rm|r??|R??|p??|P??
> SINGLE_EXT = (?i)asf|avi|gif|jpg|mov|mpg|rm|r??|R??|p??|P??
> # ACCOUNT =
> # PASSWORD =
> 
> Thanks again,
> Tony
> 
> 
> --- In [email protected], Gerard Lanois <gerardlanois@y...> wrote:
> > This makes me think that no server connections have
> > been opened.
> > 
> > Did you set up the server table?  In other words, did you
> > customize the contents of the 2_servers.sql file prior to
> > running the installer script?
> > 
> > Here is an SQL procedure you can use to determine if there
> > are any servers in your server table:
> > 
> > USE ubhcache;
> > SELECT * FROM servers;
> > 
> > 
> > That should show you all the servers you are going to
> > connect to during a run.
> > 
> > If that table is non-empty, then it is possible that
> > ubh was not able to connect to any of them at the beginning
> > of the run.  Were there any error or warning messages about
> > this earlier in the run?
> > 
> > Now that I look at the code, I see the connection logic 
> > bails out with exit(-1) if a server connection cannot be
> > established.  So, you would never get as far as you did
> > if a server connection could not be made.
> > 
> > The thing to look for is a message in the log that
> > says "Sucessfully connected".  You should see that for
> > each server in your server table.
> > 
> > The more I think about it the more likely it is your
> > server table has nothing in it.  
> > 
> > If it does, let me know.
> > 
> > 
> > 
> > Hope this helps.
> > 
> > -Gerard
> > 
> > 
> > --- tony_bierman <biermana@h...> wrote:
> > > 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/xaxhjB/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/