MySQL query works but PHP returning Exception: errorinfo:null

Question

The following code updates the table correctly, but it also returns an Exception. Any idea what might be happening here?

public function updateThis($aaa){
try
{
    $success = false;

    $query = "
        UPDATE this_table
        SET thing = '0'
        WHERE aaa = :aaa";

    $stmt = $this->conn->prepare($query);

    $stmt->bindParam(':aaa', $aaa);

    $stmt->execute();

    if($this->conn->commit())
        $success = true;

    return $success;
}
catch(Exception $e)
{
    return $e;
}
}

@drew010 It says "drew010 is a legend, give the man a point.." Actually, it said "There is no active transaction" to which I went back and added $this->conn->beginTransaction(); it now works.. — gatzkerob
– gatzkerob, Commented Jul 17, 2012 at 0:12
@rideTheWave Probably not, unless is happens to be an exceptionally long single row update. — Fluffeh
– Fluffeh, Commented Jul 17, 2012 at 0:16

Fluffeh · Accepted Answer · 2012-07-17 00:14:10Z

1

When you are using PDO, Auto-Commit is on by default, unless you specifically turn it off using Begin Transaction. I can't see it in your connection, so are you perhaps trying to commit a transaction that has already been auto-commited?

answered Jul 17, 2012 at 0:14

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query works but PHP returning Exception: errorinfo:null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related