Dozie ịdọ aka ná ntị Error WordPress: mperi mgbe ị na-eziga ngwugwu QUERY

Njehie ajụjụ PHP ka a na-eziga ngwugwu QUERY. PID=xxx

WordPressMgbe webụsaịtị emelitere akụkọ, ozi mperi nwere ike ịpụta ▼ 

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

• Ajụjụ a metụtaraLinuxBanyere nhazi ihe nkesa, enwereE-azụmahịandị mmadụ na-ejiVestaCPM zutere nsogbu a mgbe m meghere panel.
• Nke a bụ nhazi ndabara nke panel VestaCPMySQLEnwere oke na nha data.
• Iji dozie nsogbu a, gbanwee oke max_allowed_packet gị.

Ngwọta

Ị nwere ike dozie nsogbu a ngwa ngwa site na ịgbaso usoro ndị a:

nke 1:Mepee SFTP软件

nke 2:Dezie my.cnf faịlụ ▼

/etc/my.cnf

在[MYSQLD] ngalaba, tinye ma ọ bụ gbanwee paramita ndị a ▼

max_allowed_packet=524288000
wait_timeout = 100

nke 3:Malitegharịa ọrụ MySQL

Tinye iwu a site na SSH ka ịmalitegharịa ọrụ MySQL ▼

service mysqld restart

Ọ bụrụ na ị na-eji nchekwa data Mariadb, biko jiri iwu a ka ịmalitegharịa nchekwa data Mariadb ▼

service mariadb restart

nke 4:Banye gịPHPMyAdmininterface njikwa nchekwa data.

nke 5:SQL iwu ogbugbu

Pịa "SQL" wee tinye iwu na-esonụ ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Pịa "Mee"▼

希望Chen WeiliangỤzọ nkesa blọgụ nwere ike inyere gị aka dozie nsogbu ahụMySQL nchekwa dataAjụjụ njehie ajụjụ ^_^