Advertisement
Guest User

Untitled

a guest
Sep 4th, 2014
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. Error fetching data from database. Please check your database settings.
  2.  
  3. SELECT battleLifeTime as 'Life Time', map.name as 'Map', tank.name as 'Tank', battleTime as 'DateTime', battleSurvive.name as 'Survived', battleResult.name as 'Result', '' as ' - Separator 10 -', battle.dmg as 'Dmg', tank.expDmg as 'Exp Dmg', '' as ' - Separator 1 -', CAST(battle.frags AS FLOAT) as 'Frags', tank.expFrags as 'Exp Frags', '' as ' - Separator 2 -', CAST(battle.spotted AS FLOAT) as 'Spot', tank.expSpot as 'Exp Spot', battle.assistSpot+battle.assistTrack as 'Dmg Assist', '' as ' - Separator 3 -', CAST(battle.def AS FLOAT) as 'Def', tank.expDef as 'Exp Def', CAST(battle.cap AS FLOAT) as 'Cap', '' as ' - Separator 0 -', real_xp as 'Total XP', creditsNet as 'Credits Result', battle.eff as 'EFF', battle.wn8 as 'WN8', 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, tank.id as tank_id, tank.name as tank_name, battle.markOfMastery as mb_id, battle.arenaUniqueID, 0 as footer, playerTank.Id as player_Tank_Id, battle.id as battle_Id FROM battle INNER JOIN playerTank ON battle.playerTankId = playerTank.id INNER JOIN tank ON playerTank.tankId = tank.id INNER JOIN tankType ON tank.tankTypeId = tankType.Id INNER JOIN country ON tank.countryId = country.Id INNER JOIN battleResult ON battle.battleResultId = battleResult.id LEFT JOIN map on battle.mapId = map.id INNER JOIN battleSurvive ON battle.battleSurviveId = battleSurvive.id WHERE playerTank.playerId=1 AND battleTime>='2014-09-04 05:00' ORDER BY battleTime DESC
  4.  
  5. System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
  6. ambiguous column name: battleLifeTime
  7. bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
  8. bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
  9. bei System.Data.SQLite.SQLiteDataReader.NextResult()
  10. bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  11. bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  12. bei System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
  13. bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  14. bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  15. bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
  16. bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
  17. bei WinApp.Code.DB.FetchData(String sql, Boolean ShowError)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement