Hello,
I have problem about upload file file more than 10MB
An exception occurred while executing ‘SELECT fileid
FROM oc_filecache
WHERE storage
= ? AND path_hash
= ?’ with params [2, “ad0014fbb56703a5d49d5ed3c346cb8f”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
after i upgrade to 16.00 i got this problem.
please help.
thank’s
eehmke
August 12, 2019, 8:14am
2
Can you connect to MySQL directly? Check the settings in config.php.
For normal mysql connections with marked I can access settings, files that I have uploaded, download files.
These constraints appear when I upload files more than 10 MB. I tried restarting the database service, but nothing changed.
Vps that I use
Os: Centos 7.x
Panel: VestaCP
Database: Mariadb 10.2
Mariadb config
[mysqld]
datadir = / var / lib / mysql
socket = / var / lib / mysql / mysql.sock
symbolic-links = 0
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1024M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix = on
innodb_file_format = barracuda
innodb_file_per_table = 1
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections = 70
max_user_connections = 30
wait_timeout = 10
interactive_timeout = 50
long_query_time = 5
# slow_query_log = 1
# slow_query_log_file = / var / log / mysql-slow-queries.log
[mysqld_safe]
log-error = / var / log / mariadb / mariadb.log
pid-file = / var / run / mariadb / mariadb.pid
#
# include all files from the config directory
#
! includedir /etc/my.cnf.d
may can you help me…
Thank’s