My books aren’t quite closed yet on 2020, but 2020 was at least a good year for me and this business. I am unlikely to see a repeat next year.
Much of the new income was from one commercial client and the work there is slowing down. So I expect less revenue in 2021. But what a nice year it was! I nearly doubled my income from 2019. Normally I’d have spent a good portion of it, but with the pandemic there was no place to spend it. It normally goes toward fancy vacations (like a trip to Ecuador and the Galapagos in 2019), but this year except for a short cruise right before the pandemic hit in earnest, we had no choice but to vacation at home. My phpBB consulting is ideal work during a pandemic, as it is all done from home safely over the Internet. So thank you to all who trusted me with your forums in 2020 and kept me very much in the black.
Otherwise, my work in December was kind of slow because there wasn’t much to bill the one commercial client although curiously they did give me a $250 bonus! I enjoyed the downtime, but I also gave back to the community. Both my digests and filter by country extensions had new releases in December. More importantly I continue to work on a Spamremover extension, which finds spam using the Akismet web service. I had nothing to release yet, but I am getting close to a release.
Other work in December:
- Worked with a client using my digests extension on Siteground hosting. Subscribers stopped getting digests. I helped the client set the email settings properly to match Siteground’s SMTP server but afterward there were still issues. It turned out that digests weren’t going out because no cron job was set up. It may have disappeared when Siteground moved him to a new server and they didn’t replicate his digests cron job. After finally getting into Siteground with the client’s help, I was able to set up a new phpBB cron which seems to work.
- Upgraded a board from phpBB 3.3.1 to 3.3.2. Also added markup to display a favicon.
- Upgraded a major client’s board from phpBB 3.2.2 to 3.3.2. There are many customizations to phpBB 3.2.2 that had to be carried over in phpBB 3.3.2. I first did an upgrade to the test environment to work out any kinks, then a month or so later did a production upgrade to the board. All appears to be okay. I had to change the owner of the /cache/production folder to get rid of a HTTP 500 error. Later, I chased lots of styling issues, mainly on the view topic page and related to mobile display.
- Issue with too many login attempts during admin login. I reset the number of password attempts using SQL and provided him with the SQL I used. But it didn’t work. I tried to delete the cache manually using FTP but didn’t have permissions in the twig folder. Also, CAPTCHA would not come up even though a message said to solve the CAPTCHA. Had to give my account (and his too) founder permissions. Later I realized there was a simpler solution: use phpBB’s lost password feature. The CAPTCHA issue I figured out was likely a bug in phpBB, so I submitted a problem report. It turns out that if a CAPTCHA is used, allow_url_fopen is false and the CAPTCHA is validated with a post request, the error will occur. A HTTP GET request though won’t have an issue. This is a bug in phpBB that needs fixing.
- A phpBB 3.2 board that can’t be upgraded had emailing issues. Test emails went out okay. Could not get SMTP to work for sending email. I suggested talking with the client’s web host to see if they are blocking “spammy” looking outgoing emails. Later, I added ACP Add User extension, which apparently was what he really needed.
- Updated a board from phpBB from 3.3.0 to 3.3.2, and my digests extension from 3.3.1 to 3.3.3. No surprises, just slow FTP and I couldn’t find cPanel credentials that worked. Later, I updated Cleantalk to version 5.7.3.
- Upgraded forum from phpBB 3.0.x to 3.3.2. No issues during upgrade. Most of the work was trying to replicate the styling to give a similar look. It’s quite close. Created a custom style that inherits from the Elegance SoftBlue style. Copied over two templates. Installed reCaptcha V3 but registrations aren’t allowed. I disabled the contact form. I changed PHP to version 7.4 and set allow_url_fopen to true. Later, I added an extension to add next and previous post buttons inside a topic. I also moved the post edit controls from top right corner to bottom right of the post. I expanded width of content window from what it was before (980px) to the default 1152px.
- Troubleshooting. Too many SQL connections error. I gave advice on the general issue and what causes it, and suggested Cleantalk’s spam firewall service if the issue is due to malicious robots (to keep spammers off the site), but first to look at traffic for the main domain and see if general increased usage was the cause. As requested, I repaired and optimized all database tables for the board. Last I heard the too many SQL connections problem was still an issue. The client’s hosting is Bluehost. I’ve seen this before on Bluehost. In my opinion, their shared servers do not allow enough resources for reasonable shared usage. I’d avoid hosting with Bluehost if you have a choice.
- Upgraded a board from version 3.2.2 to 3.3.2. Updated the stop forum spam extension to version 1.3.10 and NavBar search extension to version 3.2.4. I created a custom style “custom” and put style changes there and made it the default. I changed PHP from version 5.6 to 7.4. No issues during upgrade.
- Troubleshooting. Investigating why images and phpBB Gallery extension was taking up so much space. Primary issue was that the old gallery was copies from a /gallery_old folder. Suggested changing Gallery JPEG compression to 85% to match phpBB’s attachment settings.