Sombulula impazamo ye-WordPress Isilumkiso: Impazamo ngelixa uthumela i-QUERY ipakethi

Imposiso yombuzo we-PHP Impazamo xa bekuthunyelwa QUERY ipakethi.PID=xxx

WordPressXa iwebhusayithi ihlaziya inqaku, lo myalezo wemposiso ulandelayo unokuvela ▼ 

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

• Le ngxaki inxulumeneLinuxuqwalaselo lomncedisi, zikhonaEzorhweboabantu basebenzisaVestaCPNdinale ngxaki emva kwephaneli.
• Olu luqwalaselo olungagqibekanga lweqela lenjongo yeVestaCPMySQLKukho umda kubungakanani bedatha.
• Ukulungisa oku, tshintsha iparameter yepakethi enkulu_evumelekileyo.

Isisombululo

Ungawusombulula ngokukhawuleza lo mba ngokulandela la manyathelo:

Isiqendu 1:Vula iSFTP软件

Isiqendu 2:Hlela ifayile yam.cnf ▼

/etc/my.cnf

在[I-MYSQLD] icandelo, yongeza okanye ulungise ezi parameters zilandelayo ▼

max_allowed_packet=524288000
wait_timeout = 100

Isiqendu 3:Qala kwakhona inkonzo ye-MySQL

Qala kwakhona inkonzo yakho ye-MySQL ngokungenisa lo myalelo ulandelayo nge-SSH ▼

service mysqld restart

Ukuba usebenzisa ugcino lwedatha lukaMariadb, nceda usebenzise lo myalelo ulandelayo ukuqalisa kwakhona ugcino lwedatha lukaMariadb ▼

service mariadb restart

Isiqendu 4:ngena eyakhoI-PHPMyAdminUjongano lolawulo lweDatabase.

Isiqendu 5:SQL yenza umyalelo

Cofa "SQL" kwaye ufake lo myalelo ulandelayo ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Cofa "Kwenza" ▼

IthembaChen WeiliangIndlela yokwabelana ngeblogi, inokukunceda ukusombululaMySQL databaseUmbuzo wemposiso ^_^