ID: 48765 User updated by: mypost100 at gmail dot com Reported By: mypost100 at gmail dot com -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: Windows XP sp3 PHP Version: 5.3.0 New Comment:
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! Previous Comments: ------------------------------------------------------------------------ [2009-07-02 10:15:34] johan...@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
