[Help] 8elw ligi voi8ia edo!!!!

[Mit-sos]

Kalimera se olous. 8a i8ela mia mikri voi8ia. kserw oti den einai to katalilo meros na apef8in8w ala dn kserw pou alou!!! lipon ekana ena kenourgio compile to l2jserver kai otan paw na egkatastisw tn database ksekinaei kanonika ala otan ftanei stin armors.sql mou grafi

afto:

 

something caused an error while executing instruction:

c:/program files/mysql/mysql server 5.5/bin/mysql.exe -h localhost -u root --pasword *******(den tn anaferw :P) -D l2jdb

 

with file armor.sql

 

 

kai stis epiloges katw mou leei na kanw restart to programa i na sinexisw i na ftiaksw ena log me afta pou den exoun egkatasta8i i na bgw. pataw na sinexisw kai meta mou to bgazi sto armorsets.sql ksanapataw na sinexisw kai meta to bgazi sto auto_chat.sql kai meta se ala kai se ala arxia kai etsi den ginete tpt sxedon egkatastasi stin database...

exw kani complete peripou 5-6 fores to l2jserver kai panta mou grafi to idio!!! exi sinvi se kanenan i stin teliki kseri kanis pou na milisw??? ala sas efxaristw an mou apantisete!

[Natsu]

prpei na pareis ena ena ta sql kai na ta valeis manual na deis pia sou vgazoun error kai meta osa sou vgazoun fix afto edw..

 

CREATE TABLE `armor` (

  `item_id` int(11) NOT NULL default '0',

  `name` varchar(70) default NULL,

  `bodypart` varchar(15) NOT NULL default '',

  `crystallizable` varchar(5) NOT NULL default '',

  `armor_type` varchar(5) NOT NULL default '',

  `weight` int(5) NOT NULL default '0',

  `material` varchar(15) NOT NULL default '',

  `crystal_type` varchar(4) NOT NULL default '',

  `avoid_modify` int(1) NOT NULL default '0',

  `duration` int(3) NOT NULL default '0',

  `p_def` int(3) NOT NULL default '0',

  `m_def` int(2) NOT NULL default '0',

  `mp_bonus` int(3) NOT NULL default '0',

  `price` int(11) NOT NULL default '0',

  `crystal_count` int(4) default NULL,

  `sellable` varchar(5) default NULL,

  `dropable` varchar(5) default NULL,

  `destroyable` varchar(5) default NULL,

  `tradeable` varchar(5) default NULL,

  `item_skill_id` decimal(11,0) NOT NULL default '0',

  `item_skill_lvl` decimal(11,0) NOT NULL default '0',

  PRIMARY KEY  (`item_id`)

) TYPE=MyISAM;

 

to knc etsi );

[Mit-sos]

se oti kai na kanw manual error mou bgazi!!!

[Natsu]

ti den katalveneis?? se opio sql sou vgazei error alazeis afto pou sou lew..

[Mit-sos]

to katalava ala pali dn ginete tpt!!!

[Mit-sos]

telos panton to vrika!!!! an sas sinvi alakste ta arxia .sql pou den litourgoun me ala enos alou projekt

[Natsu]

einai la9os afto pou les gt den einai idia ola ta project kai o tropos pou sou edi3a pos na to knc einai o swstos :)

[Pauler]

Μαλλον το armor.sql εχει καποιο `typo`. Περνα χειροκινητα το .sql ωστε να δεις ποιο ειναι το error.