MySQL i błędy w konsoli

lpiob / MTA-XyzzyRP

Gamemod RP do gry Multi Theft Auto, napisany głównie w języku LUA, w oparciu o bazę danych MySQL. Stworzony oryginalnie w 2012 roku i rozwijany dalej na potrzeby serwera http://lss-rp.pl/

Other

44 stars 96 forks source link

Siemka! Postanowiłem założyć serwer. Wgrałem paczkę, wszystko zrobiłem zgodnie z tutorialem, W konsoli mam następujące błędy: [18-10-19 19:05:24] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:05:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:05:55] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:05:55] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:06:02] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:06:02] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:06:02] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:06:13] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:06:13] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:06:26] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:06:26] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:06:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:06:34] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:06:34] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-19 19:06:55] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:06:55] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:06:55] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:06:57] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:06:57] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:07:03] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:07:03] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:07:28] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:07:28] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:07:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:07:48] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:07:48] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:07:48] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:07:53] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:07:53] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:07:59] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:07:59] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:08:30] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:08:30] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:08:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:08:34] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:08:34] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-19 19:08:41] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:08:41] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:08:41] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:08:43] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:08:43] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:09:01] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:09:01] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:09:32] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:09:32] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:09:33] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:09:33] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:09:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:09:34] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:09:34] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:09:34] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:10:04] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:10:04] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:10:23] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:10:23] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:10:27] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:10:27] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:10:27] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:10:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:10:34] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:10:34] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-19 19:10:35] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:10:35] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:11:06] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:11:06] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"] [18-10-19 19:11:13] WARNING: [XyzzyRP]/DB2/sql.lua:28: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:11:13] ERROR: [XyzzyRP]/lss-domy/domy.lua:117: bad argument #1 to 'ipairs' (table expected, got nil) [18-10-19 19:11:20] ERROR: [XyzzyRP]/DB/sql.lua:43: attempt to call global 'mysql_escape_string' (a nil value) [18-10-19 19:11:20] ERROR: [XyzzyRP]/lss-core/server_stats.lua:26: call: failed to call 'DB:esc' [string "?"] [18-10-19 19:11:20] ERROR: [XyzzyRP]/lss-core/server_stats.lua:27: bad argument #2 to 'format' (string expected, got boolean) [18-10-19 19:11:34] WARNING: [XyzzyRP]/DB2/sql.lua:37: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean] [18-10-19 19:11:37] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-19 19:11:37] ERROR: [XyzzyRP]/lss-core/server_stats.lua:14: call: failed to call 'DB:zapytanie' [string "?"]

DB i DB2 wypełniłem poprawnie, w czym jest problem? I jeszcze gdy chcę się zalogować to wpisuję dane itd. klikam zaloguj i nic się nie dzieje. Zalogowałem się tylko przez konsolę, ale panel nadal jest. Jak mogę zarejestrować nowe konto i stworzyć postać? Proszę o pomoc.

To wyskakuje ciągle: [18-10-21 15:44:05] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:44:05] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-21 15:44:38] INFO: Zaladowano zmienionych domow: 0 [18-10-21 15:45:28] INFO: Zaladowano zmienionych domow: 0 [18-10-21 15:46:05] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:46:05] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-21 15:46:18] INFO: Zaladowano zmienionych domow: 0 [18-10-21 15:47:08] INFO: Zaladowano zmienionych domow: 0 [18-10-21 15:47:58] INFO: Zaladowano zmienionych domow: 0 [18-10-21 15:48:05] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:05] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"]

To wyskakuje po zrestartowaniu

** Login Passed... Welcome **

[18-10-21 15:48:48] Some files in 'lss-linaheli' use deprecated functions. [18-10-21 15:48:48] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:48] ERROR: Couldn't find resource lss-logging. Check it exists. [18-10-21 15:48:48] ERROR: lss-mapa ro.luac is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:48] ERROR: lss-muzyka eq_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:48] WARNING: lss-ochrona/ochrona_c.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [18-10-21 15:48:48] Some files in 'lss-ochrona' use deprecated functions. [18-10-21 15:48:48] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:48] ERROR: Couldn't find resource lss-paliwo. Check it exists. [18-10-21 15:48:48] ERROR: Couldn't find resource lss-payment. Check it exists. [18-10-21 15:48:48] ERROR: Couldn't find resource lss-pociagi. Check it exists. [18-10-21 15:48:48] ERROR: Couldn't find resource lss-kartoteka. Check it exists. [18-10-21 15:48:48] ERROR: [XyzzyRP]/DB/sql.lua:47: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:48] ERROR: [XyzzyRP]/lss-pojemniki/pojemniki.lua:14: call: failed to call 'DB:pobierzTabeleWynikow' [string "?"] [18-10-21 15:48:48] ERROR: [XyzzyRP]/lss-pojemniki/pojemniki.lua:15: bad argument #1 to 'ipairs' (table expected, got boolean) [18-10-21 15:48:48] WARNING: lss-vehicles/vehicles.lua(Line 347) [Server] setVehicleFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen. [18-10-21 15:48:48] WARNING: lss-vehicles/vehicles_c.lua(Line 332) [Client] setVehicleFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen. [18-10-21 15:48:48] Some files in 'lss-vehicles' use deprecated functions. [18-10-21 15:48:48] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:48] ERROR: [XyzzyRP]/DB/sql.lua:47: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:48] ERROR: [XyzzyRP]/lss-vehicles/vehicles.lua:169: call: failed to call 'DB:pobierzTabeleWynikow' [string "?"] [18-10-21 15:48:48] ERROR: [XyzzyRP]/lss-vehicles/vehicles.lua:170: bad argument #1 to 'ipairs' (table expected, got boolean) [18-10-21 15:48:48] ERROR: lss-silownia laweczka_c.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:48] ERROR: lss-silownia bieznia_c.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:48] ERROR: [XyzzyRP]/DB/sql.lua:47: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:48] ERROR: [XyzzyRP]/lss-telepickups/telepickups.lua:28: call: failed to call 'DB:pobierzTabeleWynikow' [string "?"] [18-10-21 15:48:48] WARNING: lss-tempomat/tempomat_c.lua(Line 77) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState. [18-10-21 15:48:48] Some files in 'lss-tempomat' use deprecated functions. [18-10-21 15:48:48] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:48] SyncMapElementData is now disabled [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:4: Bad argument @ 'createPed' [Expected bool at argument 6, got number '225'] [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:7: Bad argument @ 'setElementDimension' [Expected element at argument 1, got boolean] [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:8: Bad argument @ 'setElementInterior' [Expected element at argument 1, got boolean] [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:9: Bad argument @ 'setElementFrozen' [Expected element at argument 1, got boolean] [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:10: Bad argument @ 'setElementData' [Expected element at argument 1, got boolean] [18-10-21 15:48:48] WARNING: [XyzzyRP]/[obiekty]/gracz-sklep_super_sam/sklep.lua:11: Bad argument @ 'setElementData' [Expected element at argument 1, got boolean] [18-10-21 15:48:48] INFO: obiektow: 342 [18-10-21 15:48:49] ERROR: [XyzzyRP]/DB/sql.lua:61: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:49] ERROR: [XyzzyRP]/[obiekty]/lss-poczta/punkt_dystrybucji.lua:29: call: failed to call 'DB:pobierzWyniki' [string "?"] [18-10-21 15:48:49] ERROR: [XyzzyRP]/DB/sql.lua:47: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:49] ERROR: [XyzzyRP]/[obiekty]/lss-prom/import_pojazdow.lua:28: call: failed to call 'DB:pobierzTabeleWynikow' [string "?"] [18-10-21 15:48:49] ERROR: [XyzzyRP]/[obiekty]/lss-prom/import_pojazdow.lua:31: bad argument #1 to 'ipairs' (table expected, got boolean) [18-10-21 15:48:49] ERROR: lss-scena naglosnienie_c.luac is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:49] WARNING: [XyzzyRP]/[obiekty]/lss-urzadmiasta/zasilki.lua:65: Bad argument @ 'setElementInterior' [Expected number at argument 2, got nil] [18-10-21 15:48:49] WARNING: [XyzzyRP]/[obiekty]/lss-urzadmiasta/zasilki.lua:66: Bad argument @ 'setElementDimension' [Expected number at argument 2, got nil] [18-10-21 15:48:49] WARNING: lss-warsztat1/warsztat_c.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [18-10-21 15:48:49] Some files in 'lss-warsztat1' use deprecated functions. [18-10-21 15:48:49] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:49] WARNING: lss-wysypisko_smieci/pedy.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8. [18-10-21 15:48:49] Some files in 'lss-wysypisko_smieci' use deprecated functions. [18-10-21 15:48:49] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:50] ERROR: wb-taxi Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: wb-taxi Na_zewnatrz.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: wb-warsztat3 Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: wb-warsztat4 Interior.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: wb-warsztat4 Warsztat4.lua is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: zasieg_obiektow zasieg_obiektow.luac is invalid. Please re-compile at http://luac.mtasa.com/ [18-10-21 15:48:50] ERROR: Couldn't find resource samp_objects. Check it exists. [18-10-21 15:48:50] ERROR: Couldn't find resource . Check it exists. [18-10-21 15:48:50] ERROR: Couldn't find resource chatbubble. Check it exists. [18-10-21 15:48:50] ERROR: [XyzzyRP]/DB/sql.lua:70: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:50] ERROR: [XyzzyRP]/[community]/drawtag/sync.lua:163: call: failed to call 'DB:zapytanie' [string "?"] [18-10-21 15:48:50] ERROR: [XyzzyRP]/DB/sql.lua:47: attempt to call global 'mysql_query' (a nil value) [18-10-21 15:48:50] ERROR: [XyzzyRP]/[community]/drawtag/sync.lua:165: call: failed to call 'DB:pobierzTabeleWynikow' [string "?"] [18-10-21 15:48:50] ERROR: [XyzzyRP]/[community]/drawtag/sync.lua:166: attempt to get length of local 'tagi' (a boolean value) [18-10-21 15:48:50] WARNING: syncedfire/synced_fire_c.lua(Line 52) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState. [18-10-21 15:48:50] WARNING: syncedfire/synced_fire_c.lua(Line 60) [Client] getVehicleRotation is deprecated and may not work in future versions. Please replace with getElementRotation. [18-10-21 15:48:50] Some files in 'syncedfire' use deprecated functions. [18-10-21 15:48:50] Use the 'upgrade' command to perform a basic upgrade of resources. [18-10-21 15:48:50] ERROR: Couldn't find resource fireworkz. Check it exists. [18-10-21 15:48:50] Querying MTA master server... success! (Auto detected IP:TUTAJ JEST IP) [18-10-21 15:48:50] Authorized serial account protection is enabled for the ACL group(s): Admin See http://mtasa.com/authserial [18-10-21 15:48:50] Server started and is ready to accept connections! [18-10-21 15:48:50] To stop the server, type 'shutdown' or press Ctrl-C [18-10-21 15:48:50] Type 'help' for a list of commands. [18-10-21 15:48:50] INFO: zmiana pogody na 12

lpiob / MTA-XyzzyRP

MySQL i błędy w konsoli #450