error deleteing row's.

[NightScare]

When i try delete everything in my mongen table i get this


Key collum information is insufficent or incorect. to many rows were affected by update


IT STILL DOES THIS WHEN I JUST SELECT ONE ROW!

Thanks

 

[excluded]

export it as a .txt file,edit what u want,then import it back.thats what i always do lol..yeh sql does suck

 

[NightScare]

I want to delete it all, as my server wont be useing any Euro monsters at all.

lol

 

[Elvin]

the reason could be because of duplicates so you are going to need some one to make you an sql query , sorry i cant help you with that highligh a

sometimes when i get that error when i delete it i just do a few rows at a time and then right click on a line thats not being deleted and then try.

 

[NightScare]

wont even let me delete one row....


when i even try edit the table in any way, it brings up the same error

wtf -.-

fkin me off now lol

 

[NightScare]

just tried restoring my databases again.


no joy. lol

 

[Elvin]

cant you just make a new mongen table and add the fields to it and then delete the whole of the other mongen table

 

[NightScare]

cant you just make a new mongen table and add the fields to it and then delete the whole of the other mongen table

Dunno how to, unless its the same as Microsoft acess? i can use acess proffesionaly, but im an SQL N00b.

+ Dont u have to set certain things in SQL? for the database to relate to the client?

 

[iJam]

Make a Microsoft acess file on your desktop , export the Table witch has the problem in it into the folder u made delete the row make sure the numbers r in order in the first coloum coz they wont load proply, then save it then go into sql delete the table, then rite click tables at the side import the file u made, then click refresh , if this is complicated add me on msn lol , [email protected] seyas gl.

 

[NightScare]

How i export a sql database into acess????

 

[iJam]

add me on msn its weird ot explain on here

 

[NewHope]

cant you just make a new mongen table and add the fields to it and then delete the whole of the other mongen table

I did this because i had the same problem.

However i sometimes still get this problem, it comes when i edit fields in the database too fast, or copy and paste alot of rows at a time... so i usualy edit one at a time now.

 

[NightScare]

Worked it out, and added u on msn incase need other help with SQL.

 

[Killmaster]

Like people have said, the row you are trying to delete has the exact same information in another row... common in mongen Im guessing.

Its annoying I know. Not much can be done about it, as Im aware of anyway.