phpBB 3.0.x with patches for Windows Web App Gallery

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

phpBB 3.0.x with patches for Windows Web App Gallery

Post by bibin »

3.0.10 Patch

Microsoft Open Tech provides these integrated pieces for those community members who need interoperability between PHPBB and Microsoft’s Platform.

Summary of fixes included in the package for the Windows Azure related issues

1. MSSQL Schema is not Windows Azure compatible
  • Comments: Updated the MSSQL schema to adjust SQL Server /SQL Azure functionality differences. Changes are made on \install\schemas\mssql_schema.sql file.
2. SERVER_PORT issue on Windows Azure
3. ACP statistics failing with SQL Azure
  • Comments: ACP statistics is calculating the database size with 'SELECT ((SUM(size) * 8.0) * 1024.0) as dbsize FROM sysfiles'. This will break the phpBB ACP statistics page in Windows Azure because sysfiles is not available in SQL Azure, but we can calculate the database size in SQL Azure using 'SELECT ((SUM(reserved_page_count) * 8.0) * 1024.0) as dbsize FROM sys.dm_db_partition_stats'.
4. Installation schema breaks with ClearDB in Windows Azure Websites
Summary of changes specific to Windows Web Application Gallery

1. Improved user experience with deletion of install directory by including a rminstall.php script that the user will run after completing the app install by clicking on a delete link.
2. Added the code to auto populate the database details in the installation wizard
  • Webmatrix publish and download from remote server will fail if the $dbport parameter is set since this cannot be updated by the web deploy when user publishes PHPBB to a remote server (or Azure )or downloads it from a remote server ( or Azure). To avoid that we had to make phpBB to auto populate the database fields in the phpBB installation wizard.
Attachments
phpBB-3.0.10-IIS.zip
sha-1 hash: d94fd41f69a9b9021674803c7dc67d3424a0d7bc
(2.39 MiB) Downloaded 2009 times
Last edited by bibin on Tue May 13, 2014 6:51 am, edited 1 time in total.

User avatar
naderman
Consultant
Posts: 1727
Joined: Sun Jan 11, 2004 2:11 am
Location: Berlin, Germany
Contact:

Re: phpBB 3.0.10 with patches for Windows Web App Gallery

Post by naderman »

An updated version of this package with patches applied for phpBB 3.0.11 is available at https://download.phpbb.com/pub/release/ ... pi.pl2.zip

bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by bibin »

Windows Web App Gallery package for phpBB 3.0.12
Attachments
phpBB-3.0.12.webpi.pl2.zip
sha-1 hash: 8d291c4dc14b59dadd9f2901e6710e815479917a
(2.39 MiB) Downloaded 2087 times
Last edited by bibin on Wed May 07, 2014 9:18 am, edited 2 times in total.

dangleemarcar
Registered User
Posts: 1
Joined: Wed Apr 02, 2014 3:55 pm

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by dangleemarcar »

Nice to hear that you are explaining the changes here. ;) Even though it is small but I appreciated the effort. :)

mrgtb
Registered User
Posts: 221
Joined: Wed Nov 28, 2007 10:09 pm

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by mrgtb »

What is this for exactly, I run a 3.0.12 board, is it a add-on or something, or to fix something. Also, has this been added to the download package of 3.0.12 on phpBB main forums if a fix, has the package been updated to include this?

bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by bibin »

This package is used by Microsoft Web Platform Installer, WebMatrix and Windows Azure app gallery. Using these tools users can easily install phpBB in windows platform.

http://www.microsoft.com/web/gallery/phpbb.aspx

bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by bibin »

Can anyone from the community upload the 3.0.12 package to the location https://download.phpbb.com/pub/release/3.0/webpi/

Package url is download/file.php?id=2669

bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

Updating phpBB version in Windows Web App Gallery

Post by bibin »

The current version of phpBB in Web App Gallery is 3.0.11 (http://www.microsoft.com/web/gallery/phpbb.aspx). I am trying to update the phpBB version to 3.0.12.

Can anyone from the community help me in uploading the 3.0.12 package available here download/file.php?id=2669 to the location https://download.phpbb.com/pub/release/3.0/webpi/

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by bantu »

Hey bibin,

I've taken the liberty to merge your new topic into the already existing topic about the Windows Web App Gallery.

I am sorry, but we are not just going to publish packages built by a third party. In order to achieve your goal I would appreciate if you would

a) ensure there is a ticket for each outstanding problem that the packages generated by us has in our tracker at https://tracker.phpbb.com.

b) submit patches, preferably in form a Github Pull Request, for each outstanding ticket

c) maintain a collection of tickets in this topic's first post (please note that all currently linked tickets seem to have been addressed)

... such that we can ensure the packages we build for 3.0.13 are fully compatibly with Windows Web App Gallery.

You may obtain development builds from https://bamboo.phpbb.com Build Artifacts, direct URL e.g. https://bamboo.phpbb.com/artifact/PHPBB ... .webpi.zip for testing.

Cheers,
bantu

bibin
Registered User
Posts: 8
Joined: Tue Jun 12, 2012 10:34 am

Re: phpBB 3.0.x with patches for Windows Web App Gallery

Post by bibin »

Hi bantu,

Thank you for looking into this.

We have already created tickets for all the issues related to web app gallery. Those details you can find in this topic's first post. We didn't face any new issues in 3.0.12 package while testing in the web app gallery.

Please let me know incase of any queries.

Thanks,
Bibin

Post Reply