An error occured while processing this request:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dwg.tournament_teams' doesn't exist
When reporting this error, please include this code: 42S02
Click here to go back
The error occured on line 157 in /sites/d/dwg/application/components/core/db.php.
Stacktrace:
#1 Problem in /sites/d/***/application/components/core/db.php on line 157 at PDOStatement->execute(Array
(
[0] => solo
)
)
#2 Problem in /sites/d/***/application/components/core/db.php on line 224 at DBQuery->execQuery("SELECT *, totalkills / nummatches as killspermatch FROM (
SELECT teamids, COUNT(nummatches) as nummatches, name, SUM(totalkills) as totalkills, SUM(totalpoints) as totalpoints, AVG(placement) as avgplacement, players, teamhash FROM (
SELECT tt.id as teamids,
tts.matchid as nummatches,
tt.name,
IFNULL(tts.kills,0) as totalkills,
IFNULL(tts.points,0) as totalpoints,
IFNULL(tts.position,0) as placement,
GROUP_CONCAT( DISTINCT( ui.epic_username ) SEPARATOR ' + ' ) as players,
MD5(GROUP_CONCAT( DISTINCT( ui.id ) ORDER BY ui.id )) as teamhash
FROM `tournament_teams` tt
LEFT JOIN tournament_list tl ON tl.id = tt.tournamentid
LEFT JOIN tournament_teamscores tts ON tts.teamid = tt.id
LEFT JOIN tournament_participants tp ON tp.teamid = tt.id
LEFT JOIN user_index ui ON ui.id = tp.userid
LEFT JOIN user_blacklist ub ON ub.userid = ui.id AND ub.deleted IS NULL AND NOW() BETWEEN ub.fromdate AND ub.todate
WHERE tl.style = 'tcs'
AND tl.starts < '2021-11-01 00:00:00'
AND tl.type = ?
AND tt.accepted IS NOT NULL
AND tp.deleted IS NULL
AND ub.id IS NULL
GROUP BY tts.matchid, tt.id
) as iq
GROUP BY teamhash
ORDER BY totalpoints DESC, totalkills DESC
) as oq WHERE nummatches > 0 ORDER BY totalpoints DESC, totalkills DESC, avgplacement DESC, nummatches DESC LIMIT 10000", "solo")
#3 Problem in /sites/d/***/sites/ikeraxo/views/tournament/tcs.php on line 50 at DB::query("SELECT *, totalkills / nummatches as killspermatch FROM (
SELECT teamids, COUNT(nummatches) as nummatches, name, SUM(totalkills) as totalkills, SUM(totalpoints) as totalpoints, AVG(placement) as avgplacement, players, teamhash FROM (
SELECT tt.id as teamids,
tts.matchid as nummatches,
tt.name,
IFNULL(tts.kills,0) as totalkills,
IFNULL(tts.points,0) as totalpoints,
IFNULL(tts.position,0) as placement,
GROUP_CONCAT( DISTINCT( ui.epic_username ) SEPARATOR ' + ' ) as players,
MD5(GROUP_CONCAT( DISTINCT( ui.id ) ORDER BY ui.id )) as teamhash
FROM `tournament_teams` tt
LEFT JOIN tournament_list tl ON tl.id = tt.tournamentid
LEFT JOIN tournament_teamscores tts ON tts.teamid = tt.id
LEFT JOIN tournament_participants tp ON tp.teamid = tt.id
LEFT JOIN user_index ui ON ui.id = tp.userid
LEFT JOIN user_blacklist ub ON ub.userid = ui.id AND ub.deleted IS NULL AND NOW() BETWEEN ub.fromdate AND ub.todate
WHERE tl.style = 'tcs'
AND tl.starts < '2021-11-01 00:00:00'
AND tl.type = ?
AND tt.accepted IS NOT NULL
AND tp.deleted IS NULL
AND ub.id IS NULL
GROUP BY tts.matchid, tt.id
) as iq
GROUP BY teamhash
ORDER BY totalpoints DESC, totalkills DESC
) as oq WHERE nummatches > 0 ORDER BY totalpoints DESC, totalkills DESC, avgplacement DESC, nummatches DESC LIMIT 10000", "solo")
#4 Problem in /sites/d/***/application/components/core/dispatcher.php on line 927 at TCSTopList->Execute("solo")
#5 Problem in /sites/d/***/application/components/core/dispatcher.php on line 655 at Dispatcher::callObjectMethod(TCSTopList, "execute", Array
(
[0] => solo
)
)
#6 Problem in /sites/d/***/application/components/core/dispatcher.php on line 447 at Dispatcher->__loadView("tournament/tcs.php", Array
(
[0] => tournament
[1] => tcs
)
, Array
(
[0] => solo
)
)
#7 Problem in /sites/d/***/application/components/core/dispatcher.php on line 469 at Dispatcher->__findView(Array
(
[0] => tournament
[1] => tcs
)
, Array
(
[0] => solo
)
)
#8 Problem in /sites/d/***/application/components/core/dispatcher.php on line 316 at Dispatcher->__findView(Array
(
[0] => tournament
[1] => tcs
)
)
#9 Problem in /sites/d/***/sites/ikeraxo/webroot/index.php on line 16 at Dispatcher->Route