Currently Viewing Posts Tagged phpbb

SphinxSearch WARNING: word overrun buffer, clipped!!!

It is a warning information when the cronjob running every night.  This cronjob is used to update or re-index the phpBB powered forum, which is a Chinese forum.

The whole error is a kind of a list of warning with same problem.

WARNING: word overrun buffer, clipped!!!
clipped (len=126, word='请注意只有使用中国付款互联网付款服务支持的中国信用卡和借记卡才可以启动该话务中心的服')
original (len=126, word='请注意只有使用中国付款互联网付款服务支持的中国信用卡和借记卡才可以启动该话务中心的服')
WARNING: word overrun buffer, clipped!!!
clipped (len=126, word='我想不管你后面是因为衣服的问题还是喜欢不喜欢的问题应该不能退了如果当时店里的人已经告')
original (len=126, word='我想不管你后面是因为衣服的问题还是喜欢不喜欢的问题应该不能退了如果当时店里的人已经告')
WARNING: word overrun buffer, clipped!!!
clipped (len=126, word='新的网上申请表含有条形码而这些条形码将可以允许我们电子传输信息从而减少了签证申请过程')
original (len=126, word='新的网上申请表含有条形码而这些条形码将可以允许我们电子传输信息从而减少了签证申请过程')

How to solve the problem with the overrun buffer warning?

Continue reading “SphinxSearch WARNING: word overrun buffer, clipped!!!”

Errors when upgrade phpBB 3.0.12 to phpBB3.1

I am going to upgrade my forums which are powered by phpBB.  The package I downloaded is automatic upgrade package. phpBB-3.0.12–

One is small forum, with most of the default settings. When I upgrade it as old way, the error came as below:

Fatal error: Composer dependencies have not been set up yet

Laterly, I found I just uploaded the folder “install”. The thing I missed is folder “vendor”.

Then, I uploaded both install and vendor folders to my forum root directory.

This error is gone and following upgrade procedures are smooth.


Continue reading “Errors when upgrade phpBB 3.0.12 to phpBB3.1”

phpBB official site is hacked

phpBB official site was hacked one week ago. It is still under maintenance.

We are sorry to report that we have been attacked through a 0-day-exploit in our PHPList installation (responsible for the mailing list about new releases). will remain unavailable while we work to recover. No vulnerabilities have been found in the phpBB software itself.
You can download phpBB here:
You can get support at the temporary support forums or on IRC: #phpbb
A more detailed explanation about the incident.
Press Contact: If you need to get in contact with the management, please email phpbb_press (at) marshalrusty (dot) com.
– the phpBB team

I do have some forum powered by phpBB. It is good news that phpBB software is OK.

Upgrade phpBB 2 to phpBB3 (part 1)

Now I will go through all steps to upgrade phpBB 2.0.22 to phpBB 3.
I use Dreamhost to host my phpBB forum. The forum I upgrade in this sample is
To upgarde a phpBB 2 forum to phpBB3, I have to install a brand new phpBB 3 forum first, then convert the old phpBB 2 forum to phpBB 3. After testing, then let the phpBB 3 forum replace the phpBB 2 forum.
This is the part 1, covering the brand new installation of phpBB 3 and backup the old phpBB 2.
1) Backup all phpBB 2 files and database.
SSH to the server.

tar cvzf forum.g2soft.tar.gz ./

Use phpMyAdmin to export database of this forum.
2) Create a new dadabase
Use phpMyAdmin to create it, named as phpbb3
3) Get the phpBB 3 package and decompress it.
SSH to the server.

cd phpBB3
cp -r -f . ~/

Here I use as a temporary domain for converting processing.
4) Start to install this new phpBB3
Enter in the Firefox. The introduction of phpBB3 is coming.

5) Click install tab, the installation compatibility testing page shown as below.

6) Click start install button.
Enter the database setting, which I created on step 2, into this page.

7) Click “process to next step”, it will test the MySql server settings.

8) Enter the Administrator information to create the Forum Administrator.

Then the test of Administrator setting will run. The result looks like below:

Continue reading “Upgrade phpBB 2 to phpBB3 (part 1)”

New Features of phpBB3

phpBB3 is released last month. I upgraded one phpBB 2.0.22 to phpBB 3 yesterday.
I will show you the details about the upgrade later. Now I just mark some good features phpBB 3 added.
UTF-8 Support, Search Engine spider Handling, Set min/max Username Length, Set min/max Password Length, Set Password Complexity Requirements, Attachments, Post Drafts, Memberlist Searching, Disallow Non-Registered User Memberlist Viewing, and also a lot of other new features.
The completed feature comparation between phpBB2 and phpBB3.
The comparation of phpBB to IPB, VB, and SMF is here.
Download phpBB 2 or phpBB 3 here.

phpBB Email settings with Gmail

I run a BBS, which is phpBB. I also use the Google Apps’ email service. How to make them work together?
Let’s discuss it now.
Version of phpBB2: 2.0.22
It is running on the Dreamhost‘s hosting.
There is a email setting under General Admin > Configuration
Say, I want to use a Gmail account as the BBS system email account. The Google Apps’s email is same as Gmail setting.
Let’s put the details here.
1) Have the Gmail or Goolge Apps’s email account works.
2) Using the menu at the top right edge of the main Gmail window (the one that shows up after you log in), click on Settings, and then Forwarding and POP / IMAP. Under POP Download, click either Enable POP for all Mail, or Enable POP for Mail that Arrives Now (which ever suits your purpose). Configure anything else that appeals to you too. Exit from the Gmail Settings Window after saving your selections (this is important).
3) Login the phpBB administrator panel.
Goto General Admin > Configuration > Email Settings

SMTP Server Address:ssl://
SMTP Username: enter your email address
SMTP Password: enter the password of your email account.

After that, the email setting is fine on your phpBB system. Any emails through the system email account will be OK. I enable account activation, which requires new users verify his email address.

Anti Forum spammer by SpamWords

As I mentioned before, I install a Spamwords 1.1.3 plugin on PHPBB 2.0.22. After about one and half month use, I feel it is so good to provent lots of spam from displaying on my G2Soft Support forum.
It is like a Wall to protect the phpbb. The spammer is blocked and the IP address is banned either.
Let me list some popular spam words I used when detect the message.
There are three types of spam words.
1) Adult content;
2) Medicine;
3) fake software;
4) Other items, say, Furniture;
The list of spam words keep growing. When I see some new type of Spam, I will add these into the spam words. So next time some spammers try to post will be blocked.
During past 1 and half month, it blocked over one hundred spams. It is not including the spam post I deleted manually about 10 posts.
This Spam Words is good and powerfull. If you have a PHPBB forum. I highly recommend it to you to protect your system.

Installation of Spamwords 1.1.3 on PHPBB 2.0.22

I have posted Fight against Spam, Spammer and Bots on PHPBB forum system.
I have Humanizer mod for PHPBB, and Hide User’s WebSite Button 1.0.3 on my forum to protect against spam.
Now I feel it is not enough. I clean the spam every day.
I found this one SpamWords.
It can prevent the spam post with the “spam words” I setup in the system in advance.
It is cool that when a spammer want to post some spam, he will receive the error message and he can not successfully post it.
If you want this plugin, you can Download file here.
It will add some tables in your PHPBB database, and modify some files and install some new files.
The difficult fact is medium.
It took me about 15 minutes to install it. Please backup all files and database before installation.

Fight against Spam, Spammer and Bots

Create a Forum, or BBS, is easy for now. But to keep it clean and away from spam is more difficult.
To take care of the PHPBB, I use it for G2Soft Supporting Forum, I add some plugins on it.
I added Humanizer mod for PHPBB, and Hide User’s WebSite Button 1.0.3.
I got some help from this two posts:
Preventing SPAM – Bots and Humans
This one is from official PHPBB support team. The advice and steps are very clear and easy to understand, but some installations are very complicated.
Spammers & Scammers

This one is from a geek. He recorded some spammers’ IP address. I use it for reference and ban them in my Forum.

Continue reading “Fight against Spam, Spammer and Bots”

  • Archives