Upgrading to 3.2 fails when using MSSQL

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
gsmaclean
Registered User
Posts: 67
Joined: Sun Nov 06, 2005 12:13 am

Upgrading to 3.2 fails when using MSSQL

Post by gsmaclean » Sun Sep 17, 2017 7:06 pm

Why does it seem like I'm the only person running PHPBB under MSSQL? Every new release it seems the MSSQL database library is released with blatant bugs in it which prevent the system from running. Obviously nobody tested the 3.1 -> 3.2 upgrade under MSSQL, because it would fail.

This is to help anyone else who may be experiencing the same frustration I went through trying to upgrade the system from 3.1 to 3.2 when running MSSQL.

It will fail. To fix it, open the /phpbb/db/tools/mssql.php file in a text editor.

On line 524, you will find:

Code: Select all

if ($this->is_sql_server_2000())
Change it to:

Code: Select all

if ($this->mssql_is_sql_server_2000())
Do the exact same thing on line 544.

This will fix the bug and allow the upgrade to complete.

It's unbelievable to me that blatant bugs such as this one, which completely prevent the system from upgrading (or running, as in previous bugs in the MSSQL library that I have found, fixed and posted), are sent out without any testing, to unsuspecting users who, unlike myself, may not be able to code in PHP and can find and fix these problems.

User avatar
david63
Jr. Extension Validator
Posts: 12844
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Upgrading to 3.2 fails when using MSSQL

Post by david63 » Sun Sep 17, 2017 9:18 pm

If you believe that you have found a bug then in order for it to get "fixed" you should post it in the bug tracker.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email or as they will be ignored

User avatar
gsmaclean
Registered User
Posts: 67
Joined: Sun Nov 06, 2005 12:13 am

Re: Upgrading to 3.2 fails when using MSSQL

Post by gsmaclean » Sun Sep 17, 2017 9:38 pm

david63 wrote:
Sun Sep 17, 2017 9:18 pm
If you believe that you have found a bug then in order for it to get "fixed" you should post it in the bug tracker.
I have done so. But until the next release, people who are attempting to upgrade today on MSSQL need to have something they can find that will solve this problem.

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7011
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Upgrading to 3.2 fails when using MSSQL

Post by JimA » Mon Sep 18, 2017 6:43 am

Thanks for your report. We've now implemented your fix which will be used in the next release.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

AutoJunkie79
Registered User
Posts: 2
Joined: Mon Jan 30, 2017 6:43 pm

Re: Upgrading to 3.2 fails when using MSSQL

Post by AutoJunkie79 » Fri Sep 22, 2017 6:44 pm

Wow thanks so much for sharing this gsmaclean!

I just spent hours searching and reading on the infamous "Installer detected a timeout" issue. My board was coming up fine after the 3.2.1 upgrade from 3.2.0 but I couldn't get the DB to upgrade. It wasn't the commonly referred to timeout setting because I got the error message just seconds after clicking "upgrade".

You are not the only one out there. ;) I'm running on Windows 2016 Std w/ MSSQL 2016 Express; PHP 7.1.9 and phpBB 3.2.1. It has definitely been a learning curve and you are right the support is thin.

I agree, the QA process is a bit lacking, especially for the Windows folks. Thanks for being my hero today!

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: david63, invenio, panhead, treemon and 19 guests