Whoops, looks like something went wrong.

2/2 QueryException in Connection.php line 669: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'avg_rating' in 'order clause' (SQL: SELECT COUNT(*) AS cnt FROM (SELECT u.Id
FROM i_user u
JOIN i_user_identity ui ON ui.parentid = u.Id
LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id
LEFT JOIN i_country c ON u._nationality = c.Id
LEFT JOIN i_user_nationality un ON un.parentid = u.Id
LEFT JOIN i_current_team ct ON ct.parentid = ui.Id
WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1
GROUP BY u.Id
ORDER BY avg_rating DESC ) AS xx)

  1. in Connection.php line 669
  2. at Connection->runQueryCallback('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array(), object(Closure)) in Connection.php line 629
  3. at Connection->run('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array(), object(Closure)) in Connection.php line 342
  4. at Connection->select('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array()) in Connection.php line 298
  5. at Connection->selectOne('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())
  6. at call_user_func_array(array(object(MySqlConnection), 'selectOne'), array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in DatabaseManager.php line 295
  7. at DatabaseManager->__call('selectOne', array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in Facade.php line 217
  8. at Facade::__callStatic('selectOne', array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in Db.php line 106
  9. at Db::getRow('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx') in Db.php line 145
  10. at Db::getRowParam('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', 'cnt') in Frontend.php line 1538
  11. at Frontend->render() in MemberList.php line 101
  12. at MemberList->render() in users.php line 211
  13. at users->renderPlayersPage('default', 'en') in users.php line 153
  14. at users->printPage('default', 'en') in users.php line 599
  15. at users->ReplaceCustomTag('PRINT_PAGE', 'default', 'default', 'en', '', '0') in Core.php line 298
  16. at Core->ProcessTag('PRINT_PAGE', 'default', 'default', 'en', '0') in Core.php line 372
  17. at Core->ProcessTemplate('<.PRINT_PAGE.> ', 'default', 'default', 'en', '0') in Core.php line 400
  18. at Core->Render('default', 'default', 'en') in Project.php line 161
  19. at Project->renderFrontendBody('default', 'en') in mainclass.php line 11
  20. at mainclass->printFrontendBody('default', 'en') in mainclass.php line 39
  21. at mainclass->ReplaceCustomTag('FRONTEND_BODY', 'default', 'default', 'en', '', '0') in Core.php line 298
  22. at Core->ProcessTag('FRONTEND_BODY', 'default', 'default', 'en', '0') in Core.php line 372
  23. at Core->ProcessTemplate('<!DOCTYPE html> <!--[if lt IE 9 ]><html lang="sk" class="ie8"> <![endif]--> <!--[if lt IE 10 ]><html lang="sk" class="ie9"> <![endif]--> <!--[if (gt IE 10)|!(IE)]><!--><html lang="sk"> <!--<![endif]--> <head> @meta @assets.css @analytics </head> <.FRONTEND_BODY.> </html>', 'default', 'default', 'en', '0') in Core.php line 400
  24. at Core->Render('default', 'default', 'en') in Frontend.php line 169
  25. at Frontend->dispatch(object(Request), object(Response)) in Frontend.php line 167
  26. at Frontend->Gss\App\{closure}(object(Request))
  27. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 143
  28. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 53
  29. at VerifyCsrfToken->handle(object(Request), object(Closure))
  30. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  31. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in StartSession.php line 61
  32. at StartSession->handle(object(Request), object(Closure))
  33. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  34. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  35. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  36. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  37. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
  38. at EncryptCookies->handle(object(Request), object(Closure))
  39. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  40. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
  41. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  42. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  43. at Pipeline->Gss\Pipeline\{closure}(object(Request))
  44. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  45. at Pipeline->then(object(Closure)) in Frontend.php line 133
  46. at Frontend->sendRequestThroughRouter(object(Request)) in Frontend.php line 93
  47. at Frontend->handle(object(Request)) in Frontend.php line 68
  48. at Frontend->run() in index.php line 16

1/2 PDOException in Connection.php line 333: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'avg_rating' in 'order clause'

  1. in Connection.php line 333
  2. at PDO->prepare('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx') in Connection.php line 333
  3. at Connection->Gss\Core\Database\{closure}(object(MySqlConnection), 'SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array()) in Connection.php line 662
  4. at Connection->runQueryCallback('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array(), object(Closure)) in Connection.php line 629
  5. at Connection->run('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array(), object(Closure)) in Connection.php line 342
  6. at Connection->select('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array()) in Connection.php line 298
  7. at Connection->selectOne('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())
  8. at call_user_func_array(array(object(MySqlConnection), 'selectOne'), array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in DatabaseManager.php line 295
  9. at DatabaseManager->__call('selectOne', array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in Facade.php line 217
  10. at Facade::__callStatic('selectOne', array('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', array())) in Db.php line 106
  11. at Db::getRow('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx') in Db.php line 145
  12. at Db::getRowParam('SELECT COUNT(*) AS cnt FROM (SELECT u.Id FROM i_user u JOIN i_user_identity ui ON ui.parentid = u.Id LEFT JOIN i_user_identity_coach_position uicp ON uicp.parentid = ui.Id LEFT JOIN i_country c ON u._nationality = c.Id LEFT JOIN i_user_nationality un ON un.parentid = u.Id LEFT JOIN i_current_team ct ON ct.parentid = ui.Id WHERE 1 AND ui._identity_type_id= '2' AND ui._active=1 AND u.Id != 1 AND u._active = 1 GROUP BY u.Id ORDER BY avg_rating DESC ) AS xx', 'cnt') in Frontend.php line 1538
  13. at Frontend->render() in MemberList.php line 101
  14. at MemberList->render() in users.php line 211
  15. at users->renderPlayersPage('default', 'en') in users.php line 153
  16. at users->printPage('default', 'en') in users.php line 599
  17. at users->ReplaceCustomTag('PRINT_PAGE', 'default', 'default', 'en', '', '0') in Core.php line 298
  18. at Core->ProcessTag('PRINT_PAGE', 'default', 'default', 'en', '0') in Core.php line 372
  19. at Core->ProcessTemplate('<.PRINT_PAGE.> ', 'default', 'default', 'en', '0') in Core.php line 400
  20. at Core->Render('default', 'default', 'en') in Project.php line 161
  21. at Project->renderFrontendBody('default', 'en') in mainclass.php line 11
  22. at mainclass->printFrontendBody('default', 'en') in mainclass.php line 39
  23. at mainclass->ReplaceCustomTag('FRONTEND_BODY', 'default', 'default', 'en', '', '0') in Core.php line 298
  24. at Core->ProcessTag('FRONTEND_BODY', 'default', 'default', 'en', '0') in Core.php line 372
  25. at Core->ProcessTemplate('<!DOCTYPE html> <!--[if lt IE 9 ]><html lang="sk" class="ie8"> <![endif]--> <!--[if lt IE 10 ]><html lang="sk" class="ie9"> <![endif]--> <!--[if (gt IE 10)|!(IE)]><!--><html lang="sk"> <!--<![endif]--> <head> @meta @assets.css @analytics </head> <.FRONTEND_BODY.> </html>', 'default', 'default', 'en', '0') in Core.php line 400
  26. at Core->Render('default', 'default', 'en') in Frontend.php line 169
  27. at Frontend->dispatch(object(Request), object(Response)) in Frontend.php line 167
  28. at Frontend->Gss\App\{closure}(object(Request))
  29. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 143
  30. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 53
  31. at VerifyCsrfToken->handle(object(Request), object(Closure))
  32. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  33. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in StartSession.php line 61
  34. at StartSession->handle(object(Request), object(Closure))
  35. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  36. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  37. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  38. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  39. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
  40. at EncryptCookies->handle(object(Request), object(Closure))
  41. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  42. at Pipeline->Gss\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 42
  43. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  44. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 128
  45. at Pipeline->Gss\Pipeline\{closure}(object(Request))
  46. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  47. at Pipeline->then(object(Closure)) in Frontend.php line 133
  48. at Frontend->sendRequestThroughRouter(object(Request)) in Frontend.php line 93
  49. at Frontend->handle(object(Request)) in Frontend.php line 68
  50. at Frontend->run() in index.php line 16