Pro1KiLLeR Posted March 27, 2017 Share Posted March 27, 2017 7 hours ago, Mr_Moose said: The file db.sql contains all database tables and structures required. Currently these won't be created automatically when using MySQL so you'll have to import that file into your database. What management software are you using? PhpMyAdmin, MySQL workbench, command line or anything else. Methods to setup a database properly varies between these. What management software are you using? I use PhpMyAdmin Link to comment
Mr_Moose Posted March 27, 2017 Author Share Posted March 27, 2017 Alright, the easiest way then would be to use default options and create a new user, make sure you mark the checkbox "create a database with the same name and grant all privileges". Link to comment
Mr.OppS Posted March 27, 2017 Share Posted March 27, 2017 HeLp ! ================================================================== = Multi Theft Auto: San Andreas v1.5.3 ================================================================== = Server name : Default MTA Server = Server IP address: auto = Server port : 22003 = = Log file : .. 1.5/server/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [2017-03-27 00:56:11] Compacting accounts database 'internal.db' ... [2017-03-27 00:57:08] Resources: 88 loaded, 0 failed [2017-03-27 00:57:08] Compacting database 'registry.db' ... [2017-03-27 00:57:08] Starting resources.... [2017-03-27 00:57:08] ERROR: [resources]\GTWgui\s_refresh.lua:26: bad argument #1 to 'pairs' (table expected, got nil) [2017-03-27 00:57:26] Server minclientversion is now 1.3.0-9.04311 [2017-03-27 00:57:52] WARNING: alternate_hud/client.lua(Line 53) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday. [2017-03-27 00:57:52] Some files in 'alternate_hud' use deprecated functions. [2017-03-27 00:57:52] Use the 'upgrade' command to perform a basic upgrade of resources. [2017-03-27 00:57:52] ERROR: modshop GUI/client.luac is invalid. Please re-compile at http://luac.mtasa.com/ [2017-03-27 00:57:52] Server minclientversion is now 1.3.2 [2017-03-27 00:57:53] WARNING: GTWaccounts/c_intro.lua(Line 72) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday. [2017-03-27 00:57:53] Some files in 'GTWaccounts' use deprecated functions. [2017-03-27 00:57:53] Use the 'upgrade' command to perform a basic upgrade of resources. [2017-03-27 00:57:54] Server minclientversion is now 1.3.4-0.00000 [2017-03-27 00:58:00] Loaded path map paths/maps/san_andreas in 3518 ms [2017-03-27 00:58:00] Loaded all path maps in 3553 ms [2017-03-27 00:58:00] Querying MTA master server... success! (Auto detected IP:45.244.233.48) [2017-03-27 00:58:00] Authorized serial account protection is enabled for the ACL group(s): `Admin` See http://mtasa.com/authserial [2017-03-27 00:58:00] Server started and is ready to accept connections! [2017-03-27 00:58:00] To stop the server, type 'shutdown' or press Ctrl-C [2017-03-27 00:58:00] Type 'help' for a list of commands. [2017-03-27 00:58:19] Server minclientversion is now 1.5.3-9.11204.0 [2017-03-27 00:58:19] CONNECT: [#]=>Mr.SpY connected (IP: 192.168.1.103 Serial: 991D5140B7B12DB88A1648FA607A5DE4 Version: 1.5.3-9.11204.7) [2017-03-27 00:58:20] JOIN: [#]=>Mr.SpY joined the game (IP: 192.168.1.103) [2017-03-27 01:00:48] QUIT: [#]=>Mr.SpY left the game [Quit] [2017-03-27 01:00:50] CONNECT: [#]=>Mr.SpY connected (IP: 192.168.1.103 Serial: 991D5140B7B12DB88A1648FA607A5DE4 Version: 1.5.3-9.11204.7) [2017-03-27 01:00:51] JOIN: [#]=>Mr.SpY joined the game (IP: 192.168.1.103) [2017-03-27 01:01:36] LOGIN: (Everyone, Admin, Console, VIP, Supporter, Developer) [#]=>Mr.SpY successfully logged in as 'SpY' (IP: 192.168.1.103 Serial: 991D5140B7B12DB88A1648FA607A5DE4) How to fix this Error ERROR: [resources]\GTWgui\s_refresh.lua:26: bad argument #1 to 'pairs' (table expected, got nil) ERROR: modshop GUI/client.luac is invalid. Please re-compile at http://luac.mtasa.com/ ?????? Link to comment
Mr_Moose Posted March 28, 2017 Author Share Posted March 28, 2017 Download the v4.0-beta branch instead: https://github.com/404rq/GTW-RPG/tree/v4.0-development GTWgui is not used in v3.0 so the function causing that error can safely be removed, mod-shop is a compiled resource which also appears to be abandoned. It's easy to decompile but it it wouldn't be right to do that, which leaves us with no other option than including a different mod system or skip the mod system resource completely. Link to comment
Mr.OppS Posted March 28, 2017 Share Posted March 28, 2017 (edited) 5 hours ago, Mr_Moose said: Download the v4.0-beta branch instead: https://github.com/404rq/GTW-RPG/tree/v4.0-development GTWgui is not used in v3.0 so the function causing that error can safely be removed, mod-shop is a compiled resource which also appears to be abandoned. It's easy to decompile but it it wouldn't be right to do that, which leaves us with no other option than including a different mod system or skip the mod system resource completely. Thank you Keep it up good job &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& But in v4.0-Beta ! still there problem ================================================================== = Multi Theft Auto: San Andreas v1.5.3 ================================================================== = Server name : GTW-RPG MTA Server V.4 = Server IP address: auto = Server port : 22003 = = Log file : .. 1.5/server/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [2017-03-28 16:04:41] ERROR: Couldn't find file img/ICEPLATE.jpg for resource GTWfastfood [2017-03-28 16:04:41] Loading of resource 'GTWfastfood' failed [2017-03-28 16:05:19] ERROR: Couldn't find file data/images/1.jpg for resource housesystem [2017-03-28 16:05:19] Loading of resource 'housesystem' failed [2017-03-28 16:05:54] Resources: 95 loaded, 0 failed [2017-03-28 16:05:54] Starting resources..... [2017-03-28 16:05:55] WARNING: [resources]\GTWcore\s_core.lua:24: Bad argument @ 'xmlNodeGetChildren' [Expected xml-node at argument 1, got boolean] [2017-03-28 16:05:55] ERROR: [resources]\GTWcore\s_core.lua:25: bad argument #1 to 'ipairs' (table expected, got boolean) [2017-03-28 16:06:08] Server minclientversion is now 1.5.3-9.11204.0 [2017-03-28 16:06:28] WARNING: alternate_hud/client.lua(Line 53) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible. [2017-03-28 16:06:28] Some files in 'alternate_hud' use deprecated functions. [2017-03-28 16:06:28] Use the 'upgrade' command to perform a basic upgrade of resources. [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:4: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:5: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:6: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:7: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:8: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:43] WARNING: GTWaccounts/c_intro.lua(Line 74) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible. [2017-03-28 16:06:43] Some files in 'GTWaccounts' use deprecated functions. [2017-03-28 16:06:43] Use the 'upgrade' command to perform a basic upgrade of resources. [2017-03-28 16:06:43] ERROR: attempt to call a nil value [2017-03-28 16:06:43] ERROR: [resources]\GTWantispam\s_lang.lua:19: call: failed to call 'GTWcore:getLanguage' [string "?"] [2017-03-28 16:06:44] ERROR: Couldn't find resource GTWfastfood. Check it exists. [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:20: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:21: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:22: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:23: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:23: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:24: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:25: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:26: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:27: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\turf_s.lua:55: attempt to perform arithmetic on global 'payout_time_interval' (a nil value) [2017-03-28 16:06:45] WARNING: [resources]\GTWturf\turf_s.lua:22: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got nil] [2017-03-28 16:06:45] WARNING: [resources]\GTWturf\turf_s.lua:23: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got nil] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:18: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:19: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:20: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:21: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:22: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:45] ERROR: Couldn't find resource GTWbluehellpatch. Check it exists. [2017-03-28 16:06:49] Loaded path map paths/maps/san_andreas in 2712 ms [2017-03-28 16:06:49] Loaded all path maps in 2729 ms [2017-03-28 16:06:49] Querying MTA master server... success! (Auto detected IP:45.244.27.133) [2017-03-28 16:06:49] Authorized serial account protection is enabled for the ACL group(s): `Admin` See http://mtasa.com/authserial [2017-03-28 16:06:49] Server started and is ready to accept connections! [2017-03-28 16:06:49] To stop the server, type 'shutdown' or press Ctrl-C [2017-03-28 16:06:49] Type 'help' for a list of commands. [2017-03-28 16:07:00] CONNECT: [#]=>Mr.SpY connected (IP: 192.168.1.103 Serial: 991D5140B7B12DB88A1648FA607A5D Version: 1.5.3-9.11204.7) [2017-03-28 16:07:01] JOIN: [#]=>Mr.SpY joined the game (IP: 192.168.1.103) [2017-03-28 16:07:10] ERROR: [resources]\GTWcore\s_core.lua:81: attempt to compare number with nil [2017-03-28 16:07:25] LOGIN: (Everyone, Admin, Console, VIP, Supporter, Developer) [#]=>Mr.SpY successfully logged in as 'SpY' (IP: 192.168.1.103 Serial: 991D5140B7B12DB88A1648FA607A5D) [2017-03-28 16:07:26] WARNING: [misc]\dxmoneylogs\server.lua:19: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got nil] [2017-03-28 16:09:31] Stopping resources......... [2017-03-28 16:09:31] WARNING: [resources]\GTWcore\s_core.lua:70: Bad argument @ 'xmlNodeGetChildren' [Expected xml-node at argument 1, got boolean] [2017-03-28 16:09:31] ERROR: [resources]\GTWcore\s_core.lua:71: bad argument #1 to 'ipairs' (table expected, got boolean) [2017-03-28 16:09:33] Closing SQLite3 database How to fix this Error !!! [2017-03-28 16:05:55] WARNING: [resources]\GTWcore\s_core.lua:24: Bad argument @ 'xmlNodeGetChildren' [Expected xml-node at argument 1, got boolean] [2017-03-28 16:05:55] ERROR: [resources]\GTWcore\s_core.lua:25: bad argument #1 to 'ipairs' (table expected, got boolean) [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:4: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:5: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:6: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:28] ERROR: attempt to call a nil value [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:7: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:28] ERROR: [misc]\dxmoneylogs\server.lua:8: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:43] ERROR: attempt to call a nil value [2017-03-28 16:06:43] ERROR: [resources]\GTWantispam\s_lang.lua:19: call: failed to call 'GTWcore:getLanguage' [string "?"] [2017-03-28 16:06:44] ERROR: Couldn't find resource GTWfastfood. Check it exists. [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:20: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:21: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:22: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:44] ERROR: attempt to call a nil value [2017-03-28 16:06:44] ERROR: [resources]\GTWgrouplogs\logs.lua:23: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:23: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:24: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:25: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:26: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\data.lua:27: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:45] ERROR: [resources]\GTWturf\turf_s.lua:55: attempt to perform arithmetic on global 'payout_time_interval' (a nil value) [2017-03-28 16:06:45] WARNING: [resources]\GTWturf\turf_s.lua:22: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got nil] [2017-03-28 16:06:45] WARNING: [resources]\GTWturf\turf_s.lua:23: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got nil] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:18: call: failed to call 'GTWcore:getMySQLHost' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:19: call: failed to call 'GTWcore:getMySQLDatabase' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:20: call: failed to call 'GTWcore:getMySQLUser' [string "?"] [2017-03-28 16:06:45] ERROR: attempt to call a nil value [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:21: call: failed to call 'GTWcore:getMySQLPass' [string "?"] [2017-03-28 16:06:45] ERROR: [resources]\GTWvehicleshop\vehicle_s.lua:22: attempt to concatenate local 'mysql_host' (a nil value) [2017-03-28 16:06:45] ERROR: Couldn't find resource GTWbluehellpatch. Check it exists. [2017-03-28 16:07:10] ERROR: [resources]\GTWcore\s_core.lua:81: attempt to compare number with nil [2017-03-28 16:07:26] WARNING: [misc]\dxmoneylogs\server.lua:19: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got nil] [2017-03-28 16:09:31] WARNING: [resources]\GTWcore\s_core.lua:70: Bad argument @ 'xmlNodeGetChildren' [Expected xml-node at argument 1, got boolean] [2017-03-28 16:09:31] ERROR: [resources]\GTWcore\s_core.lua:71: bad argument #1 to 'ipairs' (table expected, got boolean) Please, give us step by step how to fix them ! or make Video how to fix Error of MySQL *(PhpMyAdmin)* Edited March 28, 2017 by King SpY Link to comment
ChicoRDL Posted September 9, 2020 Share Posted September 9, 2020 Good afternoon! First of all I would like to stress how wonderfully this resource pack is fantastic. In the past I got to use this and follow both on the GTW server and as a hobby on my local server. But now I see that you have version 4.0 with the base called MySQL. I have a problem, I've already researched and searched but I can't change to SQlite. So I come here to ask if anyone can help me solve this problem. Thank you. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now