Help Error At Navicat

[FreakbuZz]

Hey guys ! i have that error and i cant log in .. My char freeze at Loading screen... I know that bug is at Navicat but i don't know how to fix it ...

 

 

[powerboy2]

Exeis pira3ei files?

[FreakbuZz]

Ε ναι lol :P 

[powerboy2]

apo ekei s bgrazei error..8a ebales kati trelo i 8a ksexases kati na baleis kai den bgazei nohma diabase ti leei to game server console kai 8umhsou ti ala3es 

[nikosdevil20]

Hey guys ! i have that error and i cant log in .. My char freeze at Loading screen... I know that bug is at Navicat but i don't know how to fix it ...

 

 

tsekare tis diadromes ap tis db, kai ap oti vlepw kati gia lastvotehopzone, kai apenergopiise kai to debug..an pas sto navicat sou anoixei tis db molis patas panw? se rwtaw mipws paizei kati sto mysql..

[powerboy2]

y des an exeis balei swsta tis diadromes apo tis db kai tsekare mipws exeis balei kati api8ano giati mexri kai mia telia ( . ) mporei na sta xalasei ola

[SadStatue]

Δώσε μου το link από το vote reward system που βρήκες εδω

επίσης ποιο revision του frozen εχεις; Παιζει να μην εκανες σωστο adapt το vote reward system.

Λογικά πέρασες λάθος το .sql η πείραξες το table.

Αν απλά πείραξες αρκετά το table,σβήσε το και ξανακάνε inject το sql.

Edited July 10, 2014 by SadStatue

[FirefoxAurora]

1)MySql - console :

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

logika 8a sou vgalei erro kai gia topzone meta... an sou vgalei tote kaneis auto

2)MySql - console :
 

ALTER TABLE `characters` ADD `lastVoteTopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `hasVotedHop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `hasVotedTop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `monthVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `totalVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `tries` INT UNSIGNED DEFAULT 3;

H allios console kai kaneis auto

 

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `lastVoteTopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `hasVotedHop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `hasVotedTop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `monthVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `totalVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `tries` INT UNSIGNED DEFAULT 3;

[Nightw0lf]

 

1)MySql - console :

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

logika 8a sou vgalei erro kai gia topzone meta... an sou vgalei tote kaneis auto

2)MySql - console :

 

ALTER TABLE `characters` ADD `lastVoteTopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `hasVotedHop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `hasVotedTop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `monthVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `totalVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `tries` INT UNSIGNED DEFAULT 3;

H allios console kai kaneis auto

 

 

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `lastVoteTopzone` BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE `characters` ADD `hasVotedHop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `hasVotedTop` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `monthVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `totalVotes` INT UNSIGNED DEFAULT 0;
ALTER TABLE `characters` ADD `tries` INT UNSIGNED DEFAULT 3;

to mono swsto an diavasate to error einai auto

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

 

kala gia tous upoloipous den to sizitaw kameni asfaleia

[SadStatue]

to mono swsto an diavasate to error einai auto

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

 

kala gia tous upoloipous den to sizitaw kameni asfaleia

 

Δεν σε βλεπω να βοηθας ομως;

[Nightw0lf]

eisai xazos? diavase ksana kai pes mou an voithaw i oxi...

[SadStatue]

eisai xazos? diavase ksana kai pes mou an voithaw i oxi...

 

Απλά κάνεις comments αγορίνα μου.

Ο FirefoxAurora απάντησε και λέει οτι ΑΝ σου βγαλει άλλο error κάνεις και τα άλλα.

Απλά μπήκες,έκρινες και βγήκες

[Nightw0lf]

koita epidi exeis liga post tha se dikaiologisw

gia na deis poso eksipnos eisai pane sti photo kai diavase akrivws amesws meta to "Unknown Column"

kai meta tha deis tin apantisi mou:

 

to mono swsto an diavasate to error einai auto

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

 

kala gia tous upoloipous den to sizitaw kameni asfaleia

auti i entoli sto navicat dinei sto table characters ena extra column to opoio legete `lastVoteHopzone`

mantepse ti eleipe... auto!

ase ta upoloipa pou apantise kai o mozillaaurora to mono pithano na xreiastei einai allo ena idio me tin topzone giati pane paketo auta

to ipoloipo pou egrapse einai apo entelws diaforetiko system kai einai se npc

 

pane pies to kafe sou twra

[FirefoxAurora]

koita epidi exeis liga post tha se dikaiologisw

gia na deis poso eksipnos eisai pane sti photo kai diavase akrivws amesws meta to "Unknown Column"

kai meta tha deis tin apantisi mou:

 

auti i entoli sto navicat dinei sto table characters ena extra column to opoio legete `lastVoteHopzone`

mantepse ti eleipe... auto!

ase ta upoloipa pou apantise kai o mozillaaurora to mono pithano na xreiastei einai allo ena idio me tin topzone giati pane paketo auta

to ipoloipo pou egrapse einai apo entelws diaforetiko system kai einai se npc

 

pane pies to kafe sou twra

Θα ηθελα να δω το NPC αυτο....

[SadStatue]

200 φορες δεν χρειαζετε να τα λεω,παει και offtopic

Εδωσες ακριβως την ιδια απαντηση με τον Firefox

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

και μετα απλα σχολιασες.

[Nightw0lf]

Θα ηθελα να δω το NPC αυτο....

pane sto http://l2jhellas.info/ pou eimai developer kai des to :poker face:

 

 

200 φορες δεν χρειαζετε να τα λεω,παει και offtopic

Εδωσες ακριβως την ιδια απαντηση με τον Firefox

ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

και μετα απλα σχολιασες.

kai fisika edwsa tin idia apantisi mono pou tin ksekatharisa oti to swsto einai auti i grammh giati:

giati ta upoloipa ean mpoun mesa apo lathos tou xristi epidi tou ta edwse o mozilla aurora se kathe xaraktira tha uparxoun:

1 ALTER TABLE `characters` ADD `lastVoteHopzone` BIGINT UNSIGNED DEFAULT NULL;

2 ALTER TABLE `characters` ADD `lastVoteTopzone` BIGINT UNSIGNED DEFAULT NULL;

3 ALTER TABLE `characters` ADD `hasVotedHop` INT UNSIGNED DEFAULT 0;

4 ALTER TABLE `characters` ADD `hasVotedTop` INT UNSIGNED DEFAULT 0;

5 ALTER TABLE `characters` ADD `monthVotes` INT UNSIGNED DEFAULT 0;

6 ALTER TABLE `characters` ADD `totalVotes` INT UNSIGNED DEFAULT 0;

7 ALTER TABLE `characters` ADD `tries` INT UNSIGNED DEFAULT 3;

AXRHSTA KELIA = LAG

auto pou kanete twra einai spam katharo giati exw dwsei idi tin lusi kai eimaste se aggliko section kai grafoume greek/greeklish