ошыбка базы даных при выполнении /protected/yiic cron scan

[morda1983]

http://stat2.ki-eb.pp.ua/ cтатистика тут!

exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wp.bronesite' in 'field list'. The SQL statement executed was: UPDATE wot_player wp
JOIN
(SELECT
wps.player_id,
(1240-1040/POWER(LEAST(a.midl,6),0.164))_wps.frags/wps.battles
+wps.damage_dealt/wps.battles_530/(184_EXP(0.24_a.midl)+130)
+wps.spotted/wps.battles_125
+LEAST(wps.dropped_capture_points/wps.battles,2.2)100
+((185/(0.17+EXP((wps.wins/wps.battles_100-35)-0.134)))-500)0.45
+(6-LEAST(a.midl,6))-60 wn6,

(1240-1040/POWER(LEAST(a.midl,6),0.164))_wps.frags/wps.battles
+wps.damage_dealt/wps.battles_530/(184_EXP(0.24_a.midl)+130)
+wps.spotted/wps.battles_125_LEAST(a.midl,3)/3
+LEAST(wps.dropped_capture_points/wps.battles,2.2)100
+((185/(0.17+EXP((wps.wins/wps.battles_100-35)-0.134)))-500)_0.45
-((5-LEAST(a.midl,5))_125)/(1+EXP((a.midl-POWER(wps.battles/220,3/a.midl))_1.5)) wn7,

wps.damage_dealt/wps.battles_(10/(a.midl+2))_(0.23+2_a.midl/100)
+250_wps.frags/wps.battles
+wps.spotted/wps.battles_150
+log(1.732,wps.capture_points/wps.battles+1)_150
+wps.dropped_capture_points/wps.battles*150 effect,

980_a.rDAMAGEc + 210_a.rDAMAGEc_a.rFRAGc + 155_a.rFRAGc_a.rSPOTc + 75_a.rDEFc_a.rFRAGc + 145_LEAST(1.8,a.rWINc) wn8,

LN(wps.battles)/10_(wps.xp/wps.battles+wps.damage_dealt/wps.battles_(
2_wps.wins/wps.battles+
0.9_wps.frags/wps.battles+
0.5_wps.spotted/wps.battles+
0.5_wps.capture_points/wps.battles+
0.5*wps.dropped_capture_points/wps.battles)
) bronesite

FROM wot_player_statistic wps
JOIN (SELECT
wpt.player_id,
SUM(wt.tank_level * wpt.battles)/sum(wpt.battles) midl,
GREATEST(0,(wps.damage_dealt/SUM(etv.dmg_wpt.battles)-0.22)/(1-0.22)) rDAMAGEc,
GREATEST(0,LEAST(wps.damage_dealt/SUM(etv.dmg_wpt.battles)+0.2,(wps.frags/SUM(etv.frag_wpt.battles)-0.12)/(1-0.12))) rFRAGc,
GREATEST(0,LEAST(wps.damage_dealt/SUM(etv.dmg_wpt.battles)+0.1,(wps.spotted/SUM(etv.spot_wpt.battles)-0.38)/(1-0.38))) rSPOTc,
GREATEST(0,LEAST(wps.damage_dealt/SUM(etv.dmg_wpt.battles)+0.1,(wps.dropped_capture_points/SUM(etv.def_wpt.battles)-0.10)/(1-0.10))) rDEFc,
GREATEST(0,(wps.wins/SUM(etv.win/100_wpt.battles)-0.71)/(1-0.71)) rWINc
FROM wot_player_tank wpt
JOIN wot_player_statistic wps ON wpt.player_id = wps.player_id AND wps.statistic_id=1
JOIN wot_tank wt ON wt.tank_id = wpt.tank_id
LEFT JOIN wot_wn8_etv etv ON etv.IDNum=wpt.tank_id
JOIN wot_player_clan wpc ON wpt.player_id = wpc.player_id AND wpc.escape_date IS NULL AND wpc.clan_id=:clan
GROUP BY wpt.player_id) a ON a.player_id = wps.player_id
WHERE wps.statistic_id=1) a ON a.player_id=wp.player_id
SET wp.wn6=a.wn6, wp.wn7=a.wn7, wp.wn8=a.wn8, wp.effect=a.effect, wp.bronesite=a.bronesite' in /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/db/CDbCommand.php:358
Stack trace:
#0 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/models/WotPlayer.php(140): CDbCommand->execute(Array)
#1 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/components/WotService.php(358): WotPlayer::calcRating()
#2 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/commands/CronCommand.php(9): WotService::scanClan(122942)
#3 [internal function]: CronCommand->actionScan()
#4 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(CronCommand), Array)
#5 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#6 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#7 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/base/CApplication.php(180): CConsoleApplication->processRequest()
#8 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/framework/yiic.php(33): CApplication->run()
#9 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/yiic.php(7): require_once('/home/admin/web...')
#10 /home/admin/web/stat2.ki-eb.pp.ua/public_html/protected/yiic(4): require_once('/home/admin/web...')
#11 {main}morda@

[borodulin]

нужно обновить структуру базы. Свежую структуру выложил в protected/data. Всё базу убивать не нужно, можно сделать только обновление, из файлика update_1.sql.

[morda1983]

спс помогло!