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

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


The stupid question is the question not asked
	PerlMonks