Anybody knows how to fix this error: MySQL server has gone away
I (maybe) found a solution but I don't know to implement in HMG/Harbour enverionment.
See: https://matomo.org/faq/troubleshooting/faq_183/
Thx, Serge
MySQL question
Moderator: Rathinagiri
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
MySQL question
There's nothing you can do that can't be done...
Re: MySQL question
Serge for time
bQuery:=oServer:Query("SET SESSION wait_timeout = 86400")
If bQuery:NetErr()
MsgStop ( bQuery:Error() )
return Nil
Endif
sometimes when the data is larger than the field, it can give you this error, in mysql intallation directory
find my.ini and add
[mysqld]
# 8 hours
wait_timeout = 28800
# 8 hours
interactive_timeout = 28800
max_allowed_packet = 256M
i hope this help you
bQuery:=oServer:Query("SET SESSION wait_timeout = 86400")
If bQuery:NetErr()
MsgStop ( bQuery:Error() )
return Nil
Endif
sometimes when the data is larger than the field, it can give you this error, in mysql intallation directory
find my.ini and add
[mysqld]
# 8 hours
wait_timeout = 28800
# 8 hours
interactive_timeout = 28800
max_allowed_packet = 256M
i hope this help you
- serge_girard
- Posts: 3165
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact: