[HELP]Clan Problem

[Bobi]

What is this table in SQL Clan notices ?

and for what use this table ?

 

because when i restart server i read error:

 

dublicate ID clan_notices table

 

and server dont want run .

 

where is problem ?

 

--------------------------

all time when restart server i get this error and server stop loading other files

if i make empty table clan_notices server will run ok

 

so how can fix this problem ?

L2jBrasil rev 955

 

[Bobi]

bump

[`Rοmeο]

go at clan_notices table select anything and delete it...

restart the server and reply

[Bobi]

go at clan_notices table select anything and delete it...

restart the server and reply

 

i make this all time

and all time i need make clan_notices table empty because server read dublicat ID and not run

[xAddytzu]

i make this all time

and all time i need make clan_notices table empty because server read dublicat ID and not run

omfg !!

 

because your entry was duplicate, you don't have update statment ...

String mda = PlayerGetNotice(activeChar);

if (mda.equals(null))

{

PreparedStatement statement = con.prepareStatement("INSERT INTO clan_notices

statment methods

}

else

{

PreparedStatement statement = con.prepareStatement("UPDATE clan_notices SET notice=? WHERE clan_id=?");

statment methods

}

[Bobi]

in who files need  change this

 

String mda = PlayerGetNotice(activeChar);
if (mda.equals(null))
{
PreparedStatement statement = con.prepareStatement("INSERT INTO clan_notices
statment methods
}
else
{
PreparedStatement statement = con.prepareStatement("UPDATE clan_notices SET notice=? WHERE clan_id=?");
statment methods
}

[xAddytzu]

Search the f***** message "Error while creating clan notice"

[Bobi]

and how to add this in clan_notince table in sql ?

[Bobi]

Search the f***** message "Error while creating clan notice"

 

Bump

 

so this need add in slq or in java ?

 

String mda = PlayerGetNotice(activeChar);

if (mda.equals(null))

{

PreparedStatement statement = con.prepareStatement("INSERT INTO clan_notices

statment methods

}

else

{

PreparedStatement statement = con.prepareStatement("UPDATE clan_notices SET notice=? WHERE clan_id=?");

statment methods

}

[Gogos™]

Update your pack they fixed something for clan_notice check here

 

[Bobi]

omg i wait him 5 days for fix it .....

 

btw tnx xAddytzu

 

problem fixed

[Setekh]

well thats how they work.. imho ppl are better on there own then with packs like this, that don't know how to fix up a simple prepared statement xD