Konzani chenjezo Lolakwika la WordPress: Zolakwika potumiza QUERY paketi

Vuto la funso la PHP Vuto potumiza QUERY paketi. PID=xxx

WordPressTsambali likasintha nkhaniyi, zolakwika zotsatirazi zitha kuwoneka ▼ 

Warning: Error while sending QUERY packet. PID=13691 in /home/用户名/域名/public_html/wp-includes/wp-db.php on line 1942
  • Vutoli likugwirizana ndiLinuxkasinthidwe ka seva, paliZamalondaanthu amagwiritsaVestaCPNdili ndi vuto pambuyo pa gulu.
  • Uku ndikokusintha kosasintha kwa gulu la VestaCPMySQLPali malire a kukula kwa data.
  • Kuti mukonze izi, sinthani max_allowed_packet parameter.

Yankho

Mutha kuthetsa vutoli mwachangu potsatira njira izi:

Khwerero 1:Tsegulani SFTP软件

Khwerero 2:Sinthani fayilo ya my.cnf ▼

/etc/my.cnf

在[YAM'MBUYO YOTSATIRAD] gawo, onjezani kapena sinthani magawo otsatirawa ▼

max_allowed_packet=524288000
wait_timeout = 100

Khwerero 3:Yambitsaninso ntchito ya MySQL

Yambitsaninso ntchito yanu ya MySQL polemba lamulo lotsatirali kudzera pa SSH ▼

service mysqld restart

Ngati mukugwiritsa ntchito nkhokwe ya Mariadb, chonde gwiritsani ntchito lamulo ili kuti muyambitsenso nkhokwe ya Mariadb ▼

service mariadb restart

Khwerero 4:lowani wanuPulogalamu ya PHPMawonekedwe a database.

Khwerero 5:SQL kuchita lamulo

Dinani "SQL" ndikuyika lamulo lotsatirali ▼

SHOW VARIABLES LIKE 'max_allowed_packet'
  • Dinani "Chotsani" ▼

Lamulo la SQL la PHPMyAdmin ONETSANI ZINTHU ZOSIYANA NGATI 'max_allowed_packet'

 

ChiyembekezoChen WeiliangNjira yogawana mabulogu, ingakuthandizeni kuthetsaMySQL databaseFunso lolakwika ^_^

发表 评论

Imelo yanu sisindikizidwa. Minda yofunikira imagwiritsidwa ntchito * Chizindikiro

Pitani pamwamba