#48765 [Opn->Fbk]: When I use for MYSQLi "load data local infile" Apache 2.2.11 gives out ERROR!

ID: 48765 Updated by: kalle@php.net Reported By: mypost100 at gmail dot com -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Windows XP sp3 PHP Version: 5.3.0 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2009-07-02 11:56:30] mypost100 at gmail dot com Apache: apache_2.2.11-win32-x86-openssl-0.9.8i.msi PHP: php-5.3.0-Win32-VC6-x86.zip MySql: mysql-5.1.34-win32.msi (5.1.34-community) Start PHP without errors. max_execution_time = 180 max_input_time = 180 I use HTTPS(SSL) - I can't use simple HTTP. table1 dump (9 fields): CREATE TABLE IF NOT EXISTS table1 ( partnum varchar(20) NOT NULL DEFAULT '0', partnumre varchar(20) NOT NULL DEFAULT '0', partname varchar(50) NOT NULL DEFAULT '0', qumin varchar(5) NOT NULL DEFAULT '0', weight varchar(10) NOT NULL DEFAULT '0', rg varchar(5) NOT NULL DEFAULT '0', price varchar(10) NOT NULL DEFAULT '0', pfand varchar(10) NOT NULL DEFAULT '0', suppid int(5) unsigned NOT NULL DEFAULT '1', KEY partnum (partnum(7)) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; Code: $qu1="ALTER TABLE table1 ALTER COLUMN suppid SET DEFAULT \"1\""; $setdefault=mysqli_query($MYSQLI_CONPR,$qu1); $qu2="ALTER TABLE table1 DISABLE KEYS"; $indexoff=mysqli_query($MYSQLI_CONPR,$qu2); I use for loading 7 fields $qu3="LOAD DATA LOCAL INFILE 'D:/file.txt' INTO TABLE table1 FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' (partnum,partnumre,partname,weight,rg,price,pfand)"; $res_load=mysqli_query($MYSQLI_CONPR,$qu3); Later 3-4 sec after run script Apache gives out window with error "The program has caused an error and will be closed" (but dont close and works causing same error) PHP 5.2.10 takes for this operation too 3-4 sec, but without any errors and all OK! ------------------------------------------------------------------------ [2009-07-02 10:15:34] johannes@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. What kind of error are you getting? What does your code look like? What MySQL version? What does the table and statement look like? ------------------------------------------------------------------------ [2009-07-02 03:03:22] mypost100 at gmail dot com Description: ------------ Hello. When I use for MYSQLi "load data local infile" (file.txt = 1100000 rows) divider of columns - [ ; ] Apache 2.2.11 gives out ERROR! Loaded rows = 620000 and stop of execution file php. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48765&edit=1