SQL HELP!!

[kakarotokarotos]

Kalispera paides!!!Edw kai kati meres prwspa8w mesw t navicat na perasw kapia SQL Arxeia.....Gia tn aribeia 8elw na perasw mia buffer stn server m...Otan paw na perasw to arxeio apo to navicat m bgazei to e3eis problima....

 

[Err] 1054 - Unknown column 'faction_id' in 'field list'

[Err] INSERT INTO npc

  (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`, `ss`, `bss`, `ss_rate`, `AI`, `drop_herbs`)

VALUES

  (212121, 20821, 'Buffer', 1, 'Maniac Moderator', 1, 'NPC.a_casino_FDarkElf', 8.00, 20.00, 70, 'female', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 50, 120, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'fighter', 'false');

[Msg] Finished - Unsuccessfully

 

 

8a ektimousa pragmatika polu an 8a mporousate na me help.....exw kanei 1000ades search alla dn exw brei tpt!!Thnx!! :)

[Apithanos]

perase to manually.

to dokimases?

[kakarotokarotos]

Distixws to dokimasa kai auto alla kai pali tpt........

[kr1n0s*]

Distixws to dokimasa kai auto alla kai pali tpt........

otan les tpt??  kanonika molis kaneis save eprpe na s bgalei kapio error di3e mas edw to error na s poume ti einai..

 

PS: eise se la8os section

[kakarotokarotos]

Otan lew tpt enow oti pernaw to sql arxeio sto navicat manually kai otan mpainw sto game kai pataw to ip gia na kanw to spawn dn briskei to ip!!

[MixMasteR]

wrong section !!!

 

-Reported

[kr1n0s*]

Otan lew tpt enow oti pernaw to sql arxeio sto navicat manually kai otan mpainw sto game kai pataw to ip gia na kanw to spawn dn briskei to ip!!

eise sigouros pws :

1ton to bazeis sto swsto table?

2ro oti to kaneis save?

 

afou den s gbazei sfalma otan klineis to para8iro tote den exei problima h db s....

[kuba90]

kala eseis oloi pou apantate, kai eiste donator, vip kai den ksero go ti skata , kopria exete sto kefali mesa ? Den blepete ?

[Err] 1054 - Unknown column 'faction_id' in 'field list'

 

O pinakas npc pou exeis arxige stin database sou einai palios, kai den exei tin stili faction_id. Prospatheis na baleis ston pinaka times kai stin stili faction_id i opia den iparxei. Lisi:

 

1) Kane update to npc table sou sto latest tou project pou xrisimopoieis.

 

2) An den mporeis, eisigage mia stili ston pinaka npc me onoma faction_id kai tipo int.

 

 

Imarton me tous spammers, den kserete, to boulonete apla :) Thank you.

[kakarotokarotos]

Thnx Kuba Eixes apoluto dikio!!Thnx kai pali!! :)

[Coyote™]

Thnx Kuba Eixes apoluto dikio!!Thnx kai pali!! :)

 

Solved ~> Locked