comment on

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
[download]

[ ar0n -- want job (boston) ]

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

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.