HELP MYSQL ERROR Please
#1

yesterday and a few days before it went fine, then all of a sudden there is no spawn in the game of new players.

LOG ERROR :
Code:
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',150602188,12000,230,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,2500,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,77,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,2500,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,230,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:57 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,2500,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392457,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392457)")
[18:00:58 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392458,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392458)")
[18:00:58 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392458,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392458)")
[18:00:58 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,2500,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392458,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392458)")
[18:00:58 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,135,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392458,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392458)")
[18:00:58 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,77,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392458,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392458)")
[18:00:59 12/03/19] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Armour' doesn't have a default value (Query: "INSERT INTO ucty3(Username,Heslo,Penize,Skin,XS,YS,ZS,DLRows,DLX,DLY,DLOn,MRows,MX,MY,MOn,Spawn,SpawnTime,IP,Dynamic,Log) VALUES ('Riko',1,12000,134,-2236.506591,252.379806,35.826198,3,608,122,1,5,608,155,1,0,1575392459,'62.141.24.76','CDE480F0E4C84DED9EDFA5ADC9E8844488FC0805',1575392459)")
TABLE :
Code:
 	CREATE TABLE `ucty3` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `Username` varchar(25) NOT NULL,
 `Heslo` int(11) NOT NULL,
 `Penize` int(11) NOT NULL,
 `Skin` int(11) NOT NULL,
 `Armour` float NOT NULL,
 `WSlot0` int(11) NOT NULL,
 `WSlot1` int(11) NOT NULL,
 `WSlot2` int(11) NOT NULL,
 `ASlot2` int(11) NOT NULL,
 `WSlot3` int(11) NOT NULL,
 `ASlot3` int(11) NOT NULL,
 `WSlot4` int(11) NOT NULL,
 `ASlot4` int(11) NOT NULL,
 `WSlot5` int(11) NOT NULL,
 `ASlot5` int(11) NOT NULL,
 `WSlot6` int(11) NOT NULL,
 `ASlot6` int(11) NOT NULL,
 `WSlot8` int(11) NOT NULL,
 `ASlot8` int(11) NOT NULL,
 `WSlot9` int(11) NOT NULL,
 `ASlot9` int(11) NOT NULL,
 `WSlot10` int(11) NOT NULL,
 `WSlot11` int(11) NOT NULL,
 `Job` int(11) NOT NULL,
 `Lokalita` int(11) NOT NULL,
 `Dovolena` int(11) NOT NULL,
 `Gang` int(11) NOT NULL,
 `KarieraGang` int(11) NOT NULL,
 `AdminLevel` int(11) NOT NULL,
 `VIP` int(11) NOT NULL,
 `Smrt` int(11) NOT NULL,
 `Zabil` int(11) NOT NULL,
 `Vary` int(11) NOT NULL,
 `Wanted` int(11) NOT NULL,
 `SekundVeVezeni` int(11) NOT NULL,
 `TypVezeni` int(11) NOT NULL,
 `Sekundy` int(11) NOT NULL,
 `XS` float NOT NULL,
 `YS` float NOT NULL,
 `ZS` float NOT NULL,
 `PS` int(11) NOT NULL,
 `WS` int(11) NOT NULL,
 `AutPrukaz` tinyint(1) NOT NULL,
 `MotPrukaz` tinyint(1) NOT NULL,
 `LetPrukaz` tinyint(1) NOT NULL,
 `LodPrukaz` tinyint(1) NOT NULL,
 `Vzdelani` int(11) NOT NULL,
 `AktivStyl` int(11) NOT NULL,
 `Box` tinyint(1) NOT NULL,
 `Kungfu` tinyint(1) NOT NULL,
 `Kneehead` tinyint(1) NOT NULL,
 `Grabkick` tinyint(1) NOT NULL,
 `Elbow` tinyint(1) NOT NULL,
 `DLRows` int(11) NOT NULL,
 `DLX` int(11) NOT NULL,
 `DLY` int(11) NOT NULL,
 `DLOn` tinyint(1) NOT NULL,
 `MRows` int(11) NOT NULL,
 `MX` int(11) NOT NULL,
 `MY` int(11) NOT NULL,
 `MOn` tinyint(1) NOT NULL,
 `Spawn` int(11) NOT NULL,
 `SpawnTime` int(11) NOT NULL,
 `IP` varchar(16) NOT NULL,
 `Log` int(11) NOT NULL,
 `Dynamic` varchar(45) NOT NULL,
 PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2426 DEFAULT CHARSET=cp1250
Reply


Messages In This Thread
HELP MYSQL ERROR Please - by itachi - 03.12.2019, 16:03
Re: HELP MYSQL ERROR Please - by Joe Staff - 03.12.2019, 16:33
Re: HELP MYSQL ERROR Please - by itachi - 03.12.2019, 16:39
Re: HELP MYSQL ERROR Please - by Calisthenics - 03.12.2019, 18:24

Forum Jump:


Users browsing this thread: 1 Guest(s)