[Ajuda] MySQL
#1

Deu esse erro:
server_log:
Код:
[18:58:03] 1054, Unknown column 'testef' in 'field list', OnQueryFinish, UPDATE `mteams` SET `Team` = testef, `Level` = 2 WHERE `Nome` = 'Gustavo', 1
mysql_log:
Код:
[18:58:03] Passing query UPDATE `mteams` SET `Team` = testef, `Level` = 2 WHERE `Nome` = 'Gustavo' | siii
[18:58:03] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[18:58:03] OnQueryError() - Called.
Linha:
pawn Код:
new Query[128];
    format(Query, sizeof(Query), "UPDATE `mteams` SET `Team` = %s, `Level` = 2 WHERE `Nome` = '%s'", tName, GetName(playerid));
    mysql_query(Query, _THREAD_TEAM8, 0, gSQL);
Era para atualizar a coluna que tem o nome do player mudando o Team e o Level na tabela mteams, mais nгo sei porque esta dando erro, me ajudem!
Reply


Messages In This Thread
MySQL - by Gustavo Aguiar - 13.01.2013, 19:51
Re: MySQL - by Joao Pedro - 13.01.2013, 20:06
Re: MySQL - by Gustavo Aguiar - 13.01.2013, 23:25
Re: MySQL - by Gustavo Aguiar - 14.01.2013, 17:29
Re: MySQL - by paulor - 14.01.2013, 17:46
Re: MySQL - by [JD]BlackFire - 14.01.2013, 17:58

Forum Jump:


Users browsing this thread: 2 Guest(s)