Database Queries

SELECT `store`.* FROM `store` LEFT JOIN `user` ON `store`.`user_id` = `user`.`id` WHERE `slug` IS NULL

SELECT * FROM `team` WHERE `slug`=''

SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `league` ON `user_theme`.`user_id` = `league`.`user_id` LEFT JOIN `club` ON `user_theme`.`user_id` = `club`.`user_id` LEFT JOIN `team` ON `user_theme`.`team_id` = `team`.`id` WHERE (((league.slug = "") OR (club.slug = "")) OR (team.slug = "")) AND (`user_theme`.`is_active`=1)

SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `user` ON `user_theme`.`user_id` = `user`.`id` WHERE (`user_theme`.`is_active`=1) AND (`user`.`type_id`=1)

SELECT * FROM `user` WHERE `id`=1

SELECT * FROM `club` WHERE `slug`=''

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `store` WHERE `user_id`=1

SELECT `site_page_type`.* FROM `site_page_type` LEFT JOIN `site_pages` ON `site_page_type`.`id` = `site_pages`.`type_id` WHERE `site_page_type`.`name` IN ('Footer Quick link', 'Footer Contact Us', 'Footer About Us')

SELECT * FROM `site_pages` WHERE `type_id` IN (32, 33, 34)

SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (1, 'yii\\web\\HttpException:404', 1752083499.6634, '[51.83.243.159][-][-]', 'yii\\base\\InvalidRouteException: Unable to resolve the request \"index.html\". in /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Module.php:537\nStack trace:\n#0 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/web/Application.php(103): yii\\base\\Module->runAction()\n#1 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest()\n#2 /var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php(18): yii\\base\\Application->run()\n#3 {main}\n\nNext yii\\web\\NotFoundHttpException: Page not found. in /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/web/Application.php:115\nStack trace:\n#0 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest()\n#1 /var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php(18): yii\\base\\Application->run()\n#2 {main}')

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (4, 'application', 1752083499.6482, '[51.83.243.159][-][-]', '$_GET = []\n\n$_POST = []\n\n$_FILES = []\n\n$_COOKIE = [\n \'_frontend_CSRF\' => \'7ea47fc1aa949ead40ea73c1af249fc65877df55739e77be95ba98c4d1e32c5ba:2:{i:0;s:14:\\\"_frontend_CSRF\\\";i:1;s:32:\\\"nKWZ0nJg4p9fYYI0QqZ7Vs918bgGjrzH\\\";}\'\n \'_ga\' => \'GA1.2.1395808819.1752083497\'\n \'_gid\' => \'GA1.2.1430915304.1752083497\'\n \'_gat_UA-150275111-1\' => \'1\'\n \'_ga_MSBQ1JLBR6\' => \'GS2.2.s1752083498$o1$g0$t1752083498$j60$l0$h0\'\n]\n\n$_SERVER = [\n \'USER\' => \'sportshubsoccer\'\n \'HOME\' => \'/var/www/vhosts/sportshub.com\'\n \'SCRIPT_NAME\' => \'/index.php\'\n \'REQUEST_URI\' => \'/index.html\'\n \'QUERY_STRING\' => \'\'\n \'REQUEST_METHOD\' => \'GET\'\n \'SERVER_PROTOCOL\' => \'HTTP/1.0\'\n \'GATEWAY_INTERFACE\' => \'CGI/1.1\'\n \'REDIRECT_URL\' => \'/index.html\'\n \'REMOTE_PORT\' => \'54078\'\n \'SCRIPT_FILENAME\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php\'\n \'SERVER_ADMIN\' => \'[no address given]\'\n \'CONTEXT_DOCUMENT_ROOT\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web\'\n \'CONTEXT_PREFIX\' => \'\'\n \'REQUEST_SCHEME\' => \'https\'\n \'DOCUMENT_ROOT\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web\'\n \'REMOTE_ADDR\' => \'51.83.243.159\'\n \'SERVER_PORT\' => \'443\'\n \'SERVER_ADDR\' => \'74.208.93.48\'\n \'SERVER_NAME\' => \'devfront.sportshubsoccer.com\'\n \'SERVER_SOFTWARE\' => \'Apache\'\n \'SERVER_SIGNATURE\' => \'<address>Apache Server at devfront.sportshubsoccer.com Port 443</address>\n\'\n \'PATH\' => \'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\'\n \'HTTP_COOKIE\' => \'_frontend_CSRF=7ea47fc1aa949ead40ea73c1af249fc65877df55739e77be95ba98c4d1e32c5ba%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_frontend_CSRF%22%3Bi%3A1%3Bs%3A32%3A%22nKWZ0nJg4p9fYYI0QqZ7Vs918bgGjrzH%22%3B%7D; _ga=GA1.2.1395808819.1752083497; _gid=GA1.2.1430915304.1752083497; _gat_UA-150275111-1=1; _ga_MSBQ1JLBR6=GS2.2.s1752083498$o1$g0$t1752083498$j60$l0$h0\'\n \'HTTP_ACCEPT_ENCODING\' => \'gzip, deflate, br\'\n \'HTTP_REFERER\' => \'https://devfront.sportshubsoccer.com/service-worker.js?v=1647540009\'\n \'HTTP_ACCEPT\' => \'*/*\'\n \'HTTP_USER_AGENT\' => \'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/75.0.3765.0 Safari/537.36\'\n \'HTTP_CONNECTION\' => \'close\'\n \'HTTP_X_ACCEL_INTERNAL\' => \'/internal-nginx-static-location\'\n \'HTTP_X_REAL_IP\' => \'51.83.243.159\'\n \'HTTP_HOST\' => \'devfront.sportshubsoccer.com\'\n \'proxy-nokeepalive\' => \'1\'\n \'HTTPS\' => \'on\'\n \'PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'UNIQUE_ID\' => \'aG6sK0CZG4ODPZpPwD-hjgAAAAA\'\n \'REDIRECT_STATUS\' => \'200\'\n \'REDIRECT_HTTPS\' => \'on\'\n \'REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'REDIRECT_UNIQUE_ID\' => \'aG6sK0CZG4ODPZpPwD-hjgAAAAA\'\n \'FCGI_ROLE\' => \'RESPONDER\'\n \'PHP_SELF\' => \'/index.php\'\n \'REQUEST_TIME_FLOAT\' => 1752083499.6409\n \'REQUEST_TIME\' => 1752083499\n]')