Hey, I have a problem
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?
Hey, I have a problem
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