NeXt2k20
Wiek: 28 Na forum: 2322 dni Posty: 35
Nick w MP: NeXt
Piwa : 3
Cze??, mam ma?y problem z baz? danych od play your stories
A dok?adnie z tabel? pystories_vehicles
Gdy chc? kupi? auto to dostaje taki b??d w konsoli:
Dane nie zapisuj? si? w tabeli.
Cytat: [2021-03-04 16:29] WARNING: pystories-db\s_db.lua:11: dbExec failed; (1364) Field 'text' doesn't have a default value
Chcia?em ustawi? warto?? domy?ln? na 0 lecz dla typu 'TEXT' nie mo?na przypisa? warto?ci domy?lnej wi?c nie wiem jak rozwi?za? problem.
Problem tyczy si? ka?dego pola typu TEXT poniewa?, nie posiada warto?ci domy?lnej.
Struktura tabeli:
Kod:
CREATE TABLE IF NOT EXISTS `pystories_vehicles` (
`id` int(11) NOT NULL,
`model` int(11) NOT NULL DEFAULT '411',
`frozen` int(11) NOT NULL DEFAULT '0',
`pos` varchar(82) NOT NULL DEFAULT '0, 0, 0, 0, 0, 0',
`text` text CHARACTER SET utf32 COLLATE utf32_polish_ci NOT NULL,
`health` int(11) NOT NULL DEFAULT '1000',
`fuel` int(11) NOT NULL DEFAULT '100',
`mileage` int(11) NOT NULL DEFAULT '0',
`driver` text NOT NULL,
`color` varchar(50) NOT NULL DEFAULT '255, 255, 255',
`headlights` varchar(41) NOT NULL DEFAULT '255, 255, 255',
`paintjob` tinyint(1) NOT NULL DEFAULT '3',
`tuning` text NOT NULL,
`panelstates` text NOT NULL,
`rent` varchar(255) CHARACTER SET utf32 COLLATE utf32_bin DEFAULT '0',
`plateText` text NOT NULL,
`ownedPlayer` int(11) NOT NULL DEFAULT '0',
`ownedGroup` varchar(111) NOT NULL,
`parking` int(11) NOT NULL DEFAULT '0',
`police` tinyint(2) NOT NULL DEFAULT '0',
`neon` int(11) NOT NULL DEFAULT '0',
`blokada` text NOT NULL,
`registered` varchar(10) NOT NULL DEFAULT 'true',
`tp_to_parking` varchar(99) DEFAULT NULL,
`rh` tinyint(1) NOT NULL DEFAULT '0',
`mk2` tinyint(1) NOT NULL DEFAULT '0',
`mk1` tinyint(1) NOT NULL DEFAULT '0',
`naped` tinyint(1) NOT NULL DEFAULT '0',
`engine` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5198 DEFAULT CHARSET=latin1;
https://imgur.com/a/nXrHvYL
Z g?ry dzi?kuje za pomoc, stawiam