daily pastebin goal
70%
SHARE
TWEET

Untitled

a guest Sep 4th, 2014 157 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top