Hallo ich bin's wieder euer Problemkind 
Folgendes Problem:
[20:02:40:144 +02:00] [Thread 3136] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: vehicleInsert:civ:B_Quadbike_01_F:Car:76561198057742713:1:1:[]:2:778896
In unserer Garage werden auch nie Fahrzeuge gespeichert (Egal welche Fraktion)
Immer wenn man diese gerade erst eingeparkt hat dann nachschaut bei der Garagen KI
sagt er mir meine Garage sei leer.. hat dieser Code damit was zutun?
Bitte einmal einen vollständigen [lexicon]ExtDB[/lexicon] log geben und den kompletten Eintrag aus der custom.ini von [lexicon]ExtDB[/lexicon].
Scheint als würde bei dir was mit der Unique ID nicht ganz stimmen, zur Kontrolle aber mal bitte die beiden dinge.
Zur Not, schau mal in die Datenbank, dort sollte die ID als PrimaryKey und notnull sowie Autoincrement stehen.
Es darf auf keinen Fall irgendeiner der Tables in der vehicleTable auf Unique stehen. < sollte der Fehler sein, denn der Fehler besagt dass du versuchst einen String einzufügen der bereits existiert und das darf nicht weil er angeblich Unique ist (einzigartig)
C:\server\A3Master\@extDB2\[lexicon]extDB[/lexicon]\sql_custom_v2\altis-life-rpg-4.ini
Was für files nutzt du? Hast du überhaupt die richtige DB? Denn hier sind einige Dinge nicht ganz korrekt.
@Shinji ich weis meine Version nicht ich hab krampfhaft versucht die 4.4 zu installieren und halt alles auf [lexicon]Tanoa[/lexicon] anzupassen 
[Default]
Version = 12
Number of Inputs = 0
Sanitize Input Value Check = false
Sanitize Output Value Check = false
Prepared Statement Cache = true
Return InsertID = false
Strip = true
Strip Chars Action = STRIP
Strip Chars = /\|;{}<>'`
Strip Custom Chars = \/\|;{}<>'`
;; INPUT / OUTPUT Options
;; String (Removes " from value, then wraps value with ")
;; BeGUID (Converts value into BEGUID)
;; Check (Sanitize value check)
;; NoCheck
;; Strip (Strips Chars)
;; NoStrip
;;______________________________________________________________
[resetLifeVehicles]
;;
SQL1_1 = CALL resetLifeVehicles;
Number of Inputs = 0
Prepared Statement Cache = false
;;______________________________________________________________
[deleteDeadVehicles]
;;
SQL1_1 = CALL deleteDeadVehicles;
Number of Inputs = 0
Prepared Statement Cache = false
;;______________________________________________________________
[deleteOldHouses]
;;
SQL1_1 = CALL deleteOldHouses;
Number of Inputs = 0
Prepared Statement Cache = false
;;______________________________________________________________
[deleteOldGangs]
;;
SQL1_1 = CALL deleteOldGangs;
Number of Inputs = 0
Prepared Statement Cache = false
;;**************************************************************
;;**************************************************************
;; GANGS
;;
;;______________________________________________________________
[gangIDPlayer]
;;
SQL1_1 = SELECT id FROM gangs WHERE members LIKE ? AND active='1';
Number of Inputs = 1
SQL1_INPUTS = 1
;;______________________________________________________________
[gangNameSelectID]
;;
SQL1_1 = SELECT id FROM gangs WHERE name=? AND active=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[gangOwnerSelectID]
;;
SQL1_1 = SELECT id FROM gangs WHERE owner=? AND active=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[gangInsert]
;;
SQL1_1 = INSERT INTO gangs (owner, name, members) VALUES(?,?,?);
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[gangUpdate]
;;
SQL1_1 = UPDATE gangs SET active=1, owner=?,members=? WHERE id=?;
Number of Inputs = 3
SQL1_INPUTS = 1, 2, 3
;;______________________________________________________________
[gangRemove]
;;
SQL1_1 = UPDATE gangs SET active='0' WHERE id=?;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[gangInfo]
;; Get Gang Info
;;
SQL1_1 = SELECT id, owner, name, maxmembers, bank, members FROM gangs WHERE active='1' AND members LIKE ?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1, 2-String, 3-String, 4, 5, 6
;;______________________________________________________________
[gangBankInfoUpdate]
;; Update Gang Bank
;;
SQL1_1 = UPDATE gangs SET bank=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[gangInfoUpdate]
;; Update Gang Info
;;
SQL1_1 = UPDATE gangs SET bank=?, maxmembers=?, owner=? WHERE id=?;
SQL1_INPUTS = 1, 2, 3-String, 4
Number of Inputs = 4
;;______________________________________________________________
[gangMaxMembersUpdate]
;; Update Gang Max Members
;;
SQL1_1 = UPDATE gangs SET maxmembers=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[gangMembersUpdate]
;; Update Gang Members
;;
SQL1_1 = UPDATE gangs SET members=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[gangOwnerUpdate]
;; Update Gang Owner
;;
SQL1_1 = UPDATE gangs SET owner=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;**************************************************************
;;**************************************************************
;; PLAYERS
;;
;;______________________________________________________________
[playerInfo]
;;
SQL1_1 = SELECT playerid, name FROM players WHERE playerid=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1, 2
;;______________________________________________________________
[playerInfoInsert]
;;
SQL1_1 = INSERT INTO players
;; 1 2 3 4 5 6 7 8 9 10 11
SQL1_2 = (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?);
SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11
Number of Inputs = 11
;;______________________________________________________________
[playerWestInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9, 10
;;______________________________________________________________
[playerCivInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9
;;______________________________________________________________
[playerIndependentInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, med_licenses, mediclevel, med_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9
;;______________________________________________________________
[playerWestUpdate]
;;
SQL1_1 = UPDATE players
;; 1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?
SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6
Number of Inputs = 6
;;______________________________________________________________
[playerCivilianUpdate]
;;
SQL1_1 = UPDATE players
;; 1 2 3 4 5 6 7
SQL1_2 = SET name=?, cash=?, bankacc=?, civ_licenses=?, civ_gear=?, arrested=? WHERE playerid=?;
SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6, 7
Number of Inputs = 7
;;______________________________________________________________
[playerIndependentUpdate]
;;
SQL1_1 = UPDATE players
;; 1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, med_licenses=?, med_gear=? WHERE playerid=?;
SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6
Number of Inputs = 6
;;______________________________________________________________
[playerUpdateCash]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET cash=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateBank]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET bankacc=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateBank+Cash]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET cash=?, bankacc=? WHERE playerid=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[playerUpdateCopLicense]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET cop_licenses=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateCivLicense]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET civ_licenses=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateMedLicense]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET med_licenses=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateCopGear]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET cop_gear=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateCivGear]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET civ_gear=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateMedGear]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET med_gear=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateAlive]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET alive=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateArrested]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET arrested=? WHERE playerid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;**************************************************************
;;**************************************************************
;; VEHICLES
;;
;;______________________________________________________________
[vehicleDead]
;;
SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[vehicleInsert]
;;
SQL1_1 = INSERT INTO vehicles
;; 1 2 3 4 5 6 7 8 9
SQL1_2 = (side, classname, type, pid, alive, active, inventory, color, plate)
SQL1_3 = VALUES (?,?,?,?,?,?,?,?,?);
SQL1_INPUTS = 1, 2, 3, 4, 5, 6, 7, 8, 9
Number of Inputs = 9
;;______________________________________________________________
[vehicleInfo]
;;
;; 1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE id=? AND pid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9
;;______________________________________________________________
[vehiclesInfo]
;;
;; 1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE pid=? AND alive=1 AND active = 0 AND side=? AND type=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9
;;______________________________________________________________
[vehicleUpdateActive]
;;
SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND id=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[vehicleUpdateActivePlate]
;;
SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND plate=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[vehicleUpdateAlive]
;;
SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND id=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[vehicleUpdateAlivePlate]
;;
SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;**************************************************************
;;**************************************************************
;; Wanted System
;;
;;______________________________________________________________
[housingCount]
;;
SQL1_1 = SELECT COUNT(*) FROM houses WHERE owned='1';
Number of Inputs = 0
;;______________________________________________________________
[housingInit]
;;
SQL1_1 = SELECT houses.id, houses.pid, houses.pos, players.name FROM houses INNER JOIN players ON houses.pid=players.playerid WHERE houses.owned='1' LIMIT ?,10;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1, 2-String, 3-String, 4-String
;;______________________________________________________________
[housingFetchPlayerHouse]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4
;;______________________________________________________________
[housingCheckHouse]
;;
SQL1_1 = SELECT CASE
SQL1_2 = WHEN EXISTS(SELECT id FROM houses WHERE pos=? AND owned='1')
SQL1_3 = THEN 'false' ELSE 'true'
SQL1_4 = END
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1
;;______________________________________________________________
[housingAddHouse]
;;
SQL1_1 = INSERT INTO houses (pid, pos, inventory, containers, owned)
SQL1_2 = VALUES(?,?,?,?,?);
SQL1_INPUTS = 1, 2, 3, 4, 5
SQL2_1 = SELECT id FROM houses WHERE pos=? AND pid=? AND owned='1';
SQL2_INPUTS = 2, 1
Number of Inputs = 5
OUTPUT = 1
;;______________________________________________________________
[housingSellHouse]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE pid=? AND pos=? AND owned='1';
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[housingSellHouse2]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE id=?;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[houseUpdateContainer]
;;
SQL1_1 = UPDATE houses SET containers=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[housingUpdateInventory]
;;
SQL1_1 = UPDATE houses SET inventory=? WHERE id=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[housingCleanup]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4
;;**************************************************************
;;**************************************************************
;; Wanted System
;;
;;______________________________________________________________
[wantedGetCrimes]
;;
SQL1_1 = SELECT wantedID, wantedCrimes FROM wanted WHERE wantedID=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2
;;______________________________________________________________
[wantedUpdateCrimes]
;;
SQL1_1 = UPDATE wanted SET wantedCrimes = ?, wantedBounty = wantedBounty + ?, active = '1' WHERE wantedID=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[wantedInsertCrimes]
;;
SQL1_1 = INSERT INTO wanted (wantedID, wantedName, wantedCrimes, wantedBounty, active)
SQL1_2 = VALUES(?,?,?,?,?);
SQL1_INPUTS = 1, 2, 3, 4, 5
Number of Inputs = 5
;;______________________________________________________________
[wantedFetchBounty]
;;
SQL1_1 = SELECT wantedID, wantedName, wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4
;;______________________________________________________________
[wantedFetchCrimes]
;;
SQL1_1 = SELECT wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1, 2
;;______________________________________________________________
[wantedFetchID]
;;
SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1' AND wantedID in (?);
SQL1_INPUTS = 1-STRIP
Number of Inputs = 1
OUTPUT = 1-String, 2-String
;;______________________________________________________________
[wantedFetchPerson]
;;
SQL1_1 = SELECT wantedID, wantedName, wantedBounty FROM wanted WHERE wantedID=? AND active='1';
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3
;;______________________________________________________________
[wantedFetchName]
;;
SQL1_1 = SELECT wantedName FROM wanted WHERE wantedID=?;
SQL1_INPUTS = 1
Number of Inputs = 1
OUTPUT = 1-String
;;______________________________________________________________
[wantedFetchIDAll]
;;
SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1';
OUTPUT = 1-String, 2-String
;;______________________________________________________________
[wantedUpdateName]
;;
SQL1_1 = UPDATE wanted
SQL1_2 = SET wantedName=? WHERE wantedID=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[wantedRemoveCrimes]
;;
SQL1_1 = UPDATE wanted
SQL1_2 = SET active = 0, wantedCrimes = '[]', wantedBounty = 0 WHERE wantedID=?;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[DYNMARKET_Price_Set]
;;
SQL1_1 = UPDATE dynmarket SET prices = ? WHERE id=1;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[DYNMARKET_Price_Get]
;;
SQL1_1 = SELECT prices FROM dynmarket WHERE id=1;
OUTPUT = 1Mir scheint es als wäre deine DB falsch?
Unknown column 'inventory' in 'field list'
Heißt dass er beim Housing das Inventar nicht als Tabelle findet.
Ich weis nicht, ich hab diese hier benutzt und nur mein Benutzer umgestellt auf meinen weil root zu unsicher ist.
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `AltisLife`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `AltisLife` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `AltisLife`;
DELIMITER $$
--
-- Procedures
-- Edit arma3 to match a user in MySQ
-- For external databases: Edit localhost to match arma3server IP
--
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END$$
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END$$
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END$$
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END$$
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
BEGIN
DELETE FROM `containers` WHERE `owned` = 0;
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Table structure for table `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`uid` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`aliases` text NOT NULL,
`playerid` varchar(50) NOT NULL,
`cash` int(100) NOT NULL DEFAULT '0',
`bankacc` int(100) NOT NULL DEFAULT '0',
`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
`mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`civ_licenses` text NOT NULL,
`cop_licenses` text NOT NULL,
`med_licenses` text NOT NULL,
`civ_gear` text NOT NULL,
`cop_gear` text NOT NULL,
`med_gear` text NOT NULL,
`civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
`cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
`med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
`arrested` tinyint(1) NOT NULL DEFAULT '0',
`adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`blacklist` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `playerid` (`playerid`),
KEY `name` (`name`),
KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Table structure for table `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`side` varchar(15) NOT NULL,
`classname` varchar(32) NOT NULL,
`type` varchar(12) NOT NULL,
`pid` varchar(32) NOT NULL,
`alive` tinyint(1) NOT NULL DEFAULT '1',
`active` tinyint(1) NOT NULL DEFAULT '0',
`plate` int(20) NOT NULL,
`color` int(20) NOT NULL,
`inventory` varchar(500) NOT NULL,
`gear` text NOT NULL,
`fuel` double NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `side` (`side`),
KEY `pid` (`pid`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `houses`
-- Needed for extDB latest update on git
--
CREATE TABLE IF NOT EXISTS `houses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` varchar(32) NOT NULL,
`pos` varchar(64) DEFAULT NULL,
`owned` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `gangs`
-- Needed for extDB latest update on git
--
CREATE TABLE IF NOT EXISTS `gangs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`members` text,
`maxmembers` int(2) DEFAULT '8',
`bank` int(100) DEFAULT '0',
`active` tinyint(4) DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `containers`
-- Needed for extDB latest update on git
--
CREATE TABLE IF NOT EXISTS `containers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` varchar(32) NOT NULL,
`classname` varchar(32) NOT NULL,
`pos` varchar(64) DEFAULT NULL,
`inventory` varchar(500) NOT NULL,
`gear` text NOT NULL,
`dir` varchar(64) DEFAULT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`owned` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `wanted`
-- Needed for extDB latest update on git
--
CREATE TABLE `wanted` (
`wantedID` varchar(50) NOT NULL,
`wantedName` varchar(52) NOT NULL,
`wantedCrimes` text NOT NULL,
`wantedBounty` int(100) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`wantedID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;Ach hier noch ein Screen von NaviCat falls es hilft
Sorry ich bin noch nicht lange dabei, hab viel GTA:SA programmiert
Hier benutze ich aber root, in NaviCat halt nur. 
Hmz Ich denke deine Custom ini. Also die File deren Pfad ich dir gegeben habe ist falsch. Die DB scheint mir richtig zu sein nur fehlen die Einträge dafür in der altis-life.ini.
Such bitte nochmal in den Tuts durch danach
Ich meine nicht den Pfad, sondern die Datei dazu scheint nicht korrekt zu sein.
Achso, owee.. sorry
Ich hab die Datei aus irgendein Tutorial gezogen... ist offenbar doch nicht das von nox.
EDIT:
Aus diesem hier hab ich meine Datei:
https://native-network.net/wsif/entry/60-…altis-life-4-0/
Dachte das wäre alles richtig und korrekt weil es aus dem Forum selbst stammt
Ich habe mich jetzt nochmal belesen es kann auch sein das die Autos schon beim Kauf nicht eingetragen werden, wie kann ich dies beheben?
Offenbar ist die DB futsch.. nur kannst du mir erklären wie ich die wieder auf Vordermann bringen kann?
Du hast eine Al4.4 DB und eine [lexicon]extdb[/lexicon] ini für al 4.0
Du musst die [lexicon]extdb[/lexicon] custom DB File nutzen.
extdb3 is meines wissens nach buggy und nur über umwege zu erreichen. Ergo -> noch nicht "released"
Okay... lass es mich so erklären:
Mission 4.x
[lexicon]ExtDB[/lexicon] 2 (3.x +)
ServerVersion 4.x
Datenbank 4.4 <<<<<<<<<<<<< woher bitte?
Deine DATENBANK ABFRAGEN 4.0... <
Dein Problem ist einfach das die Versionen deiner Files nicht kompatibel sind. Entweder du nimmst ALLES von 4.4 oder ALLES von 4.0 < im Downloadbereich sehe ich nur 4.0
Heißt also, dass deine Datenbank falsch wäre wenn du nun diese Files aus dem Downloadbereich nutzen willst. < Ergo Datenbank löschen + die DB vom Downloadbereich einfügen.
Danke dir, für diese ausführliche Erklärung somit hat auch ein PrideGame es verstanden.
Entschuldige bitte, falls das jetzt etwas forsch ausgedrückt war, wusste nur leider nicht mehr wie ich mich sonst ausdrücken sollte.
Gott nein alles gut ich will ja lernen und ich will ja mein Projekt ausbauen und aufbauen jedoch bin ich manchmal ziemlich verpeilt.
Ich habe die v4.4 von Altis Life genommen das ist doch die richtige Version wenn meine Datenbank auch v4.4 ist, oder etwa nicht?
Wenn du die 4.4 nutzen willst, musst du Server/Mission/DB abfragen von 4.4 haben. die Versionen sollten alle zusammenhängen sonst siehst du ja was passiert.
