ID: 29476 Updated by: [EMAIL PROTECTED] Reported By: hugo_pl at users dot sourceforge dot net -Status: Open +Status: Bogus Bug Type: SQLite related Operating System: GNU/Linux, WindowsXP PHP Version: 5.0.0 New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Cannot replicate the problem on any platform (Linux or Windows). Sounds like a problem with your sqlite install. Previous Comments: ------------------------------------------------------------------------ [2004-08-01 00:50:38] hugo_pl at users dot sourceforge dot net Description: ------------ When I call the function: sqlite_fetch_column_types(...); or the method: fetchColumnTypes(...); of the SQLiteDatabase Object, the entire database is locked forever... and I cant modify the database until Apache is restarted. I tested this with Apache2 SAPI module, and SQLite version 2.8.14 on win32 and 2.8.13 and 2.8.14 on Linux. In all plataforms, the database is unlocked only when I restart Apache, if I never call sqlite_fetch_column_types or the method fetchColumnTypes, all runs Ok. P.S.: English is not my natural language. Reproduce code: --------------- <?php // Open a database file... $db = sqlite_open('test.db'); sqlite_busy_timeout($db, 1000); //! Uncomment this line to see the bug!! //sqlite_fetch_column_types($db, 'papers'); sqlite_query($db, 'select * from papers limit 10'); // Any Update query and kabbom... =/ sqlite_query($db, 'update papers set papel="Hi" where id=1'); sqlite_close($db); ?> Expected result: ---------------- No warnings about a locked database when I send the update query Actual result: -------------- Warning: sqlite_query() [function.sqlite-query]: database is locked... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29476&edit=1