MySQL error
#2

query[5426]
savingstring[6425]

You don't need so much long strings!
Use www.lettercount.com to count characters in string.
Your query string is 794 characters long. Plus 20 characters for player name = 814. You don't need 5426 chars!

----

Your string is too long. You can make 2 shorter strings and merge it:

pawn Код:
format(query, sizeof(query), "SELECT cash, deposit, payday, paycheck, connecttime, age, sex, level, number, phonebook, job, skin, team, accent, admin, spectate, banned, muted, reportmuted, \
    experiance, vip, vipmuted, jailed, jailtime, toggedvipchat, housekey, warns, posx, posy, posz, posa, health, armor, materials, cocaine, packages, interior, virtualworld, dice, \
    weapon1, weapon1a, weapon2, weapon2a, weapon3, weapon3a, weapon4, weapon4a,"
);
    format(query, sizeof(query), "%s weapon5, weapon5a, weapon6, weapon6a, weapon7, weapon7a, weapon8, weapon8a, weapon9, weapon9a, weapon10, \
    weapon10a, weapon11, weapon11a, weapon12, weapon12a, killlog0, killlog1, killlog2, killlog3, killlog4, killlog5, killlog6, killlog7, killlog8, killlog9, deaths, faction, rank, leader, \
    duty, crimes, wantedlevel, radio, radiofreq, spam, dashboard FROM playerdata WHERE user = '%s'"
, query, pname);
    mysql_query(query);
Reply


Messages In This Thread
MySQL error - by ryansheilds - 02.03.2012, 22:21
Re: MySQL error - by Pooh7 - 02.03.2012, 22:30
Re: MySQL error - by yvoms - 02.03.2012, 22:36
Re: MySQL error - by iTorran - 02.03.2012, 22:42
Re: MySQL error - by Pooh7 - 02.03.2012, 22:43
Re: MySQL error - by ryansheilds - 02.03.2012, 22:50
Re: MySQL error - by Pooh7 - 02.03.2012, 22:53
Re: MySQL error - by ryansheilds - 02.03.2012, 23:12
Re: MySQL error - by Ricop522 - 03.03.2012, 00:32

Forum Jump:


Users browsing this thread: 5 Guest(s)