[an odd problem]

[danieldada]

Okay, an odd problem which i have never seen, nor have i ever thought could happen is that, when i edit something in the db... like take for instance.... a npcs text or make a new npc and put the lines into cq_action.... edit/add and then refresh it or close / re open to check them. And it reverts back to what it was / removes what was added. (Tryed this with server on + off)

things i have tryed are:....
Different action (backup)
Reinstall mysql
Reinstall navicat

i have been told it's a query problem but, since i've never seen this problem i'm not sure exactly what else to do.

Don't flame, Say your a noob because you don't and haven't had this problem before. Just post help if ya got it. Thanks.

Note: Problem has been solved as far as i know. But i'm leaving this incase someone else has the problem

[Necron33]

Okay, try this:
1.Copy all your data to another cq_action.how?
1.empty the second cq_action
2.dump a .sql of the first cq_action
3.exxcute the sql in the second cq_action

2.now right click on the first cq_action and click empty
3.then click test.
4.transfer data from the 2nd table to the first again.

Tell me if it Worked!