File is empty - import contact from csv

Hey, I have a problem :frowning:

When I want to import a csv file with my contacts into the Contacts - import contact. After uploading the file and click next I see the message “your file is empty one”. What can I do with this?

Please provide SUiteCRM version, Operating System, PHP/Web Server Database configuration and check all your logs (SuiteCRM, SugarCRM, PHP/Web Server, Browser) and report back what you see (at the time of the error)

Version 7.8.2
Sugar Version 6.5.24 (Build 509)
Operating System - Windows 10 x64

Fri Apr  7 01:01:47 2017 [913042][1][FATAL]  Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Fri Apr  7 01:01:47 2017 [913042][1][FATAL]  Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away

PHP/Web Server 5.6

Last Log Apache

7.123.2.4 - - [07/Apr/2017:06:45:30 +0200] "GET / HTTP/1.1" 200 2762 "-" "Opera/9.80 (Windows NT 6.1; WOW64) Presto/2.12 Version/12.16" UA -
194.165.48.1 - - [07/Apr/2017:09:10:49 +0200] "GET / HTTP/1.1" 200 2762 "-" "gus/Nutch-1.10" PL -

Log bug Apache - nothing

Browser - Chrome 57.0.2987.133

Try this:

Locate the configuration file for MySql (normally it is called my.cnf or my.ini, but it depends on the implementation that you have).

Find the following variables:
. max_allowed_packets and increase the value to 500M
. increase to at least 300 seconds all the variables that contain “wait_timeout” at the end of their name and in case add also a variable called wait_time_out

You may also want to increase the values of net_write_timeout and net_read_timeout

Additionally you may want to increase your php.ini environment configuration variables:
max_execution_time = xx <-- try putting 3000
max_input_time = xx <-- 3000
max_input_vars = xx <— 10000
memory_limit = xx <— 500M
upload_max_filesize = xx <-- 256M

Please report back if it works

In case you want to know more about that error, check this page from MySql:
https://dev.mysql.com/doc/refman/5.6/en/gone-away.html