[Trinity] SQL Error Help...

[Hyldran0]

abdullah

Delete

[Hyldran0]

Really? No one ?

[stoneharry]

Duplicate entry = something with that primary key already exists.

If you really want to force that data in, change the insert statement to a replace statement.

[Hyldran0]

Duplicate entry = something with that primary key already exists.

If you really want to force that data in, change the insert statement to a replace statement.

How to do that ?

[shumi]

you can do that with the update sql statement.
But as the error suggests, that spell allready exists on that target.

[Hyldran0]

Well it isen't that spell is Bear Form, and i cannot learn it from that Druid trainer i want the spell ti get into..

[stoneharry]

Learn how databases and MySQL works, then you will understand the answers given here.

[shumi]

You can delete that spell with

DELETE FROM npc_trainer WHERE enrty=12042 AND spell=5487

and after that just put the insert sql.
And like stoneharry said. Learn it and you will understand.

Have a good day.

[Hyldran0]

I was suspected a better answer but okey..
I'll add them manually instead. thanks for non help.

I was asking for a fix not an more advanced way.

[Serpious]

Dude, wtf? All the answers here are good enough for a person with even really basic SQL knowledge to understand.

[Hyldran0]

You'r picture says everything about you

Well i was looking for a fast fix.
Seems like this forum is dying.

Was better 1-2 years ago.
People where nicer

back to Topic. I fixed it my self now, thanks for no help.

[2dgreengiant]

Change INSERT to REPLACE, worked for me when I just tested it :P

[Hyldran0]

Change INSERT to REPLACE, worked for me when I just tested it :P

See this guy ? He pwns !!!
Thanks alot, But still i fixed it my self!

+rep

[Serpious]

Change INSERT to REPLACE, worked for me when I just tested it :P

See this guy ? He pwns !!!
Thanks alot, But still i fixed it my self!

+rep

change the insert statement to a replace statement.

2d wrote the same thing stoneharry did.

[stoneharry]

2d wrote the same thing stoneharry did.

This .