System error

error:  DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's,women,africa,olivia phiri,computers' AND
two.value = 'Index Page' ORDER ' at line 4 [for Statement "SELECT one.doc_id FROM
Post_0039 AS one, Post_0039 AS two WHERE
one.doc_id = two.doc_id AND
one.value = 'ict's,women,africa,olivia phiri,computers' AND
two.value = 'Index Page' ORDER BY doc_id"] at /usr/local/lib/perl5/site_perl/5.8.7/Gadgets/Standard/Post.pm line 450.
context: 
... 
446:  $sql .= " ORDER BY doc_id";
447:  # warn "dumping results for:\n$sql\n";
448: 
449:  my $sth = $dbh->prepare_cached( $sql );
450:  $sth->execute();
451: 
452:  my @results;
453:  while ( my $row = $sth->fetchrow_arrayref() ) {
454:  push @results, $row->[0];
... 
code stack:  /usr/local/lib/perl5/site_perl/5.8.7/Gadgets/Standard/Post.pm:450
/pub/tag/dhandler:22
/&TemplateMain/autohandler-postpage:17
/&TemplateMain/autohandler-main:2
raw error






























DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's,women,africa,olivia phiri,computers' AND 
    two.value = 'Index Page'  ORDER ' at line 4 [for Statement "SELECT one.doc_id FROM
  Post_0039 AS one, Post_0039 AS two WHERE 
    one.doc_id = two.doc_id AND 
    one.value = 'ict's,women,africa,olivia phiri,computers' AND 
    two.value = 'Index Page'  ORDER BY doc_id"] at /usr/local/lib/perl5/site_perl/5.8.7/Gadgets/Standard/Post.pm line 450.


Trace begun at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'s,women,africa,olivia phiri,computers\' AND ^J    two.value = \'Index Page\'  ORDER \' at line 4 [for Statement "SELECT one.doc_id FROM^J  Post_0039 AS one, Post_0039 AS two WHERE ^J    one.doc_id = two.doc_id AND ^J    one.value = \'ict\'s,women,africa,olivia phiri,computers\' AND ^J    two.value = \'Index Page\'  ORDER BY doc_id"] at /usr/local/lib/perl5/site_perl/5.8.7/Gadgets/Standard/Post.pm line 450.^J') called at /usr/local/lib/perl5/site_perl/5.8.7/Gadgets/Standard/Post.pm line 450
Gadgets::Standard::Post::free_tag_search('Gadgets::Standard::Post', 'ict\'s,women,africa,olivia phiri,computers', 'Index Page') called at /pub/tag/dhandler line 22
HTML::Mason::Commands::__ANON__ at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x95336e0)') called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1250
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef) called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 916
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x954d324)') called at /&TemplateMain/autohandler-postpage line 17
HTML::Mason::Commands::__ANON__ at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x94d7d7c)') called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1255
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef) called at /&TemplateMain/autohandler-main line 2
HTML::Mason::Commands::__ANON__ at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9536d70)') called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1250
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
eval {...} at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 413
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x954d324)') called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 167
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x954d324)') called at /usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 817
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x8a2caf0)', 'Apache=SCALAR(0x94d7884)') called at /usr/local/lib/perl5/site_perl/5.8.7/Gadgets.pm line 157
Gadgets::simple_handle_request('Gadgets=HASH(0x8a2c850)', 'Apache=SCALAR(0x94d7884)') called at /webtree/handler.pl line 63
HTML::Mason::handler('Apache=SCALAR(0x94d7884)') called at /dev/null line 0
eval {...} at /dev/null line 0