phpBB • Free and Open Source Forum Software

Instead of reseting views count can I change the data type to unsigned int? I would rather do that to keep my topic's view count as is instead of starting from zero.

Topic's view count in one of the threads in my forum is dangerously close to reaching the max value of UNSIGNED MEDIUMINT (16777215) in MySQL (8.0) which is the data type for topic_views column in phpbb_topics table. What happens when it reaches the limit and overflows? Can I change the data type in...

Anyone?

A spam bot registered on my forum and sent over 1500 PMs that I would like to remove. How can i do it gracefully? Would this work: DELETE FROM `phpbb_privmsgs` WHERE author_id = <spam bot id> DELETE FROM `phpbb_privmsgs_to` WHERE author_id = <spam bot id> I tried to do it using Empty PM outbox in AC...

I followed this guide:
https://www.phpbb.com/support/docs/en/3 ... upgrade31/

And "zw" was the disable forum message that I set before upgrading.

After upgrading (update database only) finished I got these errors: [phpBB Debug] "zw" in file /var/www/xxx/public_html/phpbb/user.php on line 351 [phpBB Debug] "count(): Parameter must be an array or an object that implements Countable" in file /var/www/xxx/public_html/phpbb/cac...

Fixed it by adding to php files it nginx. It might be an overkill, but it works.

Anyone?

Lumpy Burgertushie wrote: ↑Sat Jan 13, 2018 3:48 pm try disabling cloudfare to test.

Same thing happens

Since moving my board to a different server with same config (phpbb3.1.10, Debian 8, nginx, php5.6.30, mariadb, sphinx, memcache, cloudflare) I have problem with caching unread posts. When I click on Unread posts, click on any unread topic, reply (or not), click on unread posts again i still have th...

Anyone?

Edit:
Nevermind, fixed it by replacing 3.1.10 acp_search.php with this:
https://github.com/phpbb/phpbb/blob/3.1 ... search.php

Any ideas?

https://tracker.phpbb.com/browse/PHPBB3-14011 Thanks not the case for me. In my case index is being created, but after every step in indexing (3000 posts or so) I get The submitted form was invalid. Try submitting again. error and I can continue it using Continue previous indexing process , but it ...

I now discovered that I also can't change Search backend in Search settings (currently I'm on Sphinx Fulltext). I get The submitted form was invalid. Try submitting again.

When I try to create phpbb Native Fulltext index by Create Index button in Maintenance tab, after a few seconds I get: All posts up to post id 3000 have now been indexed, of which 2945 posts were within this step. The current rate of indexing is approximately 205.9 posts per second. Indexing in prog...