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

[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:
IIS 10 on Win Server 2019
PHP 7.3.4
MySQL 8.0.15
vBulletin 5.5.1

My vBulletin install is a completely clean copy (deleted old files, uploaded new files, edited config files with db connection info, everything else is as shipped in the vBulletin download). No hacks, no addons, no template edits.

This is what I get when I try to access certain threads (others work fine):

Database error in vBulletin 5.5.1:

Invalid SQL:
UPDATE session SET `lastactivity`=1554903985,`styleid`=2,`languageid`=1
WHERE (`sessionhash` = 'b52e7cdf9ca810993208bb289b1c3355')
/**session**/;

MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 01:46:25 PM
Error Date : Wednesday, April 10th 2019 @ 01:46:26 PM

I've also gotten this error when I access the initial forum page. Note that whenever this db problem happens, in the vBulletin browser window I just get a blank page, no error message. The DB error message gets emailed to my account.

Database error in vBulletin 5.5.1:

Invalid SQL:
INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
VALUES('ff13bcfdadf8fcbc4a3f0f587082f02f',0,'128.173.39.5','aeaa50617a6dc35ab376d2678f7de2 d2',1554905236,'',2,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36',0,0,0,'',0)
/**session**/;

MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 02:07:16 PM
Error Date : Wednesday, April 10th 2019 @ 02:07:17 PM
Script : https://vtsl.vetmed.vt.edu/forums/
Referrer :
IP Address : 128.173.39.5
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in [path]\vb\database.php on line 1203
#1 vB_Database->halt() called in [path]\vb\database\mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]\vb\database.php on line 557
#3 vB_Database->query_write() called in [path]\vb\db\query\insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->doInserts() called in [path]\vb\db\query\insert.php on line 98
#5 vB_dB_Query_Insert->execSQL() called in [path]\vb\db\assertor.php on line 301
#6 vB_dB_Assertor->assertQuery() called in [path]\vb\db\assertor.php on line 473
#7 vB_dB_Assertor->insertIgnore() called in [path]\vb\session.php on line 593

[Wayne Luke]

It is because the system is trying to run queries too fast for MySQL. I am looking for a solution.

[Wayne Luke]

Can you try adding the following line to the end of your /core/includes/config.php file?

vB_Shutdown::instance()->setCalled();

Can you post a copy of your PHP Info output? You can send it to me as a Private Message if desired. In your AdminCP go to Maintenance -> View PHP Info. Select the output, copy it, paste it into a post.

[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 Repair the session table. I attempted. It Checked "OK", but repair was not supported on the table storage engine of that table (InnoDb), so I could not do that. I let me know via the Support ticket.

Here's the PHP Info output:

PHP Version 7.3.4

System	Windows NT VI3-2019 10.0 build 17763 (Windows Server 2016) AMD64
Build Date	Apr 2 2019 21:50:57
Compiler	MSVC15 (Visual C++ 2017)
Architecture	x64
Configure Command	cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--with-pdo-oci=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--without-analyzer" "--with-pgo"
Server API	CGI/FastCGI
Virtual Directory Support	disabled
Configuration File (php.ini) Path	C:\Windows
Loaded Configuration File	C:\PHP\php.ini
Scan this dir for additional .ini files	(none)
Additional .ini files parsed	(none)
PHP API	20180731
PHP Extension	20180731
Zend Extension	320180731
Zend Extension Build	API320180731,NTS,VC15
PHP Extension Build	API20180731,NTS,VC15
Debug Build	no
Thread Safety	disabled
Zend Signal Handling	disabled
Zend Memory Manager	enabled
Zend Multibyte Support	disabled
IPv6 Support	enabled
DTrace Support	disabled
Registered PHP Streams	php, file, glob, data, http, ftp, zip, compress.zlib, phar
Registered Stream Socket Transports	tcp, udp
Registered Stream Filters	convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*

This program makes use of the Zend Scripting Language Engine: Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies

---

Configuration

bcmath

BCMath support

enabled

bcmath.scale	0	0

calendar

Calendar support

enabled

cgi-fcgi

cgi.check_shebang_line	1	1
cgi.discard_path	0	0
cgi.fix_pathinfo	1	1
cgi.force_redirect	1	1
cgi.nph	0	0
cgi.redirect_status_env	no value	no value
cgi.rfc2616_headers	0	0
fastcgi.impersonate	1	1
fastcgi.logging	0	0

Core

PHP Version

7.3.4

allow_url_fopen	Off	Off
allow_url_include	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	UTF-8	UTF-8
default_mimetype	text/html	text/html
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
enable_post_data_reading	On	On
error_append_string	no value	no value
error_log	c:/PHP/php_errors.log	c:/PHP/php_errors.log
error_prepend_string	no value	no value
error_reporting	32759	22527
expose_php	Off	Off
extension_dir	C:\php\ext	C:\php\ext
file_uploads	On	On
hard_timeout	2	2
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.;C:\php\pear	.;C:\php\pear
input_encoding	no value	no value
internal_encoding	no value	no value
log_errors	On	On
log_errors_max_len	1024	1024
mail.add_x_header	Off	Off
mail.force_extra_parameters	no value	no value
mail.log	no value	no value
max_execution_time	30	30
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
memory_limit	16M	16M
open_basedir	d:\VTSL\forums	d:\VTSL\forums
output_buffering	4096	4096
output_encoding	no value	no value
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	4096K	4096K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
report_memleaks	On	On
report_zend_debug	On	On
request_order	GP	GP
sendmail_from	no value	no value
sendmail_path	no value	no value
serialize_precision	-1	-1
short_open_tag	Off	Off
SMTP	localhost	localhost
smtp_port	25	25
sys_temp_dir	no value	no value
syslog.facility	LOG_USER	LOG_USER
syslog.filter	no-ctrl	no-ctrl
syslog.ident	php	php
track_errors	Off	Off
unserialize_callback_func	spl_autoload_call	no value
upload_max_filesize	2M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
windows.show_crt_warning	Off	Off
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
zend.assertions	-1	-1
zend.detect_unicode	On	On
zend.enable_gc	On	On
zend.multibyte	Off	Off
zend.script_encoding	no value	no value

ctype

ctype functions

enabled

date

date/time support	enabled
timelib version	2018.01RC3
"Olson" Timezone Database Version	2018.9
Timezone Database	internal
Default timezone	UTC

date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	no value	no value

dom

DOM/XML	enabled
DOM/XML API Version	20031129
libxml Version	2.9.9
HTML Support	enabled
XPath Support	enabled
XPointer Support	enabled
Schema Support	enabled
RelaxNG Support	enabled

filter

Input Validation and Filtering

enabled

filter.default	unsafe_raw	unsafe_raw
filter.default_flags	no value	no value

hash

hash support

enabled

Hashing Engines

md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

MHASH support	Enabled
MHASH API Version	Emulated Support

iconv

iconv support	enabled
iconv implementation	"libiconv"
iconv library version	1.15

iconv.input_encoding	no value	no value
iconv.internal_encoding	no value	no value
iconv.output_encoding	no value	no value

json

json support	enabled
json version	1.7.0

libxml

libXML support	active
libXML Compiled Version	2.9.9
libXML Loaded Version	20909
libXML streams	enabled

mysqli

Client API library version	mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Active Persistent Links	0
Inactive Persistent Links	0
Active Links	1

mysqli.allow_local_infile	Off	Off
mysqli.allow_persistent	On	On
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	no value	no value
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
mysqli.rollback_on_cached_plink	Off	Off

mysqlnd

Version	mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Compression	supported
core SSL	supported
extended SSL	not supported
Command buffer size	4096
Read buffer size	32768
Read timeout	86400
Collecting statistics	Yes
Collecting memory statistics	No
Tracing	n/a
Loaded plugins	mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
API Extensions	mysqli

bytes_sent	21454
bytes_received	3114611
packets_sent	334
packets_received	4225
protocol_overhead_in	16900
protocol_overhead_out	1336
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	1314
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	1004
bytes_received_prepare_response_packet	120852
bytes_received_change_user_packet	2990267
packets_sent_command	161
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	146
packets_received_rset_field_meta	0
packets_received_rset_row	156
packets_received_prepare_response	1818
packets_received_change_user	2093
result_set_queries	146
non_result_set_queries	10
no_index_used	7
bad_index_used	0
slow_queries	0
buffered_sets	143
unbuffered_sets	3
ps_buffered_sets	0
ps_unbuffered_sets	0
flushed_normal_sets	3
flushed_ps_sets	0
ps_prepared_never_executed	0
ps_prepared_once_executed	0
rows_fetched_from_server_normal	1947
rows_fetched_from_server_ps	0
rows_buffered_from_client_normal	1944
rows_buffered_from_client_ps	0
rows_fetched_from_client_normal_buffered	1944
rows_fetched_from_client_normal_unbuffered	3
rows_fetched_from_client_ps_buffered	0
rows_fetched_from_client_ps_unbuffered	0
rows_fetched_from_client_ps_cursor	0
rows_affected_normal	3
rows_affected_ps	0
rows_skipped_normal	1944
rows_skipped_ps	0
copy_on_write_saved	0
copy_on_write_performed	0
command_buffer_too_small	0
connect_success	3
connect_failure	0
connection_reused	0
reconnect	0
pconnect_success	3
active_connections	18446744073709551615
active_persistent_connections	18446744073709551615
explicit_close	2
implicit_close	0
disconnect_close	0
in_middle_of_command_close	0
explicit_free_result	146
implicit_free_result	0
explicit_stmt_close	0
implicit_stmt_close	0
mem_emalloc_count	0
mem_emalloc_amount	0
mem_ecalloc_count	0
mem_ecalloc_amount	0
mem_erealloc_count	0
mem_erealloc_amount	0
mem_efree_count	0
mem_efree_amount	0
mem_malloc_count	0
mem_malloc_amount	0
mem_calloc_count	0
mem_calloc_amount	0
mem_realloc_count	0
mem_realloc_amount	0
mem_free_count	0
mem_free_amount	0
mem_estrndup_count	0
mem_strndup_count	0
mem_estrdup_count	0
mem_strdup_count	0
mem_edupl_count	0
mem_dupl_count	0
proto_text_fetched_null	0
proto_text_fetched_bit	0
proto_text_fetched_tinyint	33
proto_text_fetched_short	413
proto_text_fetched_int24	0
proto_text_fetched_int	962
proto_text_fetched_bigint	1447
proto_text_fetched_decimal	3
proto_text_fetched_float	0
proto_text_fetched_double	0
proto_text_fetched_date	18
proto_text_fetched_year	0
proto_text_fetched_time	0
proto_text_fetched_datetime	183
proto_text_fetched_timestamp	218
proto_text_fetched_string	6660
proto_text_fetched_blob	0
proto_text_fetched_enum	236
proto_text_fetched_set	0
proto_text_fetched_geometry	0
proto_text_fetched_other	0
proto_binary_fetched_null	0
proto_binary_fetched_bit	0
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	0
proto_binary_fetched_int24	0
proto_binary_fetched_int	0
proto_binary_fetched_bigint	0
proto_binary_fetched_decimal	0
proto_binary_fetched_float	0
proto_binary_fetched_double	0
proto_binary_fetched_date	0
proto_binary_fetched_year	0
proto_binary_fetched_time	0
proto_binary_fetched_datetime	0
proto_binary_fetched_timestamp	0
proto_binary_fetched_string	0
proto_binary_fetched_json	0
proto_binary_fetched_blob	0
proto_binary_fetched_enum	0
proto_binary_fetched_set	0
proto_binary_fetched_geometry	0
proto_binary_fetched_other	0
init_command_executed_count	0
init_command_failed_count	0
com_quit	2
com_init_db	3
com_query	156
com_field_list	0
com_create_db	0
com_drop_db	0
com_refresh	0
com_shutdown	0
com_statistics	0
com_process_info	0
com_connect	0
com_process_kill	0
com_debug	0
com_ping	0
com_time	0
com_delayed_insert	0
com_change_user	0
com_binlog_dump	0
com_table_dump	0
com_connect_out	0
com_register_slave	0
com_stmt_prepare	0
com_stmt_execute	0
com_stmt_send_long_data	0
com_stmt_close	0
com_stmt_reset	0
com_stmt_set_option	0
com_stmt_fetch	0
com_deamon	0
bytes_received_real_data_normal	2970852
bytes_received_real_data_ps	0

pcre

PCRE (Perl Compatible Regular Expressions) Support	enabled
PCRE Library Version	10.32 2018-09-10
PCRE Unicode Version	11.0.0
PCRE JIT Support	enabled
PCRE JIT Target	x86 64bit (little endian + unaligned)

pcre.backtrack_limit	-1	1000000
pcre.jit	1	1
pcre.recursion_limit	100000	100000

PDO

PDO drivers	no value

Phar

Phar API version	1.1.1
Phar-based phar archives	enabled
Tar-based phar archives	enabled
ZIP-based phar archives	enabled
gzip compression	enabled
bzip2 compression	disabled (install ext/bz2)
OpenSSL support	disabled (install ext/openssl)

Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

phar.cache_list	no value	no value
phar.readonly	On	On
phar.require_hash	On	On

readline

Readline library	WinEditLine

cli.pager	no value	no value
cli.prompt	\b \>	\b \>

Reflection

Reflection

enabled

session

Session Support	enabled
Registered save handlers	files user
Registered serializer handlers	php_serialize php php_binary wddx

session.auto_start	Off	Off
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_httponly	no value	no value
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_samesite	no value	no value
session.cookie_secure	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.lazy_write	On	On
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	files	files
session.save_path	no value	no value
session.serialize_handler	php	php
session.sid_bits_per_character	5	5
session.sid_length	26	26
session.upload_progress.cleanup	On	On
session.upload_progress.enabled	On	On
session.upload_progress.freq	1%	1%
session.upload_progress.min_freq	1	1
session.upload_progress.name	PHP_SESSION_UPLOAD_PROGRESS	PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix	upload_progress_	upload_progress_
session.use_cookies	1	1
session.use_only_cookies	1	1
session.use_strict_mode	0	0
session.use_trans_sid	0	0

SimpleXML

SimpleXML support	enabled
Schema support	enabled

SPL

Interfaces	OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support	enabled
Internal Sendmail Support for Windows	enabled

assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.exception	0	0
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
from	no value	no value
session.trans_sid_hosts	no value	no value
session.trans_sid_tags	a=href,area=href,frame=src,form=	a=href,area=href,frame=src,form=
url_rewriter.hosts	no value	no value
url_rewriter.tags	form=	form=
user_agent	no value	no value

tokenizer

Tokenizer Support

enabled

wddx

WDDX Session Serializer	enabled

xml

XML Support	active
XML Namespace Support	active
libxml2 Version	2.9.9

xmlreader

XMLReader

enabled

xmlwriter

XMLWriter

enabled

zip

Zip	enabled
Zip version	1.15.4
Libzip version	1.4.0

zlib

Stream Wrapper	compress.zlib://
Stream Filter	zlib.inflate, zlib.deflate
Compiled Version	1.2.11
Linked Version	1.2.11

zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value

Additional Modules

Environment

_FCGI_X_PIPE_	\\.\pipe\IISFCGI-bf76c06e-54ed-4ff6-86a7-6aa3e77b58fe
ALLUSERSPROFILE	C:\ProgramData
APPDATA	C:\Windows\system32\config\systemprofile\AppData\Roaming
APP_POOL_CONFIG	C:\inetpub\temp\apppools\vtsl\vtsl.config
APP_POOL_ID	vtsl
CommonProgramFiles	C:\Program Files\Common Files
CommonProgramFiles(x86)	C:\Program Files (x86)\Common Files
CommonProgramW6432	C:\Program Files\Common Files
COMPUTERNAME	VI3-2019
ComSpec	C:\Windows\system32\cmd.exe
DriverData	C:\Windows\System32\Drivers\DriverData
GIT_LFS_PATH	C:\Program Files\Git LFS
LOCALAPPDATA	C:\Windows\system32\config\systemprofile\AppData\Local
NUMBER_OF_PROCESSORS	2
OS	Windows_NT
Path	C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerSh ell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Git\cmd;C:\Program Files\Git LFS;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps
PATHEXT	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE	AMD64
PROCESSOR_IDENTIFIER	AMD64 Family 23 Model 1 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL	23
PROCESSOR_REVISION	0102
ProgramData	C:\ProgramData
ProgramFiles	C:\Program Files
ProgramFiles(x86)	C:\Program Files (x86)
ProgramW6432	C:\Program Files
PSModulePath	C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
PUBLIC	C:\Users\Public
SystemDrive	C:
SystemRoot	C:\Windows
TEMP	C:\Windows\TEMP
TMP	C:\Windows\TEMP
USERDOMAIN	VMIL
USERNAME	VI3-2019$
USERPROFILE	C:\Windows\system32\config\systemprofile
windir	C:\Windows

PHP Variables

$_SERVER['_FCGI_X_PIPE_']	\\.\pipe\IISFCGI-bf76c06e-54ed-4ff6-86a7-6aa3e77b58fe
$_SERVER['ALLUSERSPROFILE']	C:\ProgramData
$_SERVER['APPDATA']	C:\Windows\system32\config\systemprofile\AppData\Roaming
$_SERVER['APP_POOL_CONFIG']	C:\inetpub\temp\apppools\vtsl\vtsl.config
$_SERVER['APP_POOL_ID']	vtsl
$_SERVER['CommonProgramFiles']	C:\Program Files\Common Files
$_SERVER['CommonProgramFiles(x86)']	C:\Program Files (x86)\Common Files
$_SERVER['CommonProgramW6432']	C:\Program Files\Common Files
$_SERVER['COMPUTERNAME']	VI3-2019
$_SERVER['ComSpec']	C:\Windows\system32\cmd.exe
$_SERVER['DriverData']	C:\Windows\System32\Drivers\DriverData
$_SERVER['GIT_LFS_PATH']	C:\Program Files\Git LFS
$_SERVER['LOCALAPPDATA']	C:\Windows\system32\config\systemprofile\AppData\Local
$_SERVER['NUMBER_OF_PROCESSORS']	2
$_SERVER['OS']	Windows_NT
$_SERVER['Path']	C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerSh ell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\Git\cmd;C:\Program Files\Git LFS;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps
$_SERVER['PATHEXT']	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
$_SERVER['PROCESSOR_ARCHITECTURE']	AMD64
$_SERVER['PROCESSOR_IDENTIFIER']	AMD64 Family 23 Model 1 Stepping 2, AuthenticAMD
$_SERVER['PROCESSOR_LEVEL']	23
$_SERVER['PROCESSOR_REVISION']	0102
$_SERVER['ProgramData']	C:\ProgramData
$_SERVER['ProgramFiles']	C:\Program Files
$_SERVER['ProgramFiles(x86)']	C:\Program Files (x86)
$_SERVER['ProgramW6432']	C:\Program Files
$_SERVER['PSModulePath']	C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
$_SERVER['PUBLIC']	C:\Users\Public
$_SERVER['SystemDrive']	C:
$_SERVER['SystemRoot']	C:\Windows
$_SERVER['TEMP']	C:\Windows\TEMP
$_SERVER['TMP']	C:\Windows\TEMP
$_SERVER['USERDOMAIN']	VMIL
$_SERVER['USERNAME']	VI3-2019$
$_SERVER['USERPROFILE']	C:\Windows\system32\config\systemprofile
$_SERVER['windir']	C:\Windows
$_SERVER['ORIG_PATH_INFO']	/forums/index.php
$_SERVER['URL']	/forums/index.php
$_SERVER['SERVER_SOFTWARE']	Microsoft-IIS/10.0
$_SERVER['SERVER_PROTOCOL']	HTTP/1.1
$_SERVER['SERVER_PORT_SECURE']	1
$_SERVER['SERVER_PORT']	443
$_SERVER['SERVER_NAME']	vtsl.vetmed.vt.edu
$_SERVER['SCRIPT_NAME']	/forums/index.php
$_SERVER['SCRIPT_FILENAME']	D:\vtsl\forums\index.php
$_SERVER['REQUEST_URI']	/forums/admincp/index.php?do=phpinfo&
$_SERVER['REQUEST_METHOD']	GET
$_SERVER['REMOTE_USER']	no value
$_SERVER['REMOTE_PORT']	54168
$_SERVER['REMOTE_HOST']	128.173.39.5
$_SERVER['REMOTE_ADDR']	128.173.39.5
$_SERVER['QUERY_STRING']	do=phpinfo
$_SERVER['PATH_TRANSLATED']	D:\vtsl\forums\index.php
$_SERVER['LOGON_USER']	no value
$_SERVER['LOCAL_ADDR']	128.173.242.100
$_SERVER['INSTANCE_META_PATH']	/LM/W3SVC/2
$_SERVER['INSTANCE_NAME']	VTSL
$_SERVER['INSTANCE_ID']	2
$_SERVER['HTTPS_SERVER_SUBJECT']	C=US, PostalCode=24061, S=Virginia, L=Blacksburg, STREET=800 Washington St. SW, O=Virginia Polytechnic Institute and State University, OU=Secure Identity Services, CN=vtsl.vetmed.vt.edu
$_SERVER['HTTPS_SERVER_ISSUER']	C=US, S=MI, L=Ann Arbor, O=Internet2, OU=InCommon, CN=InCommon RSA Server CA
$_SERVER['HTTPS_SECRETKEYSIZE']	4096
$_SERVER['HTTPS_KEYSIZE']	256
$_SERVER['HTTPS']	on
$_SERVER['GATEWAY_INTERFACE']	CGI/1.1
$_SERVER['DOCUMENT_ROOT']	D:\vtsl
$_SERVER['CONTENT_TYPE']	no value
$_SERVER['CONTENT_LENGTH']	0
$_SERVER['CERT_SUBJECT']	no value
$_SERVER['CERT_SERIALNUMBER']	no value
$_SERVER['CERT_ISSUER']	no value
$_SERVER['CERT_FLAGS']	no value
$_SERVER['CERT_COOKIE']	no value
$_SERVER['AUTH_USER']	no value
$_SERVER['AUTH_PASSWORD']	no value
$_SERVER['AUTH_TYPE']	no value
$_SERVER['APPL_PHYSICAL_PATH']	D:\vtsl\
$_SERVER['APPL_MD_PATH']	/LM/W3SVC/2/ROOT
$_SERVER['IIS_UrlRewriteModule']	7,1,1993,2351
$_SERVER['UNENCODED_URL']	/forums/admincp/index.php?do=phpinfo&
$_SERVER['IIS_WasUrlRewritten']	1
$_SERVER['HTTP_X_ORIGINAL_URL']	/forums/admincp/index.php?do=phpinfo&
$_SERVER['HTTP_UPGRADE_INSECURE_REQUESTS']	1
$_SERVER['HTTP_USER_AGENT']	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36
$_SERVER['HTTP_REFERER']	https://vtsl.vetmed.vt.edu/forums/admincp/index.php?do=nav
$_SERVER['HTTP_HOST']	vtsl.vetmed.vt.edu
$_SERVER['HTTP_COOKIE']	_ga=GA1.2.1473110162.1552169599; _fbp=fb.1.1552172232109.1531608944; __utmz=20747903.1552172235.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utma=20747903.1473110162.1552169599.1553294882.1553350762.5; __unam=76ba173-169aaefbb92-42354848-2; CFCLIENT_VTSL=""; bbnp_notices_displayed=; bbdiscussion_view=%7B.179.-1554903982%2C.180.-1554903933%2C.182.-1554903247%2C.193.-1554903950%2C.628.-1554903954%2C.633.-1554903701%2C.3281.-1554903978%2C.3286.-1554903962%2C.3290.-1554903974%2C.3292.-1554903970%2C.3306.-1554903966%2C.3333.-1554903946%2C.3343.-1554903942%2C.3347.-1554903321%2C.3353.-1554903937%2C.3357.-1554903925%2C.3365.-1554903929%2C.3373.-1554903575%7D; bblastvisit=1554916403; bblastactivity=1554926758; CFID=93684; CFTOKEN=dcaac334df505b55-58B2275A-AF05-03ED-DB5C06C9457EB775; CFGLOBALS=urltoken%3DCFID%23%3D93684%26CFTOKEN%23%3Ddcaac334df505b55%2D58B2275A%2DAF05%2D0 3ED%2DDB5C06C9457EB775%23lastvisit%3D%7Bts%20%272019%2D04%2D10%2016%3A09%3A28%27%7D%23hitc ount%3D1070%23timecreated%3D%7Bts%20%272019%2D03%2D28%2020%3A34%3A19%27%7D%23cftoken%3Ddca ac334df505b55%2D58B2275A%2DAF05%2D03ED%2DDB5C06C9457EB775%23cfid%3D93684%23; bbcpsession=d5f5aab8cecccdbedbc871e632634a96; bbsessionhash=9f472ecd5ed9b8f9f3dfd106dcd5af0e
$_SERVER['HTTP_ACCEPT_LANGUAGE']	en-US,en;q=0.9
$_SERVER['HTTP_ACCEPT_ENCODING']	gzip, deflate, br
$_SERVER['HTTP_ACCEPT']	text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3
$_SERVER['HTTP_CONTENT_LENGTH']	0
$_SERVER['HTTP_CONNECTION']	close
$_SERVER['HTTP_CACHE_CONTROL']	max-age=0
$_SERVER['FCGI_ROLE']	RESPONDER
$_SERVER['PHP_SELF']	/forums/index.php
$_SERVER['REQUEST_TIME_FLOAT']	1554926996.6338
$_SERVER['REQUEST_TIME']	1554926996

---

PHP Credits

Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski

Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger

Zend Scripting Language Engine	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API	Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization	Stig Bakken, Sascha Schumann, Jani Taskinen
Windows Support	Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski, Kalle Sommer Nielsen
Server API (SAPI) Abstraction Layer	Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer	Wez Furlong, Sara Golemon
PHP Data Objects Layer	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler	Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
Consistent 64 bit support	Anthony Ferrara, Anatol Belski

Apache 2.0 Handler	Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
CGI / FastCGI	Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI	Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Embed	Edin Kadribasic
FastCGI Process Manager	Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
litespeed	George Wang
phpdbg	Felipe Pena, Joe Watkins, Bob Weinand

BC Math	Andi Gutmans
Bzip2	Sterling Hughes
Calendar	Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net	Wez Furlong
ctype	Hartmut Holzgraefe
cURL	Sterling Hughes
Date/Time Support	Derick Rethans
DB-LIB (MS SQL, Sybase)	Wez Furlong, Frank M. Kromann, Adam Baratz
DBA	Sascha Schumann, Marcus Boerger
DOM	Christian Stocker, Rob Richards, Marcus Boerger
enchant	Pierre-Alain Joye, Ilia Alshanetsky
EXIF	Rasmus Lerdorf, Marcus Boerger
fileinfo	Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans, Anatol Belski
Firebird driver for PDO	Ard Biesheuvel
FTP	Stefan Esser, Andrew Skalski
GD imaging	Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText	Alex Plotnick
GNU GMP support	Stanislav Malyshev
Iconv	Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP	Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter	Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
InterBase	Jouni Ahto, Andrew Avdeev, Ard Biesheuvel
Internationalization	Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON	Jakub Zelenka, Omar Kilani, Scott MacVicar
LDAP	Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML	Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
Multibyte String Functions	Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO	George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQLi	Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd	Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8	Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO	Wez Furlong
ODBC	Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
Opcache	Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Dmitry Stogov, Xinchen Hui
OpenSSL	Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO	Wez Furlong
pcntl	Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps	Andrei Zmievski
PHP Archive	Gregory Beaver, Marcus Boerger
PHP Data Objects	Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash	Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix	Kristian Koehntopp
PostgreSQL driver for PDO	Edin Kadribasic, Ilia Alshanetsky
PostgreSQL	Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell	Vlad Krupin
Readline	Thies C. Arntzen
Recode	Kristian Koehntopp
Reflection	Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions	Sascha Schumann, Andrei Zmievski
Shared Memory Operations	Slava Poliakov, Ilia Alshanetsky
SimpleXML	Sterling Hughes, Marcus Boerger, Rob Richards
SNMP	Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP	Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets	Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
Sodium	Frank Denis
SPL	Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO	Wez Furlong
SQLite3	Scott MacVicar, Ilia Alshanetsky, Brad Dewar
System V Message based IPC	Wez Furlong
System V Semaphores	Tom May
System V Shared Memory	Christian Cartus
tidy	John Coggeshall, Ilia Alshanetsky
tokenizer	Andrei Zmievski, Johannes Schlueter
WDDX	Andrei Zmievski
XML	Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader	Rob Richards
xmlrpc	Dan Libby
XMLWriter	Rob Richards, Pierre-Alain Joye
XSL	Christian Stocker, Rob Richards
Zip	Pierre-Alain Joye, Remi Collet
Zlib	Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner

Authors	Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Philip Olson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey
Editor	Peter Cowburn
User Note Maintainers	Daniel P. Brown, Thiago Henrique Pojda
Other Contributors	Previously active authors, editors and other contributors are listed in the manual.

Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs

PHP Websites Team	Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers	Damien Seguy, Daniel P. Brown
Network Infrastructure	Daniel P. Brown
Windows Infrastructure	Alex Schoenmaker

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact [email protected].

[Wayne Luke]

Please open core/packages/vbdbsearch/db/mysql/querydefs.php in a text editor.

On line 590, you should see this code:

    $buffered = false;

Change it to:

    $buffered = true;

This will revert a performance change but the search system should work how it did in 5.5.0.

You can remove the code that I asked you to put into your config.php file.

[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:

Invalid SQL:
INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
VALUES('305fa6641df5a46f764d500082b5fede',0,'128.173.39.5','aeaa50617a6dc35ab376d2678f7de2 d2',1554934957,'',2,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36',0,0,0,'',0)
/**session**/;

MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 10:22:37 PM
Error Date : Wednesday, April 10th 2019 @ 10:22:37 PM

Script : https://vtsl.vetmed.vt.edu/forums/
Referrer :
IP Address : 128.173.39.5
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in [path]\vb\database.php on line 1203
#1 vB_Database->halt() called in [path]\vb\database\mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]\vb\database.php on line 557
#3 vB_Database->query_write() called in [path]\vb\db\query\insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->doInserts() called in [path]\vb\db\query\insert.php on line 98
#5 vB_dB_Query_Insert->execSQL() called in [path]\vb\db\assertor.php on line 301
#6 vB_dB_Assertor->assertQuery() called in [path]\vb\db\assertor.php on line 473
#7 vB_dB_Assertor->insertIgnore() called in [path]\vb\session.php on line 593
#8 vB_Session->save() called in [path]\vb\shutdown.php on line 86
#9 vB_Shutdown->shutdown() called in [path]\vb\vb.php on line 483
#10 vB::shutdown() called in on line

[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:

Database error in vBulletin 5.5.1:

Invalid SQL:
UPDATE session SET `lastactivity`=1554935016,`styleid`=2,`languageid`=1
WHERE (`sessionhash` = '363f6ca172f63f255d5dc66d1f322b2a')
/**session**/;

MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 10:23:36 PM
Error Date : Wednesday, April 10th 2019 @ 10:23:37 PM
Script : https://vtsl.vetmed.vt.edu/forums/fo...xample-package
Referrer : https://vtsl.vetmed.vt.edu/forums/fo...ocuments/page2
IP Address : 128.173.39.5
Username : jmgreen
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in [path]\vb\database.php on line 1203
#1 vB_Database->halt() called in [path]\vb\database\mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]\vb\database.php on line 557
#3 vB_Database->query_write() called in [path]\vb\db\query\update.php on line 116
#4 vB_dB_Query_Update->doUpdates() called in [path]\vb\db\query\update.php on line 101
#5 vB_dB_Query_Update->execSQL() called in [path]\vb\db\assertor.php on line 301
#6 vB_dB_Assertor->assertQuery() called in [path]\vb\db\assertor.php on line 538
#7 vB_dB_Assertor->update() called in [path]\vb\session.php on line 612

[Wayne Luke]

What happens if you replace your 5.5.1 files with 5.5.0 files?

[jmgreen]

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

[jmgreen]

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

[Wayne Luke]

We're going to need a support ticket with access to the servers. This has to be due to server configuration and we need to figure out what is different and how to counteract it. Please mention this topic in the support ticket. The link is at the bottom of this page.

[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 the connection(s) will be made to allow it through. Access is currently restricted to university IP addresses.