Yanju Ikilọ Aṣiṣe Wodupiresi: Aṣiṣe lakoko fifiranṣẹ apo-iwe QUERY

Aṣiṣe ibeere PHP Aṣiṣe lakoko fifiranṣẹ apo-iwe QUERY. PID=xxx

WordPressNigbati oju opo wẹẹbu ba ṣe imudojuiwọn nkan naa, ifiranṣẹ aṣiṣe atẹle le han ▼ 

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

• Iṣoro yii ni ibatan siLinuxserver iṣeto ni, nibẹ ni o waIṣowo E-commerceeniyan nloVestaCPMo ni isoro yi lẹhin ti awọn nronu.
• Eyi ni iṣeto aiyipada ti nronu VestaCPMySQLOpin wa si iwọn data.
• Lati ṣatunṣe eyi, yi paramita max_allowed_packet rẹ pada.

Ojutu

O le yara yanju iṣoro yii nipa titẹle awọn igbesẹ wọnyi:

Igbesẹ 1:Ṣii SFTPSọfitiwia

Igbesẹ 2:Ṣatunkọ faili my.cnf ▼

/etc/my.cnf

wa[MYSQLD] apakan, ṣafikun tabi yipada awọn paramita atẹle ▼

max_allowed_packet=524288000
wait_timeout = 100

Igbesẹ 3:Tun iṣẹ MySQL bẹrẹ

Tun iṣẹ MySQL bẹrẹ nipa titẹ aṣẹ atẹle nipasẹ SSH ▼

service mysqld restart

Ti o ba nlo data data Mariadb, jọwọ lo aṣẹ atẹle lati tun bẹrẹ data Mariadb ▼

service mariadb restart

Igbesẹ 4:buwolu wọle rẹPHPMyAdminData isakoso ni wiwo.

Igbesẹ 5:SQL ṣiṣẹ pipaṣẹ

Tẹ "SQL" ki o si tẹ aṣẹ wọnyi ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Tẹ "Ṣiṣe" ▼

iretiChen WeiliangỌna pinpin bulọọgi, le ṣe iranlọwọ fun ọ lati yanjuMySQL databaseIbeere aṣiṣe ibeere ^_^