ID: 46212 Updated by: [EMAIL PROTECTED] Reported By: kristof dot coomans at telenet dot be -Status: Open +Status: Assigned Bug Type: SQLite related Operating System: Windows XP PHP Version: 5.3CVS-2008-10-01 (snap) -Assigned To: +Assigned To: scottmac New Comment:
This works on Linux and Mac but not Windows. Previous Comments: ------------------------------------------------------------------------ [2008-10-01 15:37:08] kristof dot coomans at telenet dot be Description: ------------ SQLite3::exec with valid query fails with the error message "SQL logic error or missing database". Actually testing with http://snaps.php.net/win32/php5.3-win32-200809251104.zip since there is no snapshot for win32 yet for today. Reproduce code: --------------- <?php @unlink( 'test.sqlite3.db' ); $cn = new SQLite3( 'test.sqlite3.db' ); $sql = "CREATE TABLE ezcontentclass_attribute ( can_translate INTEGER(11) DEFAULT '1', contentclass_id INTEGER(11) NOT NULL DEFAULT '0', data_float1 float DEFAULT NULL, data_float2 float DEFAULT NULL, data_float3 float DEFAULT NULL, data_float4 float DEFAULT NULL, data_int1 INTEGER(11) DEFAULT NULL, data_int2 INTEGER(11) DEFAULT NULL, data_int3 INTEGER(11) DEFAULT NULL, data_text1 varchar(50) DEFAULT NULL, data_text2 varchar(50) DEFAULT NULL, data_text3 varchar(50) DEFAULT NULL, data_text5 longtext, data_type_string varchar(50) NOT NULL DEFAULT '', id INTEGER, identifier varchar(50) NOT NULL DEFAULT '', is_information_collector INTEGER(11) NOT NULL DEFAULT '0', is_required INTEGER(11) NOT NULL DEFAULT '0', is_searchable INTEGER(11) NOT NULL DEFAULT '0', placement INTEGER(11) NOT NULL DEFAULT '0', serialized_name_list longtext NOT NULL, version INTEGER(11) NOT NULL DEFAULT '0', PRIMARY KEY ( id, version ) )"; $succes = @$cn->exec( $sql ); if ( !$succes ) { print( "Error " . $cn->lastErrorCode() . ": " . $cn->lastErrorMsg() . PHP_EOL ); } ?> Expected result: ---------------- The script should finish without any warnings. Executing the sql with the sqlite3 command line client works fine. Actual result: -------------- Error 1: SQL logic error or missing database ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46212&edit=1