ich heul net rum, hab einfach nur gehofft das einer antwortet und mir hilft und dieser fehler hat ja nix mit dem spiel zutun sondern mit der datenbank
Beiträge von DrBong
-
-
ok hier kriegt man wohl garkeine antwort
-
Code
Alles anzeigenFehler SQL-Befehl: CREATE TABLE `characters` ( `account_name` varchar( 64 ) NOT NULL , `id` int( 11 ) NOT NULL AUTO_INCREMENT , `char_name` varchar( 64 ) NOT NULL , `zuly` decimal( 11, 0 ) NOT NULL default '500', `level` decimal( 11, 0 ) NOT NULL default '1', `curHp` decimal( 18, 0 ) NOT NULL default '50', `curMp` decimal( 18, 0 ) NOT NULL default '18', `str` decimal( 11, 0 ) NOT NULL default '15', `con` decimal( 11, 0 ) NOT NULL default '15', `dex` decimal( 11, 0 ) NOT NULL default '15', `_int` decimal( 11, 0 ) NOT NULL default '15', `cha` decimal( 11, 0 ) NOT NULL default '10', `sen` decimal( 11, 0 ) NOT NULL default '10', `face` decimal( 11, 0 ) NOT NULL default '1', `hairStyle` decimal( 11, 0 ) NOT NULL default '1', `sex` decimal( 11, 0 ) NOT NULL default '0', `exp` decimal( 11, 0 ) NOT NULL default '0', `skillp` decimal( 11, 0 ) NOT NULL default '0', `statp` decimal( 11, 0 ) NOT NULL default '0', `clanid` decimal( 11, 0 ) NOT NULL default '0', `unionid` decimal( 11, 0 ) NOT NULL default '0', `union1points` int( 11 ) NOT NULL default '0', `union2points` int( 11 ) NOT NULL default '0', `union3points` int( 11 ) NOT NULL default '0', `union4points` int( 11 ) NOT NULL default '0', `union5points` int( 11 ) NOT NULL default '0', `union6points` int( 11 ) NOT NULL default '0', `union7points` int( 11 ) NOT NULL default '0', `union8points` int( 11 ) NOT NULL default '0', `union9points` int( 11 ) NOT NULL default '0', `union10points` int( 11 ) NOT NULL default '0', `classid` decimal( 11, 0 ) NOT NULL default '0', `deletetime` decimal( 20, 0 ) NOT NULL default '0', `clan_rank` int( 11 ) NOT NULL default '0', `stamina` int( 11 ) NOT NULL default '5000', `quests` blob, `questflags` blob, `quickbar` varchar( 255 ) NOT NULL default '0', `basic_skills` varchar( 512 ) NOT NULL default '11,12,16,20,41,42,43,181,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', `askill` varchar( 255 ) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', `askilllvl` varchar( 255 ) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', `pskill` varchar( 255 ) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', `pskilllvl` varchar( 255 ) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', `respawnid` int( 11 ) NOT NULL default '51', `townid` int( 11 ) NOT NULL default '20', `class_skills` varchar( 255 ) NOT NULL default '0', `class_skills_level` varchar( 255 ) NOT NULL default '1', PRIMARY KEY ( `id` ) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =3 MySQL meldet: Dokumentation #1074 - Column length too big for column 'basic_skills' (max = 255); use BLOB or TEXT insteadkann mir da einer weiter helfen ? kenne mich net wirklich mit mysql aus