Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

  • #2
    It is because the system is trying to run queries too fast for MySQL. I am looking for a solution.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


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

      Code:
      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.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        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

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

        Comment


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

          On line 590, you should see this code:
          Code:
              $buffered = false;
          Change it to:
          Code:
              $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 10th Apr '19, 2:15pm.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            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

            Comment


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

              Comment


              • #8
                What happens if you replace your 5.5.1 files with 5.5.0 files?
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API - Full / Mobile
                Vote for your favorite feature requests and the bugs you want to see fixed.

                Comment


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

                  Comment


                  • #10
                    I replaced the files. Restarted IIS. Still same issue.

                    Comment


                    • #11
                      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.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API - Full / Mobile
                      Vote for your favorite feature requests and the bugs you want to see fixed.

                      Comment


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

                        Comment

                        Related Topics

                        Collapse

                        Working...
                        X