KZ Timer error SQL_HasResultSet

Discussion in 'KZTimer & Other Plugins' started by die_man, Feb 11, 2018.

  1. die_man

    die_man NEW

    Joined:
    Dec 24, 2017
    Messages:
    6
    Likes Received:
    3
    How i can solve this? Help, plz!

    When write !profile and select a player, this error appears in server console.
    Code:
    [SM] Exception reported: Invalid query Handle 0 (error: 4)
    [SM] Blaming: KZTimerGlobal.smx
    [SM] Call stack trace:
    [SM]   [0] SQL_HasResultSet
    [SM]   [1] Line 2467, kztimerGlobal/sql.sp::SQL_ViewRankedPlayerCallback5
    Meta list
    Code:
    Listing 6 plugins:
      [01] SourceMod (1.8.0.6040) by AlliedModders LLC
      [02] CS Tools (1.8.0.6040) by AlliedModders LLC
      [03] SDK Tools (1.8.0.6040) by AlliedModders LLC
      [04] SDK Hooks (1.8.0.6040) by AlliedModders LLC
      [05] DHooks (2.0.4) by AlliedModders
      [06] SteamWorks Extension (1.2.2) by Kyle Sanderson
    I using KZ Timer Testing branch: https://bitbucket.org/kztimerglobalteam/kztimerglobal/branch/Testing

    Another problem, it looks like the points for end maps are not working.
     
    Last edited: Feb 11, 2018
  2. Sikari

    Sikari Yay for bugs! Staff Member KZGlobalAdmin Programmer

    Joined:
    Jul 31, 2016
    Messages:
    214
    Likes Received:
    354
    Sorry, the testing branch is testing branch for a reason
     
  3. die_man

    die_man NEW

    Joined:
    Dec 24, 2017
    Messages:
    6
    Likes Received:
    3
    What are the latest stable version?
     
  4. nykaN

    nykaN PRO Official Map Tester Mapper

    Joined:
    Dec 20, 2015
    Messages:
    145
    Likes Received:
    404
  5. die_man

    die_man NEW

    Joined:
    Dec 24, 2017
    Messages:
    6
    Likes Received:
    3
    Installed, but same error appears in console before write !profile and select a player
    Code:
    [SM] Exception reported: Invalid query Handle 0 (error: 4)
    L 02/12/2018 - 14:58:15: [SM] Blaming: KZTimerGlobal.smx
    [SM] Call stack trace:
    [SM]   [0] SQL_HasResultSet
    [SM]   [1] Line 2467, kztimerGlobal/sql.sp::SQL_ViewRankedPlayerCallback5
    
     
  6. Zpamm

    Zpamm Hold Tight Staff Member KZGlobalAdmin

    Joined:
    Jan 15, 2016
    Messages:
    905
    Likes Received:
    1,003
    KZTimer uses NULL dates and strict mode doesn't let it insert them into the table. This can be solved by disabling strict mode though.

    Strict mode affects whether the server permits '0000-00-00' as a valid date: If strict mode is not enabled, '0000-00-00' is permitted and inserts produce no warning. If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.

    This should help you
    https://stackoverflow.com/a/40889485
    ^^^ didnt type that, its from another thread
     
    Café likes this.

Share This Page