[MYSQL] Trouble with command

Hi friends, i'm having a trouble with a command...
I scripted a gang system for my server, i write it and tested it on my localhost ubuntu server. The code works great, no problem here.
The trouble is when i upload the gamemode to the hosting, the command does not work.
It sends the "UNKNOWN COMMAND" message, but a custom that i put on OnPlayerCommandPerformed.
The code is the same, the database is the same, the plugins are the same that i have on my local server.
I can't found the problem.
In my local server i used the "mysql_static.so" plugin. On the hosting server, this plugin does not load correctly, so i have to use "mysql.so" instead. Can this be the problem?

Here is the command:

The command gets the gang id of the player, then gets all users from database who have the same gang id, and do a loop of all this users to put his information on a string, then display all the user list on a dialog

What the version of MySQL are you using?

I'm using BlueG Mysql/R33

It is very weird, on localhost works well. On the hosting "UNKNOWN COMMAND"
I also checked if the gamemode uploads correctly, and yes.
Also i restarted the server 5 times, but the same.
Is there a difference between mysql.so and mysql_static.so?

im sure that the trouble has something to do with the sql querys.

also the databases has exactly the same structure.


the problem was that in the hosting database my test account had the rank of 5, and the array of ranks in my script has size of 5. so the script was trying to acces the element 6 of the array, causing it to return 0 and showing the unkown command error.

Forum Jump:

Users browsing this thread: 1 Guest(s)