Количество тем

[malkin]

Час добрый. Количество тем у пользователей неправильно показывает. Какие способы есть обновить показатели?

[Sumanai]

На главной странице админ панели совсем не бывали? Ни разу?

[malkin]

Sumanai, Намек понял. Я забыл упоминуть, но Синхронизировать счётчики тем не помогает. Вернее помог бы но я ее выполнить не могу. Слишком много тем.

[Sumanai]

А как вы хотите по другому? Отключите форум в настройках и выполняйте.

[malkin]

А как вы хотите по другому?

Думал через базу данных можно. форум отключил всёравно: Internal Server Error

[Sumanai]

Думал через базу данных можно.

Оно так и есть. Скрипт обращается к базе данных и считает все темы, перезаписывая значения счётчиков. Иначе никак, разве что руками считать и записывать, но этот мазохизм займёт у вас пару недель.

[malkin]

<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

set_time_limit (0);
sync ('forum', '', '', FALSE, TRUE);
sync ('topic', '', '', FALSE, TRUE);
trigger_error('Ok');
?>

Создал файл в корень файла. Выполнилось успешно, но счетчик не обновился. Может код не совсем верный?

[Sumanai]

Понятия не имею, что за код.

[VEG]

malkin, У меня на slutsk.net 140397 сообщений (на 4 тысячи меньше, чем у вас). Синхронизация проходит буквально за секунду-две. У меня обычный shared хостинг. С какой ошибкой падает скрипт, если вы запускаете синхронизацию счётчиков тем из админки (как и положено)? В зависимости от того, на что оно ругается, и нужно действовать. Скорее всего нужно будет изменить ограничения для скриптов на сервере (в зависимости от хостера это можно либо делать самому, либо просить хостера). Если же по каким-то причинам мешающие ограничения изменить нельзя, возможно, придётся выкачивать базу на локалку, делать синхронизацию на локалке, а потом обратно заливать базу на сервер.

[malkin]

С какой ошибкой падает скрипт, если вы запускаете синхронизацию счётчиков тем из админки (как и положено)?

Если же по каким-то причинам мешающие ограничения изменить нельзя, возможно, придётся выкачивать базу на локалку, делать синхронизацию на локалке, а потом обратно заливать базу на сервер.

Я думаю можно. У меня ВДС. Только подскажите в каких файлах.

[VEG]

malkin, Значит ищите логи ошибок Apache, там будет указана причина ошибки.

[malkin]

Спойлер

[Sun Mar 23 02:48:05 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations
[Sun Mar 23 02:51:19 2014] [error] server reached MaxClients setting, consider raising the MaxClients setting
[Sun Mar 23 02:52:39 2014] [warn] mod_fcgid: process 850 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:39 2014] [warn] mod_fcgid: process 987 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:43 2014] [warn] mod_fcgid: process 1674 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:43 2014] [warn] mod_fcgid: process 978 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:53 2014] [warn] mod_fcgid: process 1682 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:53 2014] [warn] mod_fcgid: process 1678 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:52:59 2014] [warn] mod_fcgid: process 1686 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:53:21 2014] [warn] mod_fcgid: process 1698 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:53:21 2014] [warn] mod_fcgid: process 1694 graceful kill fail, sending SIGKILL
[Sun Mar 23 02:53:22 2014] [notice] caught SIGTERM, shutting down
[Sun Mar 23 02:53:35 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Sun Mar 23 02:53:35 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations
[Sun Mar 23 02:59:30 2014] [error] server reached MaxClients setting, consider raising the MaxClients setting
[Sun Mar 23 03:00:43 2014] [warn] mod_fcgid: process 1669 graceful kill fail, sending SIGKILL
[Sun Mar 23 03:00:49 2014] [warn] mod_fcgid: process 951 graceful kill fail, sending SIGKILL
[Sun Mar 23 03:00:49 2014] [warn] mod_fcgid: process 1673 graceful kill fail, sending SIGKILL
[Sun Mar 23 03:01:05 2014] [warn] mod_fcgid: process 1658 graceful kill fail, sending SIGKILL
[Sun Mar 23 03:01:08 2014] [notice] caught SIGTERM, shutting down
[Sun Mar 23 03:01:19 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Sun Mar 23 03:01:19 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations
[Sun Mar 23 03:03:25 2014] [error] [client 61.191.154.113] File does not exist: /var/www/manager
[Sun Mar 23 03:23:28 2014] [warn] mod_fcgid: cleanup zombie process 1238
[Sun Mar 23 04:01:19 2014] [error] [client 176.57.128.87] File does not exist: /var/www/phpTest
[Sun Mar 23 04:01:19 2014] [error] [client 176.57.128.87] File does not exist: /var/www/phpMyAdmin
[Sun Mar 23 04:01:19 2014] [error] [client 176.57.128.87] File does not exist: /var/www/pma
[Sun Mar 23 04:01:19 2014] [error] [client 176.57.128.87] File does not exist: /var/www/myadmin
[Sun Mar 23 05:24:54 2014] [error] [client 119.84.41.5] File does not exist: /var/www/exit
[Sun Mar 23 06:23:01 2014] [notice] Graceful restart requested, doing restart

Спойлер

[Tue Mar 25 13:39:30 2014] [error] [client 61.19.197.202] File does not exist: /var/www/phpTest
[Tue Mar 25 13:39:31 2014] [error] [client 61.19.197.202] File does not exist: /var/www/phpMyAdmin
[Tue Mar 25 13:39:31 2014] [error] [client 61.19.197.202] File does not exist: /var/www/pma
[Tue Mar 25 13:39:32 2014] [error] [client 61.19.197.202] File does not exist: /var/www/myadmin
[Tue Mar 25 15:17:02 2014] [warn] mod_fcgid: cleanup zombie process 6525
[Tue Mar 25 16:45:16 2014] [error] [client 202.53.8.82] File does not exist: /var/www/horde
[Tue Mar 25 20:25:48 2014] [warn] mod_fcgid: cleanup zombie process 8700
[Tue Mar 25 21:03:28 2014] [warn] mod_fcgid: cleanup zombie process 8913
[Tue Mar 25 22:40:48 2014] [warn] mod_fcgid: process 9568 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:40:48 2014] [warn] mod_fcgid: process 9535 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:40:54 2014] [warn] mod_fcgid: process 9684 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:40:54 2014] [warn] mod_fcgid: process 9566 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:40:54 2014] [warn] mod_fcgid: process 9563 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:41:00 2014] [warn] mod_fcgid: process 9690 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:41:00 2014] [warn] mod_fcgid: process 9687 graceful kill fail, sending SIGKILL
[Tue Mar 25 22:41:03 2014] [notice] caught SIGTERM, shutting down
[Tue Mar 25 22:41:15 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Tue Mar 25 22:41:15 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations

Добавлено спустя 2 минуты 34 секунды:
в php.ini

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

memory_limit = 444M

[VEG]

Запустите синхронизацию тем и покажите, какая строчка появится в логах. Все ошибки за всё время не нужны.

[malkin]

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

[Wed Mar 26 01:29:27 2014] [notice] caught SIGTERM, shutting down
[Wed Mar 26 01:29:39 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Wed Mar 26 01:29:39 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations
[Wed Mar 26 01:31:46 2014] [error] server reached MaxClients setting, consider raising the MaxClients setting
[Wed Mar 26 01:33:08 2014] [warn] mod_fcgid: process 1481 graceful kill fail, sending SIGKILL
[Wed Mar 26 01:33:08 2014] [warn] mod_fcgid: process 1202 graceful kill fail, sending SIGKILL
[Wed Mar 26 01:33:10 2014] [notice] caught SIGTERM, shutting down
[Wed Mar 26 01:33:23 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Wed Mar 26 01:33:23 2014] [notice] Apache/2.2.16 (Debian) mod_fcgid/2.3.6 configured -- resuming normal operations

Добавлено спустя 5 минут 16 секунд:

apache2.conf

#
# The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
#
LockFile ${APACHE_LOCK_DIR}/accept.lock

#
# PidFile: The file in which the server should record its process
# identification number when it starts.
# This needs to be set in /etc/apache2/envvars
#
PidFile ${APACHE_PID_FILE}

#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 300

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15

##
## Server-Pool Size Regulation (MPM specific)
##

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_prefork_module>
StartServers 1
MinSpareServers 1
MaxSpareServers 5
MaxClients 10
MaxRequestsPerChild 0
</IfModule>

# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadLimit: ThreadsPerChild can be changed to this maximum value during a
# graceful restart. ThreadLimit can only be changed by stopping
# and starting Apache.
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_worker_module>
StartServers 1
MinSpareThreads 1
MaxSpareThreads 4
ThreadLimit 64
ThreadsPerChild 25
MaxClients 10
MaxRequestsPerChild 0
</IfModule>

# event MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_event_module>
StartServers 1
MaxClients 10
MinSpareThreads 1
MaxSpareThreads 4
ThreadLimit 64
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>

# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}

#
# AccessFileName: The name of the file to look for in each directory
# for additional configuration directives. See also the AllowOverride
# directive.
#

AccessFileName .htaccess

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<Files ~ "^\.ht">
Order allow,deny
Deny from all
Satisfy all
</Files>

#
# DefaultType is the default MIME type the server will use for a document
# if it cannot otherwise determine one, such as from filename extensions.
# If your server contains mostly text or HTML documents, "text/plain" is
# a good value. If most of your content is binary, such as applications
# or images, you may want to use "application/octet-stream" instead to
# keep browsers from trying to display binary files as though they are
# text.
#
DefaultType text/plain


#
# HostnameLookups: Log the names of clients or just their IP addresses
# e.g., www.apache.org (on) or 204.62.129.132 (off).
# The default is off because it'd be overall better for the net if people
# had to knowingly turn this feature on, since enabling it means that
# each client request will result in AT LEAST one lookup request to the
# nameserver.
#
HostnameLookups Off

# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here. If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog ${APACHE_LOG_DIR}/error.log

#
# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
#
LogLevel warn

# Include module configuration:
Include mods-enabled/*.load
Include mods-enabled/*.conf

# Include all the user configurations:
Include httpd.conf

# Include ports listing
Include ports.conf

#
# The following directives define some format nicknames for use with
# a CustomLog directive (see below).
# If you are behind a reverse proxy, you might want to change %h into %{X-Forwarded-For}i
#
LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

# Include of directories ignores editors' and dpkg's backup files,
# see README.Debian for details.

# Include generic snippets of statements
Include conf.d/

# Include the virtual host configurations:
Include sites-enabled/
Include fastpanel-sites/*.conf
Include /etc/apache2/fastpanel-sites/*.conf

Добавлено спустя 10 минут 34 секунды:
Менял значение MaxClient на 21. Тоже самое.

[malkin]

Перевел на локалку.
Значения прибавил.
memory_limit = 512M
max_allowed_packet 512
и другие тоже. В итоги при выполнение синхронизации (после 11 минут) выходит белый экран.

Перед выполнением очистил лог:

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

[Wed Mar 26 18:27:49 2014] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 26 18:27:49 2014] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 26 18:27:49 2014] [notice] Apache/2.2.22 (Win32) mod_ssl/2.2.22 OpenSSL/1.0.1c PHP/5.2.12 configured -- resuming normal operations
[Wed Mar 26 18:27:49 2014] [notice] Server built: Apr 20 2012 18:42:30
[Wed Mar 26 18:27:49 2014] [notice] Parent: Created child process 4644
[Wed Mar 26 18:27:50 2014] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Mar 26 18:27:50 2014] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 26 18:27:51 2014] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Child process is running
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Acquired the start mutex.
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Starting 25 worker threads.
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Listening on port 443.
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Listening on port 8648.
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Listening on port 443.
[Wed Mar 26 18:27:51 2014] [notice] Child 4644: Listening on port 80.

Добавлено спустя 8 минут 46 секунд:
Код который мне на другом форуме написали тоже не работает, хоть и пишет через определенное время OK. Данный код нужно в корень сайта злить и выполнить.

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

<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

set_time_limit (0);
sync ('forum', '', '', FALSE, TRUE);
sync ('topic', '', '', FALSE, TRUE);
trigger_error('Ok');
?>

Возможно он просто для phpbbex не подходит.

[Gravi]

Выключите SSL на время, может поможет.