Sql error: General error: 25

Question

$up = $this->db->prepare ("
        UPDATE ".self::DbUser." SET UserLogin=:UserLogin WHERE UserId=:UserId; 
        UPDATE ".self::DbUProfile." SET ProfileName=:ProfileName, ProfilePhone=:ProfilePhone WHERE ProfileUserId =:UserId");

$up->bindValue (':UserLogin', $UserLogin);
$up->bindValue (':ProfileName', $ProfileName);
$up->bindValue (':ProfilePhone', $ProfilePhone);
$up->bindValue (':UserId', $UserId);

if ( !$up->execute() )...

As a result: General error: 25 bind or column index out of range

What is a problem? Thanks!

@u_mulder I thought so, too, but I've found some info saying you can, like https://stackoverflow.com/questions/6346674/pdo-support-for-multiple-queries-pdo-mysql-pdo-mysqlnd — Barmar, Mar 30 '18 at 17:43
@Barmar interesting. Then the problem should be in duplicate `userId` placeholder. — u_mulder, Mar 30 '18 at 17:44

score 1 · Accepted Answer · answered Mar 30 '18 at 18:05

The documentation for execute says (found through this question):

The keys from input_parameters must match the ones declared in the SQL. Before PHP 5.2.0 this was silently ignored.

Try splitting the query in two, and for each execute specify only parameters that are used?

Sql error: General error: 25

1 Answers1