PDA

View Full Version : mysql problem


Lirbo
14/07/2017, 11:46 AM
[13:31:24 07/14/17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'pack1_name' in 'field list' (Query: "UPDATE `user_weapon_pack1` SET `pack1_name` = '', `fist` = '', `melee` = '', `unique` = '', `grenade` = '', `secondary` = '', `shotgun` = '', `sub-machine` = '', `primary` = '', `sniper` = '', `missile` = '', `spray` = '' WHERE `id` = 4")


mysql_format(sql, query, sizeof query, "UPDATE `user_weapon_pack1` SET "); strcat(store, query);
mysql_format(sql, query, sizeof query, "`pack1_name` = '%s', ", DB[playerid][Pack1Name]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`fist` = '%s', ", DB[playerid][Pack1Hand]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`melee` = '%s', ", DB[playerid][Pack1Melee]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`unique` = '%s', ", DB[playerid][Pack1Unique]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`grenade` = '%s', ", DB[playerid][Pack1Grenade]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`secondary` = '%s', ", DB[playerid][Pack1Secondary]); strcat(store, query);
mysql_format(sql, query, sizeof query, "`shotgun` = '%s', ", DB[playerid][Pack1Shotgun]);strcat(store, query);
mysql_format(sql, query, sizeof query, "`sub-machine` = '%s', ", DB[playerid][Pack1SubMachine]);strcat(store, query);
mysql_format(sql, query, sizeof query, "`primary` = '%s', ", DB[playerid][Pack1Primary]);strcat(store, query);
mysql_format(sql, query, sizeof query, "`sniper` = '%s', ", DB[playerid][Pack1Sniper]);strcat(store, query);
mysql_format(sql, query, sizeof query, "`missile` = '%s', ", DB[playerid][Pack1Missile]);strcat(store, query);
mysql_format(sql, query, sizeof query, "`spray` = '%s' ", DB[playerid][Pack1Spray]);strcat(store, query);
mysql_format(sql, query, sizeof query, "WHERE `id` = %d", DB[playerid][ID]); strcat(store, query);
result = mysql_query(sql, store);
cache_delete(result);

Freedom.
14/07/2017, 02:53 PM
Make sure column names are true.

R4nd4ll
14/07/2017, 02:55 PM
Make sure column names are true.

Yep, The errors shows that there is a problem with the column names.
So check it again.