On 07/22/2014 01:10 PM, Bill McGonigle wrote:
> I did see this backtrace, but I'm not sure at which point the query is built
> (looks like DBIx::SearchBuilder::_DoSearch gets a perl object and builds the
> SQL?)
Maybe I see what's going on - I've got some mysql code paths being called. I
wonder if I messed up the config.
I have:
Set($DatabaseType , 'Pg');
And it _is_ mostly working, so I gotta figure it's finding the right database
(using the right DBD, etc.). So ... odd.
-Bill
[26226] [Tue Jul 22 16:52:53 2014] [warning]: DBD::Pg::st execute failed:
ERROR: function last_insert_id() does not exist
LINE 1: SELECT LAST_INSERT_ID()
^
HINT: No function matches the given name and argument types. You might need to
add explicit type casts. at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm:589)
[26226] [Tue Jul 22 16:52:53 2014] [warning]: RT::Handle=HASH(0x7f238c35c538)
couldn't execute the query 'SELECT LAST_INSERT_ID()' at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 602.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7f238c35c538)',
'SELECT LAST_INSERT_ID()') called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle.pm line 634
DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0x7f238c35c538)',
'SELECT LAST_INSERT_ID()') called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Handle/mysql.pm line 44
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7f238c35c538)',
'Tickets', 'Subject', 'openstack for Boston', 'Status', 'new', 'Queue', 5,
'Creator', ...) called at
/usr/share/perl5/vendor_perl/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create('RT::Ticket=HASH(0x7f238cb99360)',
'Subject', 'openstack for Boston', 'Status', 'new', 'Queue', 5, 'Creator', 22,
...) called at /usr/share/perl5/vendor_perl/RT/Record.pm line 316
--
Bill McGonigle, Owner
BFC Computing, LLC
http://bfccomputing.com/
Telephone: +1.855.SW.LIBRE
Email, IM, VOIP: [email protected]
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
