I guess I spoke a little too soon. Thinking everything was fixed, I
turned tracing off - and the problems started again. With tracing on,
no problems. Here is a snip of a trace:
tail -f /tmp/dbi.out
<- dbd_st_fetch, 1 cols
-> dbd_st_fetch for 08362874, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x83628f8) ] row1 at DBHelper.pm line
61 via /usr/local/sis/web/sis/admin/addescuela.cgi line 135
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x836282c)~INNER)
<- DESTROY= undef at addescuela.cgi line 135
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x8068e20)~0x83535c0)
&imp_dbh->mysql: 834b05c
<- disconnect= 1 at DBHelper.pm line 207 via
/usr/local/sis/web/sis/admin/addescuela.cgi line 268
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x83535c0)~INNER)
<- DESTROY= undef
DBI::db=HASH(0x8352d78) trace level set to 0x0/4 (DBI @ 0x0/0) in
DBI 1.48-nothread (pid 94114)
-> prepare for DBD::mysql::db (DBI::db=HASH(0x8363dd8)~0x8352d78
'SELECT id, nombre_corta FROM escuelas')
dbih_setup_handle(DBI::st=HASH(0x8352f04)=>DBI::st=HASH(0x8352fc4),
DBD::mysql::st, 8352f10, Null!)
dbih_make_com(DBI::db=HASH(0x8352d78), 8066004, DBD::mysql::st, 224,
0) thr#0
Setting mysql_use_result to 0
<- prepare= DBI::st=HASH(0x8352f04) at DBHelper.pm line 57 via
/usr/local/sis/lib/DBHelper.pm line 132
-> execute for DBD::mysql::st (DBI::st=HASH(0x8352f04)~0x8352fc4)
-> dbd_st_execute for 0834102c
-> mysql_st_interal_execute
<- mysql_st_internal_execute ERROR: returning -1
<- dbd_st_execute 4 rows
<- execute= 4 at DBHelper.pm line 60 via
/usr/local/sis/lib/DBHelper.pm line 132
-> fetchall_arrayref for DBD::mysql::st
(DBI::st=HASH(0x8352f04)~0x8352fc4)
-> dbd_st_fetch for 0834102c, chopblanks 0
dbih_setup_fbav for 2 fields => 0x8352fdc
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834102c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834102c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834102c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834102c, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x83410bc) ARRAY(0x8341170)
ARRAY(0x83411a0) ARRAY(0x83411d0) ] row4 at DBHelper.pm line 61 via
/usr/local/sis/lib/DBHelper.pm line 132
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8352fc4)~INNER)
<- DESTROY= undef at DBHelper.pm line 132
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x8363dd8)~0x8352d78)
&imp_dbh->mysql: 806605c
<- disconnect= 1 at DBHelper.pm line 207 via
/usr/local/sis/web/sis/admin/addescuela.cgi line 268
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x8352d78)~INNER)
<- DESTROY= undef
DBI::db=HASH(0x8354578) trace level set to 0x0/4 (DBI @ 0x0/0) in
DBI 1.48-nothread (pid 94115)
-> prepare for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578
'select * from escuelas where id="4"')
dbih_setup_handle(DBI::st=HASH(0x8354704)=>DBI::st=HASH(0x83547c4),
DBD::mysql::st, 8354710, Null!)
dbih_make_com(DBI::db=HASH(0x8354578), 8363004, DBD::mysql::st, 224,
0) thr#0
Setting mysql_use_result to 0
<- prepare= DBI::st=HASH(0x8354704) at DBHelper.pm line 57 via
/usr/local/sis/web/sis/admin/addescuela.cgi line 193
-> execute for DBD::mysql::st (DBI::st=HASH(0x8354704)~0x83547c4)
-> dbd_st_execute for 0834202c
-> mysql_st_interal_execute
<- mysql_st_internal_execute ERROR: returning -1
<- dbd_st_execute 1 rows
<- execute= 1 at DBHelper.pm line 60 via
/usr/local/sis/web/sis/admin/addescuela.cgi line 193
-> fetchall_arrayref for DBD::mysql::st
(DBI::st=HASH(0x8354704)~0x83547c4)
-> dbd_st_fetch for 0834202c, chopblanks 0
dbih_setup_fbav for 18 fields => 0x83547dc
<- dbd_st_fetch, 18 cols
-> dbd_st_fetch for 0834202c, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x8342200) ] row1 at DBHelper.pm line
61 via /usr/local/sis/web/sis/admin/addescuela.cgi line 193
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x83547c4)~INNER)
<- DESTROY= undef at addescuela.cgi line 193
-> trace for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578 4
'/tmp/dbi.out')
<- trace= 4 at DBHelper.pm line 49 via
/usr/local/sis/lib/DBHelper.pm line 132
-> prepare for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578
'SELECT nivel, nivel FROM nivels')
dbih_setup_handle(DBI::st=HASH(0x8342044)=>DBI::st=HASH(0x83547b8),
DBD::mysql::st, 8342050, Null!)
dbih_make_com(DBI::db=HASH(0x8354578), 8363004, DBD::mysql::st, 224,
0) thr#0
Setting mysql_use_result to 0
<- prepare= DBI::st=HASH(0x8342044) at DBHelper.pm line 57 via
/usr/local/sis/lib/DBHelper.pm line 132
-> execute for DBD::mysql::st (DBI::st=HASH(0x8342044)~0x83547b8)
-> dbd_st_execute for 082a0994
-> mysql_st_interal_execute
<- mysql_st_internal_execute ERROR: returning -1
<- dbd_st_execute 4 rows
<- execute= 4 at DBHelper.pm line 60 via
/usr/local/sis/lib/DBHelper.pm line 132
-> fetchall_arrayref for DBD::mysql::st
(DBI::st=HASH(0x8342044)~0x83547b8)
-> dbd_st_fetch for 082a0994, chopblanks 0
dbih_setup_fbav for 2 fields => 0x8342200
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 082a0994, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 082a0994, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 082a0994, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 082a0994, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x8342254) ARRAY(0x83422d8)
ARRAY(0x83421ac) ARRAY(0x834217c) ] row4 at DBHelper.pm line 61 via
/usr/local/sis/lib/DBHelper.pm line 132
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x83547b8)~INNER)
<- DESTROY= undef at DBHelper.pm line 132
-> trace for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578 4
'/tmp/dbi.out')
<- trace= 4 at DBHelper.pm line 49 via
/usr/local/sis/lib/DBHelper.pm line 132
-> prepare for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578
'SELECT grado, grado FROM grados')
dbih_setup_handle(DBI::st=HASH(0x8342218)=>DBI::st=HASH(0x8342044),
DBD::mysql::st, 8342224, Null!)
dbih_make_com(DBI::db=HASH(0x8354578), 8363004, DBD::mysql::st, 224,
0) thr#0
Setting mysql_use_result to 0
<- prepare= DBI::st=HASH(0x8342218) at DBHelper.pm line 57 via
/usr/local/sis/lib/DBHelper.pm line 132
-> execute for DBD::mysql::st (DBI::st=HASH(0x8342218)~0x8342044)
-> dbd_st_execute for 083420a4
-> mysql_st_interal_execute
<- mysql_st_internal_execute ERROR: returning -1
<- dbd_st_execute 7 rows
<- execute= 7 at DBHelper.pm line 60 via
/usr/local/sis/lib/DBHelper.pm line 132
-> fetchall_arrayref for DBD::mysql::st
(DBI::st=HASH(0x8342218)~0x8342044)
-> dbd_st_fetch for 083420a4, chopblanks 0
dbih_setup_fbav for 2 fields => 0x83422c0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 083420a4, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x83422b4) ARRAY(0x82a0a54)
ARRAY(0x8342260) ARRAY(0x8342248) ARRAY(0x8342038) ARRAY(0x83546f8)
ARRAY(0x83420d4) ] row7 at DBHelper.pm line 61 via
/usr/local/sis/lib/DBHelper.pm line 132
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8342044)~INNER)
<- DESTROY= undef at DBHelper.pm line 132
-> trace for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578 4
'/tmp/dbi.out')
<- trace= 4 at DBHelper.pm line 49 via
/usr/local/sis/lib/DBHelper.pm line 132
-> prepare for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578
'SELECT groupo, groupo FROM groupos')
dbih_setup_handle(DBI::st=HASH(0x83422d8)=>DBI::st=HASH(0x8342218),
DBD::mysql::st, 83421d0, Null!)
dbih_make_com(DBI::db=HASH(0x8354578), 8363004, DBD::mysql::st, 224,
0) thr#0
Setting mysql_use_result to 0
<- prepare= DBI::st=HASH(0x83422d8) at DBHelper.pm line 57 via
/usr/local/sis/lib/DBHelper.pm line 132
-> execute for DBD::mysql::st (DBI::st=HASH(0x83422d8)~0x8342218)
-> dbd_st_execute for 0834223c
-> mysql_st_interal_execute
<- mysql_st_internal_execute ERROR: returning -1
<- dbd_st_execute 4 rows
<- execute= 4 at DBHelper.pm line 60 via
/usr/local/sis/lib/DBHelper.pm line 132
-> fetchall_arrayref for DBD::mysql::st
(DBI::st=HASH(0x83422d8)~0x8342218)
-> dbd_st_fetch for 0834223c, chopblanks 0
dbih_setup_fbav for 2 fields => 0x82a0a54
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834223c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834223c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834223c, chopblanks 0
<- dbd_st_fetch, 2 cols
-> dbd_st_fetch for 0834223c, chopblanks 0
<- fetchall_arrayref= [ ARRAY(0x83420b0) ARRAY(0x83420bc)
ARRAY(0x8342308) ARRAY(0x834202c) ] row4 at DBHelper.pm line 61 via
/usr/local/sis/lib/DBHelper.pm line 132
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8342218)~INNER)
<- DESTROY= undef at DBHelper.pm line 132
-> disconnect for DBD::mysql::db (DBI::db=HASH(0x8364dd8)~0x8354578)
&imp_dbh->mysql: 836305c
<- disconnect= 1 at DBHelper.pm line 207 via
/usr/local/sis/web/sis/admin/addescuela.cgi line 268
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x8354578)~INNER)
<- DESTROY= undef
There are some errors here, but I don't really understand the
significance of them. If anyone could shed some knowledge on what might
be going on - I would appreciate it.
Regards,
Chris
> -----Original Message-----
> From: Christopher Heidbrink [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 25, 2005 11:18 PM
> To: [email protected]
> Subject: Strange problems with fetchall_arrayref DBI, DBD::mysql
>
>
> Hello. I was having some strange problems with
> fetchall_arrayref in my code and thought I would share this
> with the list. The specific problem was when I was
> conducting multiple prepare/execute(s) and then using
> fetchall_arrayref to retrieve the data. The really strange
> part was it seemed as if I changed a bit of code here or
> there my script (I was currently working on) would work (with
> multiple statements) but then in other (seemingly) unrelated
> scripts all of the statements would not return data.
>
> Being relatively new to DBI, didn't really think to look
> there, so I upgraded mysql to 4.1.11 (from 4.1.5-gamma).
> Didn't help. This was my current config of DBI and related
> modules at this time: perl -MDBI -e 'DBI->installed_versions'
> Perl : 5.008005 (i386-freebsd-64int)
> OS : freebsd (5.3-release)
> DBI : 1.42
> DBD::mysql : 2.9004
> DBD::Sponge : 11.10
> DBD::Proxy : install_driver(Proxy) failed: Can't locate
> RPC/PlClient.pm in @INC
> DBD::File : 0.30
> DBD::ExampleP : 11.12
> DBD::DBM : 0.01
>
> I turned tracing on, and on the data that wasn't getting
> returned to my script, was showing up just fine in the trace
> log (the arrayrefs & rows were all there for the statements I
> was executing). Decided to upgrade DBI to 1.48. Still the
> same problems.
>
> Decided to upgrade DBD::mysql to 2.9006 and now it seems
> everything is working.
>
> perl -MDBI -e 'DBI->installed_versions'
> Perl : 5.008005 (i386-freebsd-64int)
> OS : freebsd (5.3-release)
> DBI : 1.48
> DBD::mysql : 2.9006
> DBD::Sponge : 11.10
> DBD::Proxy : install_driver(Proxy) failed: Can't locate
> RPC/PlClient.pm in @INC
> DBD::File : 0.33
> DBD::ExampleP : 11.12
> DBD::DBM : 0.02
>
> I looked through the changelog for DBD::mysql and didn't find
> anything specific to the problem that I was having but maybe
> there is some summarization going on in the changelog or I'm
> not seeing something that is actual related.
>
> Regards,
>
> Chris
>
>
>
>
>
