Caught exception in nneweb::Controller::Root->article "DBD::Pg::st execute failed: ERROR: value "32400242006" is out of range for type integer CONTEXT: unnamed portal parameter $1 = '...' at /home/www-admin/nnemaster/nneweb/script/../lib/nneweb/Controller/Root.pm line 1190, <CONF> line 127803."

Request

do {
  require Symbol;
  my $a = bless({
    _log                 => bless({
                              _body => "[info] *** Request 6708 (1.221/s) [879829] [Tue Mar 19 01:32:00 2024] ***\n[debug] Path is \"/\"\n[debug] Arguments are \"story/id/32400242006\"\n[debug] \"GET\" request for \"story/id/32400242006/\" from \"52.90.181.205\"\n[debug] Request for rawhostname = 'amherstbulletin.com'\n[debug] handletheme: site count test result: \$VAR1 = 7;\n[error] Caught exception in nneweb::Controller::Root->article \"DBD::Pg::st execute failed: ERROR:  value \"32400242006\" is out of range for type integer\nCONTEXT:  unnamed portal parameter \$1 = '...' at /home/www-admin/nnemaster/nneweb/script/../lib/nneweb/Controller/Root.pm line 1190, <CONF> line 127803.\"\n",
                              _psgi_errors => \*main::STDERR,
                              abort => undef,
                              autoflush => 0,
                              level => 31,
                            }, "Catalyst::Log"),
    _path                => "story/id/32400242006/",
    _read_length         => 0,
    _read_position       => 0,
    _use_hash_multivalue => 0,
    action               => "/",
    address              => "52.90.181.205",
    arguments            => ["story", "id", 32400242006],
    base                 => bless(do{\(my $o = "https://amherstbulletin.com/")}, "URI::https"),
    body_parameters      => {},
    captures             => [],
    cookies              => {},
    data_handlers        => {
                              "application/json" => sub { ... },
                              "application/x-www-form-urlencoded" => sub { ... },
                            },
    env                  => {
                              "Catalyst.Stash.v2"             => sub { ... },
                              "DOCUMENT_ROOT"                 => "/var/www/html",
                              "DOCUMENT_URI"                  => "/story/id/32400242006/",
                              "FCGI_ROLE"                     => "RESPONDER",
                              "GATEWAY_INTERFACE"             => "CGI/1.1",
                              "HTTP_ACCEPT"                   => "*/*",
                              "HTTP_HOST"                     => "amherstbulletin.com",
                              "HTTP_REFERER"                  => "http://amherstbulletin.com/story/id/32400242006/",
                              "HTTP_USER_AGENT"               => "claudebot",
                              "HTTPS"                         => "on",
                              "PATH_INFO"                     => "/story/id/32400242006/",
                              "plack.original_request_method" => "GET",
                              "psgi.errors"                   => 'fix',
                              "psgi.input"                    => bless(Symbol::gensym(), "IO::Handle"),
                              "psgi.multiprocess"             => 1,
                              "psgi.multithread"              => "",
                              "psgi.nonblocking"              => "",
                              "psgi.run_once"                 => "",
                              "psgi.streaming"                => 1,
                              "psgi.url_scheme"               => "https",
                              "psgi.version"                  => [1, 1],
                              "psgix.cleanup"                 => 1,
                              "psgix.cleanup.handlers"        => [],
                              "psgix.harakiri"                => 1,
                              "QUERY_STRING"                  => "",
                              "REDIRECT_STATUS"               => 200,
                              "REMOTE_ADDR"                   => "52.90.181.205",
                              "REMOTE_PORT"                   => 47200,
                              "REMOTE_USER"                   => "",
                              "REQUEST_METHOD"                => "GET",
                              "REQUEST_SCHEME"                => "https",
                              "REQUEST_URI"                   => "/story/id/32400242006/",
                              "SCRIPT_FILENAME"               => "/var/www/html/story/id/32400242006/",
                              "SCRIPT_NAME"                   => "",
                              "SERVER_ADDR"                   => "10.0.0.8",
                              "SERVER_NAME"                   => "amherstbulletin.com",
                              "SERVER_PORT"                   => 443,
                              "SERVER_PROTOCOL"               => "HTTP/1.1",
                              "SERVER_SOFTWARE"               => "nginx/1.18.0",
                            },
    headers              => bless({
                              "::std_case" => { cookie => "Cookie", https => "HTTPS" },
                              "accept"     => "*/*",
                              "host"       => "amherstbulletin.com",
                              "https"      => "on",
                              "referer"    => "http://amherstbulletin.com/story/id/32400242006/",
                              "user-agent" => "claudebot",
                            }, "HTTP::Headers"),
    match                => "/",
    method               => "GET",
    parameters           => {},
    protocol             => "HTTP/1.1",
    query_parameters     => {},
    remote_user          => "",
    secure               => 1,
    uploads              => {},
    uri                  => bless(do{\(my $o = "https://amherstbulletin.com/story/id/32400242006/")}, "URI::https"),
  }, "Catalyst::Request");
  $a->{env}{"psgi.errors"} = *{$a->{_log}{_psgi_errors}};
  $a;
}

Response

bless({
  _log => bless({
    _body => "[info] *** Request 6708 (1.221/s) [879829] [Tue Mar 19 01:32:00 2024] ***\n[debug] Path is \"/\"\n[debug] Arguments are \"story/id/32400242006\"\n[debug] \"GET\" request for \"story/id/32400242006/\" from \"52.90.181.205\"\n[debug] Request for rawhostname = 'amherstbulletin.com'\n[debug] handletheme: site count test result: \$VAR1 = 7;\n[error] Caught exception in nneweb::Controller::Root->article \"DBD::Pg::st execute failed: ERROR:  value \"32400242006\" is out of range for type integer\nCONTEXT:  unnamed portal parameter \$1 = '...' at /home/www-admin/nnemaster/nneweb/script/../lib/nneweb/Controller/Root.pm line 1190, <CONF> line 127803.\"\n",
    _psgi_errors => \*main::STDERR,
    abort => undef,
    autoflush => 0,
    level => 31,
  }, "Catalyst::Log"),
  _response_cb => sub { ... },
  body => undef,
  cookies => {},
  encodable_content_type => qr/text|xml$|javascript$/,
  encoding => bless({ Name => "utf-8-strict", strict_utf8 => 1 }, "Encode::utf8"),
  finalized_headers => 0,
  headers => bless({
    "::std_case"   => { "x-catalyst" => "X-Catalyst" },
    "content-type" => "text/html; charset=utf-8",
    "x-catalyst"   => 5.90128,
  }, "HTTP::Headers"),
  status => 200,
}, "Catalyst::Response")

Stash

{
  advertiseurl               => undef,
  artsection                 => "Arts",
  artsectionsiteoverride     => undef,
  calendartoparticle         => 53996311,
  canonicalhostbase          => "https://www.amherstbulletin.com/",
  cbuzzdomain                => "gazettenet",
  cbuzzwidget                => "22815963481662152843",
  citysparkid                => 8252,
  citysparkscript            => "https://portal.CitySpark.com/PortalScripts/amherstbulletin",
  citysparksection           => "Events",
  classifiedhost             => "marketplace",
  clientip                   => "52.90.181.205",
  connatixid                 => "",
  connatixplayer             => "",
  copyrightnotice            => "Copyright &copy; 2023 to 2024 by H.S. Gere &amp; Sons, Inc. All rights reserved.",
  customblockkeyword         => undef,
  customblockname            => undef,
  customblocksection         => undef,
  dfpadclient                => "ca-pub-4997120530824758",
  displayads                 => "y",
  domainname                 => "amherstbulletin.com",
  eeditionhost               => "",
  fbid                       => 272019639649492,
  googlesiteverify           => "eccn9qmiwGf3C08l0fhenuQbyESVNbpXyRRxy8Lj6Pc",
  homecentercount            => 1,
  hostbase                   => "https://amherstbulletin.com/",
  letterformemail            => "amherst\@gazettenet.com.com",
  newsletterurl              => undef,
  nne_page_type              => "article/",
  obitbrowsetarget           => undef,
  obitstartinhouse           => undef,
  opinionsection             => "Commentary",
  opinionsectionsiteoverride => undef,
  paywallhost                => "",
  paywallversion             => undef,
  rawhostbase                => bless(do{\(my $o = "https://amherstbulletin.com/")}, "URI::https"),
  realmatchid                => undef,
  recaptchasitekey           => "6Ldlg10pAAAAAN4fYAOdrdvyAI0to059iXFaNyZ2",
  sitecode                   => "AB",
  siteid                     => 7,
  sitename                   => "Amherst Bulletin",
  skiplocaladblock           => 0,
  sportformemail             => "sports\@gazettenet.com",
  sportsection               => "Sports",
  sportsectionsiteoverride   => undef,
  theme                      => "full",
  tipformemail               => "amherst\@gazettenet.com",
  twittersite                => "\@amherstbulletin",
  weatherenabled             => 1,
  weathersource              => "https://nneamherst5.accuweather.com/hostedpages/widget/v2/NNEamherst5/current-weather/amherst,ma/conmon",
  weathertarget              => "https://nneamherst5.accuweather.com/hosted/NNEamherst5-landing.asp?partner=NNEamherst5",
  yesterdaysmostreadarticles => [],
}

Config

do {
  my $a = {
    "Action::RenderView" => {
      ignore_classes => [
                          "DBIx::Class::ResultSource::Table",
                          "DBIx::Class::ResultSourceHandle",
                          "DateTime",
                        ],
      scrubber_func  => sub { ... },
    },
    "disable_component_resolution_regex_fallback" => 1,
    "enable_catalyst_header" => 1,
    "home" => "/home/www-admin/nnemaster/nneweb",
    "name" => "nneweb",
    "Plugin::ConfigLoader" => {},
    "Plugin::Static::Simple" => {
      debug => 1,
      dirs => [],
      ignore_dirs => [],
      ignore_extensions => ["tmpl", "tt", "tt2", "html", "xhtml"],
      include_path => [
        bless({
          dirs => ["", "home", "www-admin", "nnemaster", "nneweb", "root"],
          file_spec_class => undef,
          volume => "",
        }, "Path::Class::Dir"),
      ],
      mime_types => {},
      mime_types_obj => bless({}, "MIME::Types"),
      no_logs => 1,
    },
    "root" => 'fix',
    "static" => 'fix',
  };
  $a->{"root"} = $a->{"Plugin::Static::Simple"}{include_path}[0];
  $a->{"static"} = $a->{"Plugin::Static::Simple"};
  $a;
}

nneweb on Catalyst 5.90128