Whakatupato Hapa WordPress: Hapa i te wa e tuku ana i te putea QUERY

Hapa Uiui PHP Hapa i te wa e tuku ana i te putea QUERY. PID=xxx

WordPressIna whakahouhia e te paetukutuku te tuhinga, ka puta pea te karere hapa e whai ake nei ▼ 

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

• Ko tenei raruraru e pa ana kiLinuxwhirihoranga tūmau, kei reiraE-tauhokohokokei te whakamahia e te tangataVestaCPKei a au tenei raru i muri i te roopu.
• Koinei te whirihoranga taunoa o te paewhiri VestaCPMySQLHe rohe ki te rahi o te raraunga.
• Hei whakatika i tenei, hurihia to tawhā max_allowed_packet.

Rongoā

Ka taea e koe te whakatau tere i tenei take ma te whai i enei mahi:

taahiraa 1:Whakatuwheratia te SFTP软件

taahiraa 2:Whakatikaina taku.cnf kōnae ▼

/etc/my.cnf

noho [MySQLD] waahanga, taapiri, whakarereke ranei i nga tawhā e whai ake nei ▼

max_allowed_packet=524288000
wait_timeout = 100

taahiraa 3:Tīmataria anō te ratonga MySQL

Tīmataria anō tō ratonga MySQL mā te whakauru i te whakahau e whai ake nei mā SSH ▼

service mysqld restart

Mēnā kei te whakamahi i te pātengi raraunga Mariadb, whakamahia te whakahau e whai ake nei hei whakaara anō i te pātengi raraunga Mariadb ▼

service mariadb restart

taahiraa 4:takiuru toPHPMyAdminAtanga whakahaere pātengi raraunga.

taahiraa 5:SQL mahi whakahau

Pāwhiritia "SQL" ka tomo i te whakahau e whai ake nei ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Pāwhiritia "Whakamahia" ▼

希望Ko Chen WeiliangKo te tikanga tiritahi blog, ka awhina koe ki te whakaotipātengi raraunga MySQLUiui hapa patai ^_^