On Fri, Aug 24, 2007 at 08:10:59PM -0700, Don Armstrong wrote:
> On Fri, 24 Aug 2007, Roberto C. Sánchez wrote:
> > I am still a relative Perl newbie, so I don't know anything about
> > the debugger. I will investigate and try and report back on this. If
> > you have a link that will help me get started on this, I would
> > appreciate it.
>
> perldoc perldebug; or in this case,
>
> perl -d vonage-calls.pl;
> b Time::Local::timegm;
> r;
> T;
>
perl -d vonage-calls.pl
Loading DB routines from perl5db.pl version 1.28
Editor support available.
Enter h or `h h' for help, or `man perldebug' for more help.
"-T" is on the #! line, it must also be used on the command line at vonage-calls.pl line 1.
at vonage-calls.pl line 1
Debugged program terminated. Use q to quit or R to restart,
use o inhibit_exit to avoid stopping after program termination,
h q, h R or h o to get additional info.
DB<1> b Time::Local::timegm;
Subroutine Time::Local::timegm not found.
at /usr/share/perl/5.8/perl5db.pl line 4410
DB::break_subroutine('Time::Local::timegm', ';') called at /usr/share/perl/5.8/perl5db.pl line 4474
eval {...} called at /usr/share/perl/5.8/perl5db.pl line 4474
DB::cmd_b_sub('Time::Local::timegm', ';') called at /usr/share/perl/5.8/perl5db.pl line 4051
DB::cmd_b('b', 'Time::Local::timegm;', 9425) called at /usr/share/perl/5.8/perl5db.pl line 3862
DB::cmd_wrapper('Time::Local::timegm', ';', 9425) called at /usr/share/perl/5.8/perl5db.pl line 2565
DB::DB called at /usr/share/perl/5.8/perl5db.pl line 9425
DB::fake::at_exit() called at /usr/share/perl/5.8/perl5db.pl line 8997
DB::END() called at vonage-calls.pl line 1
eval {...} called at vonage-calls.pl line 1
DB<2> r
Use `q' to quit or `R' to restart. `h q' for details.
DB<2> T
$ = DB::fake::at_exit() called from file `/usr/share/perl/5.8/perl5db.pl' line 8997
$ = DB::END() called from file `vonage-calls.pl' line 1
$ = eval {...} called from file `vonage-calls.pl' line 1
> > OK. I made the output more verbose (obviously the phone number is
> > obfuscated):
> >
> > Adding call 11856261279 to the database...
> > Using values: 11856261279, Aug 24, 2007 06:30 PM, , 10000000000, Voicemail, 00:01:00
> > ERROR: syntax error at or near "$2" at character 119
>
> What I'm missing here is where the "$2" is comming from; knowing the
> actual query (or as close as can be gotten) that is being run would
> help.
>
> DBI->trace(3); or so should help provide that information.
>
Attached. The actual file was extremely long, so I cut down to only the
first two errors.
Regards,
-Roberto
--
Roberto C. Sánchez
http://people.connexer.com/~roberto
http://www.connexer.com
DBI 1.53-ithread default trace level set to 0x0/3 (pid 20213)
-> DBI->connect(dbi:Pg:dbname=calldb, user, ****, HASH(0x9a6cc0))
-> DBI->install_driver(Pg) for linux perl=5.008008 pid=20213 ruid=1000 euid=1000
install_driver: DBD::Pg version 1.49 loaded from /usr/lib/perl5/DBD/Pg.pm
New DBI::dr (for DBD::Pg::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0xa14290)=>DBI::dr=HASH(0x99a4f0), DBD::Pg::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Pg::dr, 152, 0) thr#503010
<- install_driver= DBI::dr=HASH(0xa14290)
-> connect for DBD::Pg::dr (DBI::dr=HASH(0xa14290)~0x99a4f0 'dbname=calldb' 'user' **** HASH(0xb81bc0)) thr#503010
New DBI::db (for DBD::Pg::db, parent=DBI::dr=HASH(0x99a4f0), id=)
dbih_setup_handle(DBI::db=HASH(0x99a3d0)=>DBI::db=HASH(0xb81c00), DBD::Pg::db, a13f60, Null!)
dbih_make_com(DBI::dr=HASH(0x99a4f0), b67d50, DBD::Pg::db, 208, 0) thr#503010
-> FETCH for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'pg_server_version') thr#503010
<- FETCH= 80109 at Pg.pm line 160 via at vonage-calls.pl line 42
-> FETCH for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'private_dbdpg') thr#503010
.. FETCH DBI::db=HASH(0xb81c00) 'private_dbdpg' = undef
<- FETCH= undef at Pg.pm line 161 via at vonage-calls.pl line 42
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'private_dbdpg' HASH(0xb81e20)) thr#503010
STORE DBI::db=HASH(0xb81c00) 'private_dbdpg' => HASH(0xb81e20)
<- STORE= 1 at Pg.pm line 161 via at vonage-calls.pl line 42
<- connect= DBI::db=HASH(0x99a3d0) at DBI.pm line 625
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'PrintError' 0) thr#503010
STORE DBI::db=HASH(0xb81c00) 'PrintError' => 0
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'AutoCommit' 1) thr#503010
<- STORE= 1 at DBI.pm line 672
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'Username' 'user') thr#503010
STORE DBI::db=HASH(0xb81c00) 'Username' => 'user'
<- STORE= 1 at DBI.pm line 675 via at vonage-calls.pl line 42
<> FETCH= 'callmgr' ('Username' from cache) at DBI.pm line 675
<- connect= DBI::db=HASH(0x99a3d0)
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb81c00)~INNER 'dbi_connect_closure' CODE(0x99a2d0)) thr#503010
STORE DBI::db=HASH(0xb81c00) 'dbi_connect_closure' => CODE(0x99a2d0)
<- STORE= 1 at DBI.pm line 691 via at vonage-calls.pl line 42
-> prepare for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00 'INSERT INTO calls (trans_id, dtg, caller_name, from_number, to_number, duration) VALUES (?, TIMESTAMP WITH TIME ZONE ?, ?, ?, ?, ?)') thr#503010
New DBI::st (for DBD::Pg::st, parent=DBI::db=HASH(0xb81c00), id=)
dbih_setup_handle(DBI::st=HASH(0xb81ce0)=>DBI::st=HASH(0xb81b70), DBD::Pg::st, b81cf0, Null!)
dbih_make_com(DBI::db=HASH(0xb81c00), b85840, DBD::Pg::st, 288, 0) thr#503010
<- prepare= DBI::st=HASH(0xb81ce0) at vonage-calls.pl line 44
Day too big - 38605 > 24855
Sec too small - 38605 < 74752
Sec too big - 38605 > 11647
-> execute for DBD::Pg::st (DBI::st=HASH(0xb81ce0)~0xb81b70 '11856261279' 'Aug 24, 2007 06:30 PM' '' '1000000000' 'Voicemail' '00:01:00') thr#503010
dbdpg: ERROR: syntax error at or near "$2" at character 119
error 7 recorded: ERROR: syntax error at or near "$2" at character 119
!! ERROR: 7 'ERROR: syntax error at or near "$2" at character 119
' (err#0)
<- execute= undef at vonage-calls.pl line 130
-> err in DBD::_::common for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: syntax error at or near "$2" at character 119
' (err#0)
<- err= 7 at vonage-calls.pl line 131
-> errstr in DBD::_::common for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: syntax error at or near "$2" at character 119
' (err#0)
<- errstr= 'ERROR: syntax error at or near "$2" at character 119
' at vonage-calls.pl line 131
-> errstr for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: syntax error at or near "$2" at character 119
' (err#0)
<- errstr= ( 'ERROR: syntax error at or near "$2" at character 119
' ) [1 items] at vonage-calls.pl line 132
ERROR: syntax error at or near "$2" at character 119
-> execute for DBD::Pg::st (DBI::st=HASH(0xb81ce0)~0xb81b70 '11767780546' 'Aug 20, 2007 12:41 PM' '' '1000000000' 'Voicemail' '00:01:00') thr#503010
dbdpg: ERROR: prepared statement "dbdpg_1" does not exist
error 7 recorded: ERROR: prepared statement "dbdpg_1" does not exist
!! ERROR: 7 'ERROR: prepared statement "dbdpg_1" does not exist
' (err#0)
<- execute= undef at vonage-calls.pl line 130
-> err for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: prepared statement "dbdpg_1" does not exist
' (err#0)
<- err= 7 at vonage-calls.pl line 131
-> errstr for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: prepared statement "dbdpg_1" does not exist
' (err#0)
<- errstr= 'ERROR: prepared statement "dbdpg_1" does not exist
' at vonage-calls.pl line 131
-> errstr for DBD::Pg::db (DBI::db=HASH(0x99a3d0)~0xb81c00) thr#503010
ERROR: 7 'ERROR: prepared statement "dbdpg_1" does not exist
' (err#0)
<- errstr= ( 'ERROR: prepared statement "dbdpg_1" does not exist
' ) [1 items] at vonage-calls.pl line 132
ERROR: prepared statement "dbdpg_1" does not exist
Attachment:
signature.asc
Description: Digital signature