July 2016 work summary

Fewer clients last month but plenty of work to keep me busy and my most profitable month so far this year. I spent a good part of a week on one rehosting detailed below.

  • See this blog post on the lack of virtues of Aabaco hosting, truly the worst host on the Internet.
  • I upgraded a forum from phpBB 3.0.11 to 3.1.9. During the upgrade, experienced weird hosting issues with FTP, the web host file manager and with the database. While the upgrade seemed to go okay (no button labels appeared during it) things looked off. I looked at schemas and made manual corrections to them, hundreds of alterations altogether to make the tables reflect my 3.1.9 reference installation. I removed all but the British English language pack. I installed elegance, black and bb_mobi styles. There was lots of fine tuning working through various issues. I sent support ticket to client’s web host, since the file problems were on their side. It turned out they were due to an old cPanel installation and they had not upgraded the client. Things eventually calmed down. I applied old logo to the black and elegance styles.
  • Facebook like and share buttons that I added a year or so back for a client weren’t working on the view topic screen. Apparently the code to use had changed subtly. I replaced code in the iframe with latest code on Facebook site and it worked again.
  • More work for the client last month whose dedicated server was wiped and reloaded. User recovered his database using phpBB’s built in capability. Afterward, certain users could not login if there was a special character in their username, such as a “!”. I tried a number of approaches, eventually installed the Support Toolkit (since he had a phpBB 3.0 forum), ran the clean usernames function and that solved the problem. After repeatedly trying to login, some users got a “Not possible to convert password” error. Set the user_pass_convert column to 0 for all. In addition the user_email_hash was incorrect. Found a program to update it and that problem went away too.
  • This was my big project of the month. The user’s forum had been guest hosted on a nonprofit’s website for many years, on a host running Windows and the IIS web server. Performance was very slow. The user had a huge amount of images attached to his posts. The images folder exceeded 30GB! He wanted to get off the nonprofit site and onto a site running Linux for the faster performance. The new host was on Network Solutions where he had a contract that allowed unlimited shared hosting. With help from his tech support guy on the non-profit’s site, the client moved files and an extract of database to new Network Solutions hosting. The files containing an extract of the database did not import in phpMyAdmin and would not finish with even when I tried with bigdump.php, a staggered importer I often use on share hosting. I was able to load it into my local database after I downloaded it. I first snipped out SQL to populate the search tables and the log tables since those weren’t needed and consisted of most of the 500MB database extract. I created these tables from a reference and left them unpopulated. I then exported my local database using phpMyAdmin doing one SQL statement for every row, so bigdump.php could import it. I was then able to import the data into the client’s database. However, many primary keys and indexes were missing that I had to add by comparing his tables to my reference 3.1.9 database. I also had to add auto_increment to many primary keys. As we slowly stood up the rehosted forum, HTTP 504 Gateway timeout errors occurred while recreating the search index. These were likely due to going over some nebulous quota with the database server because he was populating tables. A call to technical support temporarily solved the problem. But eventually these 504 gateway timeouts took over stopping all traffic. I did finally notice that the server was running PHP 7. I downgraded PHP from 7 to 5.3, since phpBB 3.1 does not support PHP 7. Gateway timeouts continued irregularly. Discovered that images over 131K could not be uploaded with a post, even after changing PHP settings to allow it. The problem was his Apache web server limited uploads to about 131K. Then it was discovered that certain images (PNG images it looks like) were corrupt. So I downloaded all 30GB of these images again and then uploaded them to his host and this time the PNG images arrived uncorrupted. However, we could not fix the file upload issue because only Network Solutions could do this, and since he is using shared hosting they had to change it for everyone. There was lots of back and forth with technical support on this issue and they said it couldn’t be done. This was very strange because few people will use shared hosting with this limitation. The client eventually called the CEO of web.com (which now owns Network Solution) to complain. They eventually fixed something and the problem went away. This was a very frustrating week long endeavor that frustrated the users of the forum, but was eventually resolved with lots of persistence and complaints to Network Solutions. When things were finally settled down I went to the next step. I upgraded forum from 3.0.12 to 3.1.9. More gateway timeouts on upgrade meant yet another call to technical support. Eventually I got the upgrade script to succeed by ignoring timeouts. I had to remove one index from search table to finish the upgrade. I tweaked the prosilver style to give it white background. I centered logo image and moved the search box down. I installed the Board Announcement and Share On extensions. Customer placed ads on a template. Tweaked Board Announcements to show only on the index. The customer finally was fully rehosted, fully upgraded and things finally seemed to be working well.
  • Upgraded a forum on GoDaddy hosting from 3.0.11 to 3.1.9. Backing up database was tough due to hosting timeouts. I finally succeeded by making 4 partial backups. Installed the premium Metro style, only black and white was enabled. An error occurred during upgrade because an index already existed on the search table. I dropped it and upgrade completed.
  • Installed phpBB 3.1.9 (new install) after user had issues doing it himself. Issue getting into one.com control panel made things needlessly time consuming. I did a little basic tutoring on setting up forums, groups and group forum privileges with the client via a screen sharing session online. I helped configure his forum, added forums, and added a spambot countermeasure. He’s trying to integrate this into a WordPress site. It’s likely I’ll help him with that in August.

Leave a Reply

Your email address will not be published. Required fields are marked *