I'm seeing this on my console<div><br></div><div><div>[Thu May 3 23:06:29 2012] [warning]: DBD::Pg::st execute failed: ERROR: relation "tickets" does not exist</div><div>LINE 1: SELECT main.* FROM Tickets main WHERE (main.Status != 'dele...</div>
<div> ^ at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)</div><div>[Thu May 3 23:06:29 2012] [warning]: RT::Handle=HASH(0x848de00) couldn't execute the query 'SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Queue = '4' AND ( main.Status = 'new' OR main.Status = 'open' OR main.Status = 'stalled' ) ) AND (main.EffectiveId = <a href="http://main.id">main.id</a>) AND (main.Type = 'ticket') ORDER BY <a href="http://main.id">main.id</a> ASC LIMIT 1000' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x848de00)', 'SELECT main.* FROM Tickets main WHERE (main.Status != \'dele...') called at /usr/share/perl5/DBIx/SearchBuilder.pm line 235</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 320</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::SearchBuilder::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2955</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Tickets::_DoSearch('RT::Tickets=HASH(0x84808b0)') called at /usr/share/perl5/DBIx/SearchBuilder.pm line 503</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>DBIx::SearchBuilder::Next('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2927</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Tickets::Next('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2910</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Tickets::ItemsArrayRefWindow('RT::Tickets=HASH(0x84808b0)', 1000) called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 3441</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Tickets::_BuildItemMap('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 3482</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Tickets::ItemMap('RT::Tickets=HASH(0x84808b0)') called at /opt/rt4/share/html/Ticket/Display.html line 223</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Commands::__ANON__('id', 19) called at /usr/share/perl5/HTML/Mason/Component.pm line 135</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x73ccba8)', 'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 955</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7a0f408)') called at /opt/rt4/share/html/Ticket/autohandler line 19</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Commands::__ANON__('id', 19) called at /usr/share/perl5/HTML/Mason/Component.pm line 135</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7724e60)', 'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Interface::Web::ShowRequestedPage('HASH(0x7b76c60)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Interface::Web::HandleRequest('HASH(0x7b76c60)') called at /opt/rt4/share/html/autohandler line 53</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Commands::__ANON__('id', 19) called at /usr/share/perl5/HTML/Mason/Component.pm line 135</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x717e1c8)', 'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 1297</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::comp(undef, undef, undef, 'id', 19) called at /usr/share/perl5/HTML/Mason/Request.pm line 481</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 481</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 433</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7a0f408)') called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 85</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 85</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7a0f408)') called at /usr/share/perl5/HTML/Mason/Interp.pm line 342</div><div>
<span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::Interp::exec(undef, undef, 'id', 19) called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 48</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /usr/share/perl5/HTML/Mason/PSGIHandler.pm line 48</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x3ab53f0)', 'HTML::Mason::FakeApache=HASH(0x7b34bd8)', 'HASH(0x84b04e8)') called at /usr/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x84922a8)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RT::Interface::Web::Handler::__ANON__('CODE(0x84922a8)') called at /usr/share/perl5/Plack/Util.pm line 315</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Plack::Util::__ANON__('CODE(0x84d5b38)') called at /usr/share/perl5/Plack/Util.pm line 315</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Plack::Util::__ANON__('CODE(0x84923b0)') called at /usr/share/perl5/HTTP/Server/PSGI.pm line 185</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTTP::Server::PSGI::handle_connection('HTTP::Server::PSGI=HASH(0x3abc398)', 'HASH(0x7b5b450)', 'IO::Socket::INET=GLOB(0x8491ff0)', 'CODE(0x6f7e418)') called at /usr/share/perl5/HTTP/Server/PSGI.pm line 134</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTTP::Server::PSGI::accept_loop('HTTP::Server::PSGI=HASH(0x3abc398)', 'CODE(0x3ab96e0)') called at /usr/share/perl5/HTTP/Server/PSGI.pm line 62</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>HTTP::Server::PSGI::run('HTTP::Server::PSGI=HASH(0x3abc398)', 'CODE(0x3ab96e0)') called at /usr/share/perl5/Plack/Handler/HTTP/Server/PSGI.pm line 14</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Plack::Handler::HTTP::Server::PSGI::run('Plack::Handler::Standalone=HASH(0x6f7e898)', 'CODE(0x3ab96e0)') called at /usr/share/perl5/Plack/Loader.pm line 87</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Plack::Loader::run('Plack::Loader=HASH(0x3abc248)', 'Plack::Handler::Standalone=HASH(0x6f7e898)') called at /usr/share/perl5/Plack/Runner.pm line 263</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>Plack::Runner::run('Plack::Runner=HASH(0x68961d0)', 'CODE(0x3ab96e0)') called at /opt/rt4/sbin/rt-server line 231</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>eval {...} called at /opt/rt4/sbin/rt-server line 231 (/usr/share/perl/5.12/Carp.pm:65)</div>
<div><br></div><div><br></div><div>I configured my server in devel mode:</div><div>./configure --enable-devel-mode --with-my-user-group --with-db-type=Pg --with-web-handler=standalone,fastcgi</div><div>and I'm running it stand-alone:</div>
<div>/opt/rt4/sbin/rt-server --server Standalone --port 8080 &</div><div><br></div><div>I can't think of any reason why it would think the table "tickets" doesn't exist, because of course it does. When I paste the query into pgsql it founds 4 tickets. I'm also not seeing anything unexpected on the web form.</div>
<div><br></div><div><br></div><div><br></div>-- <br><a href="http://www.linkedin.com/in/paultomblin">http://www.linkedin.com/in/paultomblin</a><br><a href="http://careers.stackoverflow.com/ptomblin">http://careers.stackoverflow.com/ptomblin</a><br>
<br>
</div>