Ua hewa ka nīnau nīnau PHP i ka hoʻouna ʻana i ka pūʻolo QUERY. PID=xxx
WordPressKe hōʻano hou ka pūnaewele i ka ʻatikala, hiki ke ʻike ʻia ka memo hewa ma lalo nei ▼
Warning: Error while sending QUERY packet. PID=13691 in /home/用户名/域名/public_html/wp-includes/wp-db.php on line 1942
- Pili kēia pilikia meLinuxhoʻonohonoho kikowaena, aiaEʻulalake hoʻohana nei nā kānakaʻO VestaCPLoaʻa iaʻu kēia pilikia ma hope o ka panel.
- ʻO kēia ka hoʻonohonoho paʻamau o ka panel VestaCPMySQLAia ka palena i ka nui o ka ʻikepili.
- No ka hoʻoponopono ʻana i kēia, hoʻololi i kāu ʻāpana max_allowed_packet.
Pāʻoihana
Hiki iā ʻoe ke hoʻoponopono koke i kēia pilikia ma ka hahai ʻana i kēia mau ʻanuʻu:
KaʻAnuʻu 1:E wehe iā SFTPʻŌnaehana
KaʻAnuʻu 2:Hoʻoponopono i ka waihona my.cnf ▼
/etc/my.cnf
在[MySQLD] ʻāpana, hoʻohui a hoʻololi paha i kēia mau ʻāpana ▼
max_allowed_packet=524288000 wait_timeout = 100
KaʻAnuʻu 3:E hoʻomaka hou i ka lawelawe MySQL
E hoʻomaka hou i kāu lawelawe MySQL ma ke komo ʻana i kēia kauoha ma o SSH ▼
service mysqld restart
Inā hoʻohana i ka waihona Mariadb, e ʻoluʻolu e hoʻohana i kēia kauoha e hoʻomaka hou i ka waihona Mariadb ▼
service mariadb restart
KaʻAnuʻu 4:e komo i kāuPHPMyAdminʻIkepili hoʻokele waihona.
KaʻAnuʻu 5:SQL hoʻokō kauoha
Kaomi iā "SQL" a hoʻokomo i kēia kauoha ▼
SHOW VARIABLES LIKE 'max_allowed_packet'
- Kaomi iā "Execute" ▼
希望Chen WeiliangʻO ke ala kaʻana like blog, hiki ke kōkua iā ʻoe e hoʻoponoponoMySQL waihonaNīnau hewa nīnau ^_^
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kaʻana like "Solving WordPress Error Warning: Error while sending QUERY packet", he mea kōkua iā ʻoe.
Welina mai e kaʻana like i ka loulou o kēia ʻatikala:https://www.chenweiliang.com/cwl-739.html
Welina mai i ke kahawai Telegram o ka moʻomanaʻo ʻo Chen Weiliang e kiʻi i nā mea hou loa!
📚 He waiwai nui kēia alakaʻi, 🌟He manawa kakaikahi kēia, mai poina! ⏰⌛💨
Kaʻana like a like inā makemake ʻoe!
ʻO kāu kaʻana like a me kou makemake ʻo kā mākou hoʻoikaika mau!