#35345 [NEW]: SQLite won't load (specified module not found)

From: csaba at alum dot mit dot edu Operating system: Win XP Pro PHP version: 5CVS-2005-11-23 (snap) PHP Bug Type: SQLite related Bug description: SQLite won't load (specified module not found) Description: ------------ I downloaded a new snapshot (.zip) of PHP (version 5.1.0 RC7), stopped Apache 2 and overwrote the prior extracted files (about 10), all sitting in c:\winapps\php.net. In addition, I also extracted php_sqlite.dll to the same directory (since my sqlite code which had been relying on PHP 5.1 of Aug 31 no longer functioned). Next I went into c:\windows\php.ini and added the line extension=php_sqlite.dll (the only other extension I have loading is php_shmop.dll). * Note, at the least there seems to be a documentation bug because php.net/sqlite says to add php_extension=php_sqlite.dll * Now when I go to restart apache 2, I get the following confirm alert/msgbox twice: Warning PHP Startup: Unable to load dynamic library './php_sqlite.dll' - The specified module could not be found. This is an exceptionally unhelpful message as a normal person would suspect that there is a problem locating php_sqlite.dll as that is the only thing specified. At any rate, the loading is successful if I also add extension=php_pdo.dll to php.ini and plunk php_pdo.dll into the main directory. Without setting extension nor file for php_pdo_sqlite.dll Thanks, Csaba Gabor from Vienna Expected result: ---------------- 1. I expect that all I need to run my older code is php_sqlite.dll I do not expect to need php_pdo.dll which I do not currently utilitze in my code. php_pdo.dll should be relying on php_sqlite.dll, if anything, and not the other way around. 2. I expect the docs in http://php.net/sqlite (and perhaps also http://php.net/pdo-sqlite) to mention when I should use only php_sqlite.dll (and set extension), when I need to include php_pdo.dll (and whether I should use php_sqlite.dll with it or php_pdo_sqlite.dll or both). Actual result: -------------- 1. php_sqlite.dll seems to require php_pdo.dll to function. This seems counterintuitive, at best. 2. A user (me) is sure to wonder how the two ...sqlite.dll come into play. This is in addition/commensurate with being confused about how to swap drivers between v2 and 3 and when one would want to do so. In other words, there seem to be possibilities of with/without pdo, v2 or v3 drivers, and two distinct sqlite dll's. -- Edit bug report at http://bugs.php.net/?id=35345&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35345&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35345&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35345&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35345&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35345&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35345&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35345&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35345&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35345&r=support Expected behavior: http://bugs.php.net/fix.php?id=35345&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35345&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35345&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35345&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35345&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35345&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35345&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35345&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35345&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35345&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35345&r=mysqlcfg