Не работает отправка состава на матч. Внизу страницы выползает ошибка:
Цитата
Query:
select ms.*, sc.paramcount from match_substitutions ms left join subst_conditions sc on (ms.add_condition = sc.code) where game = '478071' and team = '115' order by ms.id
error: Table './fb/match_substitutions' is marked as crashed and should be repaired
Сломалась буквально час назад. Я на два клуба отправил состав, а на третий не успел
В Microsoft Edge не работает клавиша отправить
...В Chrome такая же беда.
Мой косяк, 11 замен было, сори.
В сборной при нажатии кнопки "показать" ЮЧМ, отбор, вылетает ошибка:
Query:
select pl.*, pms.gained as gained, pms.gained_exp as gained_exp, c.name as club_country_name, min(pp.position) as min_position, c.id as club_country_id, tm.name as club_name, ps.games as ps_games, ps.minutes as ps_minutes, ps.goals as ps_goals, ps.goals_from_pen as ps_goals_from_pen, ps.yellows as ps_yellows, ps.two_yellows as ps_two_yellows, ps.reds as ps_reds, ps.own_goals as ps_own_goals, ps.conceded as ps_conceded, ps.conceded_from_pen as ps_conceded_from_pen, ps.games2count as ps_games2count, psp.games_suspended, ps.sum_mark2count as ps_sum_mark2count, ps.gained as ps_gained, ps.assists as ps_assists, tse.yellows_to_susp, psp.yellows, tm.id as club, tm.roster_name as club_roster_name from tournaments t, player_positions pp, players pl left join player_match_statistics pms on (pms.player = pl.id and pms.game = 540576) left join player_statistics ps on (ps.player = pl.id and ps.tournament = '13'), players pl1 left join player_suspensions psp on (psp.player = pl1.id and psp.tournament = t.susp_tour), players pl2 left join tournament_settings tse on tse.tournament = '13', players pl3 left join (teams tm, countries c) on pl3.team = tm.id where pl.nation = '17' and tm.country = c.id and pl.national_status = '3' and pl.id = pl1.id and pl.id = pl2.id and pl.id = pl3.id and t.id = '13' and pp.player = pl.id group by pp.player union select pl.*, pms.gained as gained, pms.gained_exp as gained_exp, '' as club_country_name, min(pp.position) as min_position, 0 as club_country_id, '' as club_name, ps.games as ps_games, ps.minutes as ps_minutes, ps.goals as ps_goals, ps.goals_from_pen as ps_goals_from_pen, ps.yellows as ps_yellows, ps.two_yellows as ps_two_yellows, ps.reds as ps_reds, ps.own_goals as ps_own_goals, ps.conceded as ps_conceded, ps.conceded_from_pen as ps_conceded_from_pen, ps.games2count as ps_games2count, psp.games_suspended, ps.sum_mark2count as ps_sum_mark2count, ps.gained as ps_gained, ps.assists as ps_assists, tse.yellows_to_susp, psp.yellows, 0 as club, '' as club_roster_name from tournaments t, player_positions pp, players pl left join player_match_statistics pms on (pms.player = pl.id and pms.game = 540576) left join player_statistics ps on (ps.player = pl.id and ps.tournament = '13'), players pl1 left join player_suspensions psp on (psp.player = pl1.id and psp.tournament = t.susp_tour), players pl2 left join tournament_settings tse on tse.tournament = '13' where pl.nation = '17' and not pl.team and pl.national_status = '3' and pl.id = pl1.id and pl.id = pl2.id and t.id = '13' and pp.player = pl.id group by pp.player order by 42
error: Unknown column 't.susp_tour' in 'on clause'
konst: Бан на 7 дней за оффтопик. Ошибка исправлена.