尝试将大文件.txt导入MysQL时出错500

Question

We're using Yii framework for an internal tool.

What we have now : The user select a file .txt to upload on the server. The server clean the text file because it containts lots of characters such as """ and ;;;;

But when comes the time to import to database, server sends a 500 internal error with no more information.

The file size is 8.1 mo. The import seems to work if we delete manually some rows in order to make the file at less than 7 mo.

We took a look at the php.ini file and increased all the limits.

What is weird is that we made local server with easyphp (same config in php.ini) and it works.

Do you have an idea ??

Thanks !

Answer 1

With the information's you have provided, I can only suggest that turn on error_reporting and display_errors in your php.ini file. Increase maximum execution time and then see if any error displays or not?

Also do you have access to your log files in server? Then check php error_log for more information.