Fahrzeuge löschen sich nach einiger Zeit automatisch und werden in der Garage nicht gespeichert

Retch

Hallo zusammen,

ich arbeite derzeit bei einem Freund am Server, der ein kleines Problemchen hat. Die Fahrzeuge welche zu bestimmten Abständen bzw. Zeitpunkten nicht besetzt sind werden vom Server gelöscht. Da wir ein Modded Fun RP Server sind ist das echt teils ein blödes Problem, da oftmals die Fahrzeuge natürlich in unpassenden Momenten "von Aliens" entführt werden...

Ebenfalls funktioniert unsere Garage nicht. Die Fahrzeuge werden beim einparken nicht gespeichert.

Kann mir da wer helfen?

Hier mal die extDB3- Logs:

Code: 12-12-56.log

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.032
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[12:03:08:428794 +02:00] [Thread 4720] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[12:03:08:432491 +02:00] [Thread 4720] extDB3: SQL: Initialized: NULL = ""
[12:03:08:433750 +02:00] [Thread 4720] extDB3: Locked
[12:03:08:528579 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: PROCEDURE arma3.deleteUnpaidHouses does not exist
[12:03:08:528629 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteUnpaidHouses
[14:08:19:948192 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:08:19:968327 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_amazing_ACS8_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '584641','"[]"','"[]"','0')
[14:08:52:190766 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:08:52:190837 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='584641'
[14:09:49:166636 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:09:49:166777 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'A3HD_lenco_bearcat', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '756809','"[]"','"[]"','0')
[14:10:07:227500 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:10:07:227559 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='756809'
[14:10:50:046214 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:10:50:046322 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_titan_17_PPV', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '546889','"[]"','"[]"','0')
[14:11:07:948259 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:11:07:948395 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='546889'
[14:11:50:337225 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:11:50:338866 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_vklasse_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '262211','"[]"','"[]"','0')
[14:12:27:164011 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:12:27:164192 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='262211'
[14:12:50:664856 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:12:50:664919 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_f90_18_PD', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '294957','"[]"','"[]"','0')
[14:14:18:557617 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:14:18:557763 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_fpace_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '521411','"[]"','"[]"','0')
[14:15:35:012673 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:15:35:015306 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_raptor_PRP_17', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '534195','"[]"','"[]"','0')
[14:16:01:941056 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:16:01:941186 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='534195'
[14:16:04:746147 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:16:04:746202 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='294957'
[14:17:23:566246 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:17:23:566406 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_FPIU_13', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '886392','"[]"','"[]"','0')
[14:17:40:708519 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:17:40:708623 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='886392'
[14:17:41:547004 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:17:41:547061 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='521411'
[14:18:45:813729 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:18:45:813905 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_FPIU_13', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '808040','"[]"','"[]"','0')
[14:19:20:399540 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[14:19:20:399612 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='808040'
[14:19:46:540360 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[14:19:46:540432 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_raptor_PRP_17', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '300302','"[]"','"[]"','0')
[15:13:14:668268 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:13:14:668555 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198125959857' AND plate='300302'
[15:13:23:436156 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:13:23:436268 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_f90_18_PD', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '94767','"[]"','"[]"','0')
[15:33:23:654957 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:33:23:661186 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'M_Silverado', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '348377','"[]"','"[]"','0')
[15:33:38:515708 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:33:38:515771 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_g63amg_16_Police', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '690704','"[]"','"[]"','0')
[15:34:45:474147 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:34:45:474250 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_vklasse_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '282309','"[]"','"[]"','0')
[15:35:47:007162 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:35:47:007332 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='348377'
[15:35:54:185626 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:35:54:185694 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'M_Silverado', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '389482','"[]"','"[]"','0')
[15:36:10:040635 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:36:10:040790 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_fpace_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '895531','"[]"','"[]"','0')
[15:36:10:353756 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:36:10:353808 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='389482'
[15:37:01:744247 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:37:01:744316 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'M_Charger12_NEW', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '596347','"[]"','"[]"','0')
[15:37:57:710293 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:37:57:710631 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='596347'
[15:38:06:623519 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:38:06:623588 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'M_FPIS_NEW', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '738831','"[]"','"[]"','0')
[15:38:19:723169 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:38:19:723307 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_charger_15_CPP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '937275','"[]"','"[]"','0')
[15:38:36:657354 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:38:36:657447 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='738831'
[15:39:21:495634 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:39:21:495803 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_durango_18_DDPI', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '821907','"[]"','"[]"','0')
[15:39:35:203977 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:39:35:204067 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'M_Charger12_Slick', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '159402','"[]"','"[]"','0')
[15:40:21:252770 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:40:21:252918 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_srthellcat_15_CPP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '887370','"[]"','"[]"','0')
[15:41:20:986145 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:41:20:986220 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_titan_17_PPV', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '992697','"[]"','"[]"','0')
[15:41:51:490764 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:41:51:490892 +02:00] [Thread 2836] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='159402'
[15:41:57:652260 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:41:57:652365 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_srthellcat_15_Sheriff', 'Car', '76561198385225912', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '640451','"[]"','"[]"','0')
[15:42:20:859781 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:42:20:859868 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_amazing_ACS8_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '875995','"[]"','"[]"','0')
[15:43:14:540530 +02:00] [Thread 6736] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1

Alles anzeigen

Barney

Code

[15:42:20:859781 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Incorrect integer value: 'cop' for column 'side' at row 1
[15:42:20:859868 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO vehicles (side, classname, type, pid, alive, active, inventory, color, plate, gear, damage, insure) VALUES ('cop', 'd3s_amazing_ACS8_17_COP', 'Car', '76561198125959857', '1','1','"[[],0]"', '[[1,1,1],[1,1,1],0.5]', '875995','"[]"','"[]"','0')

Die Spalte 'side' in der Tabelle 'vehicles' ist vom Datentyp integer, müsste aber VARCHAR(10) sein. Das Kaufen eines Fahrzeugs sollte demnach auch nicht richtig funktionieren.

Code

[15:36:10:353756 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Unknown column 'fuel' in 'field list'
[15:36:10:353808 +02:00] [Thread 6852] extDB3: SQL: Error MariaDBQueryException: Input: UPDATE vehicles SET active='0', inventory='"[[],0]"', gear='"[]"', fuel='1', damage='"[]"' WHERE pid='76561198385225912' AND plate='389482'

In der Tabelle 'vehicles' gibt es die Spalte 'fuel' nicht.

Entweder altered ihr jetzt die Tabelle um das zu beheben oder ihr löscht die Tabelle einfach und legt die richtig neu an:

Das hier ist die Tabellenerstellung aus dem Altis Life Framework:

Code

DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE IF NOT EXISTS `vehicles` (
    `id`          INT NOT NULL AUTO_INCREMENT,
    `pid`         VARCHAR(17) NOT NULL,
    `side`        VARCHAR(10) NOT NULL,
    `classname`   VARCHAR(64) NOT NULL,
    `type`        VARCHAR(16) NOT NULL,
    `alive`       TINYINT NOT NULL DEFAULT 1,
    `blacklist`   TINYINT NOT NULL DEFAULT 0,
    `active`      TINYINT NOT NULL DEFAULT 0,
    `plate`       MEDIUMINT NOT NULL,
    `color`       INT NOT NULL,
    `inventory`   TEXT NOT NULL,
    `gear`        TEXT NOT NULL,
    `fuel`        DOUBLE NOT NULL DEFAULT 1,
    `damage`      VARCHAR(256) NOT NULL,
    `insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    
    PRIMARY KEY (`id`),
    INDEX `fkIdx_players_vehicles` (`pid`),
    CONSTRAINT `FK_players_vehicles` FOREIGN KEY `fkIdx_players_vehicles` (`pid`)
      REFERENCES `players` (`pid`)
      ON UPDATE CASCADE ON DELETE CASCADE,
    INDEX `index_side` (`side`),
    INDEX `index_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Alles anzeigen

Desweiteren:

Code

[12:03:08:528579 +02:00] [Thread 6692] extDB3: SQL: Error MariaDBQueryException: PROCEDURE arma3.deleteUnpaidHouses does not exist

Die Prozedur 'deleteUnpaidHouses' exisitert auch nicht, müsste man halt erstellen.

Retch

Erstmal danke für deine Antwort, habe den Beitrag mal an den Owner weitergeleitet.

Das mit den Fahrzeugen kaufen find ich interessant. Schließlich werden die ja beim "kaufen" dennoch gespwant.

Barney

Zitat von Retch

Erstmal danke für deine Antwort, habe den Beitrag mal an den Owner weitergeleitet.
Das mit den Fahrzeugen kaufen find ich interessant. Schließlich werden die ja beim "kaufen" dennoch gespwant.

Gespawnt vielleicht aber in die Datenbank werden die nicht inserted. D.h. wenn du ein Fahrzeug kaufst ist es dann vermutlich ingame vorhanden aber nicht in der DB und damit nach dem Restart weg.

Einfach mal ausprobieren, Fahrzeug kaufen und gucken obs in der DB steht.

Benutzer online in diesem Thema