Bug #9693

database schema change

Details

Submitted	2006-12-25 19:28 UTC
From	afz at php dot net
Assigned	quipo
Status	Closed
Package	MDB2_Driver_sqlite
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2006-12-25 19:28 UTC] afz at php dot net

Description:
------------
some time when execute query this errors occurred.
for more information see: http://www.sqlite.org/faq.html#q17
and solution for this bug is:

replace line 518 of sqlite.php on MDB2/Driver with:
do {
$result = @$function($query.';', $connection);
} while (sqlite_last_error($connection) == SQLITE_SCHEMA);

and replace line 521 of sqlite.php on MDB2/Driver with:
do {
$result = @$function($query.';', $connection, SQLITE_BOTH, $php_errormsg);
} while (sqlite_last_error($connection) == SQLITE_SCHEMA);