latest public version: 0.7.12
I start today 0.7.6 Program write Update of version 0.7.12 I klick OK, Load and Update

I start today 0.7.6

Program write Update of version 0.7.12

I klick OK, Load and Update

After Update is start 0.7.12

No Today Battles and no Older Battles show in this New Version.

I play another game. Not show

I make a Backdate to Version 0.7.6

All OK

  • BadButton - 03.02.2015

    It would be nice if you could try to install version 0.7.12 once more. Do it like this:

    1. Quit Wot Numbers
    2. Use Windows Explorer, go to: %appdata%/Wot Numbers/Log
    3. Find the file log.txt and delete it (it will force Wot Numbers to create a new log file)
    4. Install version 0.7.12 and start Wot Numbers as normal
    5. Go to battle view
    6. If the battle view still don't show any battles, copy the content of the file log.txt below

  • Nobody33 - 04.02.2015

    Tank you

    this work

  • FR0STY5STAR - 04.02.2015

    I've got the same problem. After i installed 0.7.12 it gave me error at the start of the run of the program and it doesn't collect new battles anymore.


    Start logging: 2015-02-04 14:34:41


    2015-02-04 14:34:47 ### EXCEPTION ###

       Source:          System.Data.SQLite

       TargetSite:      System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)

       Data:            System.Collections.ListDictionaryInternal

       Message:         SQL logic error or missing database

    no such column: playerTankBattle.battles

       Stack Trace: 

       at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

       at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

       at System.Data.SQLite.SQLiteDataReader.NextResult()

       at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

       at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

       at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

       at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

       at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

       at WinApp.Code.DB.FetchData(String sql, Boolean ShowError)


       SELECT tank.tier as 'Tier', as 'Tank', tankType.shortName as 'Type', country.shortName as 'Nation', '' as ' - Separator 0 -', playerTank.lastBattleTime as 'Last Battle', playerTankBattle.battles as 'Battles', CAST(playerTankBattle.wins*1000/nullif(playerTankBattle.battles,0) as FLOAT) / 10 as 'Win Rate', '' as ' - Separator 1 -', cast(frags as float) / nullif(battles-survived,0) as 'K/D Ratio', cast(dmg as float) / nullif(dmgReceived,0) as 'Dmg C/R', '' as ' - Separator 3 -', playerTankBattle.maxFrags as 'Frags Max', playerTankBattle.maxDmg as 'Dmg Max', playerTankBattle.maxXp as 'XP Max', '' as ' - Separator 2 -', playerTankBattle.wn8 as 'WN8', playerTankBattle.wn7 as 'WN7', playerTankBattle.eff as 'EFF',    battleResult.color as battleResultColor,  battleSurvive.color as battleSurviveColor,   CAST(battle.battleTime AS DATETIME) as battleTimeToolTip, battle.battlesCount as battlesCountToolTip,   battle.victory as victoryToolTip, battle.draw as drawToolTip, battle.defeat as defeatToolTip,   battle.survived as survivedCountToolTip, battle.killed as killedCountToolTip, as tank_id, as tank_name,   battle.markOfMastery as mb_id, battle.arenaUniqueID,  0 as footer, playerTank.Id as player_Tank_Id, as battle_Id  FROM    battle INNER JOIN         playerTank ON battle.playerTankId = INNER JOIN         tank ON playerTank.tankId = INNER JOIN         tankType ON tank.tankTypeId = tankType.Id INNER JOIN         country ON tank.countryId = country.Id INNER JOIN         battleResult ON battle.battleResultId = LEFT JOIN         map on battle.mapId = INNER JOIN         battleSurvive ON battle.battleSurviveId = WHERE   playerTank.playerId=1  AND battleTime>='2015-02-04 07:00:00'  AND is not null  ORDER BY battle.battleTime  DESC  

    2015-02-04 14:34:47 ### EXCEPTION ###

       Source:          System.Data

       TargetSite:      Void MoveTo(System.Data.DataColumn, Int32)

       Data:            System.Collections.ListDictionaryInternal

       Message:         Ordinal '1' exceeds the maximum number.

    Parameter name: ordinal

       Stack Trace: 

       at System.Data.DataColumnCollection.MoveTo(DataColumn column, Int32 newPosition)

       at WinApp.Forms.Main.GridShowBattle(String Status2Message)

  • BadButton - 04.02.2015

    The critical message from the error log is: 

    • SQL logic error or missing database no such column: playerTankBattle.battles

    It seems like the battle view is trying to show columns that are used for tank view. The latest version changes the default tank view, but for your database it seems like this has been added to the battle view.

    Please try to change to other battle views to se if any works. Hopefully is it only the "Default" view that is corrupt.

    We do not have any "reset" button to fix this, and the system has no option for altering system views. A workaround until we find any better solution to fix this is:

    1. Go to battle view
    2. Select "Edit Battle View" from the menu: "Select Battle View" 
    3. Select "Add" and create a new view, and set this as "Startup".
    4. For more information about views: Editing the Tanks / Battles view
  • BadButton - 04.02.2015

    For next version 0.7.13 is it added a "Reset" button for the "Edit Tank/Battle View" to enable resetting the system column setups in case these has come out of sync.

    I have added you as a temporary test pilot FR0STY5STAR, so you will get this version as soon as we have released next pilot version.

  • BadButton - 10.02.2015

    We had to release the new version in a hurry because of WoT 9.6 release. Hopefully will you be able to fix the system column setup using the new feature.

Sign in for replying to topic Close