MySQL question

[serge_girard]

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

[martingz]

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

[serge_girard]

Thanks, I will try !

Serge