digigir Posted August 14, 2012 Share 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 Link to comment
Spliff Posted August 14, 2012 Share 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 Link to comment
digigir Posted August 15, 2012 Share 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 Link to comment
..:D&G:.. Posted November 23, 2012 Share 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 Link to comment
CapY Posted November 24, 2012 Share 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. Link to comment
..:D&G:.. Posted November 25, 2012 Share 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. Link to comment
Castillo Posted November 25, 2012 Share 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". Link to comment
FuriouZ Posted February 16, 2013 Share Posted February 16, 2013 Does it hawe any release dates or something ? when it si complitley done ? Link to comment
Quality7 Posted May 4, 2013 Share Posted May 4, 2013 Damn can't wait for the next release D= Goodjob sir! Link to comment
Moderators Vinyard Posted May 4, 2013 Moderators Share 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. Link to comment
AeroXbird Posted March 27, 2014 Author Share 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. Link to comment
..:D&G:.. Posted March 30, 2014 Share 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 .... Link to comment
AeroXbird Posted March 30, 2014 Author Share 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. Link to comment
..:D&G:.. Posted March 30, 2014 Share Posted March 30, 2014 Can I just have the older, woking version please? I want to add some more things and release it here Link to comment
Karuzo Posted March 30, 2014 Share 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 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