System error

error:

DBD::mysql::st execute failed: Unknown column '3d' in 'field list' at /home/bitcoin/www/11/index.html line 83.

context:

...
79:
80:	#----------------------------------------------------------------------------------------------------------------------------------------------------------------------#
81:	$sth = $dbh->prepare("SELECT 1d, 3d, 7d, 30d, 92d, 183d, 274d, 365d FROM bitcoin.hash_ticker WHERE 365d > 1000 ORDER BY dt1 DESC LIMIT 1;");
82:	# $sth = $dbh->prepare("SELECT 1d, 3d, 7d, 30d, 92d, 183d, 274d, 365d FROM bitcoin.hash_ticker WHERE (365d > 1000 AND 92d > 1000) ORDER BY dt1 DESC LIMIT 1;");
83:	$sth->execute();
84:	my ($CUMULATIVE_1D, $CUMULATIVE_3D, $CUMULATIVE_1W, $CUMULATIVE_1M, $CUMULATIVE_3M, $CUMULATIVE_6M, $CUMULATIVE_9M, $CUMULATIVE_1Y) = $sth->fetchrow_array() and $sth->finish();
85:	$AVERAGE = $CUMULATIVE_1Y;
86:	#----------------------------------------------------------------------------------------------------------------------------------------------------------------------#
87:	$sth = $dbh->prepare("SELECT AVG(avg_tx_fee) FROM ( SELECT DISTINCT avg_tx_fee FROM difficulty WHERE dt >= (NOW() - INTERVAL $PERIOD DAY)) a");
...

code stack:

/home/bitcoin/www/11/index.html:83

raw error

DBD::mysql::st execute failed: Unknown column '3d' in 'field list' at /home/bitcoin/www/11/index.html line 83.


Trace begun at /usr/local/share/perl/5.30.0/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: Unknown column \'3d\' in \'field list\' at /home/bitcoin/www/11/index.html line 83.^J') called at /home/bitcoin/www/11/index.html line 83
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f44cc05b080)') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1300
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f447c1f7618)') called at /usr/local/share/perl/5.30.0/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f447c1f7618)') called at /usr/local/share/perl/5.30.0/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f449c049128)', 'Apache2::RequestRec=SCALAR(0x7f44a830e580)') called at (eval 27) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x7f44a830e580)') called at -e line 0
eval {...} at -e line 0