Yasin

Witam bardzo serdecznie po dodaniu jakiekolwiek serwera pojawia się problem z bazą danych Mógłby ktoś pomóc ? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Wed, 20 Jan 2016 17:18:03 +0000 Error: 1265 - Data truncated for column 'protocol' at row 1 IP Address: 83.145.146.206 - /Aup9f4ukjY/index.php?adsess=11eea74fd75b02bb3331434b33e97ff1&app=serwery&&module=manage&do=dodaj-serwer ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO S8nxserwery_cache (`id`,`hostname`,`players_num`,`players_max`,`players`,`map`,`next_map`,`password`,`protocol`,`system`,`vac`,`bots`,`dproto`,`online`,`link`) VALUES(62,'CS-FRAGMANIA.PL[CSGO MOD][ONLY DD2] [Skrzynki - Klucze - Skiny][email protected]',21,27,'[{\"id\":0,\"name\":\"KopcioPL\",\"score\":0,\"time\":1440.8125,\"gq_name\":\"KopcioPL\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"L Y Z H I N\",\"score\":1,\"time\":84.625,\"gq_name\":\"L Y Z H I N\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"Gabi ;3\",\"score\":2,\"time\":3200.078125,\"gq_name\":\"Gabi ;3\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\".::GANJAMAFIA::.\",\"score\":1,\"time\":2991.78125,\"gq_name\":\".::GANJAMAFIA::.\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"^_^ ExE 41\",\"score\":0,\"time\":18.359375,\"gq_name\":\"^_^ ExE 41\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"{KeitStar}Miko\",\"score\":2,\"time\":136.984375,\"gq_name\":\"{KeitStar}Miko\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"BartekXD\",\"score\":0,\"time\":1528.34375,\"gq_name\":\"BartekXD\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"Nieznana :*\",\"score\":0,\"time\":767.765625,\"gq_name\":\"Nieznana :*\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"ThC KaMa\",\"score\":1,\"time\":714.296875,\"gq_name\":\"ThC KaMa\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"ED1K\",\"score\":0,\"time\":9129.484375,\"gq_name\":\"ED1K\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"BoZus\",\"score\":0,\"time\":74.703125,\"gq_name\":\"BoZus\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"HLTV - 1shot1kill.pl trzyma FPS\",\"score\":0,\"time\":44294.359375,\"gq_name\":\"HLTV - 1shot1kill.pl trzyma FPS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"QvirtualS\",\"score\":0,\"time\":590.359375,\"gq_name\":\"QvirtualS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"DGE\",\"score\":0,\"time\":2646.203125,\"gq_name\":\"DGE\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"Tomcio [PL]\",\"score\":0,\"time\":580.515625,\"gq_name\":\"Tomcio [PL]\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"T_R_I_C_E_P_S\",\"score\":1,\"time\":489.75,\"gq_name\":\"T_R_I_C_E_P_S\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"UPS\",\"score\":0,\"time\":399.875,\"gq_name\":\"UPS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"Harimbolek [t]\",\"score\":1,\"time\":5694.84375,\"gq_name\":\"Harimbolek [t]\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"Crashu\",\"score\":0,\"time\":2550.75,\"gq_name\":\"Crashu\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"niVo\",\"score\":0,\"time\":3792.0625,\"gq_name\":\"niVo\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"ApleJack\",\"score\":0,\"time\":1245.015625,\"gq_name\":\"ApleJack\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false}]','de_dust2','[jeszcze nie glosowano]',0,'1.1.2.7/Stdio','l',1,0,1,1,'steam://connect/91.224.117.13:27160/') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | Aup9f4ukjY/applications_addon/other/serwery/modules_admin/manage/manage.php| [db_main_mysql].insert | 109 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/applications_addon/other/serwery/modules_admin/manage/manage.php| [admin_serwery_manage_manage].addServer | 28 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/sources/base/ipsController.php | [admin_serwery_manage_manage].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Wed, 20 Jan 2016 17:20:36 +0000 Error: 1265 - Data truncated for column 'protocol' at row 1 IP Address: 83.145.146.206 - /Aup9f4ukjY/index.php?adsess=11eea74fd75b02bb3331434b33e97ff1&app=serwery&&module=manage&do=dodaj-serwer ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO S8nxserwery_cache (`id`,`hostname`,`players_num`,`players_max`,`players`,`map`,`next_map`,`password`,`protocol`,`system`,`vac`,`bots`,`dproto`,`online`,`link`) VALUES(63,'CS-FRAGMANIA.PL[CSGO MOD][ONLY DD2] [Skrzynki - Klucze - Skiny][email protected]',20,27,'[{\"id\":0,\"name\":\"KopcioPL\",\"score\":6,\"time\":1593.640625,\"gq_name\":\"KopcioPL\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":6,\"gq_ping\":false},{\"id\":0,\"name\":\"L Y Z H I N\",\"score\":4,\"time\":237.453125,\"gq_name\":\"L Y Z H I N\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":4,\"gq_ping\":false},{\"id\":0,\"name\":\"Gabi ;3\",\"score\":4,\"time\":3352.90625,\"gq_name\":\"Gabi ;3\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":4,\"gq_ping\":false},{\"id\":0,\"name\":\".::GANJAMAFIA::.\",\"score\":3,\"time\":3144.609375,\"gq_name\":\".::GANJAMAFIA::.\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":3,\"gq_ping\":false},{\"id\":0,\"name\":\"^_^ ExE 41\",\"score\":1,\"time\":171.1875,\"gq_name\":\"^_^ ExE 41\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":1,\"gq_ping\":false},{\"id\":0,\"name\":\"{KeitStar}Miko\",\"score\":8,\"time\":289.8125,\"gq_name\":\"{KeitStar}Miko\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":8,\"gq_ping\":false},{\"id\":0,\"name\":\"BartekXD\",\"score\":2,\"time\":1681.171875,\"gq_name\":\"BartekXD\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"ThC KaMa\",\"score\":2,\"time\":867.125,\"gq_name\":\"ThC KaMa\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"ED1K\",\"score\":3,\"time\":9282.3125,\"gq_name\":\"ED1K\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":3,\"gq_ping\":false},{\"id\":0,\"name\":\"BoZus\",\"score\":6,\"time\":227.53125,\"gq_name\":\"BoZus\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":6,\"gq_ping\":false},{\"id\":0,\"name\":\"MaLp3k\",\"score\":2,\"time\":164.5,\"gq_name\":\"MaLp3k\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"HLTV - 1shot1kill.pl trzyma FPS\",\"score\":0,\"time\":44447.1875,\"gq_name\":\"HLTV - 1shot1kill.pl trzyma FPS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"QvirtualS\",\"score\":0,\"time\":743.1875,\"gq_name\":\"QvirtualS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"DGE\",\"score\":2,\"time\":2799.03125,\"gq_name\":\"DGE\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"Tomcio [PL]\",\"score\":2,\"time\":733.34375,\"gq_name\":\"Tomcio [PL]\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"T_R_I_C_E_P_S\",\"score\":4,\"time\":642.578125,\"gq_name\":\"T_R_I_C_E_P_S\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":4,\"gq_ping\":false},{\"id\":0,\"name\":\"UPS\",\"score\":0,\"time\":552.703125,\"gq_name\":\"UPS\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":0,\"gq_ping\":false},{\"id\":0,\"name\":\"Harimbolek [t]\",\"score\":8,\"time\":5847.671875,\"gq_name\":\"Harimbolek [t]\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":8,\"gq_ping\":false},{\"id\":0,\"name\":\"Crashu\",\"score\":2,\"time\":2703.578125,\"gq_name\":\"Crashu\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":2,\"gq_ping\":false},{\"id\":0,\"name\":\"niVo\",\"score\":6,\"time\":3944.890625,\"gq_name\":\"niVo\",\"gq_kills\":false,\"gq_deaths\":false,\"gq_score\":6,\"gq_ping\":false}]','de_dust2','[jeszcze nie glosowano]',0,'1.1.2.7/Stdio','l',1,0,1,1,'steam://connect/91.224.117.13:27160/') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | Aup9f4ukjY/applications_addon/other/serwery/modules_admin/manage/manage.php| [db_main_mysql].insert | 109 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/applications_addon/other/serwery/modules_admin/manage/manage.php| [admin_serwery_manage_manage].addServer | 28 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/sources/base/ipsController.php | [admin_serwery_manage_manage].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'[

Serwer adjust time : wpisz 60 Argin myślałem, że jesteś dobry z IP.boardu a wygląda na to że jesteś kompletnie początkujący

1. W lsql_config należy usunąć feed, który czytuje serwery 2. Tabela Serwerów musi być taka sama jak baza danych z forum

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 05 Jan 2016 18:15:11 +0000 Error: 1366 - Incorrect integer value: '' for column 'players_num' at row 1 IP Address: 162.158.103.136 - /Aup9f4ukjY/index.php?adsess=d2d3fd9b83200d0021224a60dd15237d&app=core&module=system&section=taskmanager&do=task_run_now&task_id=33&tab=serwery ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: UPDATE serwery_cache SET hostname='',players_num='',players_max='',players='[]',map='n/a',next_map='',password='',protocol='',system='',vac='',bots='',dproto=0,online='',link='steam://connect/193.33.177.36:27096/' WHERE id=36 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | Aup9f4ukjY/applications_addon/other/serwery/sources/classes/library.php | [db_main_mysql].update | 90 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/applications_addon/other/serwery/tasks/serwery_recache.php | [serweryLibrary].requeryAll | 40 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/applications/core/modules_admin/system/taskmanager.php | [task_item].runTask | 325 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/applications/core/modules_admin/system/taskmanager.php | [admin_core_system_taskmanager].taskManagerRunTask | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | Aup9f4ukjY/sources/base/ipsController.php | [admin_core_system_taskmanager].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Wszystko ładnie pięknie wgrana baza danych, forum działa w 99% po przenosinach. Ale są małe niewiadome błędy i nie wiem jak je naprawić. Task (zadanie nie chce być uruchiomione, bo pojawia się błąd z sql). Drugi problem to aplikacja która wywala błędy po dodaniu serwera do tabeli Pomocy

Daje uproszczony kod #category_ID .maintitle { background-image: url("link do obrazka"); }