Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. Asset search error (Karl Putland)
----------------------------------------------------------------------
Message: 1
Date: Mon, 17 Sep 2012 10:33:07 -0600
From: Karl Putland <[email protected]>
Subject: [Netdot-devel] Asset search error
To: [email protected]
Message-ID:
<CA+EXWsxPVTnc+1h1=z=z6-ddge6-7rdinqyatqpd0n59be+...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Click Management/Assets,
Click Search button
This is likely a Pg query issue...
*System error*
*96:* local @CARP_NOT = $cgc ? $cgc->() : caller();*97:*
shortmess_heavy(@_);*98:* }*99:* *100:* *101:* sub confess { die longmess
@_ }*102:* sub carp { warn shortmess @_ }*103:* sub cluck { warn longmess
@_ }*104:* *...* *error:* Asset can't SELECT id, serial_number,
product_id, inventory_number, physaddr, reserved_for, maint_from,
maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )
: DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
unknown
LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
^
HINT: No operator matches the given name and argument type(s). *You might
need to add explicit type casts*. [for Statement "SELECT id, serial_number,
product_id, inventory_number, physaddr, reserved_for, maint_from,
maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )
" with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%', 7='%%']
at /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
Stack:
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
*context:* *...* sub croak { die shortmess @_ } *code stack:*
/usr/local/share/perl/5.14.2/Carp.pm:100
/usr/local/share/perl/5.14.2/Class/DBI.pm:169
/usr/local/share/perl/5.14.2/Class/DBI.pm:1143
/usr/local/share/perl/5.14.2/Class/DBI.pm:1083
/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33
/usr/local/netdot/htdocs/management/asset_tasks.html:240
/usr/local/netdot/htdocs/management/autohandler:81
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951
/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21
/usr/local/netdot/htdocs/autohandler:76
raw error<http://netdot.simplesignal.net/netdot/management/asset_tasks.html#raw>
Asset can't SELECT id, serial_number, product_id, inventory_number,
physaddr, reserved_for, maint_from, maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
LIKE ? OR maint_contract LIKE ? ) )
: DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~ unknown
LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts. [for Statement "SELECT id,
serial_number, product_id, inventory_number, physaddr, reserved_for,
maint_from, maint_until
FROM asset
WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
LIKE ? OR maint_contract LIKE ? ) )
" with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%',
7='%%'] at /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line
52.
Stack:
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]
[/usr/local/netdot/htdocs/management/autohandler:81]
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
[/usr/local/netdot/htdocs/autohandler:76]
at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
Trace begun at /usr/local/share/perl/5.14.2/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Asset can\'t SELECT id,
serial_number, product_id, inventory_number, physaddr, reserved_for,
maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ?
OR inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE
? OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
LIKE $7 ) ...^J
^^JHINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts. [for Statement
"SELECT id, serial_number, product_id, inventory_number, physaddr,
reserved_for, maint_from, maint_until^JFROM asset^JWHERE ( (
custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE ?
OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )^J" with ParamValues: 1=\'%%\', 2=\'%%\',
3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line
52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J at
/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.^J')
called at /usr/local/share/perl/5.14.2/Carp.pm line 100
Carp::croak('Asset can\'t SELECT id, serial_number, product_id,
inventory_number, physaddr, reserved_for, maint_from,
maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
LIKE $7 ) ...^J
^^JHINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts. [for Statement
"SELECT id, serial_number, product_id, inventory_number, physaddr,
reserved_for, maint_from, maint_until^JFROM asset^JWHERE ( (
custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE ?
OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )^J" with ParamValues: 1=\'%%\', 2=\'%%\',
3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line
52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 169
Class::DBI::_croak('Asset', 'Asset can\'t SELECT id, serial_number,
product_id, inventory_number, physaddr, reserved_for, maint_from,
maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J:
DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract
LIKE $7 ) ...^J
^^JHINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts. [for Statement
"SELECT id, serial_number, product_id, inventory_number, physaddr,
reserved_for, maint_from, maint_until^JFROM asset^JWHERE ( (
custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for LIKE ?
OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
maint_contract LIKE ? ) )^J" with ParamValues: 1=\'%%\', 2=\'%%\',
3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line
52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
'HTML::Mason::Exception=HASH(0x7f67b8157c18)') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 1143
Class::DBI::sth_to_objects('Asset',
'DBIx::ContextualFetch::st=HASH(0x7f67b8162de0)',
'ARRAY(0x7f67fd32c490)') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 1083
Class::DBI::retrieve_from_sql('Asset', '( ( custom_serial LIKE ? OR
inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ?
OR info LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )',
'%%', '%%', '%%', '%%', '%%', '%%', '%%') called at
/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33
Class::DBI::AbstractSearch::search_where('Asset',
'ARRAY(0x7f67b8090b70)') called at
/usr/local/netdot/htdocs/management/asset_tasks.html line 240
HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
/usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67b80a0f78)',
'search', '', 'submit', 'Search', 'search_type', 'all', 'showheader',
1, 'page', 'ASSETS') called at
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305
eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, 'search', '',
'submit', 'Search', 'search_type', 'all', 'showheader', 1, 'page',
'ASSETS') called at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm
line 958
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
'page', 'ASSETS') called at
/usr/local/netdot/htdocs/management/autohandler line 81
HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
'search_type', 'all', 'showheader', 1) called at
/usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 160
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f67ac00d760)',
'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
'showheader', 1) called at
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 951
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj
line 21
HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
'search_type', 'all', 'showheader', 1) called at
/usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67ac00d760)',
'search', '', 'submit', 'Search', 'search_type', 'all', 'showheader',
1) called at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line
1305
eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, 'search', '',
'submit', 'Search', 'search_type', 'all', 'showheader', 1) called at
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 958
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line
76
HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
'search_type', 'all') called at
/usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67ac0377a8)',
'search', '', 'submit', 'Search', 'search_type', 'all') called at
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1300
eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, 'search', '',
'submit', 'Search', 'search_type', 'all') called at
/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484
eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484
eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)')
called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)')
called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f67fc594c78)',
'Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)') called at
/usr/local/netdot/lib/Netdot/Mason.pm line 40
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)')
called at -e line 0
eval {...} at -e line 0
--Karl
Karl Putland
Senior VoIP Engineer
*SimpleSignal*
3600 S Yosemite, Suite 150
Denver, CO 80237
One Number Rings All My Phones: 303-242-8608
SimpleSignal.com <http://www.simplesignal.com/> |
Blog<http://www.simplesignal.com/blog>
| Facebook <http://www.facebook.com/SimpleSignal?ref=ts> |
Twitter<http://twitter.com/simplesignal>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-devel/attachments/20120917/e2767feb/attachment.html
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 66, Issue 13
********************************************
