Hi everyone, Here's the situation: I have a bunch of excel files to read from and then import their data into a mysql database. I'm using a PHP script to do that by using a COM object. Now, everything seems to work fine: I can read the data just fine from the files, I can then construct an insert query that works and then send this to the database... however, after about 150 inserts, Apache always crashes for some reason. Here's what Windows sends me in its popup window: Problem Event Name: APPCRASH Application Name: apache.exe Application Version: 2.2.15.0 Application Timestamp: 4b8fed95 Fault Module Name: php5ts.dll Fault Module Version: 5.3.2.0 Fault Module Timestamp: 4b8ebac2 Exception Code: c0000005 Exception Offset: 00084491 OS Version: 6.1.7600.2.0.0.256.48 Locale ID: 3084 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a78882e789 Additional Information 3: 0a9e Additional Information 4: 0a9e372d3b4ad19135b953a78882e789 The table itself has something like 70 fields, though I doubt that's an issue since I can do upwards of over 6000 inserts with another script reading csv files. Anyway, if ANYONE has any idea what the hell this could be all about then please tell me, because I'm honestly at my wit's end. Thanks you, Osu
Well, allow me to answer my own question since I managed to find out what was causing the crash. Apparently, it had nothing to do with the table or the COM I was using. No, the problem came from an overuse of the PHP function strcmp. I modified my code and changed the conditions, using the operator "===" instead and everything immediately started to work perfectly. I hope this helps someone out there because it took me quite a while to locate this thing. Osu