As you may have noticed the last few days, we just recovered from a serious website error, basically caused by the failure of the Drupal 6.17 upgrade. A lot of the database upgrade queries failed, and the menu was basically gone. Such is the difficulty of changing the production site straightaway.
BB CARES and Inter-Company Games Day is coming up!
BB CARES (Community Activities Rallying Everyone to Serve) is a day of befriending those who are less fortunate, allowing us to see another side of our society. As we serve, we find that it's rewarding as we pick up leadership skills along the way too! For more info, you can look up the BB website. This would likely be held on Sunday, 25 July, together with Admiralty Constituency's Project Love.
Exasperated by recent difficulties on the website, I decided to try an external blogging client.
As you may have been aware, the website logs you out almost the very instant you log in. I've been sitting on the issue for several months, because of work commitments (hey, it's tough being a department head during daylight hours and a website admin after hours at same time!)
To my horror, realised that ALL the videos did not work! Apparently when we upgraded Drupal and other modules such as FLVMediaplayer at the same time, we had to deactivate all the modules and at that time, it caused all the links to be wiped out! So it was a painfully manual time of adding in back all the links, although thankfully the upgraded version allows easier override of default settings (to put in the hyperlinks).
Finally realised the ugly error messages on logging in and the inability to create a new account were caused by upgrading the phpBB-Drupal module to 3.0.6 WITHOUT upgrading the Forum to 3.0.6!
Tried to upgrade the Forum by patching, then by automated update, and both failed. Tried to reverse and reinstall without success. Finally decided to remove and reinstall the whole 3.0.6 and then the phpBBForum module (remembered to keep the config.php safely before doing this).
The core files were upgraded to version 6.15. At the same time, CCK, Views, Nodewords, phpBBForum Integration, Sitemap were upgraded to the current versions.
Also fixed the cron.php problem, which was suspected to do partly with the Aggregator module (which has been disabled) clashing with the Mediawikiauth bridge.
Previously, a spambot was able to bypass the user registration controls on phpBBforum by going directly to the Drupal registration page at /user/register. This page can be deactivated via the Administration pages, but also affects the phpBBforum module.
What was needed was a way to redirect spambots that tried to go to /user/register. This was done using the mod_rewrite in .htaccess. Just add the following lines to the .htaccess file in the main drupal directory.