See the discussion here.
Made a mistake in version 1.0.5 that facilitated my testing, I just forgot to correct it. It’s related to the new feature to count unapproved posts. It was counting approved posts instead, which was much easier to test than creating an account and setting up a bunch of unmoderated posts. Happily, it was a one line code fix
If the edit subscribers feature of digests is not working for you, except possibly the pagination feature, you are not alone. I haven’t had any issues with it in my development or test environments, but others have. Anyhow, there is now a solution if this is happening to you which is described in this post.
The fix will be rolled out in the next release of digests, version 3.2.16 which is in development.
In this post I detailed how you can create a custom style that encapsulates the changes you made to your style to give your bulletin board a unique look and feel.
I now offer this as a service. See my pricing summary for my current rates, which at this time are $30 noncommercial and $60 commercial.
What I will do is analyze all the changes you made to your style by comparing your changes with a referenced version of the style that you modified. Once I have done that I will create the custom style with all these changes, inheriting from the original style. And I will replace the style that you marked up with the original style. Your custom style will inherit from it.
This has some advantages:
- When updating phpBB, your custom changes are insulated. You no longer have to reapply these changes, or be scared to update phpBB or your primary style, at least if you follow phpBB’s update procedures.
- You can make tweaks to your custom style in one place. Stylesheet commands are all placed in the stylesheet.css file of the custom style.
If you have made changes to templates, you may want to update these in your custom style from time to time. New template events are added to templates occasionally with new releases of phpBB or your primary style. I can do this for you as a service too at my general hourly labor rate.
Slow month for incoming business, similar to April and May. Not that there weren’t jobs in the hopper, but these are slow moving jobs, of which I get many, mostly waiting on events from external actors. In response I’ve been working on my filter by country extension. I’m also drafting a book on phpBB. Let’s see if I finish it. If finished it will be a guide to the proper administration of phpBB forums, something that doesn’t exist outside of documentation on phpbb.com. The documentation tells you how to fill out screens, but doesn’t do much to present the bigger picture of give you ways to troubleshoot problems. Obviously if I finish it I hope to monetize it. It would be nice if it generated some passive income for when certain months are slow.
Of course October started off with a bang and I have something of a job queue at the moment. No accounting for this business.
- Updated a board from phpBB 3.2.1 to phpBB 3.2.7. I updated the prosilver_se style and reapplied the custom logo. I also updated the digests extension from version 3.2.4 to 3.2.15 and updated the Authorized for URLs extension from version 1.0.3. to 1.0.5. No issues noted. Customer will update PHP from 5.4 to 7.2.
- Two step job. First updated a development board from phpBB 3.2.5 to phpBB 3.2.7. I updated the Pages and Stop Forum Spam extensions. I reapplied the custom style. I removed what looked like a lot of unnecessary files with _ in the file name. Later I updated the production forum repeating all the steps for the development forum. There were no issues. The extensions on the production forum were already up to date.
- A client insisted on prepaying me to stand up a new forum and likely later tutoring. I set up a new board on a new domain, after first creating space for the domain. I installed phpBB 3.2.7 and the prosilver_se style. I set up reCaptcha credentials as a spambot countermeasure. Later in the month, I provided guidance on using and integrating the board as part of a larger website, which will be using WordPress. I moved the forum into a subdomain. Since a new version of phpBB was released, I updated the new board to phpBB 3.2.8 and prosilver_se style to latest edition too. I also added home link to the WordPress master site. More work on this project is likely in October.
- Invalid reCaptcha keys were causing issues for users of a board for a longstanding (ten-year!) client. I generated a new set of keys, entered them in the ACP and that resolved the problem.
- Updated a board from phpBB 3.2.7 to phpBB 3.2.8. Initially I did some troubleshooting. HTTP 500 errors were occurring. This appear to be because of too much traffic and BlueHost simply cut off further use until some time period elapsed. Later, I installed the Cleantalk extension as a spam firewall so only legitimate traffic would get through. But it doesn’t seem to have fixed the issue. I suspect security software on Bluehost is overwriting cache folder permissions is part of the problem, because many folders have 755 permissions when they should have 777 permissions, and many files have 644 permissions when they should have 666 permissions. Changing these permissions with FTP don’t seem to stick. Something is reverting the changes. Cleantalk may not be working because it cannot talk to the Cleantalk server. Enabled the allow_url_fopen PHP setting to see if that addresses the problem. (Cleantalk was not showing any traffic from the forum.) This work is still ongoing. Right now the forum is largely inaccessible generating HTTP 500 errors. The error log suggests the client is over quota and it is rudely not allowing access when some quota level is hit.
- Client tried to update board from phpBB 3.2.4 to phpBB 3.2.8 and it failed due to a resource issue, reportedly. I tried again and had no issues. Didn’t know what logo to apply so I applied the blue phpBB logo that was already there, but had to change the background area size so it didn’t repeat. Client later reapplied the correct logo.
- Client needed to rehost and update a phpBB 3.0.13-PL1 forum to the latest version. Client decided to rehost first and save upgrading phpBB for later. It turned out that the client did most of the work. I acted as an advisor. I determined PHP 5.4 was not available on the new hosting (only PHP 7 was available) but was needed as phpBB 3.0 won’t work with PHP 7. He got GoDaddy to add PHP 5.4 to his new hosting. He ended up moving the files and database. The database was moved twice because new posts had been made. I had to create a new database user and tie it to the new database to bring the rehosted forum up. I changed folder permissions and edited config.php to tell phpBB to use mysqli (being proactive). Upgrade to come?
Updated October 13, 2019 to mention that the phpbb_migrations table is always changed with an update.
When updating phpBB, you should backup your database. That’s the guidance given by the phpBB Group. Updates occur when you are moving from one micro version of phpBB to another, say 3.2.6 to 3.2.7. When moving from minor versions, like 3.1 to 3.2, you are doing an upgrade and different procedures apply.
It’s never a bad idea to backup your database. It can be done manually in phpBB: ACP > Maintenance > Backup. This method though is not foolproof. Particularly on larger forums or on shared hosting, backups can time out. Sometimes you think you have a complete backup and you don’t. The only way to know for sure is to download it, and examine it in an editor. If the bottom of the file shows the phpbb_zebra table is being populated and ends with a semicolon, it should be complete. Web hosts often offer features that make automatic database and file backups for you.
But it turns out that when making updates, generally not much of your forum’s database actually changes. Only two tables are guaranteed to change: phpbb_config and phpbb_migrations. (I use phpbb_ as your table prefix. Yours may be different. You can see your actual table prefix in your forum’s config.php file.) This is because phpBB always tracks the current version of phpBB installed, and it is stored as a row in this table. And with each update, one or more rows are added to the phpbb_migrations table to indicate what migrations were made.
Most updates don’t affect many tables. In fact, it’s typical that only the phpbb_config and phpbb_migration tables are affected.
So there is no point in making a full backup of your database prior to updating if you don’t need to. It’s a real hassle on larger forums.
It turns out that if you look through phpBB’s code you can figure out which tables are updated. The /phpbb/db/migration folder contains a number of subfolders. The programs in these subfolders do the work of changing your database during updates.
For example, there is a v320 folder. This contains the migration programs used to bring phpBB up to version 3.2.0.
There is also a v32x folder. This contains the migration programs used for each version update of phpBB 3.2. You can infer from the file names which these are. For example, v321.php and v321rc1.php are used to update from phpBB 3.2.0 to 3.2.1. “rc” in the file name means “release candidate”. There is typically at least one release candidate before an official release. So it’s a matter of reading these programs to see what tables are actually affected.
That’s what I did, and you can see the results on my Do I need to update page. Or you can examine them yourself. I’ll keep the update page updated as new micro releases occur. You might want to bookmark it and refer to it before doing your own update.
If you do it yourself, follow the official procedures on phpBB’s update page. But you may decide to backup only the tables that are actually changed to save yourself extra hassle. If an error occurs, restore these tables and recover your files.
The first half of the month was slow, the second half medium busy. After the very busy months of June and July, I didn’t mind that things slowed down. Some of the work was a continuation of work not quite completed in July:
- Here was more work for a client mentioned in my July report. This was a large rehosting effort off of Microsoft servers to Linux for a client in Australia
- August 1. I answered various questions, investigated DNS settings for client’s domains, and moved files for a dormant domain from Windows to Linux. I created database user “root” on the Windows MySQL database so his web host could create a successful extract of this database, which I couldn’t do with their control panel. It seemed strange the host couldn’t figure this out or chose not to, and I had to do it just to get the database exported.
- August 2. I discovered one of the client’s domains was blacklisted. I recommended remediation procedures. I moved the database for a Wiki based on Windows technology from Windows to Linux hosting, and placed in a .sql.gz extract of the database in a specified folder so it could be created later when the client chooses to take this up as a project.
- August 3. I created a scheduled task (cron) to run every five minutes to use with the forum to send out board emails. The limiting factor here is that the web host’s policy is to not allow more than 200 emails per hour outgoing per domain, so a scheduled cron in phpBB was needed. To do this I set the email package size to 16 with the cron to be invoked every five minutes. This got it under 200 emails per hour quota for domain. I also changed the queue_interval in database to 300 so phpBB crons would not run more often than every 5 minutes, to avoid going over quota. Created a test.php email program to help with troubleshooting emails.
- August 4. I tested emailing using contact form. The email was received but appeared to be sent outside of normal email queue. I found and looked at queue.php in the /cache/production folder and discovered emails were being, albeit sent slowly and there were several thousand email notifications in the queue that would take a couple of days to clear. I changed the cron (which used curl) to use www in the URL to call to avoid HTTP 301 messages.
- August 5 and 6. Provided additional guidance and answered questions.
- Styling work on new forum. Trying to get a logo to meet with width of the content (used CSS cover attribute) but leaving a proportional amount of vertical whitespace. I couldn’t figure out a way to do it with CSS, so wrote a little jQuery code to do it tied to window resize and page loading events. Glad to figure this out. This required advanced skills I rarely get to use and which I suspect are beyond most web developers.
- Troubleshooting. The forum was not sending emails. I noted messages in phpBB error log saying “Email message was blank”. I tried a number of things, but eventually determined that if the SiteSplat BBCore extension was disabled it wasn’t an issue, so the issue had to be somewhere inside the extension. The latest version of that style and its extension was installed. It’s possible a newer version of the extension will fix the issue. I suggested client talk with SiteSplat’s technical support to see if it’s been addressed and to update style plus extensions if there is a fix. Otherwise they have the ability to reproduce the issue. There is a user interface for the style. The client eventually figured out the if the Minify HTML setting for the style was checked, then allowed emails to go out. This is still a bug with the extension.
- This was a multistep project, still not completely finished. A domain had two phpBB forums, one an old legacy phpBB2 forum, the other a phpBB 3.0.11 forum. Server upgrades were making upgrading both of these to phpBB 3.2 important.
- In the first phase, I converted forum from phpBB 2.0.19 to phpBB 3.2.7. There were 548,000 posts that had to be converted. Placed in new folder for analysis, old forum is still in the original folder so it could be used. I recreated the search index. No issues during the conversion, but it was tedious taking about three hours overall. I disabled the contact form and new registrations, added a home link and installed PRO_UBUNTU LUCID style. This parent style was to be tweaked with additional styling changes to be used on both forums.
- Had a conversation on the phone to discuss styling requirements. I ended up doing 4.5 hours of styling work, including adding a banner, logo, moving site title and description, changing column for profiles in view topic, adding a line with links under the navigation bar, etc. Later, I did more styling work based on refined requirements.
- With the styling changes done, I upgraded the main forum from phpBB 3.0.11 to 3.2.7. I had to empty the phpbb_modules table and repopulate it from a 3.0.14 reference because nonstandard changes had been made to the ACP interface that triggered an error during the upgrade. Once I did that, the upgrade completed. I replicated the styling and extensions on the converted old forum. I changed the not logged in message, which is different on the active forum. I disabled the contact form. I set up and enabled the reCaptcha V2 spambot countermeasure. I moved the old converted phpBB 2 forum to its proper folder and moved the unconverted forum to a new space for the time being. I provided guidance on upgrading PHP to 7.2 and files and databases that can be deleted. There is at least one loose end on this work: a third-party program failed because with the move to phpBB 3.2, the old coding standards fail in the new environment. User may opt not to have me fix this program.
- I did some online tutoring on new forum that needed to be set up properly. I answered lots of questions, mostly related to permissions and moderation, roles and such, and how to configure phpBB correctly. I did ninety minutes of tutoring in total.
- I upgraded a forum from phpBB 3.1.10 to 3.2.7. The forum has 17,000 posts. I updated the following extensions: 24 hour activity stats, Lightbox, LMDI Delete Re:, Profile side switcher and Media Embed. Installed updated Lucid Lime style and reapplied style changes. I updated the German language pack. Noticed that an invalid SSL certificate needed updating. PHP should go from 5.6 to 7.2 when client is ready. I encountered HTTP 500 errors related to extension name changes in the file structure.
- A forum was rehosted but database was not loaded, so basically I was asked to stand it up again. I loaded the database from a database extract provided. The forum is a phpBB 3.0.11 board in a PHP 7.2 environment. I had to step PHP to version 5.6 to get it to come up. I added two statements to config.php so that mb_string support would work, and enabled mysqli so it would work when the forum is upgraded and moved to PHP 7.2. I recommended upgrading of forum to phpBB 3.2.7.
If you are looking to rehost your site, you might want to take advantage of a Siteground web hosting shared server sale coming up. The event begins September 2, 2019 and lasts through September 8, 2019. I use Siteground’s shared hosting to host this site.
While I like Siteground, it doesn’t make sense for everyone. In particular, before you move to Siteground’s shared hosting make sure that your databases are not too big. There are limits from 400MB to 1GB on the size of your databases, depending on the plan you choose. More details are on my rehosting page.
Also, in fairness I should note that Siteground recently raised their prices. Their GoGeek plan, their most feature-laden shared hosting plan, used to be about $20/month regular price and is now $34.95/month. However, they are a quality shared host, which is a rarity in their business. To maintain their completely solid state infrastructure means they need more revenue that hosts that still use slower disk drives.
New customers get a first year discount anyhow of $3.95/month, $5.95/month or $11.95 depending on whether you choose the StartUp, GrowBig or GoGeek plan. This represents a first year discount of between 66% and 70%.
During the sale, the GoGeek plan is discounted to $7.95/month for the first year, a savings of 77%.
Siteground will rehost you for free if you choose the GrowBig or GoGeek plan.
If you decide to sign up during the sales period, please be kind and use my affiliate link. You won’t pay anything extra and I will earn a commission.
You can see more details on their shared hosting plans and limitations here.