digigir Posted August 14, 2012 Posted August 14, 2012 Hey can you tell me, why i cannot login? please help me ================================================================== = Multi Theft Auto: San Andreas v1.3 ================================================================== = Server name : test server = Server IP address: = Server port : 22003 = = Log file : .. 1.3/Server/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [2012-08-14 20:18:03] Resources: 13 loaded, 0 failed [2012-08-14 20:18:03] Querying game-monitor.com master server... unavailable! [2012-08-14 20:18:07] Querying backup master server... success! [2012-08-14 20:18:08] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso " [2012-08-14 20:18:08] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2012-08-14 20:18:08] Starting resources............... [2012-08-14 20:18:12] ERROR: Couldn't find resource vehicle. Check it exists. [2012-08-14 20:18:12] Server started and is ready to accept connections! [2012-08-14 20:18:12] To stop the server, type 'shutdown' or press Ctrl-C [2012-08-14 20:18:12] Type 'help' for a list of commands. [2012-08-14 20:18:12] WARNING: sql\mysql.lua:29 Connecting to your MySQL as 'root' is strongly discouraged. [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:13] || || [2012-08-14 20:18:13] || < MTA VENUX > || [2012-08-14 20:18:13] || ______________ || [2012-08-14 20:18:13] || Codename SWIFT || [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:49] CONNECT: CarelessPolenta91 connected (IP: 192.168.0.8 Serial: 7B122441D4C042641F97C8E851B678E3 Version: 1.3.0-9.04400.0) [2012-08-14 20:18:56] JOIN: CarelessPolenta91 joined the game (IP: 192.168.0. [2012-08-14 20:18:56] WARNING: account\s_account.lua:44: Bad argument @ 'setPlayerNametagColor' [2012-08-14 20:19:11] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:42] INFO: Column count doesn't match value count at row 1 I cannot login, please help me
Spliff Posted August 14, 2012 Posted August 14, 2012 Hey can you tell me, why i cannot login? please help me ================================================================== = Multi Theft Auto: San Andreas v1.3 ================================================================== = Server name : test server = Server IP address: = Server port : 22003 = = Log file : .. 1.3/Server/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [2012-08-14 20:18:03] Resources: 13 loaded, 0 failed [2012-08-14 20:18:03] Querying game-monitor.com master server... unavailable! [2012-08-14 20:18:07] Querying backup master server... success! [2012-08-14 20:18:08] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso " [2012-08-14 20:18:08] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2012-08-14 20:18:08] Starting resources............... [2012-08-14 20:18:12] ERROR: Couldn't find resource vehicle. Check it exists. [2012-08-14 20:18:12] Server started and is ready to accept connections! [2012-08-14 20:18:12] To stop the server, type 'shutdown' or press Ctrl-C [2012-08-14 20:18:12] Type 'help' for a list of commands. [2012-08-14 20:18:12] WARNING: sql\mysql.lua:29 Connecting to your MySQL as 'root' is strongly discouraged. [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:13] || || [2012-08-14 20:18:13] || < MTA VENUX > || [2012-08-14 20:18:13] || ______________ || [2012-08-14 20:18:13] || Codename SWIFT || [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:49] CONNECT: CarelessPolenta91 connected (IP: 192.168.0.8 Serial: 7B122441D4C042641F97C8E851B678E3 Version: 1.3.0-9.04400.0) [2012-08-14 20:18:56] JOIN: CarelessPolenta91 joined the game (IP: 192.168.0. [2012-08-14 20:18:56] WARNING: account\s_account.lua:44: Bad argument @ 'setPlayerNametagColor' [2012-08-14 20:19:11] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:42] INFO: Column count doesn't match value count at row 1 I cannot login, please help me Did you execute the mysql database? -As you can see on the last errors you're getting, you doesn't have enough columns, so yeah 1. It does not connect to the mysql 2. You're missing some rows etc in the DB
digigir Posted August 15, 2012 Posted August 15, 2012 Hey can you tell me, why i cannot login? please help me ================================================================== = Multi Theft Auto: San Andreas v1.3 ================================================================== = Server name : test server = Server IP address: = Server port : 22003 = = Log file : .. 1.3/Server/mods/deathmatch/logs/server.log = Maximum players : 32 = HTTP port : 22005 = Voice Chat : Disabled = Bandwidth saving : Medium ================================================================== [2012-08-14 20:18:03] Resources: 13 loaded, 0 failed [2012-08-14 20:18:03] Querying game-monitor.com master server... unavailable! [2012-08-14 20:18:07] Querying backup master server... success! [2012-08-14 20:18:08] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso " [2012-08-14 20:18:08] MODULE: Loaded "SHA Module" (1.02) by "mabako" [2012-08-14 20:18:08] Starting resources............... [2012-08-14 20:18:12] ERROR: Couldn't find resource vehicle. Check it exists. [2012-08-14 20:18:12] Server started and is ready to accept connections! [2012-08-14 20:18:12] To stop the server, type 'shutdown' or press Ctrl-C [2012-08-14 20:18:12] Type 'help' for a list of commands. [2012-08-14 20:18:12] WARNING: sql\mysql.lua:29 Connecting to your MySQL as 'root' is strongly discouraged. [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:13] || || [2012-08-14 20:18:13] || < MTA VENUX > || [2012-08-14 20:18:13] || ______________ || [2012-08-14 20:18:13] || Codename SWIFT || [2012-08-14 20:18:13] ||_________________________________|| [2012-08-14 20:18:49] CONNECT: CarelessPolenta91 connected (IP: 192.168.0.8 Serial: 7B122441D4C042641F97C8E851B678E3 Version: 1.3.0-9.04400.0) [2012-08-14 20:18:56] JOIN: CarelessPolenta91 joined the game (IP: 192.168.0. [2012-08-14 20:18:56] WARNING: account\s_account.lua:44: Bad argument @ 'setPlayerNametagColor' [2012-08-14 20:19:11] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:41] INFO: Column count doesn't match value count at row 1 [2012-08-14 20:19:42] INFO: Column count doesn't match value count at row 1 I cannot login, please help me Did you execute the mysql database? -As you can see on the last errors you're getting, you doesn't have enough columns, so yeah 1. It does not connect to the mysql 2. You're missing some rows etc in the DB Ok thanks, but im not understand you said , Can you make tutorial step by step? it will help for noob
..:D&G:.. Posted November 23, 2012 Posted November 23, 2012 Soo... I don't know how to make a database and I don't know how to "execute" the mysql file, I don't even know what execute means . So, if anyone can tell me how to set up a database and what/how to "execute" the mysql file. Thanks
CapY Posted November 24, 2012 Posted November 24, 2012 Soo... I don't know how to make a database and I don't know how to "execute" the mysql file, I don't even know what execute means . So, if anyone can tell me how to set up a database and what/how to "execute" the mysql file. Thanks If you don't know how to do it, you don't deserve to run this gamemode.
..:D&G:.. Posted November 25, 2012 Posted November 25, 2012 Soo... I don't know how to make a database and I don't know how to "execute" the mysql file, I don't even know what execute means . So, if anyone can tell me how to set up a database and what/how to "execute" the mysql file. Thanks If you don't know how to do it, you don't deserve to run this gamemode. Wow, wow, come down, I am just a bigginer, don't be soo rude. I want to learn, and how would you want me to know if nobody told me? And you were like this when you first play MTA, soo start to think bro.
Castillo Posted November 25, 2012 Posted November 25, 2012 In order to use this game mode you need to have a MySQL server and phpMyAdmin, where you can create a database and import the db file. I use "xampp".
FuriouZ Posted February 16, 2013 Posted February 16, 2013 Does it hawe any release dates or something ? when it si complitley done ?
Human Resources Staff Vinyard Posted May 4, 2013 Human Resources Staff Posted May 4, 2013 Uh, sorry guys but the post date is Sat Nov 12, 2011 1:25 am, I don't think this GM is still in development... This should be closed and archived, I think.
AeroXbird Posted March 27, 2014 Author Posted March 27, 2014 Shameless self bump. It's been quite a while since I've posted an update for this, but I'm doing a little scripting here and there so I'm going to push an update to the svn soon with a little extras. Most of it is code cleanup though, if you do have some extras feel free to send a patch.
..:D&G:.. Posted March 30, 2014 Posted March 30, 2014 Eh.. I can´t register. function attemptRegister(thePlayer, username, password) if ( username ~= "" and password ~= "" ) then local success, error = exports.sql:query_free("INSERT INTO `accounts` VALUES('', '".. tostring(username) .."', '".. md5( tostring( password ) ) .."', '".. getPlayerSerial(thePlayer) .."', '0')") if ( error ) then return outputDebugString( error ) else return outputChatBox("Successfully registered your account!", thePlayer, 100, 0, 100) end end end I get an error which is: Column count doesn´t match value count at row 1 ....
AeroXbird Posted March 30, 2014 Author Posted March 30, 2014 Yeah the SQL was changed somewhere along the lines, I'm currently working on porting the entire SQL system to MTA's built-in MySQL system so you don't need to do freaky stuff with any modules.
..:D&G:.. Posted March 30, 2014 Posted March 30, 2014 Can I just have the older, woking version please? I want to add some more things and release it here
Karuzo Posted March 30, 2014 Posted March 30, 2014 It's been quite a while since I've posted an update for this, but I'm doing a little scripting here and there so I'm going to push an update to the svn soon with a little extras. Most of it is code cleanup though, if you do have some extras feel free to send a patch. [quote name=..&G:..] I want to add some more things and release it here
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