[Tidzii]

hello guys, alright, my server is running smoothly, but it appears this ERROR, i have no idea why ?
even that the server keeps running so good, i just want to fix it, incase if it makes it crash someday.

Quote:

[12:07:04] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1) [12:07:04] [MySQL] Check mysql_log.txt to review the query that threw the error. [12:07:04] Dumping query from 2015/2/2 (12:7:4) Description: Unknown column 'Gun License' in 'field list' (index 0). Query: [12:07:04] UPDATE `groups` SET `Type` = 1, `Name` = 'Secret Service', `MOTD` = 'Message for LEADER : Use /gmotd to edit this MOTD', `Allegiance` = 1, `Bug` = 0, `Radio` = 0, `DeptRadio` = 1, `IntRadio` = 7, `GovAnnouncement` = 6, `FreeNameChange` = 0, `DutyColour` = 7697781, `RadioColour` = 7697781, `Stock` = 50000, `CrateX` = '1741.81', `CrateY` = '-1779.16', `CrateZ` = '13.63', `SpikeStrips` = 1, `Barricades` = 1, `Cones` = 1, `Flares` = 1, `Barrels` = 1, `Gun License` = 14400000, `Budget` = 200000, `BudgetPayment` = 0, LockerCostType = 15, `CratesOrder` = '255', `CrateIsland` = '-1023934464', `GarageX` = '-1126.00', `GarageY` = '2.00', `GarageZ` = '', `Rank0` = 'Intern', `Rank1` = 'Agent', `Rank2` = 'Senior Agent', `Rank3` = 'Special Agent', `Rank4` = 'Supervisor', `Rank5` = 'Lead Supervisor', `Rank6` = 'Deputy Director', `Rank7` = 'Director', `Rank8` = '', `Rank9` = '', `Rank0Pay` = 5000, `Rank1Pay` = 15000, `Rank2Pay` = 20000, `Rank3Pay` = 30000, `Rank4Pay` = 40000, `Rank5Pay` = 50000, `Rank6Pay` = 70000, `Rank7Pay` = 80000, `Rank8Pay` = 0, `Rank9Pay` = 0, `Div1` = 'TNR', `Div2` = 'Investigations', `Div3` = 'Protection', `Div4` = 'Uniformed', `Div5` = 'Administration', `Div6` = 'TNR-INV', `Div7` = 'PRO-UNI', `Div8` = '', `Div9` = '', `Div10` = '', `Gun1` = 24, `Cost1` = 8, `Gun2` = 29, `Cost2` = 5, `Gun3` = 27, `Cost3` = 12, `Gun4` = 34, `Cost4` = 10, `Gun5` = 31, `Cost5` = 8, `Gun6` = 28, `Cost6` = 8, `Gun7` = 0, `Cost7` = 0, `Gun8` = 0, `Cost8` = 0, `Gun9` = 0, `Cost9` = 0, `Gun10` = 0, `Cost10` = 0, `Gun11` = 0, `Cost11` = 0, `Gun12` = 0, `Cost12` = 0, `Gun13` = 0, `Cost13` = 0, `Gun14` = 0, `Cost14` = 0, `Gun15` = 0, `Cost15` = 0, `Gun16` = 0, `Cost16` = 0 WHERE `id` = 5

[Nightmares]

Mostly happens to me when there are no tables existing for that specific thing.

[Tidzii]

So, what do you do ? you add the column ''Gun License'' or you remove it ?

[MehranGta]

Add a column in your table : 'Gun License'

[Vince]

Once more a perfect example of how a table should not look like. Anything that has a number in it belongs in a separate table.

groupid {PK, FK}	rank {PK}	description	pay
5	0	Intern	5000
5	1	Agent	15000
5	2	Senior Agent	20000

I reckon that this is a lot easier to read and a lot easier to work with. It also allow for virtually unlimited ranks and it doesn't waste space if a rank isn't used. The same goes for 'division' and the guns and their associated costs.

[Tidzii]

@Vince , Yeah But what's wrong with the ''Gun License'' Column, i add it the Groups Table's Field list, but the problem is the same .. wierd