SQL Error
#1

For some reason, my SQL system wont load.

http://pastebin.com/QGfHYDPB

(Gstylez plugin)
Reply
#2

What's wrong with it? Give us some error logging and stuff.
Reply
#3

I am able to load the plugin, but then the server crashes.
Reply
#4

Variables wont load.. When i login, nothing goes to my account. My admin level is 0, skin isnt set, no money, etc.
Reply
#5

are you exactly sure the query is correct?

any errors in mysql.txt?
Reply
#6

Yes, the query is correct, im selecting everything Where `Name` = theplayername

And no, there is no mysql errors.
Reply
#7

pawn Код:
new data[3][50]; //The data strings
        new data2[11]; //The data variables
should be
pawn Код:
new data[2][50]; //The data strings
        new data2[10]; //The data variables
your only using 10 data2s and 2 data's

thats the only error i can find.. try adding if(mysql_num_rows()) then mysql_fetch_row
Reply
#8

@The_Gangstas, I don't think having that would cause the problem.
Reply
#9

I Checked the sa-mp log and it seems im getting this bug.

Quote:

[04:21:31] sscanf warning: Strings without a length are deprecated, please add a destination size.

Quote:

sscanf(str,"p<|>s[16]s[45]dddddddddddd",data[0],data[1],data2[0],data2[0],data2[1],data2[2],data2[3],data2[4],data2[5],data2[6],data2[7],data2[8],data2[9]);

Using the Plugin.

Going to bed, will check this topic tommorow.
Reply
#10

oh you actually meant to use data2[11]. look at the sscanf you put ,data2[0],data2[0], 2 times

and you also have 12 d's remove one.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)