ID: 24587
Updated by: [EMAIL PROTECTED]
Reported By: isaac dot hopley at morton-fraser dot com
-Status: Open
+Status: Closed
-Bug Type: MySQL related
+Bug Type: Scripting Engine problem
Operating System: SuSE Linux 8.2
PHP Version: 4.3.2
New Comment:
Fixed in PHP 5. (try the beta..)
Previous Comments:
------------------------------------------------------------------------
[2003-07-10 08:44:49] isaac dot hopley at morton-fraser dot com
Description:
------------
I am trying to do a batch insert to a MySQL database.
There are rouhyly 78,000 inserts to complete however my script will
only insert 65,534 at any one time.
I am running the script using the CLI method - it does not time out but
prodces the message 'Segmentation Fault' after doing the 65,534
entries. I am not sure of the significance it being the highest 16-
bit no.
If you need full source code + database structure please let me know
and I will put in public where you can download.
Apologies if this is a know MySQL problem - I couldn't see any
explanations from this point of view.
Reproduce code:
---------------
Basically
While ( eof )
// Read File
// If certain conditions
$insertSQL = "INSERT INTO entry VALUES ('', '$ip', '$user_name',
'$new_date_time', '$new_url', '', '$code') ";
//echo $insertSQL . "<br>";
$run = mysql_query($insertSQL);
Expected result:
----------------
Zero Output
Actual result:
--------------
Segmentation fault
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24587&edit=1
