[CDBI] Inconsistent reads from database when using web interface

Perrin Harkins perrin at elem.com
Thu Aug 28 23:30:13 BST 2008


On Thu, Aug 28, 2008 at 6:01 PM, Carlos Vicente
<cvicente at network-services.uoregon.edu> wrote:
> However, after following their directions (setting
> |transaction-isolation to READ-COMMITTED|, it is still happening.

It does sound like the problem you're having.  Can you verify the
setting by checking it in the code with the same $dbh you read the
data with right before you print it?  Do you run with autocommit on?

It's also possible you might be storing data in closure variables or
globals.  Can you do some debugging to figure out if the data is being
read from the database or not?  DBI_TRACE can help there, or you can
add some straight SQL selects and print the values to the error_log
and compare them with what you see in the HTML.

- Perrin



More information about the ClassDBI mailing list