[2.3] unable to delete rows in sql database

[NewHope]

My M2server displays an error ever since i created a newmap and placed it into the mapinfo, therefore i want to delete that map. However i cannot, when i try it tells me than too many rows were affected. Anyone know of a way i can fix this problem, thanks.

 

[Akuma]

close the server and try it

VirUs

 

[DeathsDoor]

it happened to me , i just had to get a new db and it was fixed

 

[Dookie]

Yea i get this every now and then. Best way i find to fix it is just delete the field with a SQL statement.

Get a SQL window up (QueryAnalyzer or right click table and select Open Table > Query), then delete whatever SQL script is already there and replace it with this:

DELETE FROM TBL_MAPINFO
WHERE FLD_MAPFILENAME = '<MapNameHere>'

Note: If you use QueryAnalyzer make sure you select the correct database from the drop down box at the top.

Also i take no responsibility if something goes wrong (It shouldn't if you do it right) :P

- Lind

 

[NewHope]

Yea i get this every now and then. Best way i find to fix it is just delete the field with a SQL statement.

Get a SQL window up (QueryAnalyzer or right click table and select Open Table > Query), then delete whatever SQL script is already there and replace it with this:

DELETE FROM TBL_MAPINFO
WHERE FLD_MAPFILENAME = '<MapNameHere>'

Note: If you use QueryAnalyzer make sure you select the correct database from the drop down box at the top.

Also i take no responsibility if something goes wrong (It shouldn't if you do it right) :P

- Lind

Thanks it worked!