http://qs321.pair.com?node_id=135300


in reply to (Ovid) Re: Disappearing results with DBI and bind_columns
in thread Disappearing results with DBI and bind_columns

Yes, I have, actually. At trace level 3. From what I can make out of it, it appears to be finding the rows. So there appears to be some sort of problem between the execute and the fetching of the results.

Below is the output of DBI->trace

DBI 1.20-nothread dispatch trace level set to 3 Note: perl is running without the recommended perl -w option -> prepare for DBD::mysql::db (Apache::DBI::db=HASH(0x8324ff0)~0x8 +325008 'SELECT id, username, password, email FROM user WHERE username = ?') New DBI::st (for DBD::mysql::st, parent=DBI::db=HASH (0x8325008 +), id=) dbih_setup_handle(DBI::st=HASH(0x832be60)=>DBI::st=HASH(0x831bff4) +, DBD::mysql::st, 832be6c, Null!) dbih_make_com(DBI::db=HASH(0x8325008), DBD::mysql::st, 204) Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x832be60) at DB.pm line 200 -> execute for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4 ' +ar0n') -> dbd_st_execute for 0831c0b4 Binding parameters: SELECT id, username, password, email FROM user WHERE username = 'ar0n' <- dbd_st_execute 1 rows <- execute= 1 at DB.pm line 202 -> bind_columns in DBD::_::st for DBD::mysql::st (DBI::st=HASH(0x8 +32be60)~0x831bff4 SCALAR(0x824a3e4) SCALAR(0x824a42c) SCALAR(0x824a44 +4) SCALAR(0x824a45c)) dbih_setup_fbav for 4 fields => 0x8332c98 dbih_sth_bind_col 1 => SCALAR(0x824a3e4) dbih_sth_bind_col 2 => SCALAR(0x824a42c) dbih_sth_bind_col 3 => SCALAR(0x824a444) dbih_sth_bind_col 4 => SCALAR(0x824a45c) <- bind_columns= 1 at DB.pm line 203 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4) -> dbd_st_fetch for 0831c0b4, chopblanks 0 Storing row 0 (1) in 0824a3e4 Storing row 1 (ar0n) in 0824a42c Storing row 2 (j0n4) in 0824a444 Storing row 3 (jona@knowltonian.net) in 0824a45c <- dbd_st_fetch, 4 cols <- fetchrow= 'jona@knowltonian.net' row1 at DB.pm line 205 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x832be60)~0x831bff4) -> dbd_st_fetch for 0831c0b4, chopblanks 0 <- fetchrow= undef row1 at DB.pm line 205 -> prepare for DBD::mysql::db (Apache::DBI::db=HASH(0x8324ff0)~0x8 +325008 ' SELECT id, user, created, title, caption, category, type, filename, size, width, height FROM picture WHERE user = ?') New DBI::st (for DBD::mysql::st, parent=DBI::db=HASH(0x8325008), i +d=) dbih_setup_handle(DBI::st=HASH(0x831c090)=>DBI::st=HASH(0x8332cd4) +, DBD::mysql::st, 831c09c, Null!) dbih_make_com(DBI::db=HASH(0x8325008), DBD::mysql::st, 204) Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x831c090) at DB.pm line 54 -> execute for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332cd4 ' +1') -> dbd_st_execute for 08202b18 Binding parameters: SELECT id, user, created, title, caption, category, type, filename, size, width, height FROM picture WHERE user = '1' <- dbd_st_execute 4 rows <- execute= 4 at DB.pm line 56 -> bind_columns for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332 +cd4 SCALAR(0x82419a4) SCALAR(0x82419ec) SCALAR(0x8241a04) SCALAR(0x82 +41a1c) SCALAR(0x8241a34) SCALAR(0x8241a64) SCALAR(0x8241a4c) SCALAR(0 +x8243278) SCALAR(0x8243290) SCALAR(0x82432a8) SCALAR(0x82432c0)) dbih_setup_fbav for 11 fields => 0x8332ed8 dbih_sth_bind_col 1 => SCALAR(0x82419a4) dbih_sth_bind_col 2 => SCALAR(0x82419ec) dbih_sth_bind_col 3 => SCALAR(0x8241a04) dbih_sth_bind_col 4 => SCALAR(0x8241a1c) dbih_sth_bind_col 5 => SCALAR(0x8241a34) dbih_sth_bind_col 6 => SCALAR(0x8241a64) dbih_sth_bind_col 7 => SCALAR(0x8241a4c) dbih_sth_bind_col 8 => SCALAR(0x8243278) dbih_sth_bind_col 9 => SCALAR(0x8243290) dbih_sth_bind_col 10 => SCALAR(0x82432a8) dbih_sth_bind_col 11 => SCALAR(0x82432c0) <- bind_columns= 1 at DB.pm line 57 -> fetchrow for DBD::mysql::st (DBI::st=HASH(0x831c090)~0x8332cd4) -> dbd_st_fetch for 08202b18, chopblanks 0 Storing row 0 (2) in 082419a4 Storing row 1 (1) in 082419ec Storing row 2 (2001-08-03) in 08241a04 Storing row 3 (Weirdo) in 08241a1c Storing row 4 (Test) in 08241a34 Storing row 5 (9) in 08241a64 Storing row 6 (1) in 08241a4c Storing row 7 (funky.jpg) in 08243278 Storing row 8 (13913) in 08243290 Storing row 9 (0) in 082432a8 Storing row 10 (0) in 082432c0 <- dbd_st_fetch, 11 cols <- fetchrow= '0' row1 at DB.pm line 68 <> DESTROY ignored for outer handle DBI::st=HASH(0x831c090) (inner + DBI::st=HASH(0x8332cd4)) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x8332cd4)~INNER) <- DESTROY= undef at Browse.pm line 24 <> DESTROY ignored for outer handle DBI::st=HASH(0x832be60) (inner + DBI::st=HASH(0x831bff4)) -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x831bff4)~INNER) <- DESTROY= undef at Browse.pm line 93

[ ar0n -- want job (boston) ]