MySQL Error : Commands out of sync after upgrade from 5.4 to 5.5.1

[jmgreen]

I've had a ticket open. Ticket ID#2297996. I posted reference to this thread there. Server access will be tricky, as our university requires strict access control, so I'll need ip address from which...

[jmgreen]

I replaced the files. Restarted IIS. Still same issue....

[jmgreen]

So just replace the files (other than config.php in core\includes)? No script to run?

[jmgreen]

A reload after the blank index page that caused the previously mentioned error got the page the load fine. Then I tried to view a thread in one of the forums and got another blank page and the following:...

[jmgreen]

I made the code change in querydefs.php and removed the code from config.php. Restarted IIS for good measure. Still having the problem:

Database error in vBulletin 5.5.1:

...

[jmgreen]

I added the code at the end of core/includes/config.php. Restarted IIS for good measure. No change in behavior.

Also as an FYI, via my support ticket, Trevor Hannant asked me to Check and...

[jmgreen]

After upgrading from 5.4 to 5.5.1 today, I am now getting MySQL Database errors. I've submitted a ticket and haven't gotten a response yet, so I thought I'd post here.

I'm running:
...

[jmgreen]

RESOLVED::: I have my forum working now, with latest version of both vBulletin and PHP 7.1.

For informational purposes, I did the following:

1. I rolled everything (database,...

[jmgreen]

And I doubled checked and that patch has already been applied. So that's not the issue either. heavy sigh.

[jmgreen]

Do you know if vBulletin uses REQUEST_URI server variable? I ask because there's evidently a Windows Server 2008 update that fixes an issue:

"Install this update to resolve an issue...

[jmgreen]

Nevermind.... had to also close my browser and reopen. Session issue I guess. I can log in ok. But I still get the same 500 error with the warning about the user.php file.

PHP Warning:...

[jmgreen]

I made those changes, and restarted the server (just in case). Now I can't get logged in to the forum at all with my administrator username and password. I get:

PHP Warning: session_start():...

[jmgreen]

Here's my config.php file from /core/includes/ (with MySQL connection information deleted for obvious reasons)

<?php
/*=========================================================================*\...

[jmgreen]

Sure...

[PHP]

;;;;;;;;;;;;;;;;;;;
; About php.ini ;
;;;;;;;;;;;;;;;;;;;
; PHP's initialization file, generally called php.ini, is responsible for
;...

[jmgreen]

Oh, and yes, PHP is handled as FastCGI...

[jmgreen]

IIS 7
PHP 7.1.17
MySQL 5.7.18
vBulletin 5.4.1

$config['SpecialUsers']['undeletableusers'] = '';

Do I need to have a user there? I can add mine if so....

[jmgreen]

So I just went into IIS and enabled detail error messages (rather than custom) on the 500 errors for that site. Now when I call the problematic url (http://vtsl.vetmed.vt.edu/forums/register) I get:...

[jmgreen]

I just did that, and still just get the generic 500 error. (image attached). And I know I got debug working because I checked another page that I know isn't working correctly (and hasn't been for a...

[jmgreen]

The register link on my login page (I use default template) gives a 500 error. I have no idea what to do to track down what's happening. I did recently do a minor update to 5.4.1, but everything else...

[jmgreen]

It's been almost a week since I posted (I also created a Support Ticket and have heard nothing there either). Anyone have any suggestions for me??