Foia le Lapataiga Fa'aletonu ole WordPress: Sese a'o lafo le pepa QUERY

PHP fesili sese Sese a'o auina atu le pepa QUERY PID=xxx

WordPressA fa'afouina e le upega tafa'ilagi le tusiga, e ono aliali mai le fa'amatalaga sese ▼ 

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

• O lenei faʻafitauli e fesoʻotaʻi maLinuxconfiguration server, e iaiE-fefaʻatauaigao loʻo faʻaaogaina e tagataVestaCPO loʻo ia te aʻu lenei faʻafitauli pe a uma le laulau.
• Ole fa'atonuga lea ole laulau VestaCPMySQLE i ai se tapula'a i le tele o fa'amaumauga.
• Ina ia faʻaleleia lenei mea, sui lau max_allowed_packet parameter.

Fofo

E mafai ona e vave foia lenei faafitauli e ala i le mulimuli i laasaga nei:

Laasaga 1:Tatala SFTPPolokalame

Laasaga 2:Fa'asa'o my.cnf faila ▼

/etc/my.cnf

iai [MySQLD] vaega, fa'aopoopo pe fa'afou fa'amaufa'ailoga nei ▼

max_allowed_packet=524288000
wait_timeout = 100

Laasaga 3:Toe amata le auaunaga MySQL

Toe amata lau auaunaga MySQL e ala i le ulufale i le poloaiga lenei e ala ile SSH ▼

service mysqld restart

Afai e fa'aoga Mariadb database, fa'amolemole fa'aaoga le poloaiga lea e toe amata ai le Mariadb database ▼

service mariadb restart

Laasaga 4:login louPHPMyAdminFa'amatalaga pulega fa'amaumauga.

Laasaga 5:SQL fa'atonuga

Kiliki "SQL" ma ulufale i le poloaiga ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Kiliki "Fa'atino" ▼

希望Chen WeiliangBlog fa'asoa auala, e mafai ona fesoasoani ia te oe e foiaMySQL databaseFesili sese fesili ^_^