SQL запросы для удаления полей в таблице БД

[rxu]

Это критично или можно забить

Если MySQL Fulltext выбран активным поисковым механизмом, то да - поиск не будет работать. Если другой, то не критично.

[romaamor]

Сейчас выбрано - phpBB Native Fulltext
Запустил индексацию. Говорит что -
Идёт индексация всех имеющихся сообщений. Этот процесс может занять от нескольких минут до нескольких часов в зависимости от объёма данных.
Страницу нельзя закрывать ?

[rxu]

Страницу нельзя закрывать ?

Нет, до окончания процесса.

[romaamor]

Нет, до окончания процесса.

Вот ...... Дошло до 1.5 процента и форум лёг.

Страница не может быть загружена
Запрашиваемая страница не может быть загружена.
Проверьте своё интернет-соединение и попробуйте снова.
Некоторые расширения браузера, такие как блокировщики рекламы, могут неожиданно блокировать страницы. Отключите их и попробуйте ещё раз.
Пикник ТВ - форум цифрового ТВ может быть временно недоступна. Пожалуйста, зайдите позже.

[rxu]

Ошибки в логе вебсервера есть?

[romaamor]

Ошибки в логе вебсервера есть?

Только то что ниже. Но не думаю что это как то связанно.

Код: Выделить всё

[Tue Jan 28 08:08:58.781599 2025] [access_compat:error] [pid 10383] [client 195.191.219.130:45228] AH01797: client denied by server configuration: /var/www/sat_port_com_usr/data/www/piknik-tv.com/fo
[Tue Jan 28 08:09:04.735872 2025] [access_compat:error] [pid 10518] [client 195.191.219.130:45460] AH01797: client denied by server configuration: /var/www/sat_port_com_usr/data/www/piknik-tv.com/fo
[Tue Jan 28 08:09:09.453509 2025] [access_compat:error] [pid 10525] [client 195.191.219.130:56344] AH01797: client denied by server configuration: /var/www/sat_port_com_usr/data/www/piknik-tv.com/fo
[Tue Jan 28 08:09:23.788955 2025] [core:error] [pid 10584] (36)File name too long: [client 185.137.39.186:37428] AH00036: access to /.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk failed (filesystem path '/var/www/sat_port_com_usr/data/www/piknik-tv.com/.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk'), referer: https://piknik-tv.com/viewtopic.php?t=9484&start=4220
[Tue Jan 28 08:09:23.799088 2025] [core:error] [pid 10587] (36)File name too long: [client 185.137.39.186:37414] AH00036: access to /.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk failed (filesystem path '/var/www/sat_port_com_usr/data/www/piknik-tv.com/.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk'), referer: https://piknik-tv.com/viewtopic.php?t=9484&start=4220
[Tue Jan 28 08:09:24.036144 2025] [core:error] [pid 10589] (36)File name too long: [client 185.137.39.186:37430] AH00036: access to /.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk failed (filesystem path '/var/www/sat_port_com_usr/data/www/piknik-tv.com/.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk')
[Tue Jan 28 08:09:24.038531 2025] [core:error] [pid 10590] (36)File name too long: [client 185.137.39.186:37446] AH00036: access to /.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk failed (filesystem path '/var/www/sat_port_com_usr/data/www/piknik-tv.com/.tif,.tiff,.tga,.jpg,.png,.jpeg,.gif,.webp,.gtar,.gz,.tar,.zip,.rar,.ace,.torrent,.tgz,.bz2,.7z,.bin,.deb,.txt,.c,.h,.cpp,.hpp,.diz,.csv,.ini,.log,.js,.xml,.xls,.xlsx,.xlsm,.xlsb,.doc,.docx,.docm,.dot,.dotx,.dotm,.pdf,.ai,.ps,.ppt,.pptx,.pptm,.odg,.odp,.ods,.odt,.rtf,.mp4,.mpeg,.mpg,.mp3,.ogg,.ogm,.m3u,.m3u8,.ipk,.apk')

Пару раз перезагрузил сервер и индексация по тихоньку продолжается. На данный момент 9.33 %

[rxu]

Нужен лог ошибок PHP, а это больше похоже на логи доступа.

[romaamor]

То что я показал - Журнал ошибок бэкенд
А вот Журнал ошибок фронтенд

Код: Выделить всё

2025/01/28 07:48:47 [error] 1268642#1268642: *5456423 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.202, server: piknik-tv.com, request: "GET /viewtopic.php?p=228328 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=228328", host: "piknik-tv.com"
2025/01/28 07:48:54 [error] 1268640#1268640: *5456428 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 95.108.213.112, server: piknik-tv.com, request: "GET /viewtopic.php?p=166515 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=166515", host: "piknik-tv.com"
2025/01/28 07:48:57 [error] 1268642#1268642: *5456434 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.179, server: piknik-tv.com, request: "GET /viewtopic.php?t=82&start=50 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=82&start=50", host: "piknik-tv.com"
2025/01/28 07:48:58 [error] 1268642#1268642: *5456438 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.49, server: piknik-tv.com, request: "GET /viewtopic.php?p=162054 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=162054", host: "piknik-tv.com"
2025/01/28 07:49:06 [error] 1268641#1268641: *5456446 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.209, server: piknik-tv.com, request: "GET /memberlist.php?mode=viewprofile&u=42908 HTTP/1.1", upstream: "http://127.0.0.1:81/memberlist.php?mode=viewprofile&u=42908", host: "piknik-tv.com"
2025/01/28 07:49:08 [error] 1268642#1268642: *5456452 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.10, server: piknik-tv.com, request: "GET /viewtopic.php?t=9605&start=360 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=9605&start=360", host: "piknik-tv.com"
2025/01/28 07:49:10 [error] 1268641#1268641: *5456455 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.73, server: piknik-tv.com, request: "GET /threads/4668/post-327321 HTTP/1.1", upstream: "http://127.0.0.1:81/threads/4668/post-327321", host: "piknik-tv.com"
2025/01/28 07:49:14 [error] 1268641#1268641: *5456466 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.243, server: piknik-tv.com, request: "GET /viewtopic.php?p=66318 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=66318", host: "piknik-tv.com"
2025/01/28 07:49:15 [error] 1268641#1268641: *5456470 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.212, server: piknik-tv.com, request: "GET /viewtopic.php?p=326663 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=326663", host: "piknik-tv.com"
2025/01/28 07:49:18 [error] 1268641#1268641: *5456485 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.183, server: piknik-tv.com, request: "GET /viewtopic.php?p=87703 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=87703", host: "piknik-tv.com"
2025/01/28 07:49:21 [error] 1268641#1268641: *5456497 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.183, server: piknik-tv.com, request: "GET /viewtopic.php?t=7336&start=1470 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=7336&start=1470", host: "piknik-tv.com"
2025/01/28 07:49:22 [error] 1268640#1268640: *5456501 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 95.108.213.115, server: piknik-tv.com, request: "GET /viewtopic.php?p=82304 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=82304", host: "piknik-tv.com"
2025/01/28 07:49:24 [error] 1268641#1268641: *5456507 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.204, server: piknik-tv.com, request: "GET /viewtopic.php?t=8531&start=380 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=8531&start=380", host: "piknik-tv.com"
2025/01/28 07:49:25 [error] 1268642#1268642: *5456509 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 185.92.136.112, server: piknik-tv.com, request: "GET / HTTP/2.0", upstream: "http://127.0.0.1:81/", host: "piknik-tv.com"
2025/01/28 07:49:29 [error] 1268642#1268642: *5456550 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.104, server: piknik-tv.com, request: "GET /viewtopic.php?p=235307 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=235307", host: "piknik-tv.com"
2025/01/28 07:49:32 [error] 1268642#1268642: *5456556 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.195, server: piknik-tv.com, request: "GET /viewtopic.php?p=168881 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=168881", host: "piknik-tv.com"
2025/01/28 07:49:32 [error] 1268640#1268640: *5456558 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.202, server: piknik-tv.com, request: "GET /threads/4106/post-92982 HTTP/1.1", upstream: "http://127.0.0.1:81/threads/4106/post-92982", host: "piknik-tv.com"
2025/01/28 07:49:35 [error] 1268640#1268640: *5456566 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 95.108.213.112, server: piknik-tv.com, request: "GET /viewtopic.php?p=317616 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=317616", host: "piknik-tv.com"
2025/01/28 07:49:43 [error] 1268640#1268640: *5456598 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.179, server: piknik-tv.com, request: "GET /viewtopic.php?p=107866 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=107866", host: "piknik-tv.com"
2025/01/28 07:49:45 [error] 1268640#1268640: *5451112 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 46.175.190.181, server: piknik-tv.com, request: "GET /service_worker.js HTTP/2.0", upstream: "http://127.0.0.1:81/service_worker.js", host: "piknik-tv.com", referrer: "https://piknik-tv.com/service_worker.js"
2025/01/28 07:49:46 [error] 1268642#1268642: *5456608 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 66.249.66.1, server: piknik-tv.com, request: "GET /en/viewtopic.php?t=8368&start=2000 HTTP/1.1", upstream: "http://127.0.0.1:81/en/viewtopic.php?t=8368&start=2000", host: "piknik-tv.com"
2025/01/28 07:49:47 [error] 1268640#1268640: *5451112 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 46.175.190.181, server: piknik-tv.com, request: "GET /adm/index.php?i=acp_search&sid=e07628dc022d6025149548781cb613f4&mode=index&action=create&skip_rows=22742&hash=b0ccd773&sid=e07628dc022d6025149548781cb613f4 HTTP/2.0", upstream: "http://127.0.0.1:81/adm/index.php?i=acp_search&sid=e07628dc022d6025149548781cb613f4&mode=index&action=create&skip_rows=22742&hash=b0ccd773&sid=e07628dc022d6025149548781cb613f4", host: "piknik-tv.com", referrer: "https://piknik-tv.com/adm/index.php?i=acp_search&sid=e07628dc022d6025149548781cb613f4&mode=index&action=create&skip_rows=21356&hash=b0ccd773&sid=e07628dc022d6025149548781cb613f4"
2025/01/28 07:49:48 [error] 1268642#1268642: *5456189 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.49, server: piknik-tv.com, request: "GET /threads/7833/post-205059 HTTP/1.1", upstream: "http://127.0.0.1:81/threads/7833/post-205059", host: "piknik-tv.com"
2025/01/28 07:49:48 [error] 1268640#1268640: *5456618 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.209, server: piknik-tv.com, request: "GET /viewtopic.php?p=168831 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=168831", host: "piknik-tv.com"
2025/01/28 07:49:50 [error] 1268640#1268640: *5455899 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.10, server: piknik-tv.com, request: "GET /viewtopic.php?p=236151 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=236151", host: "piknik-tv.com"
2025/01/28 07:49:50 [error] 1268640#1268640: *5456621 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.73, server: piknik-tv.com, request: "GET /viewtopic.php?p=87754 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=87754", host: "piknik-tv.com"
2025/01/28 07:49:54 [error] 1268642#1268642: *5456218 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.212, server: piknik-tv.com, request: "GET /viewtopic.php?t=7434&start=870 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=7434&start=870", host: "piknik-tv.com"
2025/01/28 07:49:54 [error] 1268642#1268642: *5455768 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.243, server: piknik-tv.com, request: "GET /viewtopic.php?p=163982 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=163982", host: "piknik-tv.com"
2025/01/28 07:49:55 [error] 1268640#1268640: *5451112 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 46.175.190.181, server: piknik-tv.com, request: "GET /adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=acp_search&mode=index HTTP/2.0", upstream: "http://127.0.0.1:81/adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=acp_search&mode=index", host: "piknik-tv.com", referrer: "https://piknik-tv.com/adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=25"
2025/01/28 07:49:55 [error] 1268641#1268641: *5455695 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 89.31.38.89, server: piknik-tv.com, request: "GET /site.webmanifest HTTP/2.0", upstream: "http://127.0.0.1:81/site.webmanifest", host: "piknik-tv.com"
2025/01/28 07:49:58 [error] 1268642#1268642: *5456639 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 5.255.231.183, server: piknik-tv.com, request: "GET /viewtopic.php?p=295875 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=295875", host: "piknik-tv.com"
2025/01/28 07:50:00 [error] 1268640#1268640: *5451112 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 46.175.190.181, server: piknik-tv.com, request: "GET /adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=25 HTTP/2.0", upstream: "http://127.0.0.1:81/adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=25", host: "piknik-tv.com", referrer: "https://piknik-tv.com/adm/index.php?sid=e07628dc022d6025149548781cb613f4&i=28"
2025/01/28 07:50:01 [error] 1268642#1268642: *5456644 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.183, server: piknik-tv.com, request: "GET /viewtopic.php?t=2493&start=3350 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=2493&start=3350", host: "piknik-tv.com"
2025/01/28 07:50:03 [error] 1268642#1268642: *5456549 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 45.219.3.1, server: piknik-tv.com, request: "GET /viewtopic.php?t=6737 HTTP/2.0", upstream: "http://127.0.0.1:81/viewtopic.php?t=6737", host: "piknik-tv.com", referrer: "https://pikniktv.top/"
2025/01/28 07:50:04 [error] 1268641#1268641: *5456649 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 95.108.213.115, server: piknik-tv.com, request: "GET /topic1496-330.html HTTP/1.1", upstream: "http://127.0.0.1:81/topic1496-330.html", host: "piknik-tv.com"
2025/01/28 07:50:04 [error] 1268640#1268640: *5451112 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 46.175.190.181, server: piknik-tv.com, request: "GET / HTTP/2.0", upstream: "http://127.0.0.1:81/", host: "piknik-tv.com", referrer: "https://piknik-tv.com/"
2025/01/28 07:50:05 [error] 1268642#1268642: *5455771 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 95.24.167.111, server: piknik-tv.com, request: "GET /site.webmanifest HTTP/2.0", upstream: "http://127.0.0.1:81/site.webmanifest", host: "piknik-tv.com"
2025/01/28 07:50:05 [error] 1268640#1268640: *5456010 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 87.250.224.204, server: piknik-tv.com, request: "GET /viewtopic.php?t=82&start=10 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?t=82&start=10", host: "piknik-tv.com"
2025/01/28 07:50:05 [error] 1268641#1268641: *5456654 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 213.180.203.104, server: piknik-tv.com, request: "GET /viewtopic.php?p=183831 HTTP/1.1", upstream: "http://127.0.0.1:81/viewtopic.php?p=183831", host: "piknik-tv.com"

[rxu]

Нужен спец для проверки и настройки серверов, таймауты пачками валятся, даже просто при просмотре тем. Такого не должно быть.