System error

error:  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 'and hc.name<>'' and cn.countryName not like '%:%' and wg.high is not NULL AND wg' at line 7 select DISTINCT(wc.id),wc.country, wc.name as name2, hc.name, hc.name_rod, hc.name_dat, hc.name_vin, hc.name_tvor, hc.name_pred, TRIM(LEADING 'в:' FROM hc.predlog) as predlog, cn.countryCode, wc.city, hc.id AS city_id, wg.high, LOWER(wg.clouds) as clouds
from weatherCity as wc
left join hotelsCity as hc on wc.city=hc.id
left join allCountry as cn on wc.country=cn.countryid
LEFT JOIN weatherGoogle wg ON wg.city=wc.id and wg.date=current_date()
LEFT JOIN weatherGoogle wg2 ON wg2.city = wc.id AND wg2.date = DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY)
where and hc.name<>'' and cn.countryName not like '%:%' and wg.high is not NULL AND wg2.city=wg.city group by wc.id order by hc.name at /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm line 64.
context: 
... 
60:  sub select {
61:  my $self=shift;
62:  my $statement=shift; $self->{DBH}->do("SET NAMES UTF8");
63:  return die($self->{DBH}->errstr) unless defined($self->{DBSEL}=$self->{DBH}->prepare($statement));
64:  return die($self->{DBSEL}->errstr.' '.$statement) unless defined($self->{DBSEL}->execute(@_));
65:  return $self->rows();
66:  }
67: 
68: 
... 
code stack:  /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm:64
/var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm:145
/var/www/newTurizm/turizm.ru/Libs/Weather/Weather.pm:120
/var/www/newTurizm/turizm.ru/html/Comp/domain/POGODA/countries_center.msn:134
/usr/local/share/perl/5.10.0/HTML/Mason/Component.pm:254
/var/www/newTurizm/turizm.ru/html/Comp/header.msn:10
/var/www/newTurizm/turizm.ru/html/index.html:1
/var/www/newTurizm/turizm.ru/html/dhandler:2
raw error






























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 'and hc.name<>'' and cn.countryName not like '%:%' and wg.high is not NULL AND wg' at line 7 select DISTINCT(wc.id),wc.country, wc.name as name2, hc.name, hc.name_rod, hc.name_dat, hc.name_vin, hc.name_tvor, hc.name_pred, TRIM(LEADING 'в:' FROM hc.predlog) as predlog, cn.countryCode, wc.city,  hc.id AS city_id, wg.high, LOWER(wg.clouds) as clouds 
     from weatherCity as wc
     left join hotelsCity as hc on wc.city=hc.id
     left join allCountry as cn on wc.country=cn.countryid
     LEFT JOIN weatherGoogle wg ON wg.city=wc.id and wg.date=current_date()
     LEFT JOIN weatherGoogle wg2 ON wg2.city = wc.id AND wg2.date = DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY)
     where  and hc.name<>'' and cn.countryName not like '%:%' and wg.high is not NULL AND wg2.city=wg.city group by wc.id order by hc.name at /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm line 64.


Trace begun at /usr/local/share/perl/5.10.0/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('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 \'and hc.name<>\'\' and cn.countryName not like \'%:%\' and wg.high is not NULL AND wg\' at line 7 select DISTINCT(wc.id),wc.country, wc.name as name2, hc.name, hc.name_rod, hc.name_dat, hc.name_vin, hc.name_tvor, hc.name_pred, TRIM(LEADING \'M-PM-2:\' FROM hc.predlog) as predlog, cn.countryCode, wc.city,  hc.id AS city_id, wg.high, LOWER(wg.clouds) as clouds ^J     from weatherCity as wc^J     left join hotelsCity as hc on wc.city=hc.id^J     left join allCountry as cn on wc.country=cn.countryid^J     LEFT JOIN weatherGoogle wg ON wg.city=wc.id and wg.date=current_date()^J     LEFT JOIN weatherGoogle wg2 ON wg2.city = wc.id AND wg2.date = DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY)^J     where  and hc.name<>\'\' and cn.countryName not like \'%:%\' and wg.high is not NULL AND wg2.city=wg.city group by wc.id order by hc.name at /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm line 64.^J') called at /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm line 64
Base::DbLite::select('Base::DbLite=HASH(0x20fa020)', 'select DISTINCT(wc.id),wc.country, wc.name as name2, hc.name, hc.name_rod, hc.name_dat, hc.name_vin, hc.name_tvor, hc.name_pred, TRIM(LEADING \'M-PM-2:\' FROM hc.predlog) as predlog, cn.countryCode, wc.city,  hc.id AS city_id, wg.high, LOWER(wg.clouds) as clouds ^J     from weatherCity as wc^J     left join hotelsCity as hc on wc.city=hc.id^J     left join allCountry as cn on wc.country=cn.countryid^J     LEFT JOIN weatherGoogle wg ON wg.city=wc.id and wg.date=current_date()^J     LEFT JOIN weatherGoogle wg2 ON wg2.city = wc.id AND wg2.date = DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY)^J     where  and hc.name<>\'\' and cn.countryName not like \'%:%\' and wg.high is not NULL AND wg2.city=wg.city group by wc.id order by hc.name') called at /var/www/newTurizm/turizm.ru/Libs/Base/DbLite.pm line 145
Base::DbLite::Fetchall_hashref('Base::DbLite=HASH(0x20fa020)', 'select DISTINCT(wc.id),wc.country, wc.name as name2, hc.name, hc.name_rod, hc.name_dat, hc.name_vin, hc.name_tvor, hc.name_pred, TRIM(LEADING \'M-PM-2:\' FROM hc.predlog) as predlog, cn.countryCode, wc.city,  hc.id AS city_id, wg.high, LOWER(wg.clouds) as clouds ^J     from weatherCity as wc^J     left join hotelsCity as hc on wc.city=hc.id^J     left join allCountry as cn on wc.country=cn.countryid^J     LEFT JOIN weatherGoogle wg ON wg.city=wc.id and wg.date=current_date()^J     LEFT JOIN weatherGoogle wg2 ON wg2.city = wc.id AND wg2.date = DATE_ADD(CURRENT_DATE(),INTERVAL 3 DAY)^J     where  and hc.name<>\'\' and cn.countryName not like \'%:%\' and wg.high is not NULL AND wg2.city=wg.city group by wc.id order by hc.name') called at /var/www/newTurizm/turizm.ru/Libs/Weather/Weather.pm line 120
Weather::Weather::get_weather_by_country('Weather::Weather=HASH(0x21f09d8)', undef, 1) called at /var/www/newTurizm/turizm.ru/html/Comp/domain/POGODA/countries_center.msn line 134
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::Subcomponent=HASH(0x5500a40)') called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1297
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 254
HTML::Mason::Component::call_method('HTML::Mason::Component::FileBased=HASH(0x5182550)', 'keywords') called at /var/www/newTurizm/turizm.ru/html/Comp/header.msn line 10
HTML::Mason::Commands::__ANON__('path', '/Comp/domain/POGODA/countries_center.msn', 'country', 'burkina Faso', 'curort', 943) called at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x3f053d8)', 'path', '/Comp/domain/POGODA/countries_center.msn', 'country', 'burkina Faso', 'curort', 943) called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1302
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'path', '/Comp/domain/POGODA/countries_center.msn', 'country', 'burkina Faso', 'curort', 943) called at /var/www/newTurizm/turizm.ru/html/index.html line 1
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4e829d8)') called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1302
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef) called at /var/www/newTurizm/turizm.ru/html/dhandler line 2
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.10.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1b48728)') called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1297
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.10.0/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x5097d60)') called at /usr/local/share/perl/5.10.0/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x5097d60)') called at /usr/local/share/perl/5.10.0/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x16e9870)', 'Apache2::RequestRec=SCALAR(0x4dc7888)') called at /etc/apache2/handler.pl line 34
Turizm::Mason::handler('Apache2::RequestRec=SCALAR(0x4dc7888)') called at -e line 0
eval {...} at -e line 0