SA-MP Forums Archive
HELP MYSQL ERROR Please - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: HELP MYSQL ERROR Please (/showthread.php?tid=671000)


HELP MYSQL ERROR Please - itachi - 03.12.2019

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


Re: HELP MYSQL ERROR Please - Joe Staff - 03.12.2019

Then either add the armour column to your entry, or set the armour default value in the Db to 0.0

Re: HELP MYSQL ERROR Please - itachi - 03.12.2019

how set default value in the DB to 0,0 ?

Re: HELP MYSQL ERROR Please - Calisthenics - 03.12.2019

In table structure, you can alter the table and modify the column to add a default value (within web app). Or you can execute this query once:
pawn Code:
ALTER TABLE `ucty3` CHANGE `Armour` `Armour` float NOT NULL DEFAULT '0.0' AFTER `Skin`;
It is advised to edit the CREATE TABLE too in case you need to import the table in the future:
pawn Code:
`Armour` float NOT NULL DEFAULT '0.0',
What I also noticed is that you have columns WSlot0 to WSlot11. This is against 1NF (repeating groups). Create a separate table.

Another thing is this:
pawn Code:
`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,
Instead of 5 columns that 4 of them are 0, have a single column name fighting_style and set a value between 0 and 4. You can easily find out which fighting style the player has.