No announcement yet.

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

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

    Leave a comment:

  • 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.

    Leave a comment:

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

    Leave a comment:

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

    Leave a comment:

  • Wayne Luke
    What happens if you replace your 5.5.1 files with 5.5.0 files?

    Leave a comment:

  • 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')

    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 :
    Referrer :
    IP Address :
    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

    Leave a comment:

  • 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,'','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)

    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 :
    Referrer :
    IP Address :
    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

    Leave a comment:

  • 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.
    Last edited by Wayne Luke; Wed 10 Apr '19, 2:15pm.

    Leave a comment:

  • 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 logo 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.*
    Zend logoThis program makes use of the Zend Scripting Language Engine:
    Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies



    BCMath support enabled
    bcmath.scale 0 0

    Calendar support enabled

    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

    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 functions enabled

    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/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

    Input Validation and Filtering enabled
    filter.default unsafe_raw unsafe_raw
    filter.default_flags no value no value

    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 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 support enabled
    json version 1.7.0

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

    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

    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 (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 drivers no value

    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 library WinEditLine
    cli.pager no value no value
    cli.prompt \b \> \b \>

    Reflection enabled

    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 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 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 support enabled
    Schema support enabled

    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

    Dynamic Library Support enabled
    Internal Sendmail Support for Windows enabled 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 Support enabled

    WDDX Session Serializer enabled

    XML Support active
    XML Namespace Support active
    libxml2 Version 2.9.9

    XMLReader enabled

    XMLWriter enabled

    Zip enabled
    Zip version 1.15.4
    Libzip version 1.4.0

    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


    _FCGI_X_PIPE_ \\.\pipe\IISFCGI-bf76c06e-54ed-4ff6-86a7-6aa3e77b58fe
    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
    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
    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
    PROCESSOR_IDENTIFIER AMD64 Family 23 Model 1 Stepping 2, AuthenticAMD
    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
    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['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['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['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['PROCESSOR_IDENTIFIER'] AMD64 Family 23 Model 1 Stepping 2, AuthenticAMD
    $_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['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['SCRIPT_NAME'] /forums/index.php
    $_SERVER['SCRIPT_FILENAME'] D:\vtsl\forums\index.php
    $_SERVER['REQUEST_URI'] /forums/admincp/index.php?do=phpinfo&
    $_SERVER['REMOTE_USER'] no value
    $_SERVER['REMOTE_PORT'] 54168
    $_SERVER['QUERY_STRING'] do=phpinfo
    $_SERVER['PATH_TRANSLATED'] D:\vtsl\forums\index.php
    $_SERVER['LOGON_USER'] no value
    $_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,
    $_SERVER['HTTPS_SERVER_ISSUER'] C=US, S=MI, L=Ann Arbor, O=Internet2, OU=InCommon, CN=InCommon RSA Server CA
    $_SERVER['HTTPS'] on
    $_SERVER['CONTENT_TYPE'] no value
    $_SERVER['CERT_SUBJECT'] 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['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_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_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_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_CACHE_CONTROL'] max-age=0
    $_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].

    Leave a comment:

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

    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.

    Leave a comment:

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

    Leave a comment:

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

    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')

    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,'','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)

    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 :
    Referrer :
    IP Address :
    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

Related Topics