Magance Kuskuren WordPress Gargaɗi: Kuskure yayin aika fakitin QUERY

Kuskuren tambaya na PHP yayin aika fakitin QUERY. PID=xxx

WordPressLokacin da gidan yanar gizon ya sabunta labarin, saƙon kuskure na iya bayyana ▼ 

Warning: Error while sending QUERY packet. PID=13691 in /home/用户名/域名/public_html/wp-includes/wp-db.php on line 1942

• Wannan matsala tana da alaƙa daLinuxtsarin uwar garken, akwaiE-kasuwancimutane suna amfaniVestaCPIna da wannan matsala bayan panel.
• Wannan shine tsarin tsoho na kwamitin VestaCPMySQLAkwai iyaka ga girman bayanai.
• Don gyara wannan, canza max_allowed_packet siga.

Magani

Kuna iya magance wannan matsalar cikin sauri ta bin waɗannan matakan:

shafi na 1:Bude SFTP软件

shafi na 2:Shirya fayil ɗin my.cnf ▼

/etc/my.cnf

在[MYSQLD] sashe, ƙara ko gyara sigogi masu zuwa ▼

max_allowed_packet=524288000
wait_timeout = 100

shafi na 3:Sake kunna sabis na MySQL

Sake kunna sabis na MySQL ta shigar da umarni mai zuwa ta hanyar SSH ▼

service mysqld restart

Idan kuna amfani da bayanan Mariadb, da fatan za a yi amfani da wannan umarni don sake kunna bayanan Mariadb ▼

service mariadb restart

shafi na 4:login kuPHPMyAdminCibiyar sarrafa bayanai.

shafi na 5:SQL aiwatar da umarni

Danna "SQL" kuma shigar da umarni mai zuwa ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Danna "Execute" ▼

Fatan alkhairiChen WeiliangHanyar raba Blog, na iya taimaka muku warwarewaMySQL databaseTambayar kuskuren tambaya ^_^