Jump to content

[Alpha] [GM] VenuX: Roleplay


AeroXbird

Recommended Posts

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.8)

[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
  • Replies 141
  • Created
  • Last Reply

Top Posters In This Topic

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.8)

[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
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.8)

[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 :lol: , Can you make tutorial step by step? it will help for noob
Link to comment
  • 3 months later...
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
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
  • 2 months later...
  • 2 months later...
  • 10 months later...

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

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

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=..:D&G:..] I want to add some more things and release it here :)

Link to comment

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.


×
×
  • Create New...