ElitePortugas

Problem
You have accidentally had a forum permission set to not count the posts in the forum as such users have lots of posts missing from their post counts. However changing the forum permissions and re-syncing post counts still does add these posts the the users post count/

Cause
There is a database flag in the posts table preventing these posts being counted during a re-sync.

Solution:
1. Create a fix.php file with the following:

Código: Seleccionar todos

<?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);
$user->session_begin();
$auth->acl($user->data);
$user->setup();

$sql = 'UPDATE ' . POSTS_TABLE . ' SET post_postcount = 1';
$db->sql_query($sql);

trigger_error('<span style="color:green; font-weight:bold;">Template Data purged successfully</span><br /><br /><span style="color:red; font-weight:bold;">Please delete this file</span>');
?>


2. Upload the file to your board's root folder (the one with config.php)

3. Run it by navigating to the file in your browser (ex. http://www.yoursite.com/phpBB3/fix.php)

4. If any errors come up, post the report here.

5. Be sure to delete the file; don't leave it on your server

Well it is in the "Common phpBB3 problems and tutorials" forum so I would have though the answer obvious, this is a solution for a phpBB3 problem.




Realize um backup do seu banco de dados, e depois tente os comandos sql no phpMyAdmin

optimize table phpbb_topics;

optimize table phpbb_topics_posted;

optimize table phpbb_topics_track;

optimize table phpbb_topics_watch;

Execute um comando de cada vez, e depois diga se funcionou.




No ACP
(tabela) - Forum>Groups forum permissions>Registered users>select the forum in question and check the Advanced permissions>Misc>Increment post counter = Coloca a função em yes.




Podes ainda instalar a MOD que altera a quantidade de posts (pelo ACP).

Está Aqui

!	Master Portugas:
	Resolvido: era um BUG no viewtopic.php, resultante de uma má instalação da MOD.

Sempre a trabalhar....