PM System went nuts

[MorrisMcD]

I think it was due to me trying to get AWS to work on the same site as Inferno's RPG... I altered some of the php files with the AWS, mainly the sendpm function...

Board members and myself have experienced problems replying to pms on occasion. It will either try to reply to the wrong id or it tries to create a new pm.

Well.. With that in mind, I did notice while trying to get AWS working, pms were generating QUICKLY.. I didnt notice it till almost a day later after thinking I got things working.. Once I disabled the AWS hack, the pms stopped... It was looping somewhere apparently and in the process created massive amounts of pm and pmtext data

Here is what i see A LOT of in a dump of the data from the pm table...

INSERT INTO `pm` VALUES (34048, 31045, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34049, 31046, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34050, 31047, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34051, 31048, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34052, 31049, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34053, 31050, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34054, 31051, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34055, 31052, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34056, 31053, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34057, 31054, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34058, 31055, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34059, 31056, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34061, 31058, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34062, 31059, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34063, 31060, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34064, 31061, 0, 0, 0, 0);
INSERT INTO `pm` VALUES (34065, 31062, 0, 0, 0, 0);

Litterally it goes on and on into the 60000 with an occaional legit one. They havent reoccured but the problems exists still.. The replies dont always work.. And the wierd part is you can go to a message, read it and try to reply and get a new pm form.. Then click out of the pms and go back to the message and the reply will work fine.. I am ok with wiping out the PMs altogether, but I wanted to see what any of you might suggest. And if no better suggestion, perhaps a little help, maybe a query to wipe the pms out clean....

Thanks in advance to any help

[MorrisMcD]

anyone?

[Marco van Herwaarden]

You could remove all these PM's with the following query (run on testboard first):
[sql]DELETE from PM WHERE userid = 0;[/sql]

[MorrisMcD]

Originally Posted by MarcoH64

You could remove all these PM's with the following query (run on testboard first):
[sql]DELETE from PM WHERE userid = 0;[/sql]

I've been putting the issue off as you may have noticed... I didnt want to bother anyone about it really, but if I do that, wont I also have to do the same for pmtext for which each of those reference.. Plus.. Isnt there yet another table called pmreceipt.. If it werent for all the tables it seems to tie together, I would have already run this query, but since its in a controlled state somewhat, I am not going to be jumpy about it