using build #194 grief revert block is not reverting anything, no errors in the console. need this fix soon please :( people in my server going nuts

other notes. no errors when right clicking the grief prevent block, when trying to revert the damage also still works fine no blocks drop. using mysql, also no errors connection to it says its successful .

Any idea why this started happening all of a sudden? Did you change anything? Did this happen after an upgrade, if so to what version?

Turn on debugging /ps debugdb, /ps debugsql. Put a new grief revert block, do some grief (with another account), and then try to revert the grief, and post here the logs that come up.

switched from mysql to sqlite and it works now, but I need mysql since all my data is in there.

07.01 03:32:59 [Server] INFO DELETE FROM pstone_grief_undo WHERE field_x = 658 AND field_y = 62 AND field_z = 211 AND world = 'Tartarus Realm';
07.01 03:32:56 [Server] INFO noxturno: ok
07.01 03:32:54 [Server] INFO DELETE FROM pstone_grief_undo WHERE field_x = 658 AND field_y = 62 AND field_z = 211 AND world = 'Tartarus Realm';
07.01 03:32:52 [Server] INFO DELETE FROM pstone_grief_undo WHERE field_x = 658 AND field_y = 62 AND field_z = 211 AND world = 'Tartarus Realm';
07.01 03:32:52 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551172927',658,62,211,'Tartarus Realm',660,62,210,4,0,'');
07.01 03:32:52 [Server] INFO processing 1 grief queries...
07.01 03:32:51 [Server] INFO DELETE FROM pstone_grief_undo WHERE field_x = 658 AND field_y = 62 AND field_z = 211 AND world = 'Tartarus Realm';
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171127',658,62,211,'Tartarus Realm',659,62,209,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171127',658,62,211,'Tartarus Realm',657,62,209,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171127',658,62,211,'Tartarus Realm',658,62,210,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171127',658,62,211,'Tartarus Realm',657,62,211,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171126',658,62,211,'Tartarus Realm',656,62,210,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171126',658,62,211,'Tartarus Realm',657,62,213,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171126',658,62,211,'Tartarus Realm',657,62,214,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171126',658,62,211,'Tartarus Realm',656,62,214,4,0,'');
07.01 03:32:51 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551171125',658,62,211,'Tartarus Realm',656,62,212,4,0,'');
07.01 03:32:51 [Server] INFO processing 1 grief queries...
07.01 03:32:45 [Server] INFO Player: noxturno Command: /i ironpick 1
07.01 03:32:43 [Server] INFO robbodino attempted to destroy noxturno's Grief Revert field [GOLD_BLOCK|658 62 211]
07.01 03:32:36 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551156126',658,62,211,'Tartarus Realm',660,62,213,4,0,'');
07.01 03:32:36 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551156126',658,62,211,'Tartarus Realm',659,62,212,4,0,'');
07.01 03:32:36 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551156126',658,62,211,'Tartarus Realm',658,62,212,4,0,'');
07.01 03:32:36 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551156126',658,62,211,'Tartarus Realm',658,62,213,4,0,'');
07.01 03:32:36 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551156125',658,62,211,'Tartarus Realm',660,63,214,54,2,'');
07.01 03:32:36 [Server] INFO processing 1 grief queries...
07.01 03:32:30 [Server] INFO DELETE FROM pstone_grief_undo WHERE x = 659 AND y = 62 AND z = 213 AND world = 'Tartarus Realm';
07.01 03:32:21 [Server] INFO INSERT INTO pstone_grief_undo ( date_griefed, field_x, field_y , field_z, world, x , y, z, type_id, data, sign_text) VALUES ( '1357551141126',658,62,211,'Tartarus Realm',659,63,214,54,2,'');
07.01 03:32:21 [Server] INFO processing 1 grief queries...
07.01 03:32:15 [Server] INFO /38.64.135.8:41776 lost connection
07.01 03:32:07 [Server] INFO robbodino: BLOCK?
07.01 03:32:06 [Server] INFO UPDATE pstone_cuboids SET flags = '{"disabledFlags":["welcome-message","farewell-message"]}' WHERE x = 658 AND y = 62 AND z = 211 AND world = 'Tartarus Realm';
07.01 03:32:06 [Server] INFO processing 1 pstone queries...
07.01 03:32:01 [Server] INFO noxturno: ok grief
07.01 03:31:54 [Server] INFO DELETE FROM pstone_grief_undo WHERE x = 658 AND y = 62 AND z = 211 AND world = 'Tartarus Realm';
07.01 03:31:54 [Server] INFO INSERT INTO pstone_cuboids ( parent, x, y, z, world, minx, miny, minz, maxx, maxy, maxz, velocity, type_id, data, owner, name, packed_allowed, last_used, flags) VALUES ( 0,658,62,211,'Tartarus Realm',638,55,191,678,69,231,0.0,41,0,'noxturno','','','1357551114777','{}');

some reason the code I pasted , it starts from the bottom... is late so idk why it did that hahah hope you can find the issue from what i see mysql connects normaly but for some reason doesnt revert the grief

to be honest i am not sure if I changed something I try all builds from the recommended till the latest one I though it could of been mySQL issue on my side with giving perms but hawk eye and my other plugins have no problems, I will do this as soon as my server population is down to 10 players late at night thanks for your reply, will be posting here soon

Hey added some debug output to the latest build on jenkins. Can you try this: /ps debug, then try to revert some grief. It should spit out some lines on the logs, can you paste those here too pls.

ok here http://pastie.org/5646195

Don't see any of the debug output I added, you sure you tried this with the new build, and that you turned on /ps debug (not /ps debugsql, /ps debugdb)?

yes.. is the latest from the jenkins. I even saw on the notes debug sql added .

crap i may of done wrong command.. looking at my command logs

ok I did with only /ps debug and nothing came up on the console.

damn, found a bug. pull the new build from jenkins, its gonna output the debug stuff now.

2013-01-08 01:27:33 [INFO] [CommandLogger] Player: noxturno Command: /ps debug
2013-01-08 01:27:33 [INFO] noxturno issued server command: /ps debug
2013-01-08 01:27:38 [INFO] There are 2 out of maximum 30 players online.
2013-01-08 01:27:38 [INFO] Connected players: Dallocorte, noxturno
2013-01-08 01:27:41 [INFO] Dallocorte entered a Grief Revert field
2013-01-08 01:27:41 [INFO] Retrieving block grief
2013-01-08 01:27:41 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:27:43 [INFO] noxturno entered a Grief Revert field
2013-01-08 01:27:51 [INFO] [G] noxturno: go head grief
2013-01-08 01:28:00 [INFO] [G] noxturno: ok
2013-01-08 01:28:02 [INFO] Retrieving block grief
2013-01-08 01:28:02 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:17 [INFO] There are 2 out of maximum 30 players online.
2013-01-08 01:28:17 [INFO] Connected players: Dallocorte, noxturno
2013-01-08 01:28:19 [INFO] Retrieving block grief
2013-01-08 01:28:19 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:21 [INFO] Retrieving block grief
2013-01-08 01:28:21 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:21 [INFO] Retrieving block grief
2013-01-08 01:28:21 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:22 [INFO] Retrieving block grief
2013-01-08 01:28:22 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:22 [INFO] Retrieving block grief
2013-01-08 01:28:22 [INFO] Extracted 0 griefed blocks from the db
2013-01-08 01:28:32 [INFO] [G] noxturno: ok thats it for tonight for me on this crap
2013-01-08 01:28:36 [INFO] [G] Dallocorte: =
2013-01-08 01:28:44 [INFO] [G] noxturno: groing to do last restart to put it back to normal
2013-01-08 01:28:48 [INFO] [G] Dallocorte: alright
2013-01-08 01:28:53 [INFO] Connection reset
2013-01-08 01:28:53 [INFO] noxturno lost connection: disconnect.quitting
2013-01-08 01:28:57 [INFO] There are 1 out of maximum 30 players online.
2013-01-08 01:28:57 [INFO] Connected players: Dallocorte
2013-01-08 01:28:58 [INFO] Connection reset
2013-01-08 01:28:58 [INFO] Dallocorte lost connection: disconnect.quitting

still no fix for this?

how do I change sqlite to mysql ? thanks in advance

http://wiki.sacredlabyrinth.net/index.php?title=PreciousStones#Converting_from_SQLite_to_MySQL

Insert your SQlite data into your old MySQL tables with your old data and then load up the server and run /ps clean to clean out all the orphaned fields that were removed.since then.